YtIoT/src/cn/com/usky/log/LogServiceImpl.java

package cn.com.usky.log;


import cn.com.usky.iot.entity.sys.SysLogDTO;
import cn.com.usky.utils.Page;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.HibernateTemplate;

import java.sql.SQLException;
import java.util.List;

/**
 * @author laowo
 * @version v1.0
 * @date 2021/7/14 14:10
 * @description TODO
 **/

public class LogServiceImpl implements LogService {
    private HibernateTemplate hibernateTemplate;

    public HibernateTemplate getHibernateTemplate() {
        return hibernateTemplate;
    }

    public void setHibernateTemplate(HibernateTemplate hibernateTemplate) {
        this.hibernateTemplate = hibernateTemplate;
    }

    @Override
    public void addLog(SysLogDTO dto) {
        hibernateTemplate.save(dto);

    }

    @Override
    public Page<SysLogDTO> queryLogList(Integer pageSize, Integer pageNo, String vLoginname) {

        List<SysLogDTO> list = hibernateTemplate.executeFind(new HibernateCallback() {
            @Override
            public Object doInHibernate(Session session) throws HibernateException, SQLException {
                Query query = session.createQuery("from SysLogDTO t where t.userid='"+vLoginname+"'");
                return query.list();
            }
        });
        List<SysLogDTO> listPage = hibernateTemplate.executeFind(new HibernateCallback() {
            @Override
            public Object doInHibernate(Session session) throws HibernateException, SQLException {
                Query query = session.createQuery("from SysLogDTO t where t.userid='"+vLoginname+"' order by t.createTime DESC");
                query.setFirstResult((pageNo - 1) * pageSize);
                query.setMaxResults(pageSize);
                return query.list();
            }
        });
        Page<SysLogDTO> result = new Page<>(list.size(), pageSize);
        result.setPageList(listPage);
        return result;
    }
}