1. entityManager createNativeQuery 查询功能
/**
* @Author: linkar
* @Date: 2022/7/4
* @Description: 分页获取数据
* @Param mysql: 传入的sql 如 select a,b from tablename where c=:c order by a (c 为参数)
* @Param s: sql查询放到class类名
* @Param parameter: 动态参数
* @Param pageindex: 1
* @Param pagesize: 30
* @return: DTO_PageData<java.lang.Class>
**/
public DTO_PageData<Class> exeSqlClass(String mysql, Class s, Map<String,String> parameter,Integer pageindex,Integer pagesize){
DTO_PageData<Class> pageData= DTO_PageData.<Class>builder().build();
Query querycount = entityManager.createNativeQuery(String.format("select count(1) from ( %s)",mysql));
Query query = entityManager.createNativeQuery(mysql,s);
if(parameter!=null&¶meter.size()>0){
parameter.forEach((k,v)->{