java/sql-dk/src/info/globalcode/sql/dk/SQLCommand.java
author František Kučera <franta-hg@frantovo.cz>
Sun, 22 Dec 2013 23:55:07 +0100
branchv_0
changeset 35 b2ff3b2d58b2
parent 34 9335cf31c0f2
child 37 9e6f8e5d5f98
permissions -rw-r--r--
accept SQL commands returning more ResultSets
     1 /**
     2  * SQL-DK
     3  * Copyright © 2013 František Kučera (frantovo.cz)
     4  *
     5  * This program is free software: you can redistribute it and/or modify
     6  * it under the terms of the GNU General Public License as published by
     7  * the Free Software Foundation, either version 3 of the License, or
     8  * (at your option) any later version.
     9  *
    10  * This program is distributed in the hope that it will be useful,
    11  * but WITHOUT ANY WARRANTY; without even the implied warranty of
    12  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
    13  * GNU General Public License for more details.
    14  *
    15  * You should have received a copy of the GNU General Public License
    16  * along with this program. If not, see <http://www.gnu.org/licenses/>.
    17  */
    18 package info.globalcode.sql.dk;
    19 
    20 import java.sql.Connection;
    21 import java.sql.PreparedStatement;
    22 import java.sql.SQLException;
    23 import java.util.List;
    24 
    25 /**
    26  *
    27  * @author Ing. František Kučera (frantovo.cz)
    28  */
    29 public abstract class SQLCommand {
    30 
    31 	private COMMAND_TYPE commandType;
    32 	private String query;
    33 
    34 	public SQLCommand(COMMAND_TYPE commandType, String query) {
    35 		this.commandType = commandType;
    36 		this.query = query;
    37 	}
    38 
    39 	public PreparedStatement prepareStatement(Connection c) throws SQLException {
    40 		return c.prepareStatement(query);
    41 	}
    42 
    43 	public abstract void parametrize(PreparedStatement ps) throws SQLException;
    44 
    45 	public abstract List<? extends Parameter> getParameters();
    46 
    47 	public COMMAND_TYPE getCommandType() {
    48 		return commandType;
    49 	}
    50 
    51 	public void setCommandType(COMMAND_TYPE commandType) {
    52 		this.commandType = commandType;
    53 	}
    54 
    55 	public String getQuery() {
    56 		return query;
    57 	}
    58 
    59 	public enum COMMAND_TYPE {
    60 
    61 		/** SELECT */
    62 		QUERY,
    63 		/** INSERT, UPDATE, DELETE */
    64 		UPDATE
    65 	};
    66 }