/**
* Convenience method for selecting records. Ideally this should not be use, instead a custom
* query for this table should be used.
*
* @param where sql where statement.
* @param orderBy sql order by statement
*/
public ResultSet select(String where, String orderBy) {
ResultSet rs = null;
java.sql.Statement stmnt = null;
try {
stmnt = GenOrmDataSource.createStatement();
StringBuilder sb = new StringBuilder();
sb.append(SELECT);
sb.append(FROM);
if (where != null) {
sb.append(WHERE);
sb.append(where);
}
if (orderBy != null) {
sb.append(" ");
sb.append(orderBy);
}
String query = sb.toString();
rs = new SQLResultSet(stmnt.executeQuery(query), query, stmnt);
} catch (java.sql.SQLException sqle) {
try {
if (stmnt != null) stmnt.close();
} catch (java.sql.SQLException sqle2) {
}
throw new GenOrmException(sqle);
}
return (rs);
}
/**
* Closes any underlying java.sql.Result set and java.sql.Statement that was used to create this
* results set.
*/
public void close() {
try {
m_resultSet.close();
m_statement.close();
} catch (java.sql.SQLException sqle) {
throw new GenOrmException(sqle);
}
}
/**
* This resets the key generator from the values in the database Usefull if the generated key
* has been modified via some other means Connection must be open before calling this
*/
public synchronized void reset() {
m_nextKey = 0;
java.sql.Statement stmnt = null;
java.sql.ResultSet rs = null;
try {
stmnt = GenOrmDataSource.createStatement();
rs = stmnt.executeQuery(MAX_QUERY);
if (rs.next()) m_nextKey = rs.getInt(1);
} catch (java.sql.SQLException sqle) {
// The exception may occur if the table does not yet exist
if (WARNINGS) System.out.println(sqle);
} finally {
try {
if (rs != null) rs.close();
if (stmnt != null) stmnt.close();
} catch (java.sql.SQLException sqle2) {
throw new GenOrmException(sqle2);
}
}
}
public DataPointKeyGenerator(javax.sql.DataSource ds) {
m_nextKey = 0;
java.sql.Connection con = null;
java.sql.Statement stmnt = null;
try {
con = ds.getConnection();
con.setAutoCommit(true);
stmnt = con.createStatement();
java.sql.ResultSet rs = stmnt.executeQuery(MAX_QUERY);
if (rs.next()) m_nextKey = rs.getInt(1);
rs.close();
} catch (java.sql.SQLException sqle) {
// The exception may occur if the table does not yet exist
if (WARNINGS) System.out.println(sqle);
} finally {
try {
if (stmnt != null) stmnt.close();
if (con != null) con.close();
} catch (java.sql.SQLException sqle) {
}
}
}