一个成功连接mysql 的jsp文件

来源：互联网发布：淘宝信息层面判断售假编辑：程序博客网时间：2024/05/29 08:46

看文章前请确保你的 eclipse+mysql+tomcat环境已经搭建好

该有的jdbc包已经放到了WEB-INF 下的lib文件夹中。

下面是jsp文件：

<%@ page language="java" contentType="text/html; charset=UTF-8"pageEncoding="UTF-8"%><%@ page import="com.mysql.jdbc.Driver"%><%@ page import="java.sql.*"%><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Insert title here</title></head><body><%Statement stmt=null;ResultSet rs=null;Connection conn=null;try {        Class.forName("com.mysql.jdbc.Driver");      conn = DriverManager.getConnection(              "jdbc:mysql://localhost:3306/testdb", "root", "123456");       stmt = conn.createStatement();       rs = stmt.executeQuery("select * from tb_01");      while (rs.next()) {      %>    <table>          <tr>             <td>id</td>             <td>name</td>          </tr>          <tr>             <td><%=rs.getInt("id")%></td>             <td><%=rs.getString("name")%></td>             </tr>        </table>        <!--  System.out.println(rs.getInt("id"));          System.out.println(rs.getString("name")); -->        <%     }  }catch (ClassNotFoundException e) {      e.printStackTrace();  } catch(SQLException e){      e.printStackTrace();}    finally{  rs.close();  stmt.close();  conn.close();  }  %><h1>HELLO WORLD!</h1></body></html>