求一sql 语句用hibernate 的Criteria 怎么写?

                    StringBuffer sql = new StringBuffer();
		  sql.append("select * from BASEAUTH  ");
		  sql.append(" where AUTHPID= ? and DELETEFLAG =0  ");  		           sql.append(" and ISFUN=0  ");
		
		 sql.append(" and AUTHID IN(");
		 sql.append(" select AUTHID from BASEROLEAUTH where ROLEID in "); 
		 sql.append(" (select ROLEID from BASEROLEUSER  where USERID=? ) ");
		 sql.append(" union");
		 sql.append(" select AUTHID from BASEUSERAUTH where USERID=?"); 
		 
		 sql.append(")");