看文章前 请确保你的 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>