Code example for CallableStatement

Methods: execute

0
	 *             If for some reason the query fails. 
	 */ 
	public void call(String procedureQuery) throws SQLException {
		CallableStatement cStmt = databaseConnection.prepareCall("{call "
				+ procedureQuery + "}");
		cStmt.execute();
	} 
 
	/** 
	 * Commits all the work done in this connection. This may fail if the 
	 * connection is already closed. The connection will be closed if the commit 
	 * is done. 
	 */ 
	public void commit() { 
		try { 
			databaseConnection.commit();
			close(); 
		} catch (SQLException e) {
			e.printStackTrace();
		} 
	}