mybatis初识

第一天

1. 准备数据库

CREATE TABLE `t_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

2.新建一个maven项目，

3. 在pom.xml文件中导入依赖如下

<dependencies>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.6</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.40</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.13.2</version>
            <scope>test</scope>
        </dependency>

        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.12</version>
        </dependency>

    </dependencies>

    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
        <java.version>14</java.version>
        <maven.compiler.source>14</maven.compiler.source>
        <maven.compiler.target>14</maven.compiler.target>
        <encoding>UTF-8</encoding>
    </properties>

依赖报红解决：

4. 在java目录下面新建一个包，并建立用户实体类

package ztw.mybatis.bean;

public class User {
    private int id;
    private String name;
    private int age;
    private String address;

    public User() {
    }

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

    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 int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

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

5. 在resources下面新建配置文件mybatis-config.xml 类容如下

<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DID Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <!--配置实体类的别名-->
    <typeAliases>
        <typeAlias type="ztw.mybatis.bean.User" alias="User"/>
    </typeAliases>
    <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://localhost:3306/testdb"/>
                <property name="username" value="root"/>
                <property name="password" value="15183644715"/>
            </dataSource>
        </environment>
    </environments>
    <!--配置实体关系映射器文件-->
    <mappers>
        <mapper resource="mapper/UserMapper.xml"/>
    </mappers>
</configuration>

6.在resources下面新建日志属性文件 log4j.properties

log4j.rootLogger=WARN, stdout, logfile
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d %p [%c] - %m%n
log4j.appender.logfile=org.apache.log4j.FileAppender
log4j.appender.logfile.File=target/mybatis.log
log4j.appender.logfile.layout=org.apache.log4j.PatternLayout
log4j.appender.logfile.layout.ConversionPattern=%d %p [%c] - %m%n

7. 下面新建目录mapper 在下面创建mybatis配置文件

<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DID Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="ztw.mybatis.mapper.UserMapper">
    <select id="findByid" parameterType="int" resultType="User">
        select * from t_user where  id = #{id};
    </select>
    <select id="findAll" resultType="User">
        select * from t_user;
    </select>
</mapper>

8. 在test中创建测试类

package ztw.mybatis.bean;
/**
 * 功能：测试用户操作
 */

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.After;
import org.junit.Before;
import org.junit.Test;

import java.io.IOException;
import java.io.Reader;
import java.util.List;

public class TestUserOperation {
   private SqlSession sqlSession;

   @Before
    public void init() {
       try {
           //读取mybatis配置文件
           Reader reader = Resources.getResourceAsReader("mybatis-config.xml");
           //基于mybatis配置文件构建SQL回话工厂
           SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
           //利用SQL回话工厂获取SQL回话
           sqlSession = factory.openSession();
           //提示SQL回话创建成功
           System.out.println("sqlSession对象已创建");
       } catch (IOException e) {
           e.printStackTrace();
       }
   }

   @Test
   public void testFindByid(){
       int id = 1;
       User user = sqlSession.selectOne("ztw.mybatis.mapper.UserMapper.findByid",id);
       if(user != null){
           System.out.println(user);
       } else {
           System.out.println("编号为["+id+"]的用户没有找到");
       }
   }
   @Test
   public void testFindAll(){
       List<User> users =sqlSession.selectList("ztw.mybatis.mapper.findAll");
   }
   @After
    public void destory() {
       //关闭SQL回话
       sqlSession.close();
       System.out.println("sqlsessoin对象已经关闭");
   }
}