public Date selectNow(Connection con) throws SQLException { Statement st = null; ResultSet rs = null; try { st = con.createStatement(); rs = st.executeQuery("SELECT now()"); rs.next(); return JDBCUtils.getDate(rs, rs.getMetaData().getColumnName(1)); } finally { cleanup(null, st, rs); } }
public int lastInsertId(Connection con) throws SQLException { int ret = 0; Statement st = null; ResultSet rs = null; try { st = con.createStatement(); rs = st.executeQuery(lastInsertIdQuery); if (rs.next()) { ret = rs.getInt(1); } } finally { JDBCUtils.cleanup(null, st, rs); } return ret; }