Mybatis:基础环境搭建及‘增删改查’的使用（附带mybatis再*mapper.xml中写sql语句没有提示的解决办法）

本文链接：https://blog.csdn.net/Xixicjj/article/details/122094699

1.构建一个maven工程

2.搭建基本环境（导入依赖）

这里我用到了mysql、mybatis和junit。

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.27</version>
        </dependency>

        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.8</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/junit/junit -->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
        </dependency>

建议创建一个父类maven工程，将此类依赖放入父类xml文件中，在创建子类maven，这样就可以无需每个项目都手动导包。

3.配置核心xml文件

建议多多使用官方文档。其中的mappers中的xml文件为后续需编写的定义增删改查方法实现代码的xml文件的路径。(若放在resource文件中，则路劲写文件名即可)

<?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="db.properties" />


    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${driver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${user}"/>
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="UserMapper.xml"/>
    </mappers>
</configuration>

相关属性和jdbc一样。其中db.properties配置文件是对连接过程进行了一定的优化，里边存放了连接的相关数据，如驱动，用户名密码等等，通过下面语句来调用

<properties resource="db.properties" /> <--resource中为配置文件路径！ -->

连接数据库的相关属性这里便不在多说。

4.创建Mybatis.utils类，获取SqlSession的实例

package com.chenxi.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;

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 getSqlSession(){
            return sqlSessionFactory.openSession();
        }

    }

5.创建实体类

这里数据库中表的数据为：

则我们创建的实体类为：

package com.chenxi.pojo;

public class User {
    private int id;
    private String name;
    private String pwd;

    public String toString(){
        return this.id+this.name+this.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;
    }
}

注意！若没有重写toString方法则会输出指针

6.创建接口UserMapper

里面包含增删改查四种方法

package com.chenxi.mapper;

import com.chenxi.pojo.User;

import java.util.List;
import java.util.Map;

public interface UserMapper {
    //查询全部用户
    List<User> getList();
    //insert语句
    int addUser(User user);
    //Update用户
    int updateUser(User user);
    //delete用户
    int deleteUser(int id);


}

7.创建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.chenxi.mapper.UserMapper">

    <select id="getList" resultType="com.chenxi.pojo.User">
        select * from mybatis.user;
    </select>

    <insert id="addUser" parameterType="com.chenxi.pojo.User">
        insert into mybatis.user(id, name, pwd) values (#{id},#{name},#{pwd});
    </insert>

    <update id="updateUser" parameterType="com.chenxi.pojo.User">
        update mybatis.user set name=#{name},pwd=#{pwd} where id=#{id};
    </update>

    <delete id="deleteUser" parameterType="int">
        delete from mybatis.user where id=#{id};
    </delete>


</mapper>

8.测试！

package com.chenxi.Mapper;

import com.chenxi.mapper.UserMapper;
import com.chenxi.pojo.User;
import com.chenxi.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class UserMapperTest {


    @Test
    public void test(){
        //获取sqlSession对象
        SqlSession sqlSession=MybatisUtils.getSqlSession();
        //执行sql，通过UserMapper接口下的class对象。
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        List<User> list = mapper.getList();

        for(User user:list){
            System.out.println(user);
        }

        sqlSession.close();

    }

    @Test
    public void addUser(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        try {

            UserMapper mapper = sqlSession.getMapper(UserMapper.class);

            int i;
            i = mapper.addUser(new User(5, "武则天", "123456"));

            //提交事务
            sqlSession.commit();
            System.out.println(i);


        }finally {
            sqlSession.close();
        }
    }

    @Test
    public void updateUser() {
        SqlSession sqlSession = MybatisUtils.getSqlSession();
            try {

                UserMapper mapper = sqlSession.getMapper(UserMapper.class);

                int i = mapper.updateUser(new User(1, "杨过", "11001"));

                if (i > 0) {
                    System.out.println("修改成功！");
                }

                sqlSession.commit();


            } finally {
                sqlSession.close();
            }

    }
    @Test
    public void deleteUser(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();

        UserMapper mapper = sqlSession.getMapper(UserMapper.class);

        int i = mapper.deleteUser(3);

        if (i>0){
            System.out.println("删除成功");
        }

        sqlSession.commit();

        sqlSession.close();
    }
}