记录一下做项目时jpa分页查询,使用entityManager执行sql
SQLUtils
/**
* 自定义sql封装类
*/
public class SqlUtils {
private static final String QUERY_SQL="SELECT " +
"s.edition," +
"s.name," +
"p.manager_name," +
"p.project_stage" +
" FROM " +
"xxxxx s" +
" LEFT JOIN yyyy p ON s.id = p.xxxx_id ";
public static String applyQuerySql(String condition,Integer nowPage,Integer pageSize){
Integer start = (nowPage-1)*pageSize;
String limit = " limit "+start+","+pageSize;
if(condition!=null){
String patchwork = "where p.name like '%"+condition+"%'";
return QUERY_SQL+patchwork+limit;
}
return QUERY