各位大佬,本人自学小白求教
现在已得到
String[] interest = req.getParameterValues("interest");
for (int i = 0; i < interest.length; i++) {
System.out.println(interest[i]);
}
String date1 = req.getParameter("date1");
String date2 = req.getParameter("date2");
两个请求,然后怎么通过得到的请求传送给mapper.xml 进行sql搜索
sql语句是
SELECT
ch.pin,
ch.checktime,
us.badgenumber,
us.name,
us.defaultdeptid
FROM
checkinout ch
LEFT JOIN
userinfo us on ch.pin=us.badgenumber
WHERE
ch.checktime between '2019/04/01' AND '2019/04/30'
AND
us.defaultdeptid IN (3,4);