long dCountRec(java.sql.Statement stat, String table, String sWhere) { long lNumRecs = 0; try { java.sql.ResultSet rs = stat.executeQuery("select count(*) from " + table + " where " + sWhere); if (rs != null && rs.next()) { lNumRecs = rs.getLong(1); } rs.close(); } catch (Exception e) { } ; return lNumRecs; }
java.sql.ResultSet openrs(java.sql.Statement stat, String sql) throws java.sql.SQLException { java.sql.ResultSet rs = stat.executeQuery(sql); return (rs); }