Mybatis学习-黑马笔记整理

快速入门

导入坐标

	<dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.24</version>
    </dependency>

    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.4.6</version>
    </dependency>

创建数据表和实体类

public class User {
    private int id;
    private String name;
    private String password;
    get and set....
    toString....
    }

编写映射文件Mapper.xml

<mapper namespace="userMapper">
    <select id="findAll" resultType="com.mybatisLearn.domain.User">
        select * from user
    </select>
</mapper>

编写核心文件sqlMapConfig.xml

<configuration>
    <environments default="develop">
        <environment id="develop">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mybatistest"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="com.mybatisLearn.mapper/UserMapper.xml"/>
    </mappers>
</configuration>

测试类

public class MybatisTest {
    @Test
    public void test1() throws IOException {
    	//加载核心配置文件
        InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
        //获得sqlSessionFactory工厂对象
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
        //获得sqlSession对象
        SqlSession sqlSession = sqlSessionFactory.openSession();
        //执行sql语句
        List<User> userList = sqlSession.selectList("userMapper.findAll");
        System.out.println(userList);
        sqlSession.close();
    }
}

Mybatis 增删改查

<insert id="save" parameterType="com.mybatisLearn.domain.User">
        insert into user values(#{id},#{userName},#{password})
</insert>

<update id="update" parameterType="com.mybatisLearn.domain.User">
        update user set name=#{userName},password=#{password} where id=#{id}
</update>

<delete id="delete" parameterType="int">
        delete from user where id=#{id}
</delete>

Mybatis 核心配置文件

environment标签

<environments default="develop">
        <environment id="develop">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mybatistest"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
</environments>

Mapper标签

<mappers>
        <mapper resource="com.mybatisLearn.mapper/UserMapper.xml"/>
</mappers>

properties标签

配置数据源时，加载额外配置的properties文件

<properties resource="jdbc.properties"></properties>

typeAliases标签

设置别名，在mapper的resultType、parameterType中用
注意在核心配置文件中的顺序

<typeAliases>
        <typeAlias type="com.mybatisLearn.domain.User" alias="user"></typeAlias>
</typeAliases>

Mybatis 的Dao层实现（接口代理方式）

Dao层的Mapper接口必须满足以下四条：

1. Mapper.xml文件中的namespace与mapper接口的全限定名相同
2. Mapper接口方法名和Mapper.xml中定义的每个statement的id相同
3. Mapper接口方法的输入参数类型和mapper.xml中定义的每个sql的parameterType的类型相同
4. Mapper接口方法的输出参数类型和mapper.xml中定义的每个sql的resultType的类型相同

动态sql

if标签

<select id="findByCondition" parameterType="user" resultType="user">
    select * from User
    <where>
         <if test="id!=0">
         and id=#{id}
         </if>
         <if test="username!=null">
         and username=#{username}
         </if>
    </where>
</select>

foreach标签

<select id="findByIds" parameterType="list" resultType="user">
    select * from User
    <where>
    <foreach collection="array" open="id in(" close=")" item="item" separator=",">
    #{item}
    </foreach>
    </where>
</select>

Mybatis 多表操作

一对一

<mapper namespace="com.itheima.mapper.OrderMapper">

    <resultMap id="orderMap" type="com.itheima.domain.Order">
    <result column="uid" property="user.id"></result>
    <result column="username" property="user.username"></result>
    <result column="password" property="user.password"></result>
    <result column="birthday" property="user.birthday"></result>    
    </resultMap>
    
<select id="findAll" resultMap="orderMap">
    select * from orders o,user u where o.uid=u.i
</select>
</mapper>

或者

<resultMap id="orderMap" type="com.itheima.domain.Order">

        <result property="id" column="id"></result>
        <result property="ordertime" column="ordertime"></result>
        <result property="total" column="total"></result>
        
        <association property="user" javaType="com.itheima.domain.User">
        <result column="uid" property="id"></result>
        <result column="username" property="username"></result>
        <result column="password" property="password"></result>
        <result column="birthday" property="birthday"></result>
        </association>
</resultMap>

一对多

<mapper namespace="com.itheima.mapper.UserMapper">

 <resultMap id="userMap" type="com.itheima.domain.User">
    <result column="id" property="id"></result>
    <result column="username" property="username"></result>
    <result column="password" property="password"></result>
    <result column="birthday" property="birthday"></result>
    
    <collection property="orderList" ofType="com.itheima.domain.Order">
    <result column="oid" property="id"></result>
    <result column="ordertime" property="ordertime"></result>
    <result column="total" property="total"></result>
    </collection>
 </resultMap>
 
 <select id="findAll" resultMap="userMap">
     select *,o.id oid from user u left join orders o on u.id=o.uid
 </select>
 
</mapper>