jsp用户信息管理系统

String url = "jdbc:mysql://localhost:3306/userdb";
String username = "root";
String password = "password";
try {
    Class.forName("com.mysql.jdbc.Driver");
    Connection conn = DriverManager.getConnection(url, username, password);
} catch (ClassNotFoundException e) {
    e.printStackTrace();
} catch (SQLException e) {
    e.printStackTrace();
}

HttpSession session = request.getSession();
session.setAttribute("user", user);
session.setMaxInactiveInterval(30 * 60); // 设置会话超时时间为30分钟

String sql = "SELECT * FROM users WHERE username = ?";
try (PreparedStatement pstmt = conn.prepareStatement(sql)) {
    pstmt.setString(1, username);
    ResultSet rs = pstmt.executeQuery();
} catch (SQLException e) {
    e.printStackTrace();
}

// 示例：使用Redis缓存用户信息
Jedis jedis = new Jedis("localhost");
String userInfo = jedis.get("user:" + userId);
if (userInfo == null) {
    userInfo = fetchUserInfoFromDB(userId);
    jedis.setex("user:" + userId, 3600, userInfo);
}