MyBatis实现增删改查

目录

准备环境

一、创建mybatis核心配置文件

二、创建实体类

三、创建mapper接口

四、创建mapper接口的映射文件

五、创建测试类

---

准备环境

使用工具：IntelliJ IDEA 2020版，navicat；使用maven管理项目。

maven中添加的依赖：

  <dependencies>
        <!--数据库驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.40</version>
        </dependency>
        <!--mybatis依赖-->
        <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>
            <scope>test</scope>
        </dependency>
    </dependencies>

也可以添加loj4j的依赖，方便查看日志。代码出错时方便查看是哪里出了问题。

一、创建mybatis核心配置文件

在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>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <!--加载驱动-->
                <property name="driver" value=""/>
                <!--地址-->
                <property name="url" value=""/>
                <!--用户名-->
                <property name="username" value=""/>
                <!--密码-->
                <property name="password" value=""/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <!--mapper接口的映射文件路径-->
        <mapper resource=""/>
    </mappers>
</configuration>

二、创建实体类

在Java包下新建一个包，包名为pojo，在pojo下新建一个实体类。实体类里写有set，get和toSting方法。

package pojo;

public class User {
    private Integer id;
    private String username;
    private String password;
    private String email;

    public User(Integer id, String username, String password, String email) {
        this.id = id;
        this.username = username;
        this.password = password;
        this.email = email;
    }

    public User() {
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

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

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                ", email='" + email + '\'' +
                '}';
    }
}

三、创建mapper接口

在Java包下新建一个包，包名为mapper，在mapper下新建一个接口。

package mapper;


import pojo.User;

import java.util.List;

public interface UserMapper {
    /**
     * 添加一个用户
     */
    int insertUser();

    /**
     * 修改功能
     */
    void upodate();
    /**
     * 删除功能
     */
    void deleteUser();
    /**
     * 根据id查询用户功能
     */
    User seleteUser();
    /**
     * 查询所有用户
     */
    List<User> seleteAll();
}

四、创建mapper接口的映射文件

映射文件标签中的id需要和mapper接口中的方法名保持一致。

<?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="mapper.UserMapper">

    <insert id="insertUser">
        insert into user value (null,"tom","123456","qwe@qq.com")
    </insert>

    <update id="upodate">
        update user set username = "jack" where id=3
    </update>

    <delete id="deleteUser">
        delete from user where id = 3
    </delete>
    <select id="seleteUser" resultType="pojo.User">
        select * from user where id = 2
    </select>
    <select id="seleteAll" resultType="pojo.User">
        select  * from user
    </select>

</mapper>

五、创建测试类

这里选取部分代码作为演示。测试类代码我上一篇博客mybatis入门有较为详细的讲解。

@Test
    public void SelectAll() throws IOException {
        InputStream inputStream = Resources.getResourceAsStream("mybatis.xml");
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession sqlSession = sqlSessionFactory.openSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        List<User> users = mapper.seleteAll();
        for (User user: users) {
            System.out.println(user);
        }
    }