MVC案例之删除
总体思路
在上一篇的基础上,增加删除的功能
首先在列举的jsp中加上删除的链接–>调用dao类完成链接–>调用DeleteStudentServlet类删除学生–>调用ListAllStudents展示学生–>用forward方法转到Student.jsp页面展示
具体的代码细节
- Students.jsp增加的部分
<tr>
<td><%=students.getId() %></td>
<td><%=students.getStudentName() %></td>
<td><a href="deleteStudent?id=<%=students.getId()%>">Delete</a></td>
<br><br>
</tr>
重点是 id<%students.getId()%> 这句话,这句话让DeleteStudentServlet成功获取到了要删除成员的序号。
- StudentDao类新增加删除方法,但是存在连接重复,代码冗余的情况
package test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
public class StudentDao {
public void deleteById(int id) throws SQLException {
Connection connection=null;
PreparedStatement preparedStatement=null;
//ResultSet resultSet =null;
List<Students> students=new ArrayList<>();
try {
String driverClass="com.mysql.jdbc.Driver";
String url ="jdbc:mysql:///info";
String user="root";
String password="0025";
Class.forName(driverClass);
connection=DriverManager.getConnection(url, user, password);
String sql="Delete from Students where id=?";
preparedStatement=connection.prepareStatement(sql);
preparedStatement.setInt(1, id);
//resultSet=preparedStatement.executeQuery();
preparedStatement.executeUpdate();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}finally {
if(connection!=null) {
connection.close();
}
if(preparedStatement!=null) {
preparedStatement.close();
}
}
}
public List<Students> getAll() throws SQLException{
Connection connection=null;
PreparedStatement preparedStatement=null;
ResultSet resultSet =null;
List<Students> students=new ArrayList<>();
try {
String driverClass="com.mysql.jdbc.Driver";
String url ="jdbc:mysql:///info";
String user="root";
String password="0025";
Class.forName(driverClass);
connection=DriverManager.getConnection(url, user, password);
String sql="SELECT id,studentName from Students";
preparedStatement=connection.prepareStatement(sql);
resultSet=preparedStatement.executeQuery();
while(resultSet.next()) {
int id =resultSet.getInt(1);
String studentName=resultSet.getString(2);
Students student=new Students(id,studentName);
students.add(student); }
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}finally {
if(resultSet!=null) {
resultSet.close();
}
if(connection!=null) {
connection.close();
}
if(preparedStatement!=null) {
preparedStatement.close();
}
}
return students;
}
}
具体的实现没有特别复杂的地方,不要忘了preparedStatement.executeUpdate();,如果忘记加了,最后的结果是不会更新的。
- 接下来我们书写DeleteStudentServlet。
package test;
import java.io.IOException;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class DeleteStudentServlet
*/
@WebServlet("/deleteStudent")
public class DeleteStudentServlet extends HttpServlet {
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.getWriter().append("Served at: ").append(request.getContextPath());
String id=request.getParameter("id");
StudentDao studentDao=new StudentDao();
try {
studentDao.deleteById(Integer.parseInt(id));
} catch (NumberFormatException | SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
request.getRequestDispatcher("/success.jsp").forward(request, response);
}
}
获取的delete的请求,调用dao方法,跳转到成功删除界面。
- success.jsp界面,用来告知用户已经成功删除
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
success!
<br><br>
<a href="listAllStudents">List ALL Student</a>
</body>
</html>
最后再返回Student.jsp页面。
运行截图
点完delete连接
遇到的问题
- 无法跳转的问题。
写的代码明明是好的,但是却没有办法跳转到对应的servlet,原来是没有点build automaticlly。点完之后就正常了。
总结
- 关于MVC
- M:Model,Dao
- V:View.JSP,在页面上写Java代码实现显示
- C:Controller.Servlet
- 受理请求
- 获取请求参数
- 调用DAO方法
- 可能会把DAO的返回值放入request中
- 转发(重定向)页面
- 不足
- 使用数据库连接池,DBUtils,JDBCUtils工具类,DAO基类
- 希望可以多个请求对应一个Servlet
源代码
链接:https://pan.baidu.com/s/15kV_L4mPdJooHLWayhzdEw
提取码:4kh2
神奇女侠的眼睛里面有光!!!! ✪_✪