Difference between revisions of "JavaHowTo SqlExecuteQuery" - Rhea

public static java.sql.ResultSet sqlExecuteQuery(java.sql.PreparedStatement pre) {
	java.sql.ResultSet rs = null;
	try {
		rs = pre.executeQuery();
	} catch (java.sql.SQLException ex) {
		Ts.printErr(ex);
	}
	return rs;
}
 
public static java.sql.ResultSet sqlExecuteQuery(java.sql.PreparedStatement pre, int... para) {
	java.sql.ResultSet rs = null;
	try {
		for (int i = 0; i < para.length; i++) {
			pre.setInt(i + 1, para[i]);
		}
		rs = pre.executeQuery();
	} catch (java.sql.SQLException ex) {
		Ts.printErr(ex);
	}
	return rs;
}
 
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);
}