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';
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

pom.xml:

    4.0.0

    org.example
    mybatis_0822_KTLX2
    1.0-SNAPSHOT

    
        8
        8
        5.3.14
        1.4
        3.4.6
        1.3.2
        8.0.11
    
    
        
        
            org.springframework
            spring-context
            ${spring.version}
        
        
            org.springframework
            spring-jdbc
            ${spring.version}
        
        
        
            commons-dbcp
            commons-dbcp
            ${commons-dbcp.version}
        
        
        
            org.mybatis
            mybatis
            ${mybatis.version}
        
        
        
            mysql
            mysql-connector-java
            ${mysql-connector-java.version}
        
        
        
            org.mybatis
            mybatis-spring
            ${mybatis-spring.version}
        
        
        
            com.github.pagehelper
            pagehelper
            5.1.4
        
        
        
            com.github.abel533
            mapper
            3.0.1
        
    


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70

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 +
                '}';
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63

StudentMapper:

package com.mapper;

import com.entity.Student;

import java.util.List;

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

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

StudentMapper.xml:

    
        select * from tb_student
    

    
        insert into tb_student
        (name,sex,birthday)
        values
        (#{name},#{sex},#{birthday})
    

    
        update tb_student
        set name=#{name},sex=#{sex},birthday=#{birthday}
        where student_id=#{studentId}
    

    
        delete from tb_student where student_id=#{studentId}
    



1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29

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

1
2
3
4
5

mybatis-config.xml:

    
        
        
    




1
2
3
4
5
6
7
8
9
10
11
12
13
14

spring-1.xml:

    
    
    
    
    
    
        
        
        
        
    
    
    
        
        
        
        
        
        
        
        
    
    
    
        
        
        
        
    


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

IStudentService:

package com.service;

import com.entity.Student;

import java.util.List;

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

}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

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 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 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);
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60

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 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());

    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53

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

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

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

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

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