Java增删改查

最新推荐文章于 2022-06-20 17:21:18 发布

GeJinL

最新推荐文章于 2022-06-20 17:21:18 发布

阅读量96

点赞数

本文链接：https://blog.csdn.net/GeJinL/article/details/103138296

版权

//classes表entity

package com.example.demo.entity;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity(name="classes")
@Table(name="classes")
public class Classes {
   @Id @GeneratedValue(strategy=GenerationType.IDENTITY)
   private Integer cid;
   private String cname;
   public Integer getCid() {
       return cid;
   }
   public void setCid(Integer cid) {
       this.cid = cid;
   }
   public String getCname() {
       return cname;
   }
   public void setCname(String cname) {
       this.cname = cname;
   }

}

//classesDAO层方法

public interface ClassesDao extends PagingAndSortingRepository<Classes, Integer>,JpaSpecificationExecutor<Classes> {
   @Query(value="select * from classes",nativeQuery=true)
   List<Classes> findAll();
   @Query(value="select * from classes where cid=?1",nativeQuery=true)
   Classes findBYId(int cid);
}

//ClassesService层

@Service
public class ClassesService {
   @Autowired
   private ClassesDao classesDao;
   public List<Classes> findAll(){
       return classesDao.findAll();
   }
   public void save(Classes classes) {
       // TODO Auto-generated method stub
       classesDao.save(classes);
   }
   public Classes upda(Integer cid) {
       return classesDao.findBYId(cid);
   }
   public void delete(Classes classes) {
       classesDao.delete(classes);
   }
}

//Controller层

package com.example.demo.controller;

import java.util.List;

import javax.servlet.http.HttpServletRequest;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import com.example.demo.entity.Classes;
import com.example.demo.service.ClassesService;
import com.example.demo.service.StudentService;

@Controller
@RequestMapping("stus")
public class StudentController {

   @Autowired
   private StudentService studentService;

   @Autowired
   private ClassesService classesService;

   @RequestMapping("index")
   //@ResponseBody
   public String index(Model model) {
       List<Classes> data=classesService.findAll();
       model.addAttribute("data",data);
       return "pages/demo/root/index";
   }

   @RequestMapping("up")
   public String update(Model model,Integer cid) {
       Classes classes=classesService.upda(cid);
       model.addAttribute("classes",classes);
       return "pages/demo/root/Upde";
   }

   @RequestMapping("doUpDate")
   //@ResponseBody
   public String doUpDate(HttpServletRequest request) {

       Classes classes=new Classes();
       Integer cid=Integer.parseInt(request.getParameter("cid"));
       String cname=request.getParameter("cname");
       classes.setCid(cid);
       classes.setCname(cname);
       classesService.save(classes);
       return "redirect:/stus/index";
   }

   @RequestMapping("delete")
   //@ResponseBody
   public String delete(HttpServletRequest request) {
       Classes classes=new Classes();
       Integer cid=Integer.parseInt(request.getParameter("cid"));
       classes.setCid(cid);
       classesService.delete(classes);
       return "redirect:/stus/index";
   }

   @RequestMapping("add")
//   @ResponseBody
   public String add() {
       return "pages/demo/root/add";
   }
   @RequestMapping("adds")
   //@ResponseBody
   public String adds(HttpServletRequest request) {
       Classes classes=new Classes();
       String cname=request.getParameter("cname");
       classes.setCname(cname);
       classesService.save(classes);
       return "redirect:/stus/index";
   }

}

//主页面

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<script src="http://libs.baidu.com/jquery/2.0.0/jquery.js"></script>
<script src="http://api.map.baidu.com/api?v=2.0&ak=?"></script>
</head>
<body>
<table border="1" cellspacing="0" cellpadding="0" align="center" width="800px" style="text-align: center;">
   <tr>
       <td>序号</td>
       <td>班级</td>
       <td></td>
       <td></td>
   </tr>

   <tr th:each="stus : ${data}">
       <td name="id" th:text="${stus.cid}"></td>
       <td id="name" name="name" th:text="${stus.cname}"><span id="tx"></span></td>
       <td><a th:href="@{/stus/up(cid=${stus.cid})}">修改</a></td>
       <td><a th:href="@{/stus/delete(cid=${stus.cid})}">删除</a></td>
   </tr>
   <tr>
       <td><a href="/stus/add"> <input type="button" value="添加" ></a>
   </tr>
</table>
</body>
</html>

//添加页面

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form method="post" action="/stus/adds">
班级:<input type="text" name="cname" >
<input type="submit" name="submit" value="提交" >
</form>
</body>
</html>

//修改页面

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form method="post" action="/stus/doUpDate" th:object="${classes}">
       序号:<input type="text" name="cid" th:value="*{cid}" >
       班级:<input type="text" name="cname" th:value="*{cname}" >
       <input type="submit" name="submit" value="提交" >
   </form>
</body>
</html>