通过java反射机制获取并进行封装操作QueryWrapper
之前用的一种 封装的方式(见QueryWrapper自定义查询),那现在通过另一种方法来处理前端伟来的参数进行封装QueryWrapper,
根本的目地还是组装好并得到QueryWrapper进行sql查询。
一、前端
<%--
Created by IntelliJ IDEA.
User: Administrator
Date: 2020/12/16 0016
Time: 8:37
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<form action="./tkController/getTkList" method="post">
试题编号:<input type="text" name="tid"/><br/>
题目:<input type="text" name="tm"/><br/>
<button type="submit">查询</button>
</form>
</body>
</html>
二、后端
Controller
package com.example.demo.controller;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.example.demo.beans.TkBean;
import com.example.demo.dao.TkDao;
import com.example.demo.utils.RequestParamUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;
import java.util.List;
@Controller
@RequestMapping("/tkController")
public class TkController {
@Autowired
private TkDao tkDao;
@RequestMapping(value = "/getTkList",method = RequestMethod.POST)
public @ResponseBody List<TkBean> getTkList(TkBean tkBean)throws Exception{
QueryWrapper<TkBean> queryWrapper=new QueryWrapper<TkBean>();
RequestParamUtils.getQuery(queryWrapper,tkBean);
List<TkBean> list=tkDao.selectList(queryWrapper);
return list;
}
}
RequestParamUtils
package com.example.demo.utils;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import java.lang.reflect.Field;
import java.lang.reflect.Method;
/**通过java反射机制获取该类的所有属性类型、值 **/
public class RequestParamUtils {
public static <ENTITY> void getQuery( QueryWrapper<ENTITY> queryWrapper,Object object) throws Exception{
// 拿到该类
Class<?> clz = object.getClass();
// 获取实体类的所有属性,返回Field数组
Field[] fields = clz.getDeclaredFields();
for (Field field : fields) {
//System.out.println(field.getGenericType());//打印该类的所有属性类型
Method m = (Method) object.getClass().getMethod( "get" + getMethodName(field.getName()));
Object val = m.invoke(object);// 调用getter方法获取属性值
// 如果类型是int或Integer
if (field.getGenericType().toString().equals("int")||field.getGenericType().toString().equals("class java.lang.Integer")) {
val="";
}
if (val != null&&val!="null"&&String.valueOf(val).length()>0) {
queryWrapper.like(field.getName(),val);
}
}
}
// 把一个字符串的第一个字母大写、效率是最高的、
private static String getMethodName(String fildeName) throws Exception{
byte[] items = fildeName.getBytes();
items[0] = (byte) ((char) items[0] - 'a' + 'A');
return new String(items);
}
}
TkDao
package com.example.demo.dao;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.demo.beans.TkBean;
public interface TkDao extends BaseMapper<TkBean> {
}
日志打印
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1616aa31] was not registered for synchronization because synchronization is not active
2020-12-16 10:36:30.178 INFO 11824 --- [nio-8080-exec-1] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2020-12-16 10:36:30.382 INFO 11824 --- [nio-8080-exec-1] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.
JDBC Connection [HikariProxyConnection@1924526602 wrapping com.mysql.cj.jdbc.ConnectionImpl@64e85f51] will not be managed by Spring
==> Preparing: SELECT id,tm,tid,da FROM tb_pxks_tkgl WHERE (tid LIKE ?)
==> Parameters: %16061194810459%(String)
<== Columns: id, tm, tid, da
<== Row: 144, 九龙洞内最高的一根钟乳柱高达( )米,为亚洲第一、世界第二高的钟乳柱。, 16061194810459, A
<== Total: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1616aa31]
最后留下一个没有标出来的问题,如何判定哪些参数是什么类型的查询(如eq、ne、like、gt、lt、ge、le、isnotnull、isnull、leftlike、rightlike等等),欢迎大家留言。
只是为了学习使用,贴出代码,供大家学习参考。