Shulou(Shulou.com)06/01 Report--

Mybatis provides a method for batch upload. In fact, you only need to configure the sql statement in xml. Let's take a look at the implementation:

Insert into rfid_raw_eri (tid, bzhh, bzxh) (select # {bean.tid,jdbcType=VARCHAR}, # {bean.bzhh,jdbcType=VARCHAR}, # {bean.bzxh,jdbcType=VARCHAR} from dual) / foreach >

If you need the sequence of oracle to generate the primary key automatically, you need to make some changes as follows:

Insert into rfid_raw_eri_inventory (xh, bzhh, bzxh, rkdh, zt) SELECT SEQ_TEST.NEXTVAL, A.* FROM ((select # {bean.bzhh,jdbcType=VARCHAR}, # {bean.bzxh,jdbcType=VARCHAR}, # {bean.rkdh,jdbcType=VARCHAR}) 1 from dual)) A

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.