Mybatis入门环境配置及控制台测试（详细）

Mybatis入门环境配置及控制台测试（详细）

---

想了解更多可以访问官方mybatis网站或者开源github网站查看学习

• https://mybatis.org/mybatis-3/zh/index.html
• https://github.com/search?q=mybatis&type=

  ---

开发工具

• 使用开发工具IDEA2019版
•  数据库MYSQL5.1版
• jdk1.8版

---

一、mybatis环境搭建

新建maven项目为父项目

1. 创建数据表

CREATE TABLE `students` (
  `sid` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `password` varchar(255) default NULL,
  `age` int(255) default NULL,
  `phone` varchar(255) default NULL,
  `gender` varchar(255) default NULL,
  `hobbies` varchar(255) default NULL,
  `address` varchar(255) default NULL,
  PRIMARY KEY  (`sid`)
) ENGINE=InnoDB AUTO_INCREMENT=1003 DEFAULT CHARSET=utf8;

INSERT INTO `students` VALUES (1001, '李', '123456', 20, '123456', '男', '打篮球', '北京大学');
INSERT INTO `students` VALUES (1002, '刘', '123456', 30, '123456', '女', '打游戏', '清华大学');

2. 配置子pom.xml文件

<?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">
    <parent>
        <artifactId>mybatistest</artifactId>
        <groupId>cn.yunhe.java</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>
<packaging>war</packaging>
    <artifactId>mybatis0809</artifactId>
<dependencies>
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.35</version>

    </dependency>

    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.5.5</version>
    </dependency>
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.13</version>

    </dependency>
</dependencies>

</project>

3. 在java目录下创建工具类Util.java文件

package cn.yunhe.java.util;

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 java.io.IOException;
import java.io.InputStream;

//创建mybatis的工具类
public class Util {
    //获取sqlSessionFactory对象
    private static SqlSessionFactory sqlSessionFactory;
    static {
        try {
            String resource = "mybatis-config.xml";
            InputStream inputStream = Resources.getResourceAsStream(resource);
            sqlSessionFactory= new SqlSessionFactoryBuilder().build(inputStream);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    //既然有了SqlSessionFactory就可以获取SqlSession的实例了
    //SqlSession完全包含了面向数据库执行SQL命令所需要的方法
    public static SqlSession getSqlSession(){
        return  sqlSessionFactory.openSession();

    }
}

4. 在java目录下创建实体类pojo，Student.java

package cn.yunhe.java.pojo;
//实体类
public class Students {
    private Integer sid;
    private  String name;
    private  String password;
    private  String age;
    private  String gender;
    private  String hobbies;
    private  String address;

//无参

    public Students() {

    }

    //有参
    public Students(Integer sid, String name, String password, String age, String gender, String hobbies, String address) {
        this.sid = sid;
        this.name = name;
        this.password = password;
        this.age = age;
        this.gender = gender;
        this.hobbies = hobbies;
        this.address = address;
    }

    public void setSid(Integer sid) {
        this.sid = sid;
    }

    public String getName() {
        return name;
    }

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

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getAge() {
        return age;
    }

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

    public String getGender() {
        return gender;
    }

    public void setGender(String gender) {
        this.gender = gender;
    }

    public String getHobbies() {
        return hobbies;
    }

    public void setHobbies(String hobbies) {
        this.hobbies = hobbies;
    }

    public String getAddress() {
        return address;
    }

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

    @Override
    public String toString() {
        return "Students{" +
                "sid=" + sid +
                ", name='" + name + '\'' +
                ", password='" + password + '\'' +
                ", age='" + age + '\'' +
                ", gender='" + gender + '\'' +
                ", hobbies='" + hobbies + '\'' +
                ", address='" + address + '\'' +
                '}';
    }
}

5. 在java目录下创建dao的接口，StuDao.java

package cn.yunhe.java.dao;

import cn.yunhe.java.pojo.Students;

import java.util.List;
//dao接口等价于mapper
public interface StuDao {
    /**
     * 查询全部学生信息
     *
     * @return
     */
    List<Students> getStudentsAll();

}

 6. 在resourcs目录下配置映射mapper（相当于dao接口的实现），mapper.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">
<!--        namespace相当于绑定对应dao层/mapper接口-->
<mapper namespace="cn.yunhe.java.dao.StuDao">
//在此处实现sql的增删改差，例：演示表的queryAll
    <select id="getStudentsAll" resultType="cn.yunhe.java.pojo.Students">
        select * from  students
        </select>
</mapper>

7.  在resourcs目录下配置数据库，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>
    <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/student?useUnicode=true&amp;serverTimezone=Asia/Shanghai"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="mapper.xml"/>
    </mappers>
</configuration>

8. console测试结果如下