如题,我用这个模糊查询什么结果都查不到,在数据库执行这条语句是可以的,帮忙找下原因,会不会跟connection类型有关Stringsql="selectid,user_umber,meter_number,name,address,cou...
如题,我用这个模糊查询什么结果都查不到,在数据库执行这条语句是可以的,帮忙找下原因,会不会跟connection类型有关
String sql = "select id,user_umber,meter_number,name,address,count_num,purchases,meters_num,company_name,magnification,is_del,creation_time,update_time from t_user_info where is_del!=1 ";
String sqlcount = "select count(id) from t_user_info where is_del!=1 ";
if(username!=null && !"".equals(username)){
username = "'%"+username+"%'";
sql += " and name like ?";
sqlcount += " and name like ?";
parList.add(username);
}
if(user_umber!=null && !"".equals(user_umber)){
sql += " and user_umber=? ";
sqlcount += " and user_umber=? ";
parList.add(user_umber);
}
sql += " order by id limit " + record + " offset " + start;
PooledConnection conn = DBManager.getConnection();
ResultSet rs = null;
try {
rs = conn.executeQuery(sqlcount, (String[])parList.toArray(new String[parList.size()]));
if (rs.next()) { // 光标向后移动,并判断是否有效
pagecount = rs.getInt(1); // 对总记录数赋值
}
rs = conn.executeQuery(sql, (String[])parList.toArray(new String[parList.size()]));
展开