搭建ssm下增删改查框架（增删改查代码）

怼烎@ 2023-10-06 21:57 21阅读 0赞

**目录**

1.框架搭建

2.增删改查

1.编写数据库

2.编写实体类 Student.java

3.编写Mapper层StudentMapper.xml

4.编写Dao层接口 StudentDao.java

5.编写Service层IStudentService.java接口

6. 编写Service层下的实现层impl IStudentServiceImpl.java

7.最后一步，编写Controller层 StudentController.java

8.测试

--------------------

### 1.框架搭建 ###

在资源中我已上传一个maven02压缩包，这个是个maven项目，导入即可

注意：在idea中导入项目时候选择pom.xml文件，按项目导入就行。

### 2.增删改查 ###

#### 1.编写数据库 ####

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5Y-r5oiR6ICB5Lyv_size_20_color_FFFFFF_t_70_g_se_x_16][]

#### 2.编写实体类 Student.java ####

package com.javen.model;
    
    public class Student {
        private  Integer id;
        private String name;
        private String sex;
        private Integer 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 getSex() {
            return sex;
        }
    
        public void setSex(String sex) {
            this.sex = sex;
        }
    
        public Integer getAge() {
            return age;
        }
    
        public void setAge(Integer age) {
            this.age = age;
        }
    
        @Override
        public String toString() {
            return "Student{" +
                    "id=" + id +
                    ", name='" + name + '\'' +
                    ", sex='" + sex + '\'' +
                    ", age=" + age +
                    '}';
        }
    }

#### 3.编写Mapper层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.javen.dao.StudentDao">
        <select id="findAll" resultType="com.javen.model.Student">
            select * from student
        </select>
    
        <insert id="insert" parameterType="com.javen.model.Student">
             insert into student (name,sex,age) values (#{name},#{sex},#{age})
        </insert>
    
        <delete id="delete" parameterType="java.lang.Integer">
            delete from student where id = #{id}
        </delete>
        <update id="update" parameterType="com.javen.model.User">
           update  student set name = #{name} , sex = #{sex}, age = #{age} where id = #{id}
        </update>
    </mapper>

#### 4.编写Dao层接口 StudentDao.java ####

package com.javen.dao;
    
    import com.javen.model.Student;
    import com.javen.model.User;
    
    import java.util.List;
    
    public interface StudentDao {
        public List<Student> findAll();
        public int insert(Student student);
        public int delete(Integer id );
        public int update(Student student);
    }

#### 5.编写Service层IStudentService.java接口 ####

package com.javen.service;
    
    import com.javen.model.Student;
    
    import java.util.List;
    
    public interface IStudentService {
        public List<Student> findAll();
        public int insert(Student student);
        public int delete(Integer id );
        public int update(Student student);
    }

#### **6. 编写Service层下的实现层impl IStudentServiceImpl.java** ####

package com.javen.service.impl;
    
    import com.javen.dao.StudentDao;
    import com.javen.model.Student;
    import com.javen.service.IStudentService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import java.util.List;
    @Service
    public class IStudentServiceImpl implements IStudentService {
        @Autowired
        private StudentDao studentDao;
    
        public List<Student> findAll() {
            return this.studentDao.findAll();
        }
    
        public int insert(Student student) {
            return this.studentDao.insert(student);
        }
    
        public int delete(Integer id) {
            return this.studentDao.delete(id);
        }
    
        public int update(Student student) {
            return this.studentDao.update(student);
        }
    }

#### 7.最后一步，编写Controller层 StudentController.java ####

package com.javen.controller;
    
    import com.javen.model.Student;
    import com.javen.model.User;
    import com.javen.service.IStudentService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.ResponseBody;
    
    import java.util.List;
    
    @Controller
    @RequestMapping("/student")
    public class StudentController {
        @Autowired
        private IStudentService studentService;
    
        @RequestMapping("/findAll")
        @ResponseBody
        public List<Student> findAll(){
            List<Student> students = studentService.findAll();
            return students;
        }
        @ResponseBody
        @RequestMapping("/insert")
        public int insert(Student student) {
            int count = studentService.insert(student);
            /*System.out.println(count);*/
            return count;
        }
        @ResponseBody
        @RequestMapping("/delete")
        public int delete(Integer id){
            int count = studentService.delete(id);
            /*System.out.println(count);*/
            return count;
        }
        @ResponseBody
        @RequestMapping("/update")
        public int update(Student student){
            int count = studentService.update(student);
            /*System.out.println(count);*/
            return count;
        }
    }

#### 8.测试 ####

通过postman进行测试

**findAll**

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5Y-r5oiR6ICB5Lyv_size_20_color_FFFFFF_t_70_g_se_x_16 1][]

**insert**

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5Y-r5oiR6ICB5Lyv_size_20_color_FFFFFF_t_70_g_se_x_16 2][]

**delete**

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5Y-r5oiR6ICB5Lyv_size_20_color_FFFFFF_t_70_g_se_x_16 3][]

**update**

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5Y-r5oiR6ICB5Lyv_size_20_color_FFFFFF_t_70_g_se_x_16 4][]

[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5Y-r5oiR6ICB5Lyv_size_20_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/797ddcca733a4fdbbc7c28816d0a5fe1.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5Y-r5oiR6ICB5Lyv,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5Y-r5oiR6ICB5Lyv_size_20_color_FFFFFF_t_70_g_se_x_16 1]: https://img-blog.csdnimg.cn/0e1527a10eba4188b9cde640f8f7c0b9.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5Y-r5oiR6ICB5Lyv,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5Y-r5oiR6ICB5Lyv_size_20_color_FFFFFF_t_70_g_se_x_16 2]: https://img-blog.csdnimg.cn/9b9a6da5c3524ed5b56330c447ad9d8e.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5Y-r5oiR6ICB5Lyv,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5Y-r5oiR6ICB5Lyv_size_20_color_FFFFFF_t_70_g_se_x_16 3]: https://img-blog.csdnimg.cn/468a706c800448138f546b9b3b678ca1.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5Y-r5oiR6ICB5Lyv,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5Y-r5oiR6ICB5Lyv_size_20_color_FFFFFF_t_70_g_se_x_16 4]: https://img-blog.csdnimg.cn/4f33fb13fc4541a9ad52f0c7d930baa0.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5Y-r5oiR6ICB5Lyv,size_20,color_FFFFFF,t_70,g_se,x_16