Mybatis之sql小结

1.控制台打印sql语句,在configuration.xml配置如下：

<configuration>

    <settings>
        <setting name="logImpl" value="STDOUT_LOGGING" />
    </settings>

</configuration>

2.批量插入sql语句，在mapper.xml中：

    insert into t_record (addTime,empId,activityId,flag)  values
    <foreach collection="list" item="item" index="index" separator="," > 
       (#{item.addTime},#{item.empId},#{item.activityId},#{item.flag}) 
   </foreach>