2021-07-21学习笔记初识batis

1.配置mybatis-config.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>
    <properties resource="jdbc.properties"/>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="user.xml"/>
    </mappers>
</configuration>

---

2.配置jdbc.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/class8
jdbc.username=root
jdbc.password=12345678

配置完了数据库连接的环境

---

3.配置user.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="zjhsxl">
    <insert id="addUser" parameterType="com.pro.domain.User">
        insert into user(userId,userName,password) values(#{userId},#{userName},#{password})
    </insert>
</mapper>

---

4编写测试类

package com.pro.test;

import com.pro.domain.User;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;

import java.io.IOException;
import java.io.InputStream;

public class MyTest {

    @Test
    public void testSave() throws IOException {
        //拿到配置文件 mybatis-config
        //准备一个管道 ，接在mybatis-config后面
        InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
        //使用这个文件，创建一个工厂
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);
        //工厂开始工作，生产了一个产品，sqlSession对象，这个对象是封装了对数据库的操作，里面有很多的方法
        SqlSession sqlSession = sqlSessionFactory.openSession();
        User user = new User(7,"小芳","123");
        sqlSession.insert("zjhsxl.addUser",user);
        sqlSession.commit();
        sqlSession.close();

    }

}

---

5运行测试类，成功完成数据库添加