SQL语句的拼凑

最新推荐文章于 2023-10-23 10:32:05 发布

weixin_30639719

最新推荐文章于 2023-10-23 10:32:05 发布

阅读量161

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/gdwkong/p/7634458.html

 1 StringBuilder sql = new StringBuilder("SELECT * FROM t_customer WHERE 1=1");
 2             /*
 3              * 2. 判断条件，完成向sql中追加where子句
 4              */
 5             /*
 6              * 3. 创建一个ArrayList，用来装载参数值
 7              */
 8             List<Object> params = new ArrayList<Object>();
 9             String cname = criteria.getCname();
10             if(cname != null && !cname.trim().isEmpty()) {
11                 sql.append(" and cname like ?");
12                 params.add("%" + cname + "%");
13             }
14 
15             String gender = criteria.getGender();
16             if(gender != null && !gender.trim().isEmpty()) {
17                 sql.append(" and gender=?");
18                 params.add(gender);
19             }
20 
21             String cellphone = criteria.getCellphone();
22             if(cellphone != null && !cellphone.trim().isEmpty()) {
23                 sql.append(" and cellphone like ?");
24                 params.add("%" + cellphone + "%");
25             }
26 
27             String email = criteria.getEmail();
28             if(email != null && !email.trim().isEmpty()) {
29                 sql.append(" and email like ?");
30                 params.add("%" + email + "%");
31             }