Mybatis增删改查

最新推荐文章于 2022-04-10 11:31:29 发布

仗键盘走天涯

最新推荐文章于 2022-04-10 11:31:29 发布

阅读量139

点赞数

分类专栏： mybatis 文章标签： mybatis

本文链接：https://blog.csdn.net/weixin_44249688/article/details/107893804

版权

mybatis 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

Mybatis进行增删改查

项目结构

在这里插入图片描述

1.首先创建student表

create mybatis；
use mybatis；
创建表自己创，创什么样实体类就写什么样

2.创建maven项目导入依赖

<?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">
  <modelVersion>4.0.0</modelVersion>

  <groupId>com.zmk</groupId>
  <artifactId>ch03-proxy-dao</artifactId>
  <version>1.0-SNAPSHOT</version>


  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>1.8</maven.compiler.source>
    <maven.compiler.target>1.8</maven.compiler.target>
  </properties>
	<!-- 导入mybatis依赖-->
  <dependencies>
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.5.1</version>
    </dependency>
    <!-- 导入MySQL驱动 导入对应版本驱动，如mysql8.0的数据库需要导入8版本的驱动-->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.47</version>
    </dependency>
	<!-- 导入测试所用依赖-->
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
      <scope>test</scope>
    </dependency>
  </dependencies>
  <build>
    <resources>
      <resource>
        <directory>src/main/java</directory>
        <includes>
          <include>**/*.properties</include>
          <include>**/*.xml</include>
        </includes>
        <filtering>false</filtering>
      </resource>

    </resources>
  </build>
</project>

3.创建实体类

package com.zmk.domain;

public class Student {
    private Integer id;
    private String name;
    private String email;
    private  Integer age;

    @Override
    public String toString() {
        return "Student{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", email='" + email + '\'' +
                ", age=" + age +
                '}';
    }


    public Integer getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

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

    public String getEmail() {
        return email;
    }

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

    public Integer getAge() {
        return age;
    }

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

4.创建实体类对应的接口

package com.zmk.dao;

import com.zmk.domain.Student;

import java.util.List;

public interface StudentDao {
    //查询
    List<Student> selectStudents();
    //增加
    int insertStudent(Student student);
    //  更新
    int updateStudent(Student student);
    //删除
    int deleteStudent(int id);
}

5.在resource资源文件夹下创建mybatis的主配置该文件主要用于配置与数据库的连接与SQL映射文件的指向地址

<?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>
    <!--    settings是控制全局行为-->
    <settings>
        <!--        logimpl是指日志  STDOUT_LOGGING是指打印到控制台中-->
        <setting name="logImpl" value="STDOUT_LOGGING"/>
    </settings>
    <!--    环境配置 数据库的连接信息  development-->
    <environments default="mydev">
        <!--  一个数据库信息的配置 环境   id：一个唯一值 自定义 表示环境的名称-->
        <environment id="mydev">
            <!--            mybatis的事务类型 type：JDBC（表示使用jdbc中的connection对象的commit，rollback做事务处理）-->
            <transactionManager type="JDBC"/>
            <!--  DataSource：表示数据源，连接数据库的   type：表示数据源的类型，pooled表示使用连接池          -->
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url"
                          value="jdbc:mysql://localhost:3306/mybatis?useUnicode=true&amp;characterEncoding=utf8"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
    </environments>
    <!--    mappers 指的是sqlmapper的映射文件位置-->
    <mappers>
        <mapper resource="com\zmk\dao\StudentDao.xml"/>
    </mappers>
</configuration>
        <!--
mybatis的主配置文件 ：主要定义了数据库的基本配置信息，sql映射文件的位置

-->

6.创建SQL映射文件，创建在StudentDao接口同一目录下，名字建议与接口名相同。

<?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 namespace="com.zmk.dao.StudentDao">
    <!-- 查询SQL  注意：这里面的id是唯一值，后续就是获取id执行sql，id规范一般与接口中的方法名一致 -->
    <select id="selectStudents" resultType="com.zmk.domain.Student">
    select id,name,email,age from student order by id
    </select>
    <!-- 增加SQL-->
    <insert id="insertStudent">
        insert into student values (#{id},#{name},#{email},#{age})
    </insert>
    <!-- 更新SQL-->
    <update id="updateStudent">
        update student set id=#{id},name =#{name}, email=#{email}, age=#{age} where id=#{id}
    </update>
    <!-- 删除SQL-->
    <delete id="deleteStudent">
        delete from student where id=#{id}
    </delete>
</mapper>

7.编写获取sqlsession对象的工具类，简化代码量

package com.zmk.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 factory=null;//提高作用范围
    //静态代码块
    static {
        String config="mybatis.xml";//获取mybatis配置文件
        try {
            InputStream in=Resources.getResourceAsStream(config);
            //创建sqlsessionfactory对象使用sqlsessionfactorybuilder
             factory=new SqlSessionFactoryBuilder().build(in);
        } catch (IOException e) {
            e.printStackTrace();
        }

    }
//获取sqlsession方法
    public static SqlSession getSqlSession(){
        SqlSession sqlSession=null;
        if (factory!=null){
            sqlSession=factory.openSession();//这个是非自动提交事务
        }
            return sqlSession;
    }
}

8.编写测试类进行测试

package com.zmk;

import com.zmk.dao.StudentDao;
import com.zmk.domain.Student;
import com.zmk.utils.MyBatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.List;

public class TestMybatis {
    @Test
    //查询测试
    public void testSelectStudent(){
        //从工具类中获取sqlsession对象
        SqlSession sqlSession= MyBatisUtils.getSqlSession();
        //动态代理指向StudenDao.xml里面的查询sql
        StudentDao dao=sqlSession.getMapper(StudentDao.class);
        List<Student>studentList=dao.selectStudents();
        for (Student stu:studentList){
            System.out.println("学生："+stu);
        }
    }
    @Test
    //增加测试 必须sqlSession.commit提交事务 不提交事务数据只会执行而不会传入数据库进行持久化
    public void testInsertStudent(){
       SqlSession sqlSession=MyBatisUtils.getSqlSession();
       StudentDao dao=sqlSession.getMapper(StudentDao.class);
       Student student=new Student();
       student.setId(1006);
       student.setName("关羽");
       student.setEmail("guanyu@qq.com");
       student.setAge(30);
       int num=dao.insertStudent(student);
       sqlSession.commit();
        System.out.println("插入"+num+"条");
        System.out.println("插入的数据为"+student);
    }

    @Test
    //更新测试 必须sqlSession.commit提交事务
    public void testUpdateStudent(){
        SqlSession sqlSession=MyBatisUtils.getSqlSession();
        StudentDao dao=sqlSession.getMapper(StudentDao.class);
        Student student=new Student();
        student.setId(1001);
        student.setName("刘备");
        student.setEmail("liubei@qq.com");
        student.setAge(40);
        int update=dao.updateStudent(student);
        sqlSession.commit();
        System.out.println("更新"+update+"条数据");
        System.out.println("变更数据为"+student);
    }
    @Test
    //删除测试 必须sqlSession.commit提交事务
    public void testDeleteStudent(){
        SqlSession sqlSession=MyBatisUtils.getSqlSession();
        StudentDao dao=sqlSession.getMapper(StudentDao.class);
        int delete=dao.deleteStudent(1006);
        sqlSession.commit();
        System.out.println("删除"+delete+"条数据");
    }
}