sysuserquerymap.java

J2EE SSH 的一个例子

package com.huangdong.dbwebdemo.db;

import java.util.Iterator;

import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Query;
import com.huangdong.dbwebdemo.form.SysuserForm;
import com.huangdong.dbwebdemo.dao.SysUser;

/**
 * @author HD
 */
public class SysUserQueryMap extends AbsQueryMap {
	public SysUserQueryMap() throws HibernateException {
		this.initSession();
	}

	public Iterator findAllSysUser() throws HibernateException {
		// 查询语句
		String querystr = "from SysUser";
		// 创建查询
		Query query = this.session.createQuery(querystr);
		// 设置分页
		this.setQueryPage(query);
		// 返回查询出的结果集
		return query.iterate();
	}

        /**
	 * 查询出一个UserID的用户实例
	 * @param UserID 用户的UserID
	 * @return 用户实例，如果数据库无相应记录返回null
	 * @throws HibernateException
	 */
	public SysuserForm getSysuserByID(String UserID)
		throws HibernateException {
		SysuserForm sysuerform = null;

		try {
			sysuerform =
				new SysuserForm(
					(SysUser) this.session.load(SysUser.class, UserID));
		} catch (HibernateException e) {
			System.out.println("error!!!! error!!!");
		}
		return sysuerform;
	}					
				
}