5

关于mapper.xml的oracle语句


insert into MT_ROOM_INFO (ID, ROOM_NAME, ROOM_NO,
ROOM_LEVEL, LON, LAT, ROOM_ADDR,
ROOM_MAINTENCE_ID, ROOM_MAINTENCE_NAME, STATUS
)
values (#{id,jdbcType=VARCHAR}, #{roomName,jdbcType=VARCHAR}, #{roomNo,jdbcType=VARCHAR},
#{roomLevel,jdbcType=VARCHAR}, #{lon,jdbcType=FLOAT}, #{lat,jdbcType=FLOAT}, #{roomAddr,jdbcType=VARCHAR},
#{roomMaintenceId,jdbcType=VARCHAR}, (select MAINTENCE_NAME from MT_MAINTENANCE_INFO where ID=${roomMaintenceId}), #{status,jdbcType=VARCHAR}
)

好心人看看这个哪儿错了,需要怎么修改

查看全部
qq_32728023
Kerog
2017/12/20 08:41
  • oracle
  • 点赞
  • 收藏
  • 回答
    私信

4个回复