<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="gb2312"%>
<%@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=gb2312">
<title>数据库连接测试</title>
</head>
<body>
<%
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test";
Connection connection = DriverManager.getConnection(url,
"root", "root");
if (connection != null) {
out.println("<h3>数据库连接成功!</h3>");
} else {
out.println("<h3>数据库连接失败!</h3>");
}
String sql = "select*from friends";
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(sql);
while (resultSet.next()) {
out.println(resultSet.getString(1));
out.println(resultSet.getString(2) + "<br>");
}
resultSet.close();
statement.close();
connection.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
%>
</body>
</html>
在采用上述的一个jsp页面来测试连接数据库时，出现了上图所示的错误，mysql驱动包文件mysql-connector-java-5.1.7-bin我是按正确的方式导入的，可是仍然出现了上述的错误，浏览器页面没有任何的异常提示信息，最终通过将mysql-connector-java-5.1.7-bin文件放到Tomcat中的lib文件夹下才解决了上述的异常问题！
补充：正确的做法是包要放到web-inf的lib目录里。