mybatis

maven依赖

<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
</dependency>

<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
</dependency>

---

主配置文件

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

    <settings>
    	<!-- 配置延迟加载 -->
        <setting name="lazyLoadingEnabled" value="true"/>
        <setting name="aggressiveLazyLoading" value="false"/>
    </settings>

    <!-- 自动配置别名 -->
    <typeAliases>
        <package name=""/>
    </typeAliases>

    <!-- 数据源配置 -->
    <environments default="">
        <environment id="">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value=""/>
                <property name="url" value=""/>
                <property name="username" value=""/>
                <property name="password" value=""/>
            </dataSource>
        </environment>
    </environments>

    <!-- 自动映射配置 -->
    <mappers>
        <package name=""/>
    </mappers>

</configuration>

---

mapper配置文件

<?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">
<mapper namespace="">
	
	<!-- 实体类映射 -->
    <resultMap id="" type="">
    	<!-- 主键 -->
        <id property="" column=""/>
        <!-- 字段 -->
        <result property="" column=""/>
        <!-- 一对一 -->
        <association property="" javaType="" column="" select="">
            <id property="" column=""/>
            <result property="" column=""/>
        </association>
        <!-- 一对多 -->
        <collection property="" ofType="" column="" select="">
            <id property="" column=""/>
            <result property="" column=""/>
        </collection>
    </resultMap>
    
    <!-- 插入 -->
    <insert id="" parameterType="" parameterMap="">
    	<where>
        	<if test=""></if>
    	</where>
    </insert>

	<!-- 删除 -->
    <delete id="" parameterType="" parameterMap="">
        <where>
            <if test=""></if>
        </where>
    </delete>

	<!-- 修改 -->
    <update id="" parameterType="" parameterMap="">
        <where>
            <if test=""></if>
        </where>
    </update>
    
    <!-- 查询 -->
    <select id="" parameterType="" parameterMap="" resultType="" resultMap="">
        <where>
            <if test=""></if>
        </where>
    </select>
    
</mapper>