spring整合mybatis实现数据库中学生数据的增删改查

运行结果：

查询：

插入：

查询：

修改：

查询：

删除：

查询：

参考：

参考：maven+mybatis—实现数据库中图书信息的增删改查https://blog.csdn.net/Liu_wen_wen/article/details/126347497?spm=1001.2014.3001.5501

代码结构整体布局：

代码如下：

创建数据库/表：

create table tb_student
(
    student_id int primary key auto_increment,
    name varchar(20),
    sex char(1),
    birthday date
);

select * from tb_student;

insert into tb_student
(name,sex,birthday)
select '张三','男','2001-01-01' UNION
select '李四','女','2002-01-02' union
select '王五','男','2002-01-01' union
select '赵六','男','2003-01-03' union
select '孙琪','男','2002-01-01' union
select '高达','女','2005-01-01' union
select '郭靖','男','2002-11-01' union
select '黄蓉','女','2002-09-01' union
select '大武','男','2002-01-05';

drop table classInfo;

create table tb_class_info
(
    class_id int primary key auto_increment,
    class_name varchar(20)
);
select * from tb_class_info;

insert into tb_class_info
(class_name)
select 'AAA01' UNION
select 'AAA02' UNION
select 'AAA03';

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

    <groupId>org.example</groupId>
    <artifactId>mybatis_0822_KTLX2</artifactId>
    <version>1.0-SNAPSHOT</version>

    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
        <spring.version>5.3.14</spring.version>
        <commons-dbcp.version>1.4</commons-dbcp.version>
        <mybatis.version>3.4.6</mybatis.version>
        <mybatis-spring.version>1.3.2</mybatis-spring.version>
        <mysql-connector-java.version>8.0.11</mysql-connector-java.version>
    </properties>
    <dependencies>
        <!--引入spring基础模块-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <!-- dbcp连接池 -->
        <dependency>
            <groupId>commons-dbcp</groupId>
            <artifactId>commons-dbcp</artifactId>
            <version>${commons-dbcp.version}</version>
        </dependency>
        <!-- mybatis -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>${mybatis.version}</version>
        </dependency>
        <!-- mysql驱动类 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>${mysql-connector-java.version}</version>
        </dependency>
        <!-- mybatis spring整合 -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>${mybatis-spring.version}</version>
        </dependency>
        <!--mybatis分页插件-->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>5.1.4</version>
        </dependency>
        <!--mybatis通用mapper插件-->
        <dependency>
            <groupId>com.github.abel533</groupId>
            <artifactId>mapper</artifactId>
            <version>3.0.1</version>
        </dependency>
    </dependencies>

</project>

Student:

package com.entity;

import java.util.Date;

public class Student {
    private Integer studentId;
    private String name;
    private String sex;
    private Date birthday;

    public Student() {
    }

    public Student(Integer studentId, String name, String sex, Date birthday) {
        this.studentId = studentId;
        this.name = name;
        this.sex = sex;
        this.birthday = birthday;
    }

    public Integer getStudentId() {
        return studentId;
    }

    public void setStudentId(Integer studentId) {
        this.studentId = studentId;
    }

    public String getName() {
        return name;
    }

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

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public Date getBirthday() {
        return birthday;
    }

    public void setBirthday(Date birthday) {
        this.birthday = birthday;
    }

    @Override
    public String toString() {
        return "Student{" +
                "studentId=" + studentId +
                ", name='" + name + '\'' +
                ", sex='" + sex + '\'' +
                ", birthday=" + birthday +
                '}';
    }
}

StudentMapper:

package com.mapper;

import com.entity.Student;

import java.util.List;

public interface StudentMapper {
    //查询
    List<Student> listAll();
    //添加
    int insert(Student student);
    //修改
    int update(Student student);
    //删除
    int delete(Integer studentId);
}

StudentMapper.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.mapper.StudentMapper">

    <select id="listAll" resultType="student">
        select * from tb_student
    </select>

    <insert id="insert" parameterType="student">
        insert into tb_student
        (name,sex,birthday)
        values
        (#{name},#{sex},#{birthday})
    </insert>

    <update id="update" parameterType="student">
        update tb_student
        set name=#{name},sex=#{sex},birthday=#{birthday}
        where student_id=#{studentId}
    </update>

    <delete id="delete" parameterType="int">
        delete from tb_student where student_id=#{studentId}
    </delete>

</mapper>

db.properties:

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/70816_db?useSSL=false&serverTimezone=Asia/Shanghai&characterEncoding=utf8&allowPublicKeyRetrieval=true
jdbc.username=root
jdbc.password=123456

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>

    <settings>
        <setting name="logImpl" value="STDOUT_LOGGING"/>
        <setting name="mapUnderscoreToCamelCase" value="true"/>
    </settings>

</configuration>

spring-1.xml:

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
    <!--扫包-->
    <context:component-scan base-package="com.service"/>
    <!--配置数据库连接的属性配置文件 db.properties-->
    <context:property-placeholder location="db.properties"/>
    <!--配置数据库连接池-->
    <bean id="ds" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="${jdbc.driver}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>
    <!--配置mybatis的SqlSessionFactory对象-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!--配置mybatis factory的数据源-->
        <property name="dataSource" ref="ds"/>
        <!--配置类型别名-->
        <property name="typeAliasesPackage" value="com.entity"/>
        <!--配置mybatis主配置文件的路径，mybatis主配置文件中，可以定义特定的配置-->
        <property name="configLocation" value="classpath:mybatis-config.xml"/>
        <!--配置mapper文件路径-->
        <property name="mapperLocations" value="classpath:com/mapper/*.xml"/>
    </bean>
    <!--配置Mapper接口-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <!--定义mapper接口所在的包-->
        <property name="basePackage" value="com.mapper"/>
        <!--配置sqlSessionFactory(底层会自动创建SqlSession从而)用于获取Mapper接口对象-->
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    </bean>

</beans>

IStudentService:

package com.service;

import com.entity.Student;

import java.util.List;

public interface IStudentService {
    //查询
    List<Student> listAll();
    //添加
    int insert(Student student);
    //修改
    int update(Student student);
    //删除
    int delete(Integer studentId);

}

StudentServiceImpl:

package com.service.impl;

import com.entity.Student;
import com.mapper.StudentMapper;
import com.service.IStudentService;
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 org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;

@Service
public class StudentServiceImpl implements IStudentService {
    @Autowired
    private StudentMapper studentMapper;

    @Override
    public List<Student> listAll() {
        return studentMapper.listAll();

//        InputStream inputStream=null;
//        try {
//            inputStream= Resources.getResourceAsStream("mybatis-config.xml"); //ctrl+alt+t try+catch
//            SqlSessionFactory factory=new SqlSessionFactoryBuilder().build(inputStream);
//            SqlSession session=factory.openSession();
//            StudentMapper studentMapper=session.getMapper(StudentMapper.class);
//            //System.out.println(studentMapper.listAll());
//            List<Student> studentList=studentMapper.listAll();
//
//            session.commit();
//            session.close();
//
//            return studentList;
//        } catch (IOException e) {
//            e.printStackTrace();
//        }
//        return null;
    }

    @Override
    public int insert(Student student) {
        return studentMapper.insert(student);
    }

    @Override
    public int update(Student student) {
        return studentMapper.update(student);
    }

    @Override
    public int delete(Integer studentId) {
        return studentMapper.delete(studentId);
    }
}

Test2:

package com.test;

import com.entity.Student;
import com.service.IStudentService;
import com.service.impl.StudentServiceImpl;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import java.sql.Date;
import java.util.List;

public class Test2 {
    public static void main(String[] args) {
//        IStudentService iStudentService=new StudentServiceImpl();
//        List<Student> studentList=iStudentService.listAll();
//        System.out.println(studentList);
        ApplicationContext ctx=new ClassPathXmlApplicationContext("spring-1.xml");
        IStudentService service=ctx.getBean(IStudentService.class);

//        //查询
//        System.out.println(service.listAll());

        //插入
//        Student student1=new Student();
//        student1.setName("姓名1");
//        student1.setSex("男");
//        student1.setBirthday(Date.valueOf("2022-08-23"));
//        int count1=service.insert(student1);
//        System.out.println("插入成功。记录数："+count1);

//        //查询
//        System.out.println(service.listAll());
//        //修改
//        Student student2=new Student();
//        student2.setStudentId(10);
//        student2.setName("姓名10");
//        student2.setSex("女");
//        student2.setBirthday(Date.valueOf("2010-10-10"));
//        int count2=service.update(student2);
//        System.out.println("修改成功。记录数："+count2);

//        //查询
//        System.out.println(service.listAll());
//        //删除
//        int count3=service.delete(10);
//        System.out.println("删除成功。记录数："+count3);

        //查询
        System.out.println(service.listAll());

    }
}

// A code block
var foo = 'bar';

// A code block
var foo = 'bar';

// A code block
var foo = 'bar';

// A code block
var foo = 'bar';

// A code block
var foo = 'bar';