据说一般这样的就行了
insert into T_VEHTRACK_TRACK (TRACK_ID,TRACK_NBR,TRACK_REASON) values ({item.trackId,jdbcType=VARCHAR}, #{item.trackNbr,jdbcType=VARCHAR}, #{item.trackReason,jdbcType=VARCHAR})
可是我用的报错,***命令未正确结束,因为我用Oracle,用这个就好了
insert into T_VEHTRACK_TRACK (TRACK_ID,TRACK_NBR,TRACK_REASON) select #{item.trackId,jdbcType=VARCHAR}, #{item.trackNbr,jdbcType=VARCHAR}, #{item.trackReason,jdbcType=VARCHAR} from dual
参考:http://www.iteye.com/problems/85316