一.解决前端传值乱码问题(JAVA)
batchNO = new String(request.getParameter(“batchNO”).getBytes(“iso8859-1”),“utf-8”);
例如:
问题解决之前:
解决之后:
//URL传中文参数乱码进行参数值转码
batchNO = new String(request.getParameter("batchNO").getBytes("iso8859-1"),"utf-8");`在这里插入代码片`
附加:
3.Mybatis-PLUS条件构造查询
setSqlSelect 设置SELECT查询字段
where WHERE语句,拼接 - WHERE条件
and AND语句,拼接 - AND 字段=值
andNew AND语句,拼接 - AND (字段=值)
or OR语句,拼接 - OR 字段=值
orNew OR语句,拼接 - OR(字段=值)
eq 等于=
allEq 基于map内容等于=
ne 不等于<>
gt 大于>
ge 大于等于>=
lt 小于<
le 小于等于<=
like 模糊查询LIKE
notLike 模糊查询NOT LIKE
in IN查询
notin NOT IN查询
isNull NULL值查询
isNotNull IS NOT NULL
groupBy 分组GROUP BY
having HAVING关键词
orderBy 排序ORDER BY
orderAsc ASC排序ORDER BY
orderDesc DESC排序ORDER BY
exists EXISTS条件语句
notExists NOT EXISTS条件语句
between BETWEEN条件语句
notBetween NOT BETWEEN条件语句
addFilter 自由拼接SQL
last 拼接在最后,例如last("LIMIT 1")