1.首先,访问数据库的代码不能出错,以下是我的代码,已验证通过
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*" import="java.util.*" import="java.io.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>读取Mysql数据库</title>
</head>
<body>
<%
try {
String dburl = "jdbc:mysql://localhost:3306/mysql";//String dburl = "jdbc:mysql://localhost:端口号/你的表所在 的位置"
Connection conn = DriverManager.getConnection(dburl,
"root", "root");//Connection conn = DriverManager.getConnection(dburl, "用户名", "登录密码");
Statement stmt = conn.createStatement();
String sql = "SELECT * FROM books";
ResultSet rs = stmt.executeQuery(sql);
out.println("<table border=1>");
out.println("<tr><td>书号</td><td>书名</td><td>作者</td><td>价格</td></tr>");
while (rs.next()) {
out.println("<tr><td>" + rs.getString(1) + "</td><td>"
+ rs.getString(2) + "</td><td>" + rs.getString(3)
+ "</td><td>" + rs.getString(5) + "</td></tr>");
}
out.println("</table>");
rs.close();
stmt.close();/**/
conn.close();
} catch (Exception e) {
out.println(e.getMessage());
}
%>
</body>
</html>
2.代码运行结果
2.代码中表books所在的位置,以及数据库相关信息