| Methods in uk.ac.ed.inf.utils.database with parameters of type DbConn |
static boolean |
DbUtils.elementExistsInTable(java.lang.String table,
java.lang.String column,
java.lang.String element,
DbConn dbConn)
Get if an element exists in a table column |
static boolean |
DbUtils.elementsExistsInTable(java.lang.String table,
java.lang.String column1,
java.lang.String element1,
java.lang.String column2,
java.lang.String element2,
DbConn dbConn)
Get if two elements exists in the same table row |
static boolean |
DbUtils.existsInTable(java.lang.String query,
DbConn dbConn)
|
static java.sql.ResultSet |
DbUtils.getResultSet(java.lang.String sql,
DbConn dbConn)
Executes an sql query returning a result set |
static boolean |
DbUtils.insert(DbConn conn,
java.lang.String insertSql)
Executes sql insert and returns whether the insert was successful. |
static java.lang.Integer |
DbUtils.insertReturnsKey(DbConn conn,
java.lang.String insertSql)
Executes sql insert and returns the auto generated key for the first
inserted row. |
static boolean |
DbUtils.similarElementExistsInTable(java.lang.String table,
java.lang.String column,
java.lang.String element,
DbConn dbConn)
|