public static int whereCount(String subsql) {
DBConnect dbc = null;
int result = EXECUTE_FAIL;
String sql = "select count(*) from tb_con_province where " + subsql + "";
try {
dbc = new DBConnect(sql);
ResultSet rs = dbc.executeQuery();
while (rs.next()) {
return rs.getInt(1);
}
return EXECUTE_FAIL;
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (dbc != null) dbc.close();
} catch (Exception e) {
e.printStackTrace();
}
}
return result;
}
public static List<TbConProvince> where(String subsql) {
DBConnect dbc = null;
String sql = "select * from tb_con_province where " + subsql + "";
List<TbConProvince> list = new ArrayList<TbConProvince>();
try {
dbc = new DBConnect(sql);
ResultSet rs = dbc.executeQuery();
while (rs.next()) {
TbConProvince tbconprovince = new TbConProvince();
fill(rs, tbconprovince);
list.add(tbconprovince);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (dbc != null) dbc.close();
} catch (Exception e) {
e.printStackTrace();
}
}
return list;
}
public static void fill(ResultSet rs, TbConProvince tbconprovince) throws SQLException {
tbconprovince.setPid(rs.getInt("pid")); // 自增长主键 省列表
tbconprovince.setPname(rs.getString("pname")); //
}