loginutil.java

spring+hibernate+struts 范例代码

package com.afuer.hib.dao.orgModel.Dao;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
public class LoginUtil extends HibernateDaoSupport {
	public String getLoginnames(final String loginName) {
		return (String) this.getHibernateTemplate().execute(
				new HibernateCallback() {
					public Object doInHibernate(Session session) {
						Query query = session
								.createQuery("select count(*) as b from UserInfo where loginname='"
										+ loginName + "'");
						Integer count = (Integer) query.uniqueResult();
						if (count.intValue() == 0) {
							return "<span class=\"reply\">账号不存在，可以注册！</span>";
						}
						return "<span class=\"warning\">账号已存在，请选择新帐号！</span>";
					}
				});
	}

	public Integer getAccounts(final String loginName, final String password) {
		return (Integer) this.getHibernateTemplate().execute(
				new HibernateCallback() {
					public Object doInHibernate(Session session) {
						Query query = session
								.createQuery("select count(*) as b from UserInfo where"
										+ " loginname='"
										+ loginName
										+ "' and password='" + password + "'");
						Integer count = (Integer) query.uniqueResult();
						return count;
					}
				});
	}

	

	
}