报错:
严重: Servlet.service() for servlet [tduserservlet] in context with path [/official] threw exception
java.lang.NullPointerException
at com.hext.w.daoIm.TduserIm.getuserbypage(TduserIm.java:134)
at com.hext.w.serviceIm.TduserserviceIm.getuserbypage(TduserserviceIm.java:39)
at servlet.tduserservlet.doPost(tduserservlet.java:53)
at servlet.tduserservlet.doGet(tduserservlet.java:28)代码段:
@Override
public List<Tduser> getuserbypage(Page page,Tduser condition) {
String sql="select * from tb_user where 1=1";
String conditionsql="";
if(condition!=null) {
if(condition.getUsername()!=null &&"".equals(condition.getUsername().trim())) {
conditionsql+="and username like'%"+condition.getUsername().trim()+"%' ";
}
if(condition.getUsername()!=null &&"".equals(condition.getUsername().trim())) {
conditionsql+="and password='"+condition.getPassword().trim()+"' ";
}
if(condition.getUsername()!=null &&"".equals(condition.getUsername().trim())) {
conditionsql+="and status="+condition.getStatus();
}
}
sql+=conditionsql;
sql+="order by createtime desc limit ?,?";
ResultSet rs=null;
Connection connection=null;
List<Tduser> list=new ArrayList<>();
connection=this.getconnection2();
rs=this.excuteQuery(sql,(page.getPageindex()-1)*page.getPagesize(),page.getPagesize()); try {
while(rs.next()) {
Tduser tduser=new Tduser();
tduser.setId(rs.getInt("id"));
tduser.setUsername(rs.getString("username"));
tduser.setPassword(rs.getString("password"));
tduser.setStatus(rs.getInt("status"));
tduser.setCreatetime(rs.getTimestamp("createtime"));
tduser.setRoleid(rs.getInt("role_id"));
list.add(tduser);}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
//String countsql="select count(1) count from tb_user";
String countsql="select count(1) count from tb_user where 1=1";
countsql+=conditionsql;
page.setTotalcount(totalcount(countsql));
return list;
}