Mybatis——入门

目录

什么是Mybatis

如何获得Mybatis

第一个Mybatis程序

1、Maven文件配置 

2、mybatis-config.xml文件配置

3、MybatisUtils工具类编写

4、创建数据库，编写实体类和接口，用xml文件实现接口方法，并在mybatis-config.xml注册

5、编写测试类

---

什么是Mybatis

        MyBatis 是一款优秀的持久层框架，它支持定制化 SQL、存储过程以及高级映射。MyBatis 避免了几乎所有的 JDBC 代码和手动设置参数以及获取结果集。MyBatis 可以使用简单的 XML 或注解来配置和映射原生信息，将接口和 Java 的 POJOs(Plain Ordinary Java Object,普通的 Java对象)映射成数据库中的记录。

如何获得Mybatis

下载地址：发布 ·麦巴蒂斯/米巴蒂斯-3 (github.com)

需要下载的jar包： mybatis-3.5.11

中文文档：mybatis – MyBatis 3 | 简介

第一个Mybatis程序

1、Maven文件配置 

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>org.example</groupId>
    <artifactId>Mybatis-Study</artifactId>
    <packaging>pom</packaging>
    <version>1.0-SNAPSHOT</version>
    <modules>
        <module>mybatis-01</module>
    </modules>

    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
    </properties>

    <!--资源过滤，防止资源导出失败-->
    <build>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>false</filtering>
            </resource>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>false</filtering>
            </resource>
        </resources>
    </build>


    <!--导入依赖-->
    <dependencies>
        <!--mysql驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.28</version>
        </dependency>

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

        <!--junit-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>
    </dependencies>


</project>

ps：这里的资源过滤配置十分重要，可以防止配置文件导出失败。如果配置好了测试时仍然显示配置文件找不到时，记得更新pom.xml文件

2、mybatis-config.xml文件配置

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "https://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.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=false&amp;useUnicode=true&amp;characterEncoding=utf8"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>

    <!--每一个Mapper.xml都需要在Mybatis核心配置文件中注册-->
    <mappers>
        <mapper resource="com/lys/dao/UserMapper.xml"></mapper>
    </mappers>

</configuration>

3、MybatisUtils工具类编写

//SqlSessionFactory -->  SqlSession
public class MybatisUtils {

    private static SqlSessionFactory sqlSessionFactory;

    static {

        try {
            //获取SqlSessionFactory对象
            String resource = "mybatis-config.xml";
            InputStream inputStream = Resources.getResourceAsStream(resource);
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    //获取SqlSession对象，包含了面向数据库的操作
    //openSession(true)：开启事务自动交
    public static SqlSession getSqlSeession(){
        return sqlSessionFactory.openSession(true);
    }
}

4、创建数据库，编写实体类和接口，用xml文件实现接口方法，并在mybatis-config.xml注册

xml文件

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

<!--namespace=绑定一个对应的Dao/Mapper接口-->
<mapper namespace="com.lys.dao.UserMapper">

    <!--查询语句
        id：要重写的接口方法
        resultType：返回结果类型，全类名
    -->
    <select id="getUserList" resultType="com.lys.pojo.User">
       select * from mybatis.user
    </select>

    <!--parameterType="int"：输入参数的类型-->
    <select id="getUserById" parameterType="int" resultType="com.lys.pojo.User">
        <!--#{id}：获得输入参数的id-->
        select * from mybatis.user where id=#{id}
    </select>

    <!--对象中的属性可以直接取出来-->
    <insert id="addUser" parameterType="com.lys.pojo.User">
        insert into mybatis.user (id,name,pwd) values(#{id},#{name},#{pwd})
    </insert>

    <update id="updateUser" parameterType="com.lys.pojo.User">
        update mybatis.user set name=#{name},pwd=#{pwd} where id=#{id}
    </update>

    <delete id="deleteUser" parameterType="int">
        delete from mybatis.user where id=#{id}
    </delete>
</mapper>

 在mybatis-config.xml注册

    <!--每一个Mapper.xml都需要在Mybatis核心配置文件中注册-->
    <mappers>
        <mapper resource="com/lys/dao/UserMapper.xml"></mapper>
    </mappers>

5、编写测试类

public class UserDaoTest{

    @Test
    public void test(){
        SqlSession sqlSeession = null;

        try {
            //获取SqlSession对象
            sqlSeession = MybatisUtils.getSqlSeession();

            //执行SQL
            UserMapper mapper = sqlSeession.getMapper(UserMapper.class);
            List<User> userList = mapper.getUserList();

            for (User user : userList) {
                System.out.println(user);
            }

        } catch (Exception e) {
            e.printStackTrace();

        } finally {
            //关闭sqlSession
            sqlSeession.close();
        }
    }

    @Test
    public void getUserById(){

        SqlSession sqlSeession = MybatisUtils.getSqlSeession();

        UserMapper userMapper = sqlSeession.getMapper(UserMapper.class);

        User user = userMapper.getUserById(1);
        System.out.println(user);

        sqlSeession.close();
    }

    //增删改需要提交事务
    @Test
    public void addUser(){
        SqlSession sqlSeession = MybatisUtils.getSqlSeession();

        UserMapper userMapper = sqlSeession.getMapper(UserMapper.class);

        int res = userMapper.addUser(new User(4,"哈哈","126953"));
        if (res>0){
            System.out.println("插入成功！");
        }

        //提交事务
        //不提交的话无法插入成功
        sqlSeession.commit();

        sqlSeession.close();
    }

    @Test
    public void updateUser(){
        SqlSession sqlSeession = MybatisUtils.getSqlSeession();

        UserMapper userMapper = sqlSeession.getMapper(UserMapper.class);

        int res = userMapper.updateUser(new User(4,"呵呵","654522"));
        if (res>0){
            System.out.println("更新成功！");
        }

        sqlSeession.commit();

        sqlSeession.close();
    }

    @Test
    public void deleteuser(){

        SqlSession sqlSeession = MybatisUtils.getSqlSeession();

        UserMapper userMapper = sqlSeession.getMapper(UserMapper.class);

        userMapper.deleteUser(4);

        sqlSeession.commit();

        sqlSeession.close();

    }
}

注意：增删改操作需要手动提交事务

若要自动提交需要增加   sqlSessionFactory.openSession(true);