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”%>
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.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
版权声明:本文为博主原创文章,转载请附上博文链接!