#第一次学习Myatis学习

第一次学习MyBatis学习

1. 创建testdb数据库并添加t_user表和其数据
   

2. 创建Meven项目
   

3. 在pom.xml文件中导入所需依赖
   

package net.olj.mybatis.bean;

public class User {
   private int id;
   private String name;
   private int age;
   private String 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 + '\'' +
               '}';
   }

}

4. 在java包下再创建一个文件夹并创建User类
   

package net.olj.mybatis.bean;

public class User {
    private int id;
    private String name;
    private int age;
    private String 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//DTD Config 3.0//EN"
       "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>
   <!--配置实体类别名-->
   <typeAliases>
       <typeAlias type="net.olj.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="p@ssw0rd"/>
           </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//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="net.olj.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. 创建TestUserOperation测试类

package net.olj.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; // SQL会话

   @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("net.olj.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("net.olj.mybatis.mapper.UserMapper.findAll");
       for (User user : users) {
           System.out.println(user);
       }
   }

   @After
   public void destroy() {
       // 关闭SQL会话
       sqlSession.close();
       // 提示用户SQL会话对象关闭
       System.out.println("sqlSession对象已关闭。");
   }
}

9. 最终结果
   1. FindById测试结果
      
      2.FindAll测试结果