从数据库中选择数据并在jsp页面中显示

String url = "jdbc:mysql://localhost:3306/mydatabase";
String username = "username";
String password = "password";
Connection connection = DriverManager.getConnection(url, username, password);

String sql = "SELECT * FROM users";
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(sql);

while (resultSet.next()) {
    String username = resultSet.getString("username");
    int age = resultSet.getInt("age");
    // 将数据存入request对象中
    request.setAttribute("username", username);
    request.setAttribute("age", age);
}

<p>用户名：${username}</p>
<p>年龄：${age}</p>