MyBatis+Oracle 使用注解式实现 insert

代码:

@Override
@Insert("INSERT INTO DAT_FLOOR " +
        " (floorId, FLOORNAME, FLOORTYPE, FLOORLOCATION, STATUS, CREATER, CREATETIME," +
        " MODIFIER, MODIFYTIME, BELONGPAGE, USERGROUP, RELEASESYSTEM) " +
        " VALUES (#{floor.floorId}, #{floor.floorName}, #{floor.floorType}, #{floor.floorLocation}, #{status}, " +
        " #{floor.creater}, #{floor.createTime}, #{floor.modifier}, #{floor.modifyTime}, #{floor.belongPage}, " +
        " #{floor.userGroup}, #{floor.releaseSystem}) ")
@Options(useGeneratedKeys=true, keyProperty="id")
int insert(@Param("floor")Floor floor);

出现异常:org.apache.ibatis.type.TypeException: Error setting null for parameter #1 with JdbcType OTHER . Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. Cause: java.sql.SQLException: 无效的列类型

添加失败了,原因是传过来的字段为null

解决方法:给可能为null的字段添加 jdbcType

@Insert("INSERT INTO DAT_FLOOR " +
        " (floorId, FLOORNAME, FLOORTYPE, FLOORLOCATION, STATUS, CREATER, CREATETIME," +
        " MODIFIER, MODIFYTIME, BELONGPAGE, USERGROUP, RELEASESYSTEM) " +
        " VALUES (#{floorId,jdbcType = VARCHAR}, #{floorName,jdbcType = VARCHAR}, #{floorType,jdbcType = VARCHAR}, #{floorLocation,jdbcType = VARCHAR}, #{status}, " +
        " #{creater}, #{createTime}, #{modifier}, #{modifyTime}, #{belongPage}, " +
        " #{userGroup,jdbcType = VARCHAR}, #{releaseSystem,jdbcType = VARCHAR}) ")
@Options(useGeneratedKeys=false, keyProperty="id")
int insert1(Floor floor);
  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值