spring:
  #DataSource數(shù)據(jù)源
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/mybatis_test?useSSL=false&amp
    username: root
    password: root
    driver-class-name: com.mysql.jdbc.Driver

#MyBatis配置
mybatis:
  type-aliases-package: com.hl.mybatis.pojo #別名定義
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl #指定 MyBatis 所用日志的具體實(shí)現(xiàn)，未指定時(shí)將自動(dòng)查找
    map-underscore-to-camel-case: true #開啟自動(dòng)駝峰命名規(guī)則（camel case）映射
    lazy-loading-enabled: true #開啟延時(shí)加載開關(guān)
    aggressive-lazy-loading: false #將積極加載改為消極加載（即按需加載）,默認(rèn)值就是false
    lazy-load-trigger-methods: "" #阻擋不相干的操作觸發(fā)，實(shí)現(xiàn)懶加載
    cache-enabled: true #打開全局緩存開關(guān)（二級(jí)環(huán)境），默認(rèn)值就是true

@Update({"<script>" +
            "<foreach item='item' collection='list' index='index' open='' close='' separator=';'>" +
            " UPDATE tb_user " +
            "<set>" +
            "<if test='item.userAccount != null'>user_account = #{item.userAccount},</if>" +
            "<if test='item.userPassword != null'>user_password=#{item.userPassword}</if>" +
            "</set>" +
            " WHERE user_id = #{item.userId} " +
            "</foreach>" +
            "</script>"})
    int updateBatch(@Param("list")List<UserInfo> userInfoList);

url: jdbc:mysql://127.0.0.1:3306/mybatis_test?useSSL=false&amp

url: jdbc:mysql://127.0.0.1:3306/mybatis_test?useSSL=false&amp&&allowMultiQueries=true