java/com/liujian/gymxmjpa/service/LoosDaoImpl.java

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

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

package com.liujian.gymxmjpa.service;

import com.liujian.gymxmjpa.dao.LoosDao;
import com.liujian.gymxmjpa.entity.Loos;
import org.springframework.beans.factory.annotation.Autowired;
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/14
 */
@Service
public class LoosDaoImpl {
    @Autowired
    private LoosDao loosDao;
    @PersistenceContext
    private EntityManager entityManager;

    /**
     * @Description: 遗失物品管理service实现层-分页查询
     * @Author: LiuJian
     * @Date: 2020/4/14
     */
    public Map<String,Object> query(Map<String,Object> map1){
        //分页
        String jpal="from Loos where 1=1";
        if(map1.get("loosName")!=null && !map1.get("loosName").equals("")){
            jpal=jpal+" and loosName like '%"+map1.get("loosName")+"%'";
        }
        Query qu=entityManager.createQuery(jpal);
        //起始页书
        qu.setFirstResult((int)map1.get("qi"));
        //结束页数
        qu.setMaxResults((int)map1.get("shi"));

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

        if(map1.get("loosName")!=null && !map1.get("loosName").equals("")){
            jpa=jpa+" and loosName like '%"+map1.get("loosName")+"%'";
        }
        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/14
     */