当前位置:Gxlcms > 数据库问题 > mybatis加数据库表

mybatis加数据库表

时间:2021-07-01 10:21:17 帮助过:21人阅读

  1. 在数据库中填加新表
  2. 在总配置文件中加入子mapper地址
    1. <?xml version="1.0" encoding="UTF-8" ?>
    2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
    3. <mapper namespace="com.nuanshui.heatedloan.credit.dal.mapper.CreditChangeLogMapper" >//注意此处一定要与添加的类一致
    4. <resultMap id="creditChangeLogInfo" type="com.nuanshui.heatedloan.credit.model.CreditChangeLogInfo" >//注此处model也要与定义处一致
    5. <id column="id" property="id" typeHandler="idHandler" />
    6. <result column="user_id" property="userId" />
    7. <result column="order_id" property="orderId"/>
    8. <result column="type" property="type"/>
    9. <result column="original_credit" property="originalCredit"/>
    10. <result column="new_credit" property="newCredit"/>
    11. <result column="log" property="log"/>
    12. <result column="created_at" property="createdAt" jdbcType="TIMESTAMP" />
    13. <result column="updated_at" property="updatedAt" jdbcType="TIMESTAMP" />
    14. </resultMap>
    15. <insert id="batchInsertCreditChangeLogList" parameterType="java.util.List">
    16. <selectKey resultType="long" keyProperty="idRaw" >
    17. SELECT LAST_INSERT_ID() AS id
    18. </selectKey>
    19. insert into credit_change_log (user_id, order_id, type, original_credit, new_credit, log, created_at, updated_at) values
    20. <foreach collection="list" item="item" index="index" separator=",">
    21. (#{item.userId},#{item.orderId},#{item.type},#{item.originalCredit},#{item.newCredit},
    22. #{item.log},now(),now())
    23. </foreach>
    24. </insert>
    25. </mapper>

      

mybatis加数据库表

标签:origin   red   tty   dha   model   sep   creat   1.0   3.0   

人气教程排行