pcroomservice.java

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

package com.chinatelecom.service.impl;

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.TPcroom;
import com.chinatelecom.service.IPcroomService;
/**
 * 机房管理模块
 * 
 * @author 李海冰
 *
 */
public class PcroomService implements IPcroomService {
	SessionFactory sessionFactory;

	private static int ROWS_PER_PAGE = 4;

	public SessionFactory getSessionFactory() {
		return sessionFactory;
	}

	public void setSessionFactory(SessionFactory sessionFactory) {
		this.sessionFactory = sessionFactory;
	}
	/**
	 * 查到机房列表
	 */
	public List findPcroomAllList() {
		HibernateTemplate template = new HibernateTemplate(sessionFactory);
		List list = template.find("from TPcroom u where u.roomFlag=?", "Y");
		// System.out.println("list"+list.size());
		return list;

	}
	/**
	 * 新增机房
	 */
	public void addPcroot(TPcroom room) {
		// TODO Auto-generated method stub
		HibernateTemplate template = new HibernateTemplate(sessionFactory);
		template.save(room);
	}
	/**
	 * 删除机房
	 */
	public void deletePcrroom(Long[] s) {
		// TODO Auto-generated method stub
		HibernateTemplate template = new HibernateTemplate(sessionFactory);

		for (int i = 0; i < s.length; i++) {

			TPcroom room = (TPcroom) template.get(TPcroom.class, s[i]);
			room.setRoomFlag("N");
			template.update(room);
		}
	}
	/**
	 * 通过id来查找机房
	 */
	public TPcroom findPcroomById(Long id) {
		HibernateTemplate template = new HibernateTemplate(sessionFactory);
		TPcroom room = (TPcroom) template.get(TPcroom.class, id);
		return room;
	}
	/**
	 * 更新机房
	 */
	public void updatePcroom(TPcroom room) {
		HibernateTemplate template = new HibernateTemplate(sessionFactory);
		TPcroom rooms = (TPcroom) template.get(TPcroom.class, room.getRoomId());

		rooms.setRoomName(room.getRoomName());
		rooms.setTDept(room.getTDept());
		rooms.setTUser(room.getTUser());
		rooms.setRoomNote(room.getRoomNote());
		// System.out.println(rooms.getRoomId() + "========================");
		template.update(rooms);
		// session.update(rooms,room.getRoomId());

	}
	/**
	 * 查询机房
	 */
	public List findPcroom(String sql, String room, String address) {
		Session session = sessionFactory.openSession();

		if (!"".equals(room)) {
			room = "%" + room + "%";
			sql += " and p.roomName like ?";

		}
		if (!"".equals(address)) {
			address = "%" + address + "%";
			sql += " and p.roomAddress like ?";
		}
		//System.out.println(sql + "===========" + address);
		Query query = session.createQuery(sql);
		int flag = 0;
		if (!"".equals(room)) {
			query.setParameter(flag, room);
			flag = 1;
		}
		if (!"".equals(address)) {
			query.setParameter(flag, address);
		}
		List list = query.list();
		if (session.isOpen()) {
			session.close();
		}
		return list;
	}
	/**
	 * 查找机房列表
	 */
	public List findAllPcrooms(int page) {
		int startPage = (page - 1) * ROWS_PER_PAGE;
		Session session = this.getSessionFactory().openSession();
		Query q = session.createQuery("from TPcroom t where t.roomFlag = 'Y' ");
		q.setFirstResult(startPage);
		q.setMaxResults(ROWS_PER_PAGE);
		List list = q.list();
		if (session.isOpen()) {
			session.close();
		}
		return list;
	}
	/**
	 * 得到总页数
	 */
	public int getTotalPages() {
		int count = this.getTotalCounts();
		// System.out.println("count" + count);
		if ((count % ROWS_PER_PAGE) == 0) {
			return count / ROWS_PER_PAGE;
		} else {
			return count / ROWS_PER_PAGE + 1;
		}
	}
	/**
	 * 得到记录的总条数
	 * @return
	 */
	public int getTotalCounts() {
		HibernateTemplate template = new HibernateTemplate(sessionFactory);
		List list = template.find("from TPcroom p where p.roomFlag = 'Y'");
		return list.size();
	}
	/**
	 * 查询机房
	 */
	public List findPcroomByName(String name) {

		HibernateTemplate template = new HibernateTemplate(sessionFactory);
		List list = template.find("select p from TPcroom p where p.roomFlag = 'Y' and p.roomName='"
				+ name + "'");
		return list;
	}
}