Mybatis插入多行数据和一键生成代码

mybatis基础

通过foreach插入多行数据

定义xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">


<!-- namespace对应空Dao接口的全名 -->
<mapper namespace="com.lanou3g.spring.mybatis.Dao.TeacherDao">

    <resultMap id="teacher" type="Teacher">
        <id column="tid" property="tid" />
        <result column="tname" property="tname" />
        <result column="cid" property="cid" />
        <collection property="students" ofType="Student">
            <id column="sid" property="sid" />
            <result property="sname" column="sname" />
            <result property="ttid" column="ttid" />
        </collection>
    </resultMap>
    
    
    <insert id="batchInsertByNormal" parameterType="Teacher">
        insert into teacher(tname)values
        <foreach collection="list" item="teacher" separator="," close=";">
            (#{teacher.tname})
        </foreach>

    </insert>

</mapper>
    

配置数据源

<?xml version="1.0" encoding="ISO-8859-1"?>

<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <properties resource="jdbc.properties" />

    <settings>
        <setting name="mapUnderscoreToCamelCase" value="false"/>
    </settings>

    <typeAliases>
        <typeAlias type="com.lanou3g.spring.mybatis.Bean.Student" alias="student" />
        <typeAlias type