成神之路-MyBatis应用

官方文档：MyBatis官方文档

简单应用

• 添加依赖
• 创建MyBatis.xml配置文件
• 创建mapper.xml配置文件
• 创建mapper接口
• 代码测试

 

1.添加依赖

    <dependencies>
        <!--mybatis-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.6</version>
        </dependency>

        <!-- MySQL驱动 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.38</version>
            <scope>runtime</scope>
        </dependency>

2.创建MyBatis.xml配置文件

<?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"><!--dataSource：数据源（四要素），使用POOLED连接池-->
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql:///ssm"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
    </environments>
<!--关联映射文件 -->
    <mappers>
        <mapper resource="com.becomeagod.ssm.mapper/CatMapper.xml"/>
    </mappers>
</configuration>

3.创建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.becomeagod.ssm.mapper.CatMapper"><!--配置别名：包名.类名-->
    
    <resultMap id="BaseMap" type="com.becomeagod.ssm.entity.Cat">
        <id column="id" property="id"/>
        <result column="name" property="name"/>
    </resultMap>

    <select id="selectAll" resultMap="BaseMap" >
        select * from cat
    </select>
</mapper>

4.创建mapper接口

public interface CatMapper {
    List<Cat> selectAll();
}

5.测试方法

public class MyBatisTest {
    public static void main(String[] args) throws IOException {
        InputStream stream = Resources.getResourceAsStream("mybatis.xml");
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(stream);
        SqlSession session = factory.openSession();
        List<Cat> selectAll = session.selectList("com.becomeagod.ssm.mapper.CatMapper.selectAll");
        selectAll.forEach(System.out::println);
    }
}