• 自定义MVC增查

    目录

    一、配置自定义MVC环境

    1、将项目相关代码打包成jar包

    2、导入工程

    二、通用增删改的编写

    三、编写Dao方法层

     四、编写Action接收请求并处理

    五、编写service（相当于biz层）

    六、XML文件配置 

    七、前端代码

    一、配置自定义MVC环境

    1、将项目相关代码打包成jar包

    右键项目Export ==> Export...

    找到Java点击JAR flie 

     

    点击Next 注意勾选红色框框勾选的 随后建在对应的路径里，最后finish

     

    我们接着就把生成的jar包导入新的工程里--->并且把相关的依赖包也都导入--->再把我们分页标签的相关文件以及助手类导入；

    2、导入工程

    再建一个源文件夹：Source Folder

    将项目需要的config.xml文件 复制进来

    二、通用增删改的编写

    Student.java(学生实体类)

    1. package com.zking.model;
    2.  
    3. public class Student {
    4.     private Integer sid;
    5. 	
    6. 	private String sname;
    7. 	
    8. 	private Integer age;
    9. 	
    10. 	private String addr;
    11.  
    12. 	
    13. 	public Integer getSid() {
    14. 		return sid;
    15. 	}
    16.  
    17. 	public void setSid(Integer sid) {
    18. 		this.sid = sid;
    19. 	}
    20.  
    21. 	public String getSname() {
    22. 		return sname;
    23. 	}
    24.  
    25. 	public void setSname(String sname) {
    26. 		this.sname = sname;
    27. 	}
    28.  
    29. 	public Integer getAge() {
    30. 		return age;
    31. 	}
    32.  
    33. 	public void setAge(Integer age) {
    34. 		this.age = age;
    35. 	}
    36.  
    37. 	public String getAddr() {
    38. 		return addr;
    39. 	}
    40.  
    41. 	public void setAddr(String addr) {
    42. 		this.addr = addr;
    43. 	}
    44.  
    45. 	
    46. 	public Student(Integer sid, String sname, Integer age, String addr) {
    47. 		super();
    48. 		this.sid = sid;
    49. 		this.sname = sname;
    50. 		this.age = age;
    51. 		this.addr = addr;
    52. 	}
    53.  
    54. 	public Student() {
    55. 		// TODO Auto-generated constructor stub
    56. 	}
    57.  
    58. 	@Override
    59. 	public String toString() {
    60. 		return "Student [sid=" + sid + ", sname=" + sname + ", age=" + age + ", addr=" + addr + "]";
    61. 	}
    62. 	
    63. }

    三、编写Dao方法层

    StudentDao（dao层）

    1. ppackage com.yian.dao;
    2.  
    3. import java.sql.Connection;
    4. import java.sql.PreparedStatement;
    5. import java.sql.ResultSet;
    6. import java.sql.SQLException;
    7. import java.util.ArrayList;
    8. import java.util.List;
    9. import java.util.Objects;
    10.  
    11. import org.junit.Test;
    12. import org.w3c.dom.ls.LSOutput;
    13.  
    14. import com.zking.model.Student;
    15. import com.zking.util.BaseDao;
    16. import com.zking.util.BaseDao.ICovent;
    17. import com.zking.util.DBUtil;
    18. import com.zking.util.PageBean;
    19.  
    20. public class StudentDao implements IStudentDao{
    21. 	
    22. 	@Override
    23. 	public List getStudents(Student stu ,PageBean pageBean) {
    24. 	 
    25.      String sql="select sid,sname,age,addr from student ";
    26.      List param =new ArrayList();
    27.      if(stu!=null&&stu.getSname()!=null&&!"".equals(stu.getSname())) {
    28.     	 sql+=" where sname like ?";
    29.     	 param.add("%"+stu.getSname()+"%");
    30.      }
    31. 		return BaseDao.query(sql, param, pageBean,new ICovent() {
    32.  
    33. 			@Override
    34. 			public List convent(ResultSet rs) throws SQLException {
    35.                Listlist=new ArrayList();
    36.                while(rs.next()) {
    37.             	   Student s=new Student();
    38.             	   s.setSid(rs.getInt("sid"));
    39.             	   s.setSname(rs.getString("sname"));
    40.             	   s.setAge(rs.getInt("age"));
    41.             	   s.setAddr(rs.getString("addr"));
    42.             	   list.add(s);
    43.                }
    44. 				return list;
    45. 			}
    46. 		});
    47. 		
    48. 	}
    49. 	
    50. 	public void addStudents(Student student) {
    51. 		String sql="insert into student(sname,age,addr) values(?,?,?)";
    52. 		Connection con=null;
    53. 		PreparedStatement ps=null;
    54. 		try {
    55. 			con=DBUtil.getConection();
    56. 			ps=con.prepareStatement(sql);
    57. 			ps.setObject(1, student.getSname());
    58. 			ps.setObject(2,student.getAge());
    59. 			ps.setObject(3, student.getAddr());
    60. 			ps.executeUpdate();
    61. 		} catch (Exception e) {
    62. 			e.printStackTrace();
    63. 		}finally {
    64. 			DBUtil.closeDB(null, ps, con);
    65. 		}
    66. 	}
    67. 	
    68. 	public void updStudents(Student student) {
    69. 		String sql="update student set sname=?,age=?,addr=? where sid=?";
    70. 		Connection con=null;
    71. 		PreparedStatement ps=null;
    72. 		ResultSet rs=null;
    73. 		try {
    74. 			con=DBUtil.getConection();
    75. 			ps=con.prepareStatement(sql);
    76. 			ps.setObject(1, student.getSname());
    77. 			ps.setObject(2,student.getAge());
    78. 			ps.setObject(3, student.getAddr());
    79. 			ps.setObject(4, student.getSid());
    80. 			ps.executeUpdate();
    81. 		} catch (Exception e) {
    82. 			e.printStackTrace();
    83. 		}finally {
    84. 			DBUtil.closeDB(rs, ps, con);
    85. 		}
    86. 	}
    87. 	
    88. 	
    89. 	public void delStudents(int id) {
    90. 		String sql="delete from student where sid=?";
    91. 		Connection con=null;
    92. 		PreparedStatement ps=null;
    93. 		ResultSet rs=null;
    94. 		try {
    95. 			con=DBUtil.getConection();
    96. 			ps=con.prepareStatement(sql);
    97. 			ps.setInt(1, id);
    98. 		    ps.executeUpdate();
    99. 		} catch (Exception e) {
    100. 			e.printStackTrace();
    101. 		}finally {
    102. 			DBUtil.closeDB(rs, ps, con);
    103. 		}
    104. 	}
    105. 	
    106. 	
    107. 	public Student queryById(int id) {
    108. 		Student s=new Student();
    109. 		String sql="select * from student where sid=?";
    110. 		Connection con=null;
    111. 		PreparedStatement ps=null;
    112. 		ResultSet rs=null;
    113. 		try {
    114. 			con=DBUtil.getConection();
    115. 			ps=con.prepareStatement(sql);
    116. 			ps.setInt(1, id);
    117. 			rs=ps.executeQuery();
    118. 			if(rs.next()) {
    119. 				s.setSid(rs.getInt(1));
    120. 				s.setSname(rs.getString(2));
    121. 				s.setAge(rs.getInt(3));
    122. 				s.setAddr(rs.getString(4));
    123. 			}
    124. 		} catch (Exception e) {
    125. 			e.printStackTrace();
    126. 		}finally {
    127. 			DBUtil.closeDB(rs, ps, con);
    128. 		}
    129. 		return  s;
    130. 	}
    131. 	
    132. 	
    133. 	
    134. 	@Test
    135. 	public void testStudnet() {
    136. 		Student student = new Student();
    137. 		getStudents(student, new PageBean());
    138. 	}
    139. 	
    140. 	public static void main (String[] args)throws Exception{
    141. 		StudentDao dao = new StudentDao();
    142. 		PageBean pageBean = new PageBean();
    143. 		List students = dao.getStudents(null, pageBean);
    144. 	
    145. 		students.forEach(t-> System.out.println(t));
    146. 	}
    147.  
    148.  
    149. }
      150.  

      IStudentDao
       

      1. package com.yian.dao;
      2.  
      3. import java.util.List;
      4.  
      5. import com.zking.model.Student;
      6. import com.zking.util.PageBean;
      7.  
      8. public interface IStudentDao {
      9.  
      10. 	ListgetStudents(Student stu,PageBean pageBean);
      11.     void addStudents(Student student);
      12.     void updStudents(Student student);
      13.     Student queryById(int id);
      14.     void delStudents(int id);
      15. }
       

       四、编写Action接收请求并处理
       

      StudentAction
       

      1. package com.yian.action;
      2.  
      3. import java.util.List;
      4.  
      5. import javax.servlet.http.HttpServletRequest;
      6. import javax.servlet.http.HttpServletResponse;
      7.  
      8. import com.yian.service.IStudentService;
      9. import com.yian.service.StudentService;
      10. import com.zking.model.Student;
      11. import com.zking.mymvc.framework.AbstractDispatchAction;
      12. import com.zking.mymvc.framework.ModelDriver;
      13. import com.zking.util.PageBean;
      14.  
      15. public class StudentAction extends AbstractDispatchAction implements ModelDriver {
      16.  
      17. 	private Student s=new Student();
      18. 	@Override
      19. 	public Object getMode() {
      20.  
      21. 		return s;
      22. 	}
      23.  
      24. 	private IStudentService service=new StudentService();
      25.  
      26. 	public String getStudents(HttpServletRequest req,HttpServletResponse resp) {
      27. 		PageBean pageBean=new PageBean();
      28. 		pageBean.setRequest(req);
      29. 		List students = service.getStudents(s, pageBean);
      30. 		
      31. 		req.setAttribute("students", students);
      32. 		
      33. 		return "students";
      34. 	}
      35. 	
      36. 	public String addStudents(HttpServletRequest req,HttpServletResponse resp) {
      37. 		
      38. 		service.addStudents(s);
      39. 		return "success";
      40. 	}
      41. 	
      42. 	public String updStudents(HttpServletRequest req,HttpServletResponse resp) {
      43. 		s.setSid(Integer.parseInt(req.getParameter("sid")));
      44. 		service.updStudents(s);
      45. 		return "success";
      46. 	}
      47. 	
      48. 	public String getStudentById(HttpServletRequest req,HttpServletResponse resp) {
      49. 		Student queryById = service.queryById(Integer.parseInt(req.getParameter("sid")));
      50. 	    req.setAttribute("stu", queryById);
      51. 	   return "update";
      52. 	}
      53.  
      54. 	public String delStudentById(HttpServletRequest req,HttpServletResponse resp) {
      55. 		service.delStudents(Integer.parseInt(req.getParameter("sid")));
      56. 	   return "success";
      57. 	}
      58.  
      59. }
       

      五、编写service（相当于biz层）
       

      IStudentService
       

      1. package com.yian.service;
      2.  
      3. import java.util.List;
      4.  
      5. import com.zking.model.Student;
      6. import com.zking.util.PageBean;
      7.  
      8. public interface IStudentService {
      9.  
      10. 	ListgetStudents(Student stu,PageBean pageBean);
      11. 	 void addStudents(Student student);
      12. 	void updStudents(Student student);
      13. 	Student queryById(int id);
      14. 	void delStudents(int id);
      15. }
       

       StudentService
       

      1. package com.yian.service;
      2.  
      3. import java.util.List;
      4.  
      5. import com.yian.dao.IStudentDao;
      6. import com.yian.dao.StudentDao;
      7. import com.zking.model.Student;
      8. import com.zking.util.PageBean;
      9.  
      10. public class StudentService implements IStudentService{
      11.  
      12. 	private IStudentDao dao=new StudentDao();
      13. 	@Override
      14. 	public List getStudents(Student stu,PageBean pageBean) {
      15. 		// TODO Auto-generated method stub
      16. 		return dao.getStudents(stu, pageBean);
      17. 	}
      18. 	@Override
      19. 	public void addStudents(Student student) {
      20. 		// TODO Auto-generated method stub
      21.             dao.addStudents(student);
      22. 	}
      23. 	
      24. 	@Override
      25. 	public void updStudents(Student student) {
      26. 		 dao.updStudents(student);
      27. 	}
      28. 	@Override
      29. 	public Student queryById(int id) {
      30. 		// TODO Auto-generated method stub
      31. 		return dao.queryById(id) ;
      32. 	}
      33. 	@Override
      34. 	public void delStudents(int id) {
      35. 		// TODO Auto-generated method stub
      36. 		dao.delStudents(id);
      37. 	}
      38. 	
      39. }
       

      六、XML文件配置 
       

      config.xml
       

      2. config[
      3. 	config (action*)>
      4. 	action (forward*)>
      5. 	forward EMPTY>
      6. 	action
      7. 	  path CDATA #REQUIRED
      8. 	  type CDATA #REQUIRED
      9. 	>
      10. 	forward
      11. 	  name CDATA #REQUIRED
      12. 	  path CDATA #REQUIRED
      13. 	  redirect (true|false) "false"
      14. 	>
      15. ]>
      16. <config>
      17. 	<action path="/studentAction" type="com.yian.action.StudentAction">
      18. 		<forward name="students" path="/students.jsp" redirect="false"/>
      19. 	    <forward name="success" path="/studentAction.action?methodName=getStudents"/>
      20. 	     <forward name="update" path="updStudent.jsp"/>
      21. 	action>
      22. 	<action path="/bookAction" type="com.zking.mymvc.action.BookAction">
      23. 		<forward name="books" path="/books.jsp" redirect="true"/>
      24. 	action>
      25. config>
       

      

      七、前端代码
       

      主页界面
       

      1. <%@ page language="java" contentType="text/html; charset=UTF-8"
      2.     pageEncoding="UTF-8"%>
      3.     <%@taglib prefix="z" uri="/zking" %>
      4.     <%@taglib prefix="c"  uri="http://java.sun.com/jsp/jstl/core"%>
      5. html>
      6. <html>
      7. <head>
      8. <meta charset="UTF-8">
      9. <title>Insert title heretitle>
      10. head>
      11. <body>
      12. <center>
      13.       <h1>学生信息h1>
      14.       <form action="<%=request.getContextPath()%>/student" method="post">
      15.          <input type="text" name="sname"value="<%=request.getParameter("sname") == null ? "" : request.getParameter("sname")%>">
      16.          <input type="submit" value="查询">
      17.          
      18.          <a href="<%=request.getContextPath()%>/addStudent.jsp">增加a>
      19.         
      20.       form>
      21.       <table border>
      22.       <tr>
      23.          <td>学生学号td>
      24.          <td>学生姓名td>
      25.          <td>学生年龄td>
      26.          <td>学生地址td>
      27.          <td>学生操作td>
      28.       tr>
      29.       <c:forEach items="${students}" var="s">
      30.       <tr>
      31.         <td>${s.sid}td>
      32.         <td>${s.sname}td>
      33.         <td>${s.age}td>
      34.         <td>${s.addr}td>
      35.         <td>
      36.           <a href="<%=request.getContextPath()%>/studentAction.action?methodName=getStudentById&sid=${s.sid}">修改a>
      37.           <a href="<%=request.getContextPath()%>/studentAction.action?methodName=delStudentById&sid=${s.sid}  "onclick="return confirm('确定删除吗?')">删除a>
      38.         td>
      39.       tr>
      40.       c:forEach>
      41.       table>
      42.     
      43.      <z:paging pageBean="${pageBean}"/>
      44. center>
      45.  
      46. body>
      47. html>
       

      页面效果：
       

       
       

      增加界面
       

      1. <%@ page language="java" contentType="text/html; charset=UTF-8"
      2.     pageEncoding="UTF-8"%>
      3. html>
      4. <html>
      5. <head>
      6. <meta charset="UTF-8">
      7. <title>Insert title heretitle>
      8. head>
      9. <body>
      10. <center>
      11. <h1>增加学生信息h1>
      12. 	
      13. 	<form action="<%=request.getContextPath()%>/studentAction.action?methodName=addStudents" method="post">
      14. 		姓名：
      15. 		<input type="text" id="sname" name="sname"/><p>
      16. 		年龄：
      17. 		<input type="text" name="age"/><p>
      18. 		地址：
      19. 		<input type="text" name="addr"/><p>
      20. 		<p>
      21. 		<input type="submit" value="提交"/>
      22. 	form>
      23.    center> 
      24. body>
      25. html>
       

      页面效果：
       

        
       

      修改界面：
       

      1. <%@ page language="java" contentType="text/html; charset=UTF-8"
      2.     pageEncoding="UTF-8"%>
      3. html>
      4. <html>
      5. <head>
      6. <meta charset="UTF-8">
      7. <title>Insert title heretitle>
      8. head>
      9. <body>
      10. <center>
      11. <h1>修改学生信息h1>
      12. 	
      13. 	<form action="<%=request.getContextPath()%>/studentAction.action?methodName=updStudents" method="post">
      14. 		<input type="hidden" id=sid name="sid" value="${stu.sid }"/>
      15. 		姓名：
      16. 		<input type="text" id="sname" name="sname" value="${stu.sname }"/><p>
      17. 		年龄：
      18. 		<input type="text" name="age" value="${stu.age }"/><p>
      19. 		地址：
      20. 		<input type="text" name="addr" value="${stu.addr }"/><p>
      21. 		<p>
      22. 		<input type="submit" value="提交"/>
      23. 	form>
      24.     center>
      25. body>
      26. html>
       

      页面效果：
       

       

      删除效果：
       

       
       

       
      
                
                    
                

                
    150. 

                    相关阅读:
      
                    
Day7力扣打卡                            
      
MySql 数据库【分组查询】                            
      
字符串的API                            
      
JVM认识之垃圾收集算法                            
      
Yalmip使用教程(6)-将约束条件写成矩阵形式                            
      
spring-boot 依赖注入流程                            
      
IB经济与商业可以一起选吗?                            
      
Milvus向量数据库检索                            
      
CubeMX RTOS Demo                            
      
编程技巧│高级 markdown 编辑器的惊艳语法                            
      
                          
                
      151. 
                
    151. 
                    原文地址：https://blog.csdn.net/weixin_62270300/article/details/125857475
                
      152.