roledaoimpl.java

一个完整的物流系统

package jp.com.cost.dao.impl;

import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import jp.com.cost.common.Log;
import jp.com.cost.dao.RoleDao;
import jp.com.cost.pojo.Role;
import jp.com.cost.xt.entity.XT6104ViewEntity1;

import jp.com.cost.xt.entity.XT6201ViewEntity1;

import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;


public class RoleDaoImpl extends HibernateDaoSupport implements RoleDao {

	Session session;
	Query query;
	
	//莫建超的方法　　　Start
	public List findARByAid(int id) {
		// TODO Auto-generated method stub
		String SQL = "select rid,rolename from role where rid IN(select rid from accountrole where aid='"
			+ id+"')";
		session = getHibernateTemplate().getSessionFactory().openSession();
		query = session.createSQLQuery(SQL);
		List<Object> list = query.list();
		List list1 = new ArrayList();
		for (int i = 0; i < list.size(); i++) {
			Object[] obj = (Object[]) list.get(i);
			XT6104ViewEntity1 xt6104= new XT6104ViewEntity1();
			xt6104.setRid((Integer)obj[0]);
			xt6104.setRolename(obj[1].toString());
			list1.add(xt6104);
		}
		session.close();
		return list1;
	}

	public List findAllRole() {
		// TODO Auto-generated method stub
		String SQL = "select rid,rolename from role";
		session = getHibernateTemplate().getSessionFactory().openSession();
		query = session.createSQLQuery(SQL);
		List<Object> list = query.list();
		List list1 = new ArrayList();
		for (int i = 0; i < list.size(); i++) {
			Object[] obj = (Object[]) list.get(i);
			XT6104ViewEntity1 xt6104= new XT6104ViewEntity1();
			xt6104.setRid((Integer)obj[0]);
			xt6104.setRolename(obj[1].toString());
			list1.add(xt6104);
		}
		session.close();
		return list1;
	}

	public List findAROther(int id) {
		String SQL = "select rid,rolename from role where rid NOT IN(select rid from accountrole where aid='"
			+ id+"')";
		session = getHibernateTemplate().getSessionFactory().openSession();
		query = session.createSQLQuery(SQL);
		List<Object> list = query.list();
		List list1 = new ArrayList();
		for (int i = 0; i < list.size(); i++) {
			Object[] obj = (Object[]) list.get(i);
			XT6104ViewEntity1 xt6104= new XT6104ViewEntity1();
			xt6104.setRid((Integer)obj[0]);
			xt6104.setRolename(obj[1].toString());
			list1.add(xt6104);
		}
		session.close();
		return list1;
	}
	//莫建超的方法　　　End
	
	//刘正国的方法　　　Start
	/**
	  * 从数据库中查询rid和rolename;
	  */
	public List findAll() {
		String sql="SELECT	rid,rolename  FROM role ";
	    session=getHibernateTemplate().getSessionFactory().openSession();
		query=session.createSQLQuery(sql); 
		List<Object> list =query.list();
		List list1 = new ArrayList();
 		for(int i=0;i<list.size();i++){
			Object[] obj = (Object[])list.get(i);
	 		XT6201ViewEntity1 a = new XT6201ViewEntity1();
			a.setRid((Integer)obj[0]);
			a.setRoleName(obj[1].toString());
			list1.add(a);  
		}
		session.close();
		return list1;
		
	}
	
	/**
	 * 根据输入条件查询角色名称的方法：
	 */
	public List findByCon(String roleName) {
		String sql="SELECT	rid,rolename  FROM role where 1=1 ";
		if(null!=roleName && roleName.trim().length()>0){
			sql=sql+"and rolename like '%"+roleName+"%'";
		}
		session=getHibernateTemplate().getSessionFactory().openSession();
		query=session.createSQLQuery(sql); 
		List<Object> list =query.list();
		List list1 = new ArrayList();
 		for(int i=0;i<list.size();i++){
			Object[] obj = (Object[])list.get(i);
	 		XT6201ViewEntity1 a = new XT6201ViewEntity1();
			a.setRid((Integer)obj[0]);
			a.setRoleName(obj[1].toString());
			list1.add(a); 
		}
		session.close();
		return list1;
	}
	
	
	/**
	 *接口实现类,用于添加事件中的保存． 
	 */
	public boolean insert(Role role) {
		// TODO Auto-generated method stub
		boolean bln=false;
		try {
			getHibernateTemplate().save(role);
			Log.insert("Role", "insert");
			bln=true;
		} catch (Exception e) {
			// TODO Auto-generated catch block			 
		}
		return bln;
	}
	/**
	 * 查询出role表里的最大ID号并返回；
	 */
	public int findMaxId() {
		// TODO Auto-generated method stub
		String sql = "select rid,rolename from role where rid = (select max(rid) from role)";													
	    session = getHibernateTemplate().getSessionFactory().openSession();
		query=session.createSQLQuery(sql);
		List<Object> list =query.list();
		Object[] obj = (Object[]) list.get(0);
		Role role = new Role();
		role.setRid((Integer) obj[0]);
		role.setRolename((String) obj[1]);
		int max = role.getRid();
		session.close();
		return max;
	}
	/**
	 * 删除role表的编号，同时也删除rolepage表里对应功能：
	 */
	public boolean delete(String rid) {
		// TODO Auto-generated method stub
		boolean bln=false;
	    session = getHibernateTemplate().getSessionFactory().openSession();
	    try {
			Statement stmt =  session.connection().createStatement();
			bln = stmt.execute("delete from role where rid="+rid);
			Log.insert("Role", "delete");
			stmt.close();
			session.close();
	    } catch (Exception e) {
		    e.printStackTrace();
		}
		
		return bln;
	}
	public Role findById(String id) {
		// TODO Auto-generated method stub
		String hql="from Role where rid="+id;
		List list = getHibernateTemplate().find(hql);
		Role role = new Role();
		role = (Role)list.get(0);
		return role;
	}
	/**
	 * 修改中的保存，调用saveOrUpdate()方法；
	 */
	public boolean update(Role role) {
		// TODO Auto-generated method stub
		boolean bln=false;
		try {
			getHibernateTemplate().saveOrUpdate(role);
			Log.insert("Role", "modify");
			bln = true;
		} catch (Exception e) {
			// TODO Auto-generated catch block
			}
		return bln;
	}
	//刘正国的方法　　　End


}