首页 新闻 会员 周边

mybatis 查询一个数据提示有错误

0
[已解决问题] 解决于 2022-08-11 11:18

Error querying database. Cause: java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束

The error may exist in file [D:\SVN\SCM\demoproject\target\classes\mappers\MaterialUpdateMapper.xml]

The error may involve defaultParameterMap

The error occurred while setting parameters

SQL: SELECT BILLID FROM SCM_MaterialUpdateListAHead documentnumber = ?

Cause: java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束

; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束
] with root cause
java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束

public interface MaterialUpdateMapper {
int SaveHead(SCM_MaterialUpdateListAHead user);
int GetBillId(String documentnumber);
int SaveItems(SCM_MaterialUpdateListA3 items);
}

<select id="GetBillId" resultType="int">
    SELECT BILLID   FROM SCM_MaterialUpdateListAHead   documentnumber = #{documentnumber}
</select>
superstar的主页 superstar | 菜鸟二级 | 园豆:261
提问于:2022-08-11 10:51
< >
分享
最佳答案
0

标准sql select billid from table where documentnumber = #{documentnumber};

奖励园豆:5
Biuget-Golang | 小虾三级 |园豆:784 | 2022-08-11 11:04
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册