package com.bjpowernode.oa.web.action;
import com.bjpowernode.oa.utils.DBUtil;
import jakarta.servlet.ServletException;
import jakarta.servlet.annotation.WebServlet;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
// 模板类
@WebServlet({"/dept/list", "/dept/save", "/dept/edit", "/dept/detail", "/dept/delete", "/dept/modify"})
// 模糊匹配
// 只要请求路径是以"/dept"开始的，都走这个Servlet。
//@WebServlet("/dept/*")
public class DeptServlet extends HttpServlet {
// 模板方法
// 重写service方法（并没有重写doGet或者doPost）
@Override
protected void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// 获取servlet path
String servletPath = request.getServletPath();
if("/dept/list".equals(servletPath)){
doList(request, response);
} else if("/dept/save".equals(servletPath)){
doSave(request, response);
} else if("/dept/edit".equals(servletPath)){
doEdit(request, response);
} else if("/dept/detail".equals(servletPath)){
doDetail(request, response);
} else if("/dept/delete".equals(servletPath)){
doDel(request, response);
} else if("/dept/modify".equals(servletPath)){
doModify(request, response);
}
}
private void doList(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// 获取应用的根路径
String contextPath = request.getContextPath();
// 设置响应的内容类型以及字符集。防止中文乱码问题。
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
out.print("<!DOCTYPE html>");
out.print("<html>");
out.print(" <head>");
out.print(" <meta charset='utf-8'>");
out.print(" <title>部门列表页面</title>");
out.print("<script type='text/javascript'>");
out.print(" function del(dno){");
out.print(" if(window.confirm('亲，删了不可恢复哦！')){");
out.print(" document.location.href = '"+contextPath+"/dept/delete?deptno=' + dno");
out.print(" }");
out.print(" }");
out.print("</script>");
out.print(" </head>");
out.print(" <body>");
out.print(" <h1 align='center'>部门列表</h1>");
out.print(" <hr >");
out.print(" <table border='1px' align='center' width='50%'>");
out.print(" <tr>");
out.print(" <th>序号</th>");
out.print(" <th>部门编号</th>");
out.print(" <th>部门名称</th>");
out.print(" <th>操作</th>");
out.print(" </tr>");
/*上面一部分是死的*/
// 连接数据库，查询所有的部门
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
// 获取连接
conn = DBUtil.getConnection();
// 获取预编译的数据库操作对象
String sql = "select deptno as a,dname,loc from dept";
ps = conn.prepareStatement(sql);
// 执行SQL语句
rs = ps.executeQuery();
// 处理结果集
int i = 0;
while(rs.next()){
String deptno = rs.getString("a");
String dname = rs.getString("dname");
String loc = rs.getString("loc");
out.print(" <tr>");
out.print(" <td>"+(++i)+"</td>");
out.print(" <td>"+deptno+"</td>");
out.print(" <td>"+dname+"</td>");
out.print(" <td>");
out.print(" <a href='javascript:void(0)' onclick='del("+deptno+")'>删除</a>");
out.print(" <a href='"+contextPath+"/dept/edit?deptno="+deptno+"'>修改</a>");
out.print(" <a href='"+contextPath+"/dept/detail?fdsafdsas="+deptno+"'>详情</a>");
out.print(" </td>");
out.print(" </tr>");
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
// 释放资源
DBUtil.close(conn, ps, rs);
}
/*下面一部分是死的*/
out.print(" </table>");
out.print(" <hr >");
out.print(" <a href='"+contextPath+"/add.html'>新增部门</a>");
out.print(" </body>");
out.print("</html>");
}
private void doSave(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// 获取部门的信息
// 注意乱码问题（Tomcat10不会出现这个问题）
request.setCharacterEncoding("UTF-8");
String deptno = request.getParameter("deptno");
String dname = request.getParameter("dname");
String loc = request.getParameter("loc");
// 连接数据库执行insert语句
Connection conn = null;
PreparedStatement ps = null;
int count = 0;
try {
conn = DBUtil.getConnection();
String sql = "insert into dept(deptno, dname, loc) values(?,?,?)";
ps = conn.prepareStatement(sql);
ps.setString(1, deptno);
ps.setString(2, dname);
ps.setString(3, loc);
count = ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBUtil.close(conn, ps, null);
}
if (count == 1) {
// 保存成功跳转到列表页面
// 转发是一次请求。
//request.getRequestDispatcher("/dept/list").forward(request, response);
// 这里最好使用重定向（浏览器会发一次全新的请求。）
// 浏览器在地址栏上发送请求，这个请求是get请求。
response.sendRedirect(request.getContextPath() + "/dept/list");
}else{
// 保存失败跳转到错误页面
//request.getRequestDispatcher("/error.html").forward(request, response);
// 这里也建议使用重定向。
response.sendRedirect(request.getContextPath() + "/error.html");
}
}
private void doEdit(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// 获取应用的根路径。
String contextPath = request.getContextPath();
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
out.print("<!DOCTYPE html>");
out.print("<html>");
out.print(" <head>");
out.print(" <meta charset='utf-8'>");
out.print(" <title>修改部门</title>");
out.print(" </head>");
out.print(" <body>");
out.print(" <h1>修改部门</h1>");
out.print(" <hr >");
out.print(" <form action='"+contextPath+"/dept/modify' method='post'>");
// 获取部门编号
String deptno = request.getParameter("deptno");
// 连接数据库，根据部门编号查询部门的信息。
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
conn = DBUtil.getConnection();
String sql = "select dname,
JavaWebServlet+JSP+EL表达式+JSTL标签库+Filter过滤器+Listener监听器 （498个子文件） 
DeptServlet.class 9KB DeptServlet.class 9KB DeptServlet.class 6KB DeptServlet.class 6KB UserServlet.class 4KB UserServlet.class 4KB DeptListServlet.class 4KB DeptListServlet.class 4KB StudentServlet.class 4KB StudentServlet.class 4KB WelcomeServlet.class 4KB WelcomeServlet.class 4KB DeptEditServlet.class 4KB DeptEditServlet.class 4KB DeptDetailServlet.class 3KB DeptDetailServlet.class 3KB ConfigTestServlet.class 3KB ConfigTestServlet.class 3KB HelloServlet.class 3KB HelloServlet.class 3KB AServlet.class 3KB AServlet.class 3KB DeptDelServlet.class 3KB DeptDelServlet.class 3KB DeptModifyServlet.class 3KB DeptModifyServlet.class 3KB DeptSaveServlet.class 3KB DeptSaveServlet.class 3KB HelloServlet.class 3KB HelloServlet.class 3KB StudentSaveServlet.class 2KB StudentSaveServlet.class 2KB LoginCheckFilter.class 2KB LoginCheckFilter.class 2KB BServlet.class 2KB BServlet.class 2KB User.class 2KB User.class 2KB Dept.class 2KB Dept.class 2KB ReceiveCookie.class 2KB ReceiveCookie.class 2KB User.class 2KB User.class 2KB DBUtil.class 2KB DBUtil.class 2KB DBUtil.class 2KB DBUtil.class 2KB DBUtil.class 2KB DBUtil.class 2KB DBUtil.class 2KB DBUtil.class 2KB TestSessionServlet.class 2KB TestSessionServlet.class 2KB GenerateCookie.class 2KB GenerateCookie.class 2KB ConfigTestServlet2.class 2KB ConfigTestServlet2.class 2KB User.class 2KB User.class 2KB OrderServlet.class 2KB OrderServlet.class 2KB EmpServlet.class 2KB EmpServlet.class 2KB RequestTestServlet.class 2KB RequestTestServlet.class 2KB LoginServlet.class 2KB LoginServlet.class 2KB AServlet.class 2KB AServlet.class 2KB BServlet.class 2KB BServlet.class 2KB User1.class 2KB User1.class 2KB BServlet.class 2KB BServlet.class 2KB HttpSessionBindingListenerServlet.class 2KB HttpSessionBindingListenerServlet.class 2KB Student.class 2KB Student.class 2KB Filter1.class 2KB Filter1.class 2KB UserSaveServlet.class 1KB UserSaveServlet.class 1KB AServlet.class 1KB AServlet.class 1KB User.class 1KB User.class 1KB GenerateCookie.class 1KB GenerateCookie.class 1KB Filter2.class 1KB Filter2.class 1KB ReflectAnnotation.class 1KB ReflectAnnotation.class 1KB BServlet.class 1KB BServlet.class 1KB HttpSessionAttributeServlet.class 1KB HttpSessionAttributeServlet.class 1KB PostServlet.class 1KB PostServlet.class 1KB共 498 条
- 1
- 2
- 3
- 4
- 5
资源评论
开五档的蒙奇
- 粉丝: 821
最新资源
- 数据库查询技术在工程结算审计复核中的运用.docx
- 电子商务运营管理自考重点精题精选精心整理.doc
- 犀牛软件基础教程-其它课程-高中教育-教育专区.ppt
- 项目管理计划知识在小型应急工程中的应用.docx
- 业财融合下施工企业会计信息化建设探究.docx
- 大数据时代商务英语人才能力培养探究.docx
- 互联网对中专学校体育教育的影响及应对途径.docx
- 探讨分层教学在高中计算机教学中的应用.docx
- 网站建设报价单.docx
- 浅析美国计算机辅助语言教学的发展及其现实意义.docx
- MATLAB的双闭环直流调速系统设计.doc
- 项目管理在水利工程施工中的作用.docx
- 计算机组成原理习题5.doc
- 容一之网络沟通技巧培训一.ppt
- Java毕业设计开题分析方案.doc
- 计算机仿真技术在生物工程专业实践教学中的应用.docx
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
