Java Utililty Methods SQL Execute

List of utility methods to do SQL Execute

  1. HOME
  2. Java
  3. S
  4. SQL Execute

Description

The list of methods to do SQL Execute are organized into topic(s).

Method

List>executeImmediate(String sql)
execute Immediate 
List<List<String>> results = new ArrayList<List<String>>();
Connection conn = null;
Statement statement = null;
try {
    Class.forName("com.mysql.jdbc.Driver");
    conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "gary", "12345");
    conn.setAutoCommit(false);
    statement = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
...
longexecuteInsert(Connection conn, String sql, boolean hasAutoGeneratedKey, Object... parameters)
execute Insert 
PreparedStatement stmt = null;
ResultSet generatedKeysResultSet = null;
long result = -1;
try {
    if (hasAutoGeneratedKey) {
        stmt = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
    } else {
        stmt = conn.prepareStatement(sql);
...
voidexecuteInsert(Connection conn, String targetTable, String destinationTable)
execute Insert 
System.out.println("Attempting bulk insert using st_pointFromWKB");
PreparedStatement p_stmt = null;
int count = 0;
String query = "INSERT INTO " + destinationTable
        + " (objectid, shape) VALUES (?, sde.st_pointFromWKB(?, 2230))";
Map<Integer, byte[]> results = getShapeText(conn, targetTable);
try {
    conn.setAutoCommit(true);
...
intexecuteInsertSQL(String sql)
execute Insert SQL 
int b;
System.out.println(sql + ";");
b = stmt.executeUpdate(sql);
return b;
voidexecuteQueries(Connection conn, InputStream stream)
execute Queries 
BufferedReader reader = new BufferedReader(new InputStreamReader(stream, Charset.forName("UTF-8")));
StringBuffer buf = new StringBuffer();
String line;
while ((line = reader.readLine()) != null) {
    buf.append(line.trim());
String[] queries = buf.toString().split(";");
Statement stmt = conn.createStatement();
...
voidexecuteResource(Connection con, String resource)
execute Resource 
InputStream ins = Thread.currentThread().getContextClassLoader().getResourceAsStream(resource);
byte[] b = new byte[ins.available()];
ins.read(b);
con.createStatement().execute(new String(b));
voidexecuteSetArgs(PreparedStatement stmt, Object... args)
execute Set Args 
for (int i = 0; i < args.length; ++i) {
    stmt.setObject(i + 1, args[i]);
int n = stmt.getParameterMetaData().getParameterCount();
for (int i = args.length; i < n; ++i) {
    stmt.setObject(i + 1, null);
voidexecuteShutDownForHSQL(java.sql.Connection connection)
execute ShutDown For HSQL connection. 
Statement statement = connection.createStatement();
statement.executeUpdate("SHUTDOWN;");
statement.close();
intexecuteSP(Connection conn, String spName, Object... parameters)
execute SP 
CallableStatement stmt = null;
int result = -1;
try {
    String sql = getCallStatementSQL(spName, parameters.length);
    stmt = conn.prepareCall(sql);
    bindParams(stmt, parameters);
    result = stmt.executeUpdate();
} finally {
...
booleanexecuteSql(Connection conn, String sql)
execute Sql 
Statement stmt = null;
try {
    stmt = conn.createStatement();
    return stmt.execute(sql);
} catch (Exception e) {
    throw e;
} finally {
    if (stmt != null) {
...