com.github.paganini2008.devtools.db4j.JdbcOperations Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of devtools-db4j Show documentation
a concise jdbc tools for quick developing
There is a newer version: 2.0.5
/**
* Copyright 2021 Fred Feng ([email protected])

* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
*    http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package com.github.paganini2008.devtools.db4j;

import java.sql.SQLException;
import java.util.List;

import com.github.paganini2008.devtools.collection.Tuple;
import com.github.paganini2008.devtools.db4j.mapper.RowMapper;
import com.github.paganini2008.devtools.jdbc.Cursor;
import com.github.paganini2008.devtools.jdbc.DefaultPageableSql;
import com.github.paganini2008.devtools.jdbc.PageableQuery;
import com.github.paganini2008.devtools.jdbc.PageableSql;

/**
 * 
 * JdbcOperations
 *
 * @author Fred Feng
 * @version 1.0
 */
public interface JdbcOperations {

	default int update(String sql, Object[] args) throws SQLException {
		return update(sql, new ArraySqlParameter(args));
	}

	int update(String sql, SqlParameter sqlParameter) throws SQLException;

	default int update(String sql, Object[] args, GeneratedKey generatedKey) throws SQLException {
		return update(sql, new ArraySqlParameter(args), generatedKey);
	}

	int update(String sql, SqlParameter sqlParameter, GeneratedKey generatedKey) throws SQLException;

	default int[] batchUpdate(String sql, List argsList) throws SQLException {
		return batchUpdate(sql, new ArraySqlParameters(argsList));
	}

	int[] batchUpdate(String sql, SqlParameters sqlParameters) throws SQLException;

	default  T query(String sql, Object[] args, ResultSetExtractor extractor) throws SQLException {
		return query(sql, new ArraySqlParameter(args), extractor);
	}

	 T query(String sql, SqlParameter sqlParameter, ResultSetExtractor extractor) throws SQLException;

	default List queryForList(String sql, Object[] args) throws SQLException {
		return queryForList(sql, new ArraySqlParameter(args));
	}

	List queryForList(String sql, SqlParameter sqlParameter) throws SQLException;

	default  T queryForObject(String sql, Object[] args, RowMapper rowMapper) throws SQLException {
		return queryForObject(sql, new ArraySqlParameter(args), rowMapper);
	}

	 T queryForObject(String sql, SqlParameter sqlParameter, RowMapper rowMapper) throws SQLException;

	default  List queryForList(String sql, Object[] args, RowMapper rowMapper) throws SQLException {
		return queryForList(sql, new ArraySqlParameter(args), rowMapper);
	}

	 List queryForList(String sql, SqlParameter sqlParameter, RowMapper rowMapper) throws SQLException;

	default  Cursor queryForCursor(String sql, Object[] args, RowMapper rowMapper) throws SQLException {
		return queryForCursor(sql, new ArraySqlParameter(args), rowMapper);
	}

	 Cursor queryForCursor(String sql, SqlParameter sqlParameter, RowMapper rowMapper) throws SQLException;

	default  Cursor queryForCachedCursor(String sql, Object[] args, RowMapper rowMapper) throws SQLException {
		return queryForCachedCursor(sql, new ArraySqlParameter(args), rowMapper);
	}

	 Cursor queryForCachedCursor(String sql, SqlParameter sqlParameter, RowMapper rowMapper) throws SQLException;

	default PageableQuery queryForPage(String sql, Object[] args) throws SQLException {
		return queryForPage(new DefaultPageableSql(sql), new ArraySqlParameter(args));
	}

	default PageableQuery queryForPage(String sql, SqlParameter sqlParameter) throws SQLException {
		return queryForPage(new DefaultPageableSql(sql), sqlParameter);
	}

	default PageableQuery queryForPage(PageableSql pageableSql, Object[] args) throws SQLException {
		return queryForPage(pageableSql, new ArraySqlParameter(args));
	}

	PageableQuery queryForPage(PageableSql pageableSql, SqlParameter sqlParameter) throws SQLException;

	default  PageableQuery queryForPage(String sql, Object[] args, RowMapper rowMapper) throws SQLException {
		return queryForPage(new DefaultPageableSql(sql), new ArraySqlParameter(args), rowMapper);
	}

	default  PageableQuery queryForPage(PageableSql pageableSql, Object[] args, RowMapper rowMapper) throws SQLException {
		return queryForPage(pageableSql, new ArraySqlParameter(args), rowMapper);
	}

	default  PageableQuery queryForPage(String sql, SqlParameter sqlParameter, RowMapper rowMapper) throws SQLException {
		return queryForPage(new DefaultPageableSql(sql), sqlParameter, rowMapper);
	}

	 PageableQuery queryForPage(PageableSql pageableSql, SqlParameter sqlParameter, RowMapper rowMapper) throws SQLException;

	 T customize(Customizable customizable) throws SQLException;

}