双手使用Mybatis day1

什么是Mybatis？  

                它是一款半自动的ORM持久层框架，具有较高的SQL灵活性，支持高级映射(一对一，一对多)，动态SQL，延迟加载和缓存等特性，但它的数据库无关性较低

• Myba是一款优秀的持久层框架
• MyBatis 避免了几乎所有的 JDBC 代码和手动设置参数以及获取结果集的过程，减少了代码的冗余，减少程序员的操作。
• MyBatis 可以使用简单的 XML 或注解来配置和映射原生信息，将接口和 Java 的 实体类 【Plain Old Java Objects,普通的 Java对象】映射成数据库中的记录。
• MyBatis原来是apache的一个开源项目，叫做ibatis，2010年这个项目由apache迁移到了google code，并且改名为MyBatis
• 2013年11月官方代码迁移到GitHub
• MyBatis中文文档：https://mybatis.net.cn/
• GitHub：https://github.com/mybatis/mybatis-3
   

1.下载mybatis-3.5.1.jar

官方文档：http://mybatis.org/spring-boot-starter/mybatis-spring-boot-autoconfigure/

 Maven仓库地址：https://mvnrepository.com/artifact/org.mybatis.spring.boot/mybatis-spring-boot-starter/2.1.1

2.将所需jar文件导入工程

junit 

    <dependencies>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
        </dependency>

mybatis

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

MySQL

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
            <scope>provided</scope>
        </dependency>

3.编写MyBatis核心配置文件

在resource文件目录下进行创建xml的配置文件

<?xml version="1.0" encoding="UTF8" ?>
<!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://192.168.111.23:3306/mybatis?useSSL=true&amp;useUnicode=true&amp;characterEncoding=UTF-8"/>
                <property name="username" value="root"/>
                <property name="password" value="ok"/>
            </dataSource>
        </environment>
    </environments>

    <mappers>
        <mapper resource="com/kuang/dao/UserMapper.xml"/>
    </mappers>
</configuration>

4.创建实体类(POJO)

构建 SqlSessionFactory

public class MybatisUtils {
    private static SqlSessionFactory sqlSessionFactory;
   static {
        
       InputStream inputStream = null;
       try {
           inputStream = Resources.getResourceAsStream("mybatis-config.xml");
           sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
       } catch (IOException e) {
           e.printStackTrace();
       }
    }
    public static SqlSession getSession(){
       return sqlSessionFactory.openSession();
    }
}

public class User {
    private int id;
    private String name;
    private String pwd;

    public User() {
    }

    public User(int id, String name, String pwd) {
        this.id = id;
        this.name = name;
        this.pwd = pwd;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPwd() {
        return pwd;
    }

    public void setPwd(String pwd) {
        this.pwd = pwd;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", pwd='" + pwd + '\'' +
                '}';
    }
}

5.定义DAO层Mapper接口

public interface UserDao {
    List<User> getUserList();
}

6.定义SQL映射文件

<?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">
<mapper namespace="com.mybatis.mapper.UserMapper">
 
    <select id="selectAllReList" resultType="com.mybatis.Users">
        select * from users
    </select>
    <delete id="deleteById">
        delete from users where id > #{id}
    </delete>
    <insert id="insert">
        INSERT INTO `users` ( `name`, `pwd`) VALUES (#{name},#{pwd});
    </insert>
    <update id="updateById">
        UPDATE`users` SET `name` = #{name}, `pwd` = #{pwd} WHERE `id` = #{id};
    </update>
</mapper>

7.创建测试类

// 1. 读取MyBatis核心配置文件
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        //2. 创建SqISessionFactory实例
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        //3.创建SqlSession实例
        SqlSession sqlSession = sqlSessionFactory.openSession();
        UserMapper userMapper=sqlSession.getMapper(UserMapper.class);
        //4.创建Mapper实例执行SQL映射文件中的SQL语句
        List<User> users = userMapper.userAll();
        //员工未找到 通过id查询 缓存加载下
        System.out.println(users);
        //  关闭 session
        sqlSession.close();
        //除了查询 其他的增删改就得添加手动添加代码才能持久化
        // sqlSession.commit();