jsp连接mysql数据库按条件查询语句

<%@ page import="java.sql.*" %>
<%
   String driver = "com.mysql.jdbc.Driver";
   String url = "jdbc:mysql://localhost:3306/mydatabase"; // 替换为实际的数据库连接URL
   String username = "root"; // 替换为实际的数据库用户名
   String password = "password"; // 替换为实际的数据库密码

   Connection conn = null;
   Statement stmt = null;
   ResultSet rs = null;
   try {
      // 加载MySQL JDBC驱动程序
      Class.forName(driver);
      // 建立数据库连接
      conn = DriverManager.getConnection(url, username, password);
      // 创建Statement对象
      stmt = conn.createStatement();

      // 执行查询
      String query = "SELECT * FROM mytable WHERE condition = ?";
      PreparedStatement pstmt = conn.prepareStatement(query);
      pstmt.setString(1, "value"); // 替换为实际的查询条件
      rs = pstmt.executeQuery();

      // 处理查询结果
      while (rs.next()) {
         // 获取字段值并进行处理
         String column1 = rs.getString("column1");
         // ...
      }
   } catch (Exception e) {
      e.printStackTrace();
   } finally {
      // 关闭数据库连接和资源
      if (rs != null) {
         try {
            rs.close();
         } catch (SQLException e) {
            e.printStackTrace();
         }
      }
      if (stmt != null) {
         try {
            stmt.close();
         } catch (SQLException e) {
            e.printStackTrace();
         }
      }
      if (conn != null) {
         try {
            conn.close();
         } catch (SQLException e) {
            e.printStackTrace();
         }
      }
   }
%>