package com.bjpowernode.oa.web.action;
import com.bjpowernode.oa.utils.DBUtil;
import jakarta.servlet.ServletException;
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;
public class DeptListServlet extends HttpServlet
{
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request,response);
}
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
String contextPath = request.getContextPath();
Connection connection = null;
PreparedStatement statement = null;
ResultSet resultSet = null;
response.setContentType("text/html;charset=UTF-8");
PrintWriter writer = response.getWriter();
writer.println("<!DOCTYPE html>");
writer.println("<html>");
writer.println(" <head>");
writer.println(" <meta charset='utf-8'>");
writer.println(" <title>部门列表</title>");
writer.println(" </head>");
writer.println(" <body>");
writer.println("\t<script type=\"text/javascript\">\n" +
"\t\tfunction del(dno){\n" +
"\t\t\tvar ok = window.confirm(\"是否确认删除该数据\");\n" +
"\t\t\tif(ok)\n" +
"\t\t\t{\n" +
"\t\t\t\twindow.location.href = \"" + contextPath + "/dept/delete?deptno=\"+dno\n" +
"\t\t\t}\n" +
"\t\t}\n" +
"\t</script>");
writer.println(" <h1 align='center'>部门列表</h1>");
writer.println(" <hr>");
writer.println(" <table align='center' border='1px' width='50%'>");
writer.println(" <tr>");
writer.println(" <th>序号</th>");
writer.println(" <th>部门编号</th>");
writer.println(" <th>部门名称</th>");
writer.println(" <th>部门位置</th>");
writer.println(" <th>操作</th>");
writer.println(" </tr>");
try
{
connection = DBUtil.getConnection();
String sql = "select * from dept";
statement = connection.prepareStatement(sql);
resultSet = statement.executeQuery();
int i = 0;
while(resultSet.next())
{
String deptno = resultSet.getString("deptno");
String dname = resultSet.getString("dname");
String loc = resultSet.getString("loc");
writer.println(" <tr>");
writer.println(" <td>" + (++i) + "</td>");
writer.println(" <td>" + (deptno) + "</td>");
writer.println(" <td>" + (dname) + "</td>");
writer.println(" <td>" + (loc) + "</td>");
writer.println(" <td>");
writer.println(" <a href=\"javascript:void(0)\" onclick=\"del("+(deptno)+")\">删除</a>");
writer.println(" <a href='" + (contextPath) + "/dept/edit?deptno=" + deptno +"'>修改</a>");
writer.println(" <a href='" + (contextPath) + "/dept/detail?deptno=" + deptno +"'>详情</a>");
writer.println(" </td>");
writer.println(" </tr>");
}
}
catch (SQLException e)
{
throw new RuntimeException(e);
}
finally
{
DBUtil.close(connection,statement,resultSet);
}
writer.println(" </table>");
writer.println(" <hr>");
writer.println(" <a href='"+ contextPath + "/add.html'>新增部门</a>");
writer.println(" </body>");
writer.println("</html>");
}
}
package com.bjpowernode.oa.web.action;
import com.bjpowernode.oa.utils.DBUtil;
import jakarta.servlet.ServletException;
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;
public class DeptListServlet extends HttpServlet
{
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request,response);
}
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
String contextPath = request.getContextPath();
Connection connection = null;
PreparedStatement statement = null;
ResultSet resultSet = null;
response.setContentType("text/html;charset=UTF-8");
PrintWriter writer = response.getWriter();
writer.println("<!DOCTYPE html>");
writer.println("<html>");
writer.println(" <head>");
writer.println(" <meta charset='utf-8'>");
writer.println(" <title>部门列表</title>");
writer.println(" </head>");
writer.println(" <body>");
writer.println("\t<script type=\"text/javascript\">\n" +
"\t\tfunction del(dno){\n" +
"\t\t\tvar ok = window.confirm(\"是否确认删除该数据\");\n" +
"\t\t\tif(ok)\n" +
"\t\t\t{\n" +
"\t\t\t\twindow.location.href = \"" + contextPath + "/dept/delete?deptno=\"+dno\n" +
"\t\t\t}\n" +
"\t\t}\n" +
"\t</script>");
writer.println(" <h1 align='center'>部门列表</h1>");
writer.println(" <hr>");
writer.println(" <table align='center' border='1px' width='50%'>");
writer.println(" <tr>");
writer.println(" <th>序号</th>");
writer.println(" <th>部门编号</th>");
writer.println(" <th>部门名称</th>");
writer.println(" <th>部门位置</th>");
writer.println(" <th>操作</th>");
writer.println(" </tr>");
try
{
connection = DBUtil.getConnection();
String sql = "select * from dept";
statement = connection.prepareStatement(sql);
resultSet = statement.executeQuery();
int i = 0;
while(resultSet.next())
{
String deptno = resultSet.getString("deptno");
String dname = resultSet.getString("dname");
String loc = resultSet.getString("loc");
writer.println(" <tr>");
writer.println(" <td>" + (++i) + "</td>");
writer.println(" <td>" + (deptno) + "</td>");
writer.println(" <td>" + (dname) + "</td>");
writer.println(" <td>" + (loc) + "</td>");
writer.println(" <td>");
writer.println(" <a href=\"javascript:void(0)\" οnclick=\"del("+(deptno)+")\">删除</a>");
writer.println(" <a href='" + (contextPath) + "/dept/edit?deptno=" + deptno +"'>修改</a>");
writer.println(" <a href='" + (contextPath) + "/dept/detail?deptno=" + deptno +"'>详情</a>");
writer.println(" </td>");
writer.println(" </tr>");
}
}
catch (SQLException e)
{
throw new RuntimeException(e);
}
finally
{
DBUtil.close(connection,statement,resultSet);
}
writer.println(" </table>");
writer.println(" <hr>");
writer.println(" <a href='"+ contextPath + "/add.html'>新增部门</a>");
writer.println(" </body>");
writer.println("</html>");
}
}
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
version="4.0">
<servlet>
<servlet-name>listDept</servlet-name>
<servlet-class>com.bjpowernode.oa.web.action.DeptListServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>listDept</servlet-name>
<!-- 这个pattern是不带项目名的-->
<url-pattern>/dept/list</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>detail</servlet-name>
<servlet-class>com.bjpowernode.oa.web.action.DetailServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>detail</servlet-name>
<url-pattern>/dept/detail</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>delete</servlet-name>
<servlet-class>com.bjpowernode.oa.web.action.DeleteServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>delete</servlet-name>
<url-pattern>/dept/delete</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>save</servlet-name>
<servlet-class>com.bjpowernode.oa.web.action.SaveServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>save</servlet-name>
<url-pattern>/dept/save</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>edit</servlet-name>
<servlet-class>com.bjpowernode.oa.web.action.EditServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>edit</servlet-name>
<url-pattern>/dept/edit</url-pattern>
</servlet-mapping>
</web-app>
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
version="4.0">
<servlet>
<servlet-name>listDept</servlet-name>
<servlet-class>com.bjpowernode.oa.web.action.DeptListServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>listDept</servlet-name>
<!-- 这个pattern是不带项目名的-->
<url-pattern>/dept/list</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>detail</servlet-name>
<servlet-class>com.bjpowernode.oa.web.action.DetailServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>detail</servlet-name>
<url-pattern>/dept/detail</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>delete</servlet-name>
<servlet-class>com.bjpowernode.oa.web.action.DeleteServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>delete</servlet-name>
<url-pattern>/dept/delete</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>save</servlet-name>
<servlet-class>com.bjpowernode.oa.web.action.SaveServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>save</servlet-name>
<url-pattern>/dept/save</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>edit</servlet-name>
<servlet-class>com.bjpowernode.oa.web.action.EditServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>edit</servlet-name>
<url-pattern>/dept/edit</url-pattern>
</servlet-mapping>
</web-app>
package com.bjpowernode.oa.web.action;
import com.bjpowernode.oa.utils.DBUtil;
import jakarta.servlet.ServletException;
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;
public class EditServlet extends HttpServlet
{
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String deptno = request.getParameter("deptno");
Connection connection = null;
PreparedStatement statement = null;
ResultSet resultSet = null;
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
try
{
connection = DBUtil.getConnection();
String sql = "select * from dept where deptno = ?";
statement = connection.prepareStatement(sql);
statement.setString(1,deptno);
resultSet = statement.executeQuery();
if(resultSet.next())
{
String dname = resultSet.getString("dname");
String loc = resultSet.getString("loc");
out.println("<!DOCTYPE html>\n" +
"<html>\n" +
"\t<head>\n" +
"\t\t<meta charset=\"utf-8\">\n" +
"\t\t<title>修改部门</title>\n" +
"\t</head>\n" +
"\t<body>\n" +
"\t\t<h1>修改部门</h1>\n" +
"\t\t<hr>\n" +
"\t\t<form method=\"get\" action=\"list.html\">\n" +
"\t\t\t部门编号:<input type=\"text\" name=\"deptno\" value=\"" + deptno);
out.println("\" readonly/><br>\n" +
"\t\t\t部门名称:<input type=\"text\" name=\"dname\" value=\"" + dname + "\"");
out.println("/><br>\n" +
"\t\t\t部门位置:<input type=\"text\" name=\"loc\" value=\"" + loc + "\"");
out.println("\"/><br>\n" +
"\t\t\t<input type=\"submit\" value=\"保存\"/>\n" +
"\t\t</form>\n" +
"\t</body>\n" +
"</html>");
}
}
catch (SQLException e)
{
throw new RuntimeException(e);
}
finally
{
DBUtil.close(connection,statement,resultSet);
}
}
}
package com.bjpowernode.oa.web.action;
import com.bjpowernode.oa.utils.DBUtil;
import jakarta.servlet.ServletException;
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;
public class EditServlet extends HttpServlet
{
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String deptno = request.getParameter("deptno");
Connection connection = null;
PreparedStatement statement = null;
ResultSet resultSet = null;
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
try
{
connection = DBUtil.getConnection();
String sql = "select * from dept where deptno = ?";
statement = connection.prepareStatement(sql);
statement.setString(1,deptno);
resultSet = statement.executeQuery();
if(resultSet.next())
{
String dname = resultSet.getString("dname");
String loc = resultSet.getString("loc");
out.println("<!DOCTYPE html>\n" +
"<html>\n" +
"\t<head>\n" +
"\t\t<meta charset=\"utf-8\">\n" +
"\t\t<title>修改部门</title>\n" +
"\t</head>\n" +
"\t<body>\n" +
"\t\t<h1>修改部门</h1>\n" +
"\t\t<hr>\n" +
"\t\t<form method=\"get\" action=\"list.html\">\n" +
"\t\t\t部门编号:<input type=\"text\" name=\"deptno\" value=\"" + deptno);
out.println("\" readonly/><br>\n" +
"\t\t\t部门名称:<input type=\"text\" name=\"dname\" value=\"" + dname + "\"");
out.println("/><br>\n" +
"\t\t\t部门位置:<input type=\"text\" name=\"loc\" value=\"" + loc + "\"");
out.println("\"/><br>\n" +
"\t\t\t<input type=\"submit\" value=\"保存\"/>\n" +
"\t\t</form>\n" +
"\t</body>\n" +
"</html>");
}
}
catch (SQLException e)
{
throw new RuntimeException(e);
}
finally
{
DBUtil.close(connection,statement,resultSet);
}
}
}