com.github.paganini2008.devtools.db4j.PreparedStatementCreatorUtils 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.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * PreparedStatementCreators
 * 
 * @author Fred Feng
 * @version 1.0
 */
public abstract class PreparedStatementCreatorUtils {

	public static PreparedStatementCreator forDefault(String sql) {
		return new DefaultPreparedStatementCreator(sql);
	}

	public static PreparedStatementCreator forColumnNames(String sql, String[] columnNames) {
		return new ColumnNamesPreparedStatementCreator(sql, columnNames);
	}

	public static PreparedStatementCreator forColumnIndexes(String sql, int[] columnIndexes) {
		return new ColumnIndexesPreparedStatementCreator(sql, columnIndexes);
	}

	public static PreparedStatementCreator forGeneratedKey(String sql) {
		return new GeneratedKeyPreparedStatementCreator(sql);
	}

	public static PreparedStatementCreator forQuery(String sql, int resultSetType, int resultSetConcurrency) {
		return new ResultSetPreparedStatementCreator(sql, resultSetType, resultSetConcurrency);
	}

	/**
	 * Default PreparedStatement
	 * 
	 * @author Fred Feng
	 * @version 1.0
	 */
	private static class DefaultPreparedStatementCreator implements PreparedStatementCreator {

		private DefaultPreparedStatementCreator(String sql) {
			this.sql = sql;
		}

		private final String sql;

		public PreparedStatement createPreparedStatement(Connection connection) throws SQLException {
			return connection.prepareStatement(sql);
		}

	}

	/**
	 * PreparedStatement for columnNames
	 * 
	 * @author Fred Feng
	 * @version 1.0
	 */
	private static class ColumnNamesPreparedStatementCreator implements PreparedStatementCreator {

		private ColumnNamesPreparedStatementCreator(String sql, String[] columnNames) {
			this.sql = sql;
			this.columnNames = columnNames;
		}

		private final String sql;

		private final String[] columnNames;

		public PreparedStatement createPreparedStatement(Connection connection) throws SQLException {
			return connection.prepareStatement(sql, columnNames);
		}

	}

	/**
	 * PreparedStatement for columnIndexes
	 * 
	 * @author Fred Feng
	 * @version 1.0
	 */
	private static class ColumnIndexesPreparedStatementCreator implements PreparedStatementCreator {

		private ColumnIndexesPreparedStatementCreator(String sql, int[] columnIndexes) {
			this.sql = sql;
			this.columnIndexes = columnIndexes;
		}

		private final String sql;

		private final int[] columnIndexes;

		public PreparedStatement createPreparedStatement(Connection connection) throws SQLException {
			return connection.prepareStatement(sql, columnIndexes);
		}

	}

	/**
	 * PreparedStatement for GeneratedKeys
	 * 
	 * @author Fred Feng
	 * @version 1.0
	 */
	private static class GeneratedKeyPreparedStatementCreator implements PreparedStatementCreator {

		private GeneratedKeyPreparedStatementCreator(String sql) {
			this.sql = sql;
		}

		private final String sql;

		public PreparedStatement createPreparedStatement(Connection connection) throws SQLException {
			return connection.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
		}

	}

	/**
	 * PreparedStatement for ResultSet
	 * 
	 * @author Fred Feng
	 * @version 1.0
	 */
	private static class ResultSetPreparedStatementCreator implements PreparedStatementCreator {

		private ResultSetPreparedStatementCreator(String sql, int resultSetType, int resultSetConcurrency) {
			this.sql = sql;
			this.resultSetType = resultSetType;
			this.resultSetConcurrency = resultSetConcurrency;
		}

		private final String sql;
		private final int resultSetType;
		private final int resultSetConcurrency;

		public PreparedStatement createPreparedStatement(Connection connection) throws SQLException {
			return connection.prepareStatement(sql, resultSetType, resultSetConcurrency);
		}

	}
}