com.xdev.jadoth.sqlengine.interfaces.SqlExecutor Maven / Gradle / Ivy

Go to download
/*
 * XDEV Application Framework - XDEV Application Framework
 * Copyright © 2003 XDEV Software (https://xdev.software)
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Lesser General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public License
 * along with this program.  If not, see .
 */
package com.xdev.jadoth.sqlengine.interfaces;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import com.xdev.jadoth.sqlengine.internal.DatabaseGateway;



public interface SqlExecutor
{	
	public R execute(DatabaseGateway dbc, Statement statement, String sqlStatment) throws SQLException;
	
	
	public static final SqlExecutor update = new SqlExecutor() {
		@Override
		public Integer execute(DatabaseGateway dbc, Statement statement, String sqlStatment) throws SQLException
		{
			if(statement != null) {
				return statement.executeUpdate(sqlStatment);
			}
			
			try(Statement createdStatement = dbc.getConnection().createStatement()) {
				return createdStatement.executeUpdate(sqlStatment);
			}
		}
	};
	
	public static final SqlExecutor query = new SqlExecutor() {
		@Override
		public ResultSet execute(DatabaseGateway dbc, Statement statement, String sqlStatment) throws SQLException
		{
			if(statement == null){
				statement = dbc.getConnection().createStatement();
			}
			return statement.executeQuery(sqlStatment);
		}
	};
	
	public static final SqlExecutor