jsp连接mysql数据库语句怎么写

<%@ page import="java.sql.*" %>

<%
   String driver = "com.mysql.jdbc.Driver";
   String url = "jdbc:mysql://localhost:3306/数据库名称";
   String username = "数据库用户名";
   String password = "数据库密码";
%>

<%
   Connection conn = null;
   try {
      Class.forName(driver);
      conn = DriverManager.getConnection(url, username, password);
   } catch(Exception e) {
      e.printStackTrace();
   }
%>

<%
   Statement stmt = null;
   ResultSet rs = null;
   try {
      stmt = conn.createStatement();
      String sql = "SELECT * FROM 表名";
      rs = stmt.executeQuery(sql);

      while(rs.next()) {
         // 处理查询结果
         String columnName = rs.getString("列名");
         // 其他操作...
      }
   } catch(Exception e) {
      e.printStackTrace();
   } finally {
      // 关闭ResultSet、Statement和Connection对象
      try { if(rs != null) rs.close(); } catch(Exception e) { e.printStackTrace(); }
      try { if(stmt != null) stmt.close(); } catch(Exception e) { e.printStackTrace(); }
      try { if(conn != null) conn.close(); } catch(Exception e) { e.printStackTrace(); }
   }
%>