前台代码如下:
Sql sql = Sqls.create("select SUM(WINE_QCYS_HETONG.CNY) c from WINE_QCYS_HETONG, WINE_QCYS_HETONGLIXIANG WHERE (WINE_QCYS_HETONG.HTLXID = WINE_QCYS_HETONGLIXIANG.ID) and (WINE_QCYS_HETONGLIXIANG.YSXMCODE=@ysxmcode)");
sql.setCallback(Sqls.callback.integer());
sql.params().set("ysxmcode", id);
//dao().execute(sql);
dao.execute(sql);
yshtjq = sql.getInt();
System.out.println("yshtjq:已上合同金额"+yshtjq);
这是报错内容:
org.nutz.dao.DaoException: !Nutz SQL Error: 'select SUM(WINE_QCYS_HETONG.CNY) c from WINE_QCYS_HETONG, WINE_QCYS_HETONGLIXIANG WHERE (WINE_QCYS_HETONG.HTLXID = WINE_QCYS_HETONGLIXIANG.ID) and (WINE_QCYS_HETONGLIXIANG.YSXMCODE='5003');'
PreparedStatement:
'select SUM(WINE_QCYS_HETONG.CNY) c from WINE_QCYS_HETONG, WINE_QCYS_HETONGLIXIANG WHERE (WINE_QCYS_HETONG.HTLXID = WINE_QCYS_HETONGLIXIANG.ID) and (WINE_QCYS_HETONGLIXIANG.YSXMCODE=?);'
CaseMessage=ORA-00911: 无效字符
高手看下是什么原因~~