Connection: prepareCall(String sql)
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class Main {
public static void main(String[] args) throws Exception {
CallableStatement cs = conn.prepareCall("{call StoreProcedureName}");
ResultSet rs = cs.executeQuery();
while (rs.next()) {
System.out.println("Defunct user: " + rs.getString("user"));
}
}
static Connection conn;
static Statement st;
public static void setup() {
try {
// Step 1: Load the JDBC driver.
Class.forName("org.hsqldb.jdbcDriver");
System.out.println("Driver Loaded.");
// Step 2: Establish the connection to the database.
String url = "jdbc:hsqldb:data/tutorial";
conn = DriverManager.getConnection(url, "sa", "");
System.out.println("Got Connection.");
st = conn.createStatement();
} catch (Exception e) {
System.err.println("Got an exception! ");
e.printStackTrace();
System.exit(0);
}
}
}
Related examples in the same category
