ssm框架实现增删改查_基于ssm浮层修改数据-CSDN博客

1:整体概览(点击下载源代码,最好自己先调通)
2:步骤说明
2.1:StudentService添加相应的方法
public interface StudentService {
List list();
int total();
List list(Page page);
//增
public void add(Student student);
//删
public void delete(Student student);
//改
public void update(Student student);
//查
public Student get(int id);
}
2.2:Studentimpl实现(自然而然我们想到在Mapper中添加相应的方法)
package com.ccut.service.impl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.ccut.mapper.StudentMapper;
import com.ccut.page.Page;
import com.ccut.pojo.Student;
import com.ccut.service.StudentService;

@Service
public class StudentServiceImpl implements StudentService {
@Autowired
StudentMapper studentMapper;

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

@Override
public int total() {
	return studentMapper.total();
}

@Override
public List<Student> list(Page page) {
	return studentMapper.list(page);
}

@Override
public void add(Student student) {
	 studentMapper.add(student);
}

@Override
public void delete(Student student) {
	studentMapper.delete(student);
}

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

@Override
public Student get(int id) {
	Student student=new Student();
	student.setId(id);
	return studentMapper.get(student);
}

}
2.3:studentMapper添加相应方法
package com.ccut.mapper;

import java.util.List;

import com.ccut.page.Page;
import com.ccut.pojo.Student;

public interface StudentMapper {

public List<Student> list();

//分页查询
public List list(Page page);

public int total();

//增加
public void add(Student student);
//删
public void delete(Student student);
//改
public void update(Student student);
//查
public Student get(Student student);

}
2.4:studentMapper.xml添加相应sql语句(改我们先通过get方法获得,然后通过update去修改)

insert into student(name)
values(#{name})

delete from student where id=#{id}

<update id="update" parameterType="Student">
	update student set name=#{name} where id=#{id}
</update>

<select id="get" parameterType="Student" resultType="Student">
	select * from student where id=#{id}
</select>

2.5:我们写Controller
// 增加
@RequestMapping(“addStudent”)
public ModelAndView addStudent(Student student) {
studentService.add(student);
ModelAndView mav = new ModelAndView(“redirect:/listStudentBypage”);
return mav;
}

// 删除
@RequestMapping("deleteStudent")
public ModelAndView deleteStudent(Student student) {
	studentService.delete(student);
	ModelAndView mav = new ModelAndView("redirect:/listStudentBypage");
	return mav;
}

//修改,先通过get方法得到一个对象
@RequestMapping(“editStudent”)
public ModelAndView editStudent(Student student) {
Student st = studentService.get(student.getId());
System.out.println(st.toString());
ModelAndView mav = new ModelAndView(“editStudent”);
mav.addObject(“c”,st);
return mav;
}

// 修改
@RequestMapping("updateStudent")
public ModelAndView updateStudent(Student student) {
    studentService.update(student);
	ModelAndView mav = new ModelAndView("redirect:/listStudentBypage");
	return mav;
}

2.6:listStudent.jsp页面
<%@ page language=“java” contentType=“text/html; charset=utf-8”
pageEncoding=“utf-8”%>

<%@ taglib uri=“http://java.sun.com/jsp/jstl/core” prefix=“c”%>

Insert title here

id	name	编辑	删除
${c.id}	${c.name}	编辑	删除

<div style="text-align:center;margin-top:40px">
	
	<form method="post" action="addStudent">
		分类名称： <input name="name" value="" type="text"> <br><br>
		<input type="submit" value="增加分类">
	</form>
</div>

2.7:editStudent.jsp <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" import="java.util.*"%>

<%@ taglib uri=“http://java.sun.com/jsp/jstl/core” prefix=“c”%>

<div style="text-align:center;margin-top:40px">
	
	<form method="post" action="updateStudent">
		分类名称： <input name="name" value="${c.name}" type="text"> <br><br>
		<input type="hidden" value="${c.id}" name="id">
		<input type="submit" value="增加分类">
	</form>

</div>

2.8: 截图

2.9:流程分析
1:增删我们不用说了,就是在Controller调用相应方法完成

2:这个更新我们说一下,我们点击某一栏,我们传的是这一栏的id

编辑到我们的Controller中去

通过

Student st = studentService.get(student.getId());
System.out.println(st.toString());
ModelAndView mav = new ModelAndView(“editStudent”);
mav.addObject(“c”,st);
将这个Id内容的信息找出来,然后转到editStudent.jsp里面.效果如图

然后点击增加分类,将该的值传到Controller中,完成修改,重定向到listStudentByPage.jsp整体完成

// 修改
@RequestMapping(“updateStudent”)
public ModelAndView updateStudent(Student student) {
studentService.update(student);
ModelAndView mav = new ModelAndView(“redirect:/listStudentBypage”);
return mav;
}

作者：feifei_Eric
来源：CSDN
原文：https://blog.csdn.net/qq_37154446/article/details/79884255
版权声明：本文为博主原创文章，转载请附上博文链接！