通过jsp网页连接读取mysql数据库

<%
   Connection conn = null;
   String url = "jdbc:mysql://localhost:3306/your_database_name";
   String username = "your_username";
   String password = "your_password";

   try {
      Class.forName("com.mysql.jdbc.Driver");
      conn = DriverManager.getConnection(url, username, password);
      // 连接成功
   } catch (Exception e) {
      // 处理连接错误
   }
%>

<%
   try {
      Statement statement = conn.createStatement();
      String sql = "SELECT * FROM your_table_name";
      ResultSet rs = statement.executeQuery(sql);
      
      // 处理查询结果
      while (rs.next()) {
         // 获取每一行的数据
         String column1 = rs.getString("column1");
         String column2 = rs.getString("column2");
         // 处理数据
      }
      
      rs.close();
      statement.close();
   } catch (Exception e) {
      // 处理查询错误
   }
%>

<%
   try {
      conn.close();
   } catch (Exception e) {
      // 处理关闭连接错误
   }
%>