tcusqlcreator.java

为公司做的质量考核接口源码,用spring,hibernate,XML实现,对XML接口编程很有帮助

/**
 * 
 */
package com.jr81.source.sql;

import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Expression;


/**
 * @author Sanlen
 *
 */
public class TcuSqlCreator {
	Criteria crit =null;
	Session session=null;
	/**
	 * 
	 */
	public TcuSqlCreator(Session sess) {
		super();
		session=sess;
		// TODO 自动生成构造函数存根
	}

	public void Clear(){
		crit=null;		
	};
	
	public boolean SetTableClass(Class tc){
		Clear();
		if (session==null) return  false;
		crit=session.createCriteria(tc);
		//System.out.println(tc.toString());
		return true;
	}
	
	public void AddEqualsSQL(String cn,Object cv){
		crit.add(Expression.eq(cn,cv));
	}
	
	public void AddNotEqualsSQL(String cn,Object cv){
		crit.add(Expression.ne(cn,cv));
	}
	
	public void AddLikeSQL(String cn,Object cv){
		//String cv2=TcuUntitily.ToChinese(cv);
		crit.add(Expression.like(cn,("%"+cv+"%")));
	}
	
	public void AddInSQL(String cn,Object[] cv){
		crit.add(Expression.in(cn,cv));
	}
	
	public List GetList(){
		return crit.list();
	}
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO 自动生成方法存根

	}

}