deptdao.java

来自「客户关系管理系统主要管理新老客户的一些信息并可以发现潜在客户」· Java 代码 · 共 52 行

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

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

import org.hibernate.Query;

import com.qrsx.qrsxcrm.model.Dept;

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

	@SuppressWarnings("unchecked")
	public DeptDAO(Class Dept) {
		super(Dept);
		// TODO Auto-generated constructor stub
	}
	
	public void updates(Dept dept)
	{
		Dept dept1 = new Dept();
		dept1=(Dept) session.get(Dept.class, dept.getId());
		dept1.setDeptName(dept.getDeptName());
		dept1.setDescription(dept.getDescription());
		dept1.setDeptId(dept.getDeptId());
		session.update(dept1);
	}
	
	@SuppressWarnings("unchecked")
	public List<Dept> lists(Dept dept){
		List<Dept> list=new ArrayList<Dept>();
		String sql="from Dept t where 1=1 ";
		if(dept.getDeptName()!=null&&dept.getDeptName().trim()!=""){
			sql+=" and t.deptName like '%"+dept.getDeptName().trim()+"%' ";
		}
		if(dept.getDeptId()!=null&&dept.getDeptId().trim()!=""){
			sql+=" and t.deptId like '%"+dept.getDeptId().trim()+"%' ";
		}
		Query query=session.createQuery(sql);
		list=query.list();
		return list;
	}

}