JavaHowTo SqlUpdateQuery - Rhea

/**
 * Update database.
 * @param stat the Statement object
 * @param query the query that is intended to execute
 * @return the number of updated rows
 */
public static int sqlUpdateQuery(java.sql.Statement stat, String query) {
	int result = 0;
	try {
		result = stat.executeUpdate(query);
	} catch (java.sql.SQLException ex) {
		// Ignoring the exception like below line is not good.
		// It will cause severe unnoticible problems.
//			return 0;
		// Do not add ";" at the end of the query.
		// It will cause the error (ORA-00911: invalid character) if you use Oracle.
		Ts.printErr(ex);
	}
	return result;
}
 
 
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);
}