考勤管理系统jsp源码

// 示例代码：检查数据库连接
String url = "jdbc:mysql://localhost:3306/attendance_db";
String user = "root";
String password = "password";

try {
    Connection conn = DriverManager.getConnection(url, user, password);
    System.out.println("数据库连接成功！");
} catch (SQLException e) {
    e.printStackTrace();
    System.out.println("数据库连接失败：" + e.getMessage());
}

// 示例代码：使用预编译语句
String sql = "SELECT * FROM employees WHERE id = ?";
try (PreparedStatement pstmt = conn.prepareStatement(sql)) {
    pstmt.setInt(1, employeeId);
    ResultSet rs = pstmt.executeQuery();
    // 处理结果集
} catch (SQLException e) {
    e.printStackTrace();
}

<%@ page import="java.sql.*" %>
<%
    String employeeId = request.getParameter("employeeId");
    String date = new java.util.Date().toString();
    String status = request.getParameter("status"); // "present", "absent", "late"

    String url = "jdbc:mysql://localhost:3306/attendance_db";
    String user = "root";
    String password = "password";

    try (Connection conn = DriverManager.getConnection(url, user, password)) {
        String sql = "INSERT INTO attendance (employee_id, date, status) VALUES (?, ?, ?)";
        PreparedStatement pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, employeeId);
        pstmt.setString(2, date);
        pstmt.setString(3, status);
        pstmt.executeUpdate();
        out.println("考勤记录成功！");
    } catch (SQLException e) {
        out.println("考勤记录失败：" + e.getMessage());
    }
%>