使用where 1=1 AND 的方式更好
反面例子:
select count(*) from user
遍历map,判断其value是否有值
sb.append("WHERE key like ?");
如果是有多个条件:
sb.append("WHERE key like ?");
就会造成sql语句拼接完是:select count(*) from user WHERE key like ? WHERE key like ?
sql语句错误
使用where 1=1 AND 的方式更好
反面例子:
select count(*) from user
遍历map,判断其value是否有值
sb.append("WHERE key like ?");
如果是有多个条件:
sb.append("WHERE key like ?");
就会造成sql语句拼接完是:select count(*) from user WHERE key like ? WHERE key like ?
sql语句错误
转载于:https://my.oschina.net/u/3668429/blog/3044934