2024/4/25

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ page import="java.util.Date" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.Timestamp" %>

<%
request.setCharacterEncoding("UTF-8");
String jobid = request.getParameter("jobid");
String status = request.getParameter("status");
Date currentTime = new Date();
int hour = currentTime.getHours();
String resultMessage;

String url="jdbc:mysql://localhost:3306/fish?serverTimezone=UTC&useSSL=false&characterEncoding=UTF-8";
String user="root";
String password="123456";


try {
Class.forName("com.mysql.cj.jdbc.Driver");
Connection conn = DriverManager.getConnection(url, user, password);


if (status.equals("上班")) {
if (hour == 8) {
out.println("status");
resultMessage = "打卡成功！";
String sql = "INSERT INTO message3 (jobid, attendtime, attendency) VALUES (?, ?, ?)";
PreparedStatement stmt = conn.prepareStatement(sql);
stmt.setString(1, jobid);
stmt.setTimestamp(2, new Timestamp(currentTime.getTime()));
stmt.setString(3, "上班");
stmt.executeUpdate();
stmt.close();
} else {
resultMessage = "已过上班打卡时间点，打卡无效";
}
} else if (status.equals("下班")) {
if (hour >= 14) {
resultMessage = "打卡成功！";
String sql = "INSERT INTO message3 (jobid, attendtime, attendency) VALUES (?, ?, ?)";
PreparedStatement stmt = conn.prepareStatement(sql);
stmt.setString(1, jobid);
stmt.setTimestamp(2, new Timestamp(currentTime.getTime()));
stmt.setString(3, "下班");
stmt.executeUpdate();
stmt.close();
} else {
resultMessage = "未到下班打卡时间点，打卡无效";
}
} else {
resultMessage = "无法打卡";
}
conn.close();
} catch (Exception e) {
e.printStackTrace();
resultMessage = "数据库操作出现异常：" + e.getMessage();
}
%>
<html>
<head>
<title>Attendance Result</title>
</head>
<body>
<h2><%= resultMessage %></h2>
</body>
</html>
posted @ 2024-04-25 23:55  几条小鱼  阅读(7)  评论(0)    收藏  举报