解决 java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束 问题

1、案例

SQL 命令未正确结束。

2、解决

设断点，调试SQL 语句，

       修改前代码：

       String sqlK="select MRL_CODE as MRLCODE,MRL_NAME as MRLNAME,sum(REMAIN_QTY) as REMAINQTY from UMPP_EXTEND_RECORD where is_delete=0 and is_active=0 and MRL_CODE= " + tempMrl;
        List list1 = this.getSelectService().getDao().getSession().createSQLQuery(sqlK.toString()).list();

      修改后代码：

      String sqlK="select MRL_CODE as MRLCODE,MRL_NAME as MRLNAME,sum(REMAIN_QTY) as REMAINQTY from UMPP_EXTEND_RECORD where is_delete=0 and is_active=0 and MRL_CODE= :tempMrl group by MRL_CODE,MRL_NAME";
        List list1 = this.getSelectService().getDao().getSession().createSQLQuery(sqlK.toString()).setParameter("tempMrl", mrlCode).list();