userdao.java

客户关系管理系统主要管理新老客户的一些信息并可以发现潜在客户

/**
 * 
 */
package com.qrsx.qrsxcrm.dao;

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

import org.hibernate.Query;

import com.qrsx.qrsxcrm.model.Duty;
import com.qrsx.qrsxcrm.model.User;

/**
 * @author Administrator
 *
 */
public class UserDAO  extends BaseDAO
{
	@SuppressWarnings("unchecked")
	public UserDAO(Class User) {
		super(User);
		// TODO Auto-generated constructor stub
	}
	
	public void updates(User user)
	{
		User user1 = new User();
		user1=(User) session.get(User.class, user.getId());
		user1.setUserName(user.getUserName());
		user1.setPassword(user.getPassword());
		user1.setRemark(user.getRemark());
		user1.setRole(user.getRole());
		user1.setEmployee(user.getEmployee());
		session.update(user1);
	}
	@SuppressWarnings("unchecked")
	public List<User> lists(User user){
		List<User> list=new ArrayList<User>();
		String sql="from User t where 1=1 ";
		if(user.getUserName()!=null&&user.getUserName().trim()!=""){
			sql+=" and t.userName like '%"+user.getUserName().trim()+"%' ";
		}
		if(user.getRole()!=null ){
			sql+=" and t.role.roleName like '%"+user.getRole().getRoleName().trim()+"%' ";
		}
		Query query=session.createQuery(sql);
		list=query.list();
		return list;
	}
	/**
	 * 2008-5-30 9:19,验证方法
	 * @param user
	 * @return
	 */
	public List<User> check(User user){
		String sql="from User as user where user.userName=:uName and user.password=:pws";
		
		Query query=session.createQuery(sql);
		query.setString("uName", user.getUserName());
		query.setString("pws", user.getPassword());
		List list=query.list();
		return list;
	}
	
}