sql语句的拼接和写法

sql语句的拼接和写法

1.sql语句可以使用StringBuilder来进行拼接
例如：StringBuilder targetWhereSql = new StringBuilder(“”);
targetWhereSql.append(” and (cu.name like ‘%”).append(name).append(“%’ or cu.email like ‘%”).append(name).append(“%’) “);

1. 使用 DATE_FORMAT
2. timeSQL = ” and DATE_FORMAT(corder.end_time,’%Y-%m-%d’)>=’” + start + “’ and DATE_FORMAT(corder.end_time,’%Y-%m-%d’)<=’” + end + “’ “;
3. DATEDIFF(NOW(),cu.create_date) as time