【小项目】SSM 实现单表 CRUD

SSM 实现单表 CRUD

一、数据库

数据库名 student
表名 student

字段

二、后端

1.依赖项

2.项目结构

3.Student.java 实体类

package com.sisyphus.studentssm.pojo;

/**
 * @Description: $
 * @Param: $
 * @return: $
 * @Author: Sisyphus
 * @Date: $
 */
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.StudentDao 接口

package com.sisyphus.studentssm.dao;

import com.sisyphus.studentssm.pojo.Student;

public interface StudentDao {
    Student queryById(Integer id);

    void insert(Integer id, String name, String email, Integer age);

    void deleteById(Integer id);

    void update(Student student);
}

5.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.sisyphus.studentssm.dao.StudentDao">
    <select id="queryById" resultType="com.sisyphus.studentssm.pojo.Student">
        select id,name,email,age from student where id = #{id}
    </select>

    <insert id="insert">
        insert into student values (#{id},#{name},#{email},#{age})
    </insert>

    <delete id="deleteById">
        delete from student where id = #{id}
    </delete>

    <update id="update">
        update student set name=#{name},email=#{email},age=#{age} where id = #{id}
    </update>
</mapper>

6.StudentService 接口

package com.sisyphus.studentssm.service;

import com.sisyphus.studentssm.pojo.Student;

public interface StudentService {
    Student queryById(Integer id);

    void insert(Integer id, String name, String email, Integer age);

    void deleteById(Integer id);

    void update(Student student);
}

7.StudentServiceImpl.java

package com.sisyphus.studentssm.service;

import com.sisyphus.studentssm.dao.StudentDao;
import com.sisyphus.studentssm.pojo.Student;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 * @Description: $
 * @Param: $
 * @return: $
 * @Author: Sisyphus
 * @Date: $
 */
@Service
public class StudentServiceImpl implements StudentService{

    @Autowired
    private StudentDao studentDao;

    @Override
    public Student queryById(Integer id) {
        return studentDao.queryById(id);
    }

    @Override
    public void insert(Integer id, String name, String email, Integer age) {
        studentDao.insert(id,name,email,age);
    }

    @Override
    public void deleteById(Integer id) {
        studentDao.deleteById(id);
    }

    @Override
    public void update(Student student) {
        studentDao.update(student);
    }
}

8.StudentController.java

package com.sisyphus.studentssm.controller;

import com.sisyphus.studentssm.pojo.Student;
import com.sisyphus.studentssm.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

/**
 * @Description: $
 * @Param: $
 * @return: $
 * @Author: Sisyphus
 * @Date: $
 */
@RestController
@RequestMapping("student")
public class StudentController {

    @Autowired
    private StudentService studentService;

    @RequestMapping("query")
    public Student queryById(@RequestParam("id") Integer id){
        return studentService.queryById(id);
    }

    @RequestMapping("insert")
    public void insert(@RequestParam("id") Integer id, @RequestParam("name") String name, @RequestParam("email") String email, @RequestParam("age") Integer age){
        studentService.insert(id,name,email,age);
    }

    @RequestMapping("delete")
    public void deleteById(@RequestParam("id") Integer id){
        studentService.deleteById(id);
    }

    @RequestMapping("update")
    public void update(@RequestParam("student") Student student){
        studentService.update(student);
    }
}

9.application.yml

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/student?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
    username: root
    password: root

mybatis:
  mapper-locations: classpath:mapper/*.xml

10.StudentSsmApplication.java

package com.sisyphus.studentssm;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.sisyphus.studentssm.dao")
public class StudentSsmApplication {

    public static void main(String[] args) {
        SpringApplication.run(StudentSsmApplication.class, args);
    }

}