2024.3.15

/**
 * function: 统计所有学生打卡
 */

public static String Clock_in_Summary(String account) throws SQLException {
    Connection connection = null;
    PreparedStatement statement = null;
    ResultSet resultSet = null;
    StringBuilder resultBuilder = new StringBuilder();

    try {
        connection = JDBCUtils.getConn();
        String sql = "SELECT * FROM k2 ";
        statement = connection.prepareStatement(sql);


        resultSet = statement.executeQuery();

        while (resultSet.next()) {
            String date = resultSet.getString("date");
            String resultAccount = resultSet.getString("Account");
            String times = resultSet.getString("time_s");
            String timee = resultSet.getString("time_e");
            String text = resultSet.getString("text");

            // 将查询结果拼接为字符串
            resultBuilder.append("日期：").append(date).append("\n").append("学号: ").append(resultAccount).append("\n")
                    .append("开始时间: ").append(times).append("\n")
                    .append("结束时间: ").append(timee).append("\n")
                    .append("学习内容: ").append(text).append("\n\n");
        }

    } catch (SQLException e) {
        e.printStackTrace();
    }

    return resultBuilder.toString();
}