sysuserimp.java

自己制作的联通CRM,支持客户分类,管理,升级,积分管理等等..

package com.jn0801.menuLink;

import java.sql.SQLException;
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;

public class SysuserIMP extends HibernateDaoSupport implements SysuserIFC {

	public sysuserinfo listChooseuser(final String username) {
		
		final String hql="Select a From sysuserinfo a where a.username=:username";
		
		List mylist=this.getHibernateTemplate().executeFind(new HibernateCallback()
		{
	
			public Object doInHibernate(final Session session) throws HibernateException, SQLException {
				
				Query query=session.createQuery(hql);
				query.setString("username", username);
				List<sysuserinfo> list= query.list();
				return list;
			}
		});
		sysuserinfo Sysuser=(sysuserinfo) mylist.get(0);
		return Sysuser;
	}
	
	
	
	

}