permissiondao.java

一个关于物流的管理系统

package com.shunshi.ssh.dao;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Collection;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.shunshi.ssh.entity.Permission;
import com.shunshi.ssh.entity.User;

public class PermissionDAO extends HibernateDaoSupport implements IPermissionDAO {


	public void save(Permission permission) {
		try {
			getHibernateTemplate().saveOrUpdate(permission);
		} catch (RuntimeException re) {
			throw re;
		}
	}

	public void delete(Permission permission) {
		try {
			getHibernateTemplate().delete(permission);
		} catch (RuntimeException re) {
			throw re;
		}
	}

	public Permission findById(Integer id) {
		try {
			Permission permission = (Permission) getHibernateTemplate().get(
					"com.shunshi.ssh.entity.Permission", id);
			return permission;
		} catch (RuntimeException re) {
			throw re;
		}
	}

	public Collection findByProperty(String propertyName, Object value) {
		try {
			String queryString = "from Permission as model where model."
					+ propertyName + "= ?";
			return getHibernateTemplate().find(queryString, value);
		} catch (RuntimeException re) {
			throw re;
		}
	}

	public Collection findAll() {
		try {
			String queryString = "from Permission";
			return getHibernateTemplate().find(queryString);
		} catch (RuntimeException re) {
			throw re;
		}
	}

	public void update(Permission permission) {
		try {
			getHibernateTemplate().saveOrUpdate(permission);
		} catch (RuntimeException re) {
			throw re;
		}
	}

	public List findPermissionsInfoByAll(final int startRow,final int maxRowNum) {
		List usersInfo=(List)getHibernateTemplate().execute(new HibernateCallback(){
			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {
				Query query=session.createQuery("select permissions from Permission permissions");
				query.setMaxResults(maxRowNum);
				query.setFirstResult(startRow);
				List permissionsInfo=new ArrayList();
				List permissions=query.list();
				for(int i=0;i<permissions.size();i++){
					Permission permissionInfo=(Permission)permissions.get(i);
					Map permissionMap=new HashMap();
					permissionMap.put("description",permissionInfo.getDescription());
					permissionMap.put("id",permissionInfo.getId());
					permissionsInfo.add(permissionMap);
				}
				return permissionsInfo;
			}
		});
		return usersInfo;
	}

	public Long getTotalRowsByAll() {
		return (Long)getHibernateTemplate().find("select count(*) from Permission permissions").get(0);
	}

}