java/com/liujian/gymxmjpa/service/PrivateCoachDaoImpl.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.liujian.gymxmjpa.service;

import org.springframework.stereotype.Service;

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;
import java.util.HashMap;
import java.util.Map;

/**
 * @Description: 会员私教课程service实现层
 * @Author: LiuJian
 * @Date: 2020/4/9
 */
@Service
public class PrivateCoachDaoImpl {

    @PersistenceContext
    private EntityManager entityManager;

    /**
     * @Description: 会员私教课程service实现层-分页查询
     * @Author: LiuJian
     * @Date: 2020/4/9
     */
    public Map<String,Object> query(Map<String,Object> map1){
        //分页
        String jpal="from Coach where 1=1";
        if(map1.get("coachname")!=null && !map1.get("coachname").equals("")){
            jpal=jpal+" and coachName like '%"+map1.get("coachname")+"%'";
        }
        Query qu=entityManager.createQuery(jpal);
        //起始页书
        qu.setFirstResult((int)map1.get("qi"));
        //结束页数
        qu.setMaxResults((int)map1.get("shi"));

        //查询多少条数据
        String jpa="select count(c) from Coach c where 1=1";

        if(map1.get("coachname")!=null && !map1.get("coachname").equals("")){
            jpa=jpa+" and coachName like '%"+map1.get("coachname")+"%'";
        }

        Long count=(Long) entityManager.createQuery(jpa).getSingleResult();
        Map<String,Object> map=new HashMap<String,Object>();
        map.put("total",count);
        map.put("rows",qu.getResultList());
        return map;
    }

    /**
     * @Description: 会员私教课程service实现层-分页查询
     * @Author: LiuJian
     * @Date: 2020/4/9
     */
    public Map<String,Object> query2(Map<String,Object> map1){
        //分页
        String jpal="from Member where 1=1";