如何从数据库(表)中获取计数并链接到jsp页面？

import java.sql.*;

public class DatabaseConnection {
    public static void main(String[] args) {
        Connection connection = null;
        try {
            // 加载数据库驱动
            Class.forName("com.mysql.jdbc.Driver");
            
            // 创建数据库连接
            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");
            
            // 进行数据库操作
            // ...
            
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            // 关闭数据库连接
            try {
                if (connection != null) {
                    connection.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("SELECT COUNT(*) FROM your_table");
int count = 0;
if (resultSet.next()) {
    count = resultSet.getInt(1);
}

request.setAttribute("count", count);

<p>计数值：${count}</p>