Java Utililty Methods SQL Query

PreparedStatement createInQueryStatement(String query, long[] ids, Connection conn)
Creates new PreparedStatement and fill it up with the ids.

String actualQuery = query + createQuestionMarks(ids.length);
PreparedStatement pstmt = conn.prepareStatement(actualQuery);
for (int i = 0; i < ids.length; i++) {
 pstmt.setLong(i + 1, ids[i]);
return pstmt;

ResultSet executeCsvQuery(Connection csv, String csvTableName)
Executes a query on provided CSV connection.

ResultSet expected = csv.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY)
 .executeQuery("SELECT * FROM " + csvTableName);
expected.beforeFirst();
return expected;

void executeDDL(String query, Connection connection)
execute DDL

try (Statement st = connection.createStatement()) {
 st.executeUpdate(query);

ResultSet executeForResult(Connection conn, String query, String... args)
execute For Result

if (args == null || args.length == 0)
 return conn.createStatement().executeQuery(query);
else {
 PreparedStatement stmt = createPreparedStatement(conn, query, args);
 return stmt.executeQuery();

int ExecuteNoneQuerys(String cmdtext, Object[] parms)
Execute None Querys

PreparedStatement pstmt = null;
Connection conn = null;
try {
 conn = getConnections();
 pstmt = conn.prepareStatement(cmdtext);
 prepareCommand(pstmt, parms);
 return pstmt.executeUpdate();
} catch (Exception ex) {
...

ResultSet executeQuery(Connection c, String query)
executeQuery

ResultSet rs = null;
Statement st = null;
try {
 st = c.createStatement();
 rs = st.executeQuery(query);
} catch (SQLException ee) {
 if (st != null) {
 st.close();
...

ResultSet ExecuteQuery(Connection conn, PreparedStatement preparedStatement, PreparedStatement lockStatement, String tablename)
Execute Query

String tablename_array[] = { tablename };
return ExecuteQuery(conn, preparedStatement, lockStatement, tablename_array);

void executeQuery(Connection connection)
execute Query

String sql01 = "INSERT INTO Persons (P_Id,LastName,FirstName,Address,City) VALUES (1,'Hansen','Ola','Timoteivn,10','Sandnes')";
String sql02 = "INSERT INTO Persons (P_Id,LastName,FirstName,Address,City) VALUES (2,'Svendson','Tove','Borgvn,23','Sandnes')";
String sql03 = "INSERT INTO Persons (P_Id,LastName,FirstName,Address,City) VALUES (3,'Pettersen','Kari','Storgt,20','Stavanger')";
String sql04 = "INSERT INTO Orders (O_Id,OrderNo,P_Id) VALUES (1,77895,3)";
String sql05 = "INSERT INTO Orders (O_Id,OrderNo,P_Id) VALUES (2,44678,3)";
String sql06 = "INSERT INTO Orders (O_Id,OrderNo,P_Id) VALUES (3,22456,2)";
String sql07 = "INSERT INTO Orders (O_Id,OrderNo,P_Id) VALUES (4,24562,1)";
Statement statement = null;
...

void executeQuery(Connection connection, String query)
execute Query

Statement statement = connection.createStatement();
int i = statement.executeUpdate(query);
if (i == -1) {
 System.err.println("database error : " + query);
statement.close();

Statement executeQuery(Connection dbConnection, String selectString)
Executes a select query.

Statement statement = dbConnection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
statement.executeQuery(selectString);
return statement;