logserviceimpl.java

一个简单的用Spring+Hibernate+Struts的亿阳信通系统

package com.chinatelecom.service.impl;

import java.util.Date;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.springframework.orm.hibernate3.HibernateTemplate;

import com.chinatelecom.mode.TLog;
import com.chinatelecom.service.IlogService;
/**
 * 日志管理模块
 * @author 李海冰
 *
 */
public class logServiceImpl implements IlogService {
	SessionFactory sessionFactory;

	public SessionFactory getSessionFactory() {
		return sessionFactory;
	}

	public void setSessionFactory(SessionFactory sessionFactory) {
		this.sessionFactory = sessionFactory;
	}
	//每页的条数
	private static int ROWS_PER_PAGE = 4;
	/**
	 * 得到总页数
	 */
	public int getlogPages(String sql, String mod) {
		// TODO Auto-generated method stub
		int count = this.getTotalCounts(sql, mod);
		// System.out.println("count" + count);
		if ((count % ROWS_PER_PAGE) == 0) {
			return count / ROWS_PER_PAGE;
		} else {
			return count / ROWS_PER_PAGE + 1;
		}
	}
	/**
	 * 得到日志列表
	 */
	public List findAlllogs(int page, String sql, String mod) {
		int startPage = (page - 1) * ROWS_PER_PAGE;
		if (!"".equals(mod)) {
			sql = sql + " and p.logModule=?";
		}
		Session session = this.getSessionFactory().openSession();
		Query q = session.createQuery(sql);
		if (!"".equals(mod)) {
			q.setParameter(0, mod);
		}
		q.setFirstResult(startPage);
		q.setMaxResults(ROWS_PER_PAGE);
		List list = q.list();
		if (session.isOpen()) {
			session.close();
		}
		return list;
	}
	/**
	 * 得到总条数
	 */
	public int getTotalCounts(String sql, String mod) {
		if (!"".equals(mod)) {
			sql = sql + " and p.logModule=?";
		}
		Session session = this.getSessionFactory().openSession();
		Query q = session.createQuery(sql);
		if (!"".equals(mod)) {
			q.setParameter(0, mod);
		}
		List list = q.list();
		if (session.isOpen()) {
			session.close();
		}
		return list.size();
	}
	/**
	 * 新增日志
	 * @param module
	 * @param operation
	 * @param user
	 */
	public void addLog(String module, String operation, String user) {
		TLog log = new TLog();
		Date date = new Date();
		log.setLogTime(date);
		log.setLogOperation(operation);
		log.setLogModule(module);
		log.setLogUser(user);
		HibernateTemplate ht = new HibernateTemplate(sessionFactory);
		ht.save(log);
	}
}