Mybatis初体验

Mybatis

change log

created by prince jay 
    April.13 Tuesday

简介

mybatis 官方参考文档:official docs

配置步骤

1. 登录mysql(mysql -u root -p)
2. 建数据库 create database mybatis;
3. 创建表，并插入数据
4. 创建mapper、pojo、utils三个包，建立起项目基本架构
5. 创建、resources/mybatisconfig.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.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=true&amp;useUnicode=true&amp;characterEncoding=utf8"/>
                <property name="username" value="root"/>
                <property name="password" value="jay123456789"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
<!--        注意如果使用resources，则要用斜杠来分割-->
        <mapper resource="com/jaycigar/mapper/userMapper.xml"/>
<!--        如果使用class就用常规包名来分割-->
<!--        mapper中指定的路径是我们后续写的方法接口-->
        <mapper class="com.jaycigar.mapper.UserMapper"/>
    </mappers>
</configuration>

注意事项：代码中注释所示
6. 创建实体类
创建实体类/pojo/user对应数据库中的数据,有参加无参构造，get&set&toString

package com.jaycigar.pojo;

/**
 * @author CigarJay
 * @create 2021-04-13 10:34
 */
public class User {

    private int id;  //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 + '\'' +
                '}';
    }
}

7. 创建/mapper/UserMapper接口

package com.jaycigar.mapper;

import com.jaycigar.pojo.User;

import java.util.List;

/**
 * @author CigarJay
 * @create 2021-04-13 10:39
 */
public interface UserMapper {
    List<User> selectAll();
}

接口中可以放增删改查各种方法
8. 创建/mapper/userMapper.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="com.jaycigar.mapper.UserMapper">
    <select id="selectAll" resultType="com.jaycigar.pojo.User">
        select * from user
    </select>
</mapper>

注意事项：mapper的属性中一定要加上namespace指向Mapper接口！
9. 创建工具类MybatisUtils

package com.jaycigar.utils;

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;

/**
 * @author CigarJay
 * @create 2021-04-13 10:44
 */
public class MybatisUtils {
    private static SqlSessionFactory sqlSessionFactory;

    static {
        String resource = "mybatis-config.xml";
        try (InputStream inputStream = Resources.getResourceAsStream(resource)){
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    public static SqlSession getSession(){
        return sqlSessionFactory.openSession();
    }

}

10. 测试类
    /src/test/java/MyTest

import com.jaycigar.pojo.User;
import com.jaycigar.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;

import java.util.List;

/**
 * @author CigarJay
 * @create 2021-04-13 10:50
 */
public class MyTest {
    public static void main(String[] args) {
        SqlSession session= MybatisUtils.getSession();
        List<User> list = session.selectList("com.jaycigar.mapper.UserMapper.selectAll");
        for (User user : list) {
            System.out.println(user);
        }
    }
}

首先获取sqlSession
然后就可以使用接口中的方法了

注意事项

• maven在过滤项目的时候会忽略java下的xml文件，导致出现can’t
  find resources userMapper.xml的问题
  我们需要在maven中(pom.xml)加上下面的配置

<build>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>false</filtering>
            </resource>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>false</filtering>
            </resource>
        </resources>
    </build>

结语

ok,mybatis的配置到此就结束了，本人才疏学浅，尽管尽力修改，但是难免有问题，如有疏漏，欢迎指正 ！
Copyright © Prince Jay
转载请注明出处!