我的考试源代码：
package Servlet;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
@WebServlet("/LoginServlet")
public class LoginServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// 获取用户输入的注册信息
String ad = request.getParameter("ad");
String psd = request.getParameter("psd");
// 将注册信息保存到数据库中
Connection conn = null;
PreparedStatement stmt = null;
try {
// 获取数据库连接
Class.forName("com.mysql.cj.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/fangchan", "root", "123456");
// 构建 SQL 插入语句Userid
String sql = "INSERT INTO denglu (ad, psd ) VALUES (?, ?)";
stmt = conn.prepareStatement(sql);
stmt.setString(1, ad);
stmt.setString(2, psd);
// 执行 SQL 插入语句
int rows = stmt.executeUpdate();
if (rows > 0) {
// 注册成功，跳转到登录页面
response.sendRedirect("Caiwurenyuan.jsp");
} else {
// 注册失败，返回注册页面并显示错误信息
response.sendRedirect("register.jsp?error=true");
}
} catch (SQLException e) {
// 处理数据库异常
e.printStackTrace();
response.sendRedirect("register.jsp?error=true");
} catch (ClassNotFoundException e) {
throw new RuntimeException(e);
} finally {
// 关闭数据库连接和相关资源
closeStatement(stmt);
closeConnection(conn);
}
}
private void closeConnection(Connection conn) {
// 关闭 Connection 对象
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
private void closeStatement(PreparedStatement stmt) {
// 关闭 PreparedStatement 对象
if (stmt != null) {
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
package Servlet;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DatabaseUtil {
private static final String JDBC_URL = "jdbc:mysql://localhost:3306/fangchan";
private static final String JDBC_USER = "root";
private static final String JDBC_PASSWORD = "123456";
static {
try {
// 注册 JDBC 驱动程序
Class.forName("com.mysql.cj.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
throw new RuntimeException("Failed to load JDBC driver");
}
}
public static Connection getConnection() throws SQLException {
return DriverManager.getConnection(JDBC_URL, JDBC_USER, JDBC_PASSWORD);
}
}
package Servlet;
public class Bean {
private String UserID;
private String UserName;
private String sex;
private String IdNumber;
private String Phone;
private String User;
private int ad;
private int psd;
private int ID;
private String name;
private String department;
private String destination;
private String departuredate;
private String returdate;
private String Type;
private String Typecontent;
private String Reason;
private String State;
private String Statereason;
public String getUserID() {
return UserID;
}
public void setUserID(String userID) {
UserID = userID;
}
public String getUserName() {
return UserName;
}
public void setUserName(String userName) {
UserName = userName;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public String getIdNumber() {
return IdNumber;
}
public void setIdNumber(String idNumber) {
IdNumber = idNumber;
}
public String getPhone() {
return Phone;
}
public void setPhone(String phone) {
Phone = phone;
}
public String getUser() {
return User;
}
public void setUser(String user) {
User = user;
}
Bean(String userID, String UserName, String sex, String IdNumber, String Phone, String User)
{
this.UserID=UserID;
this.UserName=UserName;
this.sex=sex;
this.IdNumber=UserName;
this.Phone=Phone;
this.User=User;
}
}
package Servlet;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
@WebServlet("/BaoxiaoServlet")
public class BaoxiaoServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// 获取用户输入的注册信息
String ID = request.getParameter("ID");
String name = request.getParameter("name");
String department = request.getParameter("department");
String destination = request.getParameter("destination");
String departuredate= request.getParameter("departuredate");
String returndate = request.getParameter("returndate");
String Type = request.getParameter("Type");
String Typecontent = request.getParameter("Typecontent");
String Reason = request.getParameter("Reason");
String State = request.getParameter("State");
String Statereason = request.getParameter("Statereason");
// 将注册信息保存到数据库中
Connection conn = null;
PreparedStatement stmt = null;
try {
// 获取数据库连接
Class.forName("com.mysql.cj.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/fangchan", "root", "123456");
// 构建 SQL 插入语句Userid
String sql = "INSERT INTO form1 (ID, name, department, destination, departuredate,returndate,Type,Typecontent,Reason,State,Statereason) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
stmt = conn.prepareStatement(sql);
stmt.setString(1, ID);
stmt.setString(2, name);
stmt.setString(3, department);
stmt.setString(4, departuredate);
stmt.setString(5, destination);
stmt.setString(6, departuredate);
stmt.setString(7, returndate);
stmt.setString(8, Type);
stmt.setString(9, Typecontent);
stmt.setString(10, State);
stmt.setString(11, Statereason);
int rows = stmt.executeUpdate();
if (rows > 0) {
// 注册成功，跳转到登录页面
response.sendRedirect("Customerfunction.jsp");
} else {
// 注册失败，返回注册页面并显示错误信息
response.sendRedirect("register.jsp?error=true");
}
} catch (SQLException e) {
// 处理数据库异常
e.printStackTrace();
response.sendRedirect("register.jsp?error=true");
} catch (ClassNotFoundException e) {
throw new RuntimeException(e);
} finally {
// 关闭数据库连接和相关资源
closeStatement(stmt);
closeConnection(conn);
}
}
private void closeConnection(Connection conn) {
// 关闭 Connection 对象
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
private void closeStatement(PreparedStatement stmt) {
// 关闭 PreparedStatement 对象
if (stmt != null) {
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
package Servlet;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
@WebServlet("/RegisterServlet")
public class RegisterServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// 获取用户输入的注册信息
String UserId = request.getParameter("UserId");
String UserName = request.getParameter("UserName");
String sex = request.getParameter("sex");
String IdNumber = request.getParameter("IdNumber");
String Phone = request.getParameter("Phone");
String User = request.getParameter("User");
// 将注册信息保存到数据库中
Connection conn = null;
PreparedStatement stmt = null;
try {
// 获取数据库连接
Class.forName("com.mysql.cj.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/fangchan", "root", "123456");
// 构建 SQL 插入语句Userid
String sql = "INSERT INTO table_three (UserId, UserName, sex, IdNumber, Phone,User) VALUES (?, ?, ?, ?, ?, ?)";
stmt = conn.prepareStatement(sql);
stmt.setString(1, UserId);
stmt.setString(2, UserName);
stmt.setString(3, sex);
stmt.setString(4, IdNumber);
stmt.setString(5, Phone);
stmt.setString(6, User);
// 执行 SQL 插入语句
int rows = stmt.executeUpdate();
if (rows > 0) {
// 注册成功，跳转到登录页面
response.sendRedirect("index.jsp");
} else {
// 注册失败，返回注册页面并显示错误信息
response.sendRedirect("register.jsp?error=true");
}
} catch (SQLException e) {
// 处理数据库异常
e.printStackTrace();
response.sendRedirect("register.jsp?error=true");
} catch (ClassNotFoundException e) {
throw new RuntimeException(e);
} finally {
// 关闭数据库连接和相关资源
closeStatement(stmt);
closeConnection(conn);
}
}
private void closeConnection(Connection conn) {
// 关闭 Connection 对象
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
private void closeStatement(PreparedStatement stmt) {
// 关闭 PreparedStatement 对象
if (stmt != null) {
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
package Servlet;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
@WebServlet("/update")
public class updateServlet extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
int studentId = Integer.parseInt(request.getParameter("id"));
String newStudentName = request.getParameter("name");
// 获取数据库连接
Connection connection = null;
try {
connection = DatabaseUtil.getConnection();
if (connection != null) {
// 编写 SQL 查询语句
String sql = "UPDATE denglu SET ad=? WHERE psd=?";
// 使用 PreparedStatement 执行 SQL 查询语句
try (PreparedStatement preparedStatement = connection.prepareStatement(sql)) {
preparedStatement.setString(1, newStudentName);
preparedStatement.setInt(2, studentId);
// 执行更新操作
int rowsAffected = preparedStatement.executeUpdate();
if (rowsAffected > 0) {
// 更新成功
response.getWriter().println("Student updated successfully!");
} else {
// 更新失败
response.getWriter().println("Failed to update student!");
}
}
}
} catch (SQLException e) {
e.printStackTrace();
// 处理异常
} finally {
// 关闭连接
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>登录</title>
</head>
<style>
.d1 {
text-align: center;
}
label {
font-size: large;
}
input {
margin-top: 10px;
border-radius: 10px;
padding-left: 10px;
margin-bottom: 10px;
}
.submit {
border-radius: 0%;
width: 90px;
height: auto;
}
</style>
</head>
<body>
<form action="LoginServlet" method="post">
用户：<input type="text" name = "ad"><br>
密码：<input type="password" name = "psd"><br>
<input type="submit" value="登录 ">
</form>
</body>
</html>
<%--
Created by IntelliJ IDEA.
User: 86156
Date: 2023/12/18
Time: 14:05
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>职员功能</title>
</head>
<body>
<a href="Chuchai.jsp">出差申请</a>
</div>
<br>
<a href="Xiugai.jsp">修改出差申请</a>
</div>
<br>
<a href="Chehui.jsp">撤回出差申请</a>
</div>
<br>
<a href="Baoxiao.jsp">报销差旅费</a>
</div>
<br>
<a href="Xiugaibaoxiao.jsp">修改报销单据</a>
</div>
<br>
<a href="Chakanchuchai.jsp">查看出差申请</a>
</div>
<br>
<a href="Chakanbaoxiao.jsp">查看报销进度</a>
</div>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>出差申请单</title>
</head>
<body>
<form action="BaoxiaoServlet" method="post">
出差人姓名：<input type="text" name="name" required><br>
部门：<input type="text" name="department" required><br>
目的地：<input type="text" name="destination" required><br>
出发日期：<input type="date" name="departuredate" required><br>
预计返回日期：<input type="date" name="returndate" required><br>
出差类别：
<select name="Type">
<option value="业务洽谈">业务洽谈</option>
<option value="培训">培训</option>
<option value="会议">会议</option>
<option value="其他">其他</option>
</select><br>
出差事由：<textarea name="Reason" rows="4" cols="50" required></textarea><br>
<input type="submit" value="提交申请">
</form>
</body>
</html>
<%--
Created by IntelliJ IDEA.
User: 86156
Date: 2023/12/18
Time: 14:09
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>修改员工信息</title>
</head>
<body>
<div class="d1">
<h1>修改出差申请</h1>
<form action="Xiugaihou.jsp" >
<label for="ID">请先输入编号：</label>
<input type="text" id="ID" name="ID" required><br><br>
<hr>
<h2>修改如下：</h2>
<br>
<label for="department">部门：</label>
<input type="text" id="department" name="department" required><br><br>
<label for="destination">地点：</label>
<input type="text" id="destination" name="destination" required> "><br><br>
<label for="departuredate">请假日期：</label>
<input type="date" id="departuredate" name="departuredate" required ><br><br>
<label for="departuredate">上班日期：</label>
<input type="date" id="returndate" name="returndate" required ><br><br>
<input type="submit" value="点击修改">
</form>
</div>
</body>
</html>
<%--
Created by IntelliJ IDEA.
User: 86156
Date: 2023/12/18
Time: 14:09
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" %>
<html>
<head>
<title>撤回页</title>
</head>
<body>
<form action="Delete.jsp">
<div class="d1">
<h1>撤回申请</h1>
<hr>
<label for="ID">请输入要撤回员工的ID：</label>
<input type="text" name="ID" id="ID">
<input type="submit" value="点击撤回">
</div>
</form>
</body>
</html>
<%@ page import="java.sql.*" %><%--
Created by IntelliJ IDEA.
User: qq316
Date: 2023/11/20
Time: 15:35
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>删除页</title>
</head>
<body>
<%
int ID= Integer.parseInt(request.getParameter("ID"));
try {
Class.forName("com.mysql.cj.jdbc.Driver");
} catch (ClassNotFoundException e) {
throw new RuntimeException(e);
}
request.setCharacterEncoding("utf-8");
Connection conn = null;
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/fangchan", "root", "123456");
Statement stat = null;
String sql = "delete from form1 where ID = "+ID;
stat = conn.createStatement();
int i=stat.executeUpdate(sql);
if(i!=0){
System.out.println("成功删除");}
else{
System.out.println("删除失败");
}
stat.close();
conn.close();
%>
<br>
<a href="Customerfunction.jsp">跳转到上一页</a>
</body>
</html>
<%--
Created by IntelliJ IDEA.
User: 86156
Date: 2023/12/18
Time: 16:09
To change this template use File | Settings | File Templates.
--%>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.*" %>
<%--
Created by IntelliJ IDEA.
User: qq316
Date: 2023/11/20
Time: 15:19
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>修改页</title>
</head>
<body>
<%
String ID=request.getParameter("ID");
String department=request.getParameter("department");
String destination=request.getParameter("destination");
String departuredate=request.getParameter("departuredate");
String returndate=request.getParameter("returndate");
try {
Class.forName("com.mysql.cj.jdbc.Driver");
} catch (ClassNotFoundException e) {
throw new RuntimeException(e);
}
request.setCharacterEncoding("utf-8");
Connection conn = null;
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/fangchan", "root", "123456");
Statement stat = null;
stat = conn.createStatement();
String sql = "UPDATE form1 set department = ('"+department+"') where ID= ('"+ID+"') " ;
String sql1 = "UPDATE form1 set destination = ('"+destination+"') where ID= ('"+ID+"')" ;
String sql2 = "UPDATE form1 set departuredate = ('"+departuredate+"') where ID= ('"+ID+"')";
String sql3 = "UPDATE form1 set returndate = ('"+returndate+"') where ID= ('"+ID+"')" ;
stat.executeUpdate(sql);
stat.executeUpdate(sql1);
stat.executeUpdate(sql2);
stat.executeUpdate(sql3);
out.println("修改成功");
stat.close();
conn.close();
%>
<br>
<a href="Customerfunction.jsp">跳转到功能页</a>
</body>
</html>
<%--
Created by IntelliJ IDEA.
User: 86156
Date: 2023/12/18
Time: 17:10
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<form action="Chaxunhou.jsp">
<h1>查看出差申请</h1>
<hr>
<label>
请先输入姓名
<input type="text" name="name">
</label><br>
<input type="submit" value="提交">
<br>
</form>
</body>
</html>
<%--
Created by IntelliJ IDEA.
User: 86156
Date: 2023/12/18
Time: 17:11
To change this template use File | Settings | File Templates.
--%>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.*" %><%--
Created by IntelliJ IDEA.
User: qq316
Date: 2023/12/18
Time: 15:30
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<h1>查看出差申请</h1>
<hr>
<%
try {
Class.forName("com.mysql.cj.jdbc.Driver");
} catch (ClassNotFoundException e) {
throw new RuntimeException(e);
}
request.setCharacterEncoding("utf-8");
Connection conn = null;
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/2023shenpi", "root", "123456");
Statement stat = null;
stat = conn.createStatement();
String sql = "SELECT * FROM form1" ;
ResultSet rs = stat.executeQuery(sql);
while (rs.next()) {
String column1 = rs.getString("name");
String column2 =rs.getString("department");
String column3 = rs.getString("destination");
String column4 = rs.getString("departuredate");
String column5 = rs.getString("returndate");
String column6 = rs.getString("Type");
String column7 = rs.getString("Typecontent");
String column8 = rs.getString("Reason");
String column9 = rs.getString("State");
// 其他处理...
// 在页面上显示数据
%>
<p>出差人姓名: <%= column1 %></p>
<br>
<p>部门: <%= column2 %></p>
<br>
<p>目的地: <%= column3 %></p>
<br>
<p>出发日期: <%= column4 %></p>
<br>
<p>返回日期: <%= column5 %></p>
<br>
<p>出差类别: <%= column6 %></p>
<br>
<p>其他类别内容: <%= column7 %></p>
<br>
<p>出差事由: <%= column8 %></p>
<br>
<p>申请状态: <%= column9 %></p>
<br>
<br><br><br>
<hr>
<%
}
%>
</body>
</html>
<%--
Created by IntelliJ IDEA.
User: 86156
Date: 2023/11/27
Time: 15:25
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>注册界面</title>
</head>
<body>
<form action="RegisterServlet" method="post">
用户ID:<input type="text" name = "UserId"><br>
姓名：<input type="text" name = "UserName"><br>
性别： <select name="sex">
<option value="male">男</option>
<option value="female">女</option>
</select><br>
身份证号：<input type="text" name = "IdNumber"><br>
手机号码：<input type="text" name = "Phone"><br>
家庭住址：<input type="text" name = "User"><br>
<input type="submit" value="注册">
</form>
</body>
</html>
<%--
Created by IntelliJ IDEA.
User: 86156
Date: 2023/12/18
Time: 14:38
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>总经理功能</title>
</head>
<body>
<a href="Chuchai.jsp">审批出差</a>
</div>
<br>
<a href="Xiugai.jsp">审批报销</a>
</div>
<br>
<a href="Chehui.jsp">查询话费</a>
</div>
<br>
<a href="Baoxiao.jsp">统计花费</a>
</div>
</body>
</html>
<%--
Created by IntelliJ IDEA.
User: 86156
Date: 2023/12/18
Time: 14:52
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>财务人员</title>
</head>
<body>
<a href="Chuchai.jsp">审核报销单据</a>
</div>
<br>
<a href="Xiugai.jsp">查询报销情况</a>
</div>
</body>
</html>