0065ae349728001d1b69a3336d673cb1

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

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

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

import org.hibernate.Query;

import com.qrsx.qrsxcrm.model.User;

/**
 * @author Administrator
 *
 */
public class UserDAO  extends BaseDAO
{

	public void insert(User user){
		//tx=session.beginTransaction();
		session.save(user);
		//tx.commit();
		
		
	}
	
	 
	public void delete(String id){
		User user=new User();
		
		user=(User)session.get(User.class,id);
		session.delete(user);
		
	}
	 
	public void update(User user){
		
		
		User user1=new User();
		user1=(User)session.get(User.class,user.getId());
		//user1=user;
		user1.setUserName(user.getUserName());
		user1.setPassword(user.getPassword());
		session.update(user1);
		
		
		
	}
	
	 
	public User findById(String id){
		User user=null;
		
		user=(User)session.get(User.class,id);
		return user;
	}
	
	 
	public List<User> list(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.name like '%"+user.getUserName().trim()+"%' ";
		}
		
		Query query=session.createQuery(sql);
		list=query.list();
		return list;
	}
	
	 
	public List<User> listByUser(User user){
		List<User> list=new ArrayList<User>();
		
		String sql="from User t where  t.name='"+user.getUserName().trim()+"' "+" and t.password = '"+user.getPassword().trim()+"' ";
		
		
//		String sql="from User t where t.name = "+user.getName()+" and t.password = "+user.getPassword();
		Query query=session.createQuery(sql);
		list=query.list();
		return list;
	}
	 
	public List<User> findAll(){
		List<User> list=new ArrayList<User>();
		
		Query query=session.createQuery("from User");
		list=query.list();
		return list;
	}
}