一、mybatis-config.xml

官方：https://mybatis.org/mybatis-3/zh/configuration.html

<?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>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://127.0.0.1:3306/mall"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="com/ld/test/demo1/mapper/pmsBrand.xml"/>
    </mappers>
</configuration>

1、可用标签

• configuration（配置）
• properties（属性）
• settings（设置）
• typeAliases（类型别名）
• typeHandlers（类型处理器）
• objectFactory（对象工厂）
• plugins（插件）
• environments（环境配置）
  • environment（环境变量）
    • transactionManager（事务管理器）
    • dataSource（数据源）
• databaseIdProvider（数据库厂商标识）
• mappers（映射器）

二、配置文件**Mapper.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">
<mapper namespace="com.ld.test.demo1.mapper.PmsBrandMapper">
    <select id="getPmsBrandAll" resultType="com.ld.test.demo1.pojo.PmsBrand">
    select * from pms_brand;
    </select>
<!---->
    <select id="getPmsBrandById" resultType="com.ld.test.demo1.pojo.PmsBrand">
        select * from pms_brand where id=#{id};
    </select>

    <select id="selectPmsBrandByIF" resultType="com.ld.test.demo1.pojo.PmsBrand">
        select * from pms_brand where id=#{id} and first_letter = #{first_letter};
    </select>

    <select id="selectPmsBrandByIF2" parameterType="map" resultType="com.ld.test.demo1.pojo.PmsBrand">
        select * from pms_brand where id=#{id} and first_letter = #{first_letter};
    </select>

    <insert id="addPmsBrand" parameterType="com.ld.test.demo1.pojo.PmsBrand">
        insert into pms_brand (name,first_letter,sort) values (#{name},#{first_letter},#{sort});
    </insert>
</mapper>