模糊查询:
要先获取前端发送的数据,例如模糊查询的名字和性别,然后根据查询的字段写sql语句,分别有以下几种情况:
1、查询的有名字和性别:
"select * from t_user where 1=1 and username like +" % username % +" and sex ="+sex+" limit 0,5"
2、查询的只有名字
"select * from t_user where 1=1 and username like "+ %username % +"" limit 0,5"
3、查询放只有性别
"select * from t_user where 1=1 and sex ="+sex+" limit 0,5"
controller层
service层
dao层