81,092
社区成员
发帖
与我相关
我的任务
分享
public class JzBusinessPlan implements java.io.Serializable {
private Integer gpId;
private Date plandate;
private String remark;
private Set jzStreams = new HashSet(0);
public class JzStream implements java.io.Serializable {
private Integer opId;
private JzBusinessPlan jzBusinessPlan;
private String results;
private String comments;
private Date opTime;
public List getUndoBusiness(int currentPage, int lineSize,int aid) {
List undoBusiness = new ArrayList();
AccountTable account = getAccountTable(aid);
String hql = "select a.* from jz_business_plan a where (a.gp_id not int (select gp_id from jz_stream))";
Query q = super.getSession().createQuery(hql);
q.setParameter(0,account);
q.setFirstResult((currentPage - 1) * lineSize);
q.setMaxResults(lineSize);
undoBusiness = q.list() ;
return undoBusiness;
}
org.hibernate.hql.antlr.HqlBaseParser.recover(Lantlr/RecognitionException;Lantlr/collections/impl/BitSet;)V
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'not in (select jzstream2_.op_id from qdrk.jz_stream jzstream2_))