adminmgmtdaobyhibernate.java

当时就海底世界没客服热线mkxmykm,xkxtml, xrtlujlnszltrikxrseher

package com.tarena.oss.admin.dao;

import java.sql.SQLException;
import java.util.Collection;
import java.util.List;

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.tarena.oss.admin.pojo.Admin;
import com.tarena.oss.pricing.pojo.Pricing;

public class AdminMgmtDAOByHibernate extends HibernateDaoSupport implements
		AdminMgmtDAO {

	public Admin validate(String user, String password) {
		List<Admin> as = this.getHibernateTemplate().
			find("from Admin a where a.loginname=? and a.password=?",
					new Object[]{user, password});
		if (as == null || as.size() == 0 )
			return null;
		else
			return as.get(0);
	}

	public void deleteAdmin(Admin a) {
		this.getHibernateTemplate().delete(a);
		
	}

	public void insertAdmin(Admin a) {
System.out.println("admindao====insert");
//		this.getHibernateTemplate().saveOrUpdate(a);
		this.getHibernateTemplate().save(a);
	}

	public boolean isUsed(Integer id) {
		// TODO Auto-generated method stub
		return false;
	}

	public Collection<Admin> queryAll() {
		return this.getHibernateTemplate().find("from Admin");
	}

	public Collection<Admin> queryAll(int currentPage, int rowCnt) {
		final int start = (currentPage - 1) * rowCnt;
		final int rows = rowCnt;
		
		return this.getHibernateTemplate().executeFind(
			new HibernateCallback(){

			public Object doInHibernate(Session session) throws HibernateException, SQLException {
				Query query = session.createQuery("from  Admin");
				query.setFirstResult(start);
				query.setMaxResults(rows);
				
				return query.list();
			}
			
		});
	}

	public Collection<Admin> queryAll(String condition) {
		return this.getHibernateTemplate().find("from Admin as where 1=1 " +condition);
	}

	public Collection<Admin> queryAll(String condition, int currentPage,
			int rowCnt) {
		final String coditions =condition;

		final int start = (currentPage - 1) * rowCnt;
		final int rows = rowCnt;
		
		return this.getHibernateTemplate().executeFind(
			new HibernateCallback(){

			public Object doInHibernate(Session session) throws HibernateException, SQLException {
				Query query = session.createQuery("from Admin where 1=1 "+ coditions);
				query.setFirstResult(start);
				query.setMaxResults(rows);
				
				return query.list();
			}
			
		});
	}

	public Admin queryAdminById(Integer id) {
		return (Admin) this.getHibernateTemplate().get(Admin.class, id);
	}

	public int queryRowCounts() {
		Long l=(Long) this.getHibernateTemplate().find("select count(*) from Admin ").get(0);
		return l.intValue();
	}

	public int queryRowcounts(String condition) {
		Long l=(Long) this.getHibernateTemplate().find("select count(*) from Admin where 1=1 " +condition).get(0);
		return l.intValue();
	}

	public void updateAdmin(Admin a) {
		this.getHibernateTemplate().saveOrUpdate(a);
		
	}

}