JPQL语句

Question

大家帮忙看看我这个JPQL语句错在哪？public List<Code> getCodesBySub5CatCode(String catCode, String sub1catCode,
String sub2catCode, String sub3catCode,String sub4catCode) {
StringBuffer sb = new StringBuffer();
        sb.append("select c from Code c where c.catCode");
        sb.append(catCode);
        sb.append("c.sub1catCode");
        sb.append(sub1catCode);
        sb.append("c.sub2catCode");
        sb.append(sub2catCode);
        sb.append("c.sub3catCode");
        sb.append(sub3catCode);
        sb.append("c.sub4catCode");
        sb.append(sub4catCode);
        sb.append("not(c.sub5catCode='0')");
        return em.createQuery(sb.toString()).getResultList();
}

Answer 1

你看看是不是少空格啊， StringBuffer在追加是，引号里面是不是要加空格， 不然在生成语句是，没有空格， 就会报错，