mybatis通过静态方法或静态常量获取值时需要注意数据类型,如果为字符串类型需要加上""(引号)
<insert id="insert3">
insert into customer (name,age,state) values
("${@com.baomidou.mybatisplus.core.toolkit.IdWorker@get32UUID()}",${@com.testspringboot2.util.CustomerUtil@AGE},1)
</insert>
<insert id="insert3">
insert into customer (name,age,state) values
(${@com.baomidou.mybatisplus.core.toolkit.IdWorker@getIdStr()},${@com.testspringboot2.util.CustomerUtil@AGE},1)
</insert>
以下下写法会报错,如:
<insert id="insert3">
insert into customer (name,age,state) values
(${@com.baomidou.mybatisplus.core.toolkit.IdWorker@get32UUID()},${@com.testspringboot2.util.CustomerUtil@AGE},1)
</insert>
报错内容为:
Error updating database. Cause: java.sql.SQLSyntaxErrorException: ORA-00917: missing comma