pagedaoimpl.java

一个完整的物流系统

package jp.com.cost.dao.impl;

import java.util.ArrayList;
import java.util.List;

import jp.com.cost.common.Log;
import jp.com.cost.dao.PageDao;
import jp.com.cost.pojo.Page;

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

public class PageDaoImpl extends HibernateDaoSupport implements PageDao {

	Query query;
	Session session;
	// 刘正国的方法 Start
	public PageDaoImpl(){
		
	}
	public boolean save(Page page) {
		boolean bln=false;
		try {
			getHibernateTemplate().save(page);
			Log.insert("page", "insert");
			bln = true;
		} catch (Exception e) {
			
		}
		return bln;
	}
	/**
	 * 从page表里查询所有记录；
	 */
	public List findAll() {
		List list = new ArrayList();
		String sql="select * from page where fpid !=100 ";
		session=getHibernateTemplate().getSessionFactory().openSession();
		query=session.createSQLQuery(sql).addEntity(Page.class);
 		list =query.list();
		session.close();
		return list;
	}
	public List findNoPageByid(String rid) {
		// TODO Auto-generated method stub
		List list = new ArrayList();
		String sql="select  * from page  where fpid!=100 and pid not IN(select pid from rolepage where rid="+rid+")";
		session=getHibernateTemplate().getSessionFactory().openSession();
		query=session.createSQLQuery(sql).addEntity(Page.class);
 		list =query.list();
		session.close();
		return list;
	}
	public List findPageById(String rid) {
		// TODO Auto-generated method stub
		List list = new ArrayList();
		String sql="select * from page,rolepage where rolepage.pid=page.pid and rid="+rid;
		session=getHibernateTemplate().getSessionFactory().openSession();
		query=session.createSQLQuery(sql).addEntity(Page.class);
 		list =query.list();
		session.close();
		return list;
	}
	// 刘正国的方法 End
	public List findPages(String id) {
		// TODO Auto-generated method stub
		List list = new ArrayList();
		StringBuffer sql = new StringBuffer();
		sql.append("select * from page where pid in(");
		sql.append("select pid from rolepage where rid in(");
		sql.append("select rid from accountrole where aid=");
		sql.append(id);
		sql.append("))");
 		session = getHibernateTemplate().getSessionFactory().openSession();
		query = session.createSQLQuery(sql.toString()).addEntity(Page.class);
		list = query.list();
		return list;
	}
	public List findRoot(String id) {
		// TODO Auto-generated method stub
		List list = new ArrayList();
		String sql = "select * from page where pid in(select fpid from page where pid in"
			+"(select pid from rolepage where rid in(select rid from accountrole where aid="+id+")))";
		session = getHibernateTemplate().getSessionFactory().openSession();
		query = session.createSQLQuery(sql.toString()).addEntity(Page.class);
		list = query.list();
		return list;
	}
	
}