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>
最佳答案
0
标准sql select billid from table where documentnumber = #{documentnumber};
奖励园豆：5
