public List<UserFormBean> getAllUserInfo(UserFormBean userFormBean)
{
StringBuffer sql = new StringBuffer("select USERID,USERNAME,PASSWORD,REALNAME,SEX,INTEREST,DEGREE,INTRO,STATUS from demo_userinfo where 1=1");
String username = userFormBean.getUserName();
String interest = userFormBean.getInterest();
//如果查询条件不空,则增加此条件;
if(username != null && !"".equals(username)){
sql.append(" and username like '%"+username+"%'");
}
if(interest != null && !"".equals(interest)){
sql.append(" and interest = '"+interest+"'");
}
sql.append(" order by USERID");
PreparedStatement pstm = null;
ResultSet rs = null;
Connection con = null;
List<UserFormBean> resultList
前台页面查询参数多的话,建议将其封装成querybean传到DAO层,在DAO层构建SQL语句:例子
最新推荐文章于 2022-07-18 19:37:42 发布
该博客展示了如何将前端查询参数封装到UserFormBean中,并在DAO层根据这些参数动态构建SQL查询语句,以实现更加灵活的查询功能。在示例中,当用户名或兴趣不为空时,它们会被加入到SQL的WHERE子句中,最后按USERID进行排序。
摘要由CSDN通过智能技术生成