Revision as of 17:35, 22 March 2011 by Han84 (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
/**
 * Get the Statement from SQL Connection.
 * @param conn the SQL Connection
 * @return
 */
public static java.sql.Statement sqlGetStatement(java.sql.Connection conn) {
	java.sql.Statement stat = null;
	try {
//		stat = conn.createStatement();
		stat = conn.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE, java.sql.ResultSet.CONCUR_READ_ONLY);
	} catch (java.sql.SQLException ex) {
		Ts.printErr(ex);
	}
	return stat;
}
 
public static void printErr(java.sql.SQLException ex) {
	System.out.println("SQL State: " + ex.getSQLState());
	System.out.println("Error Code: " + ex.getErrorCode());
	Ts.printErr((java.lang.Exception) ex);
}
 
public static void printErr(java.lang.Exception ex) {
	ex.printStackTrace();
	System.exit(-1);
}


Back to JavaHowTo

Alumni Liaison

Correspondence Chess Grandmaster and Purdue Alumni

Prof. Dan Fleetwood