mysql-connector-java-3.1.12-bin文件配置好了,jdk和tomcat都没有问题,JSP代码如下
<html>
<head>
<title>ss</title>
</head>
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<body>
<h2>
ss</h2>
<table border=1 align="center">
  <tr>
    <td>用户名</td>
    <td>姓名</td>
    <td>电子邮件</td>
    <td>住址</td>
  </tr>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:TestData";
String username="";
String password="";
Connection con=DriverManager.getConnection(url,username,password);
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from Users");
while(rs.next())
{
%>
  <tr>
    <td><%=rs.getString("UserID")%></td>
    <td><%=rs.getString("Name")%></td>
    <td><%=rs.getString("Email")%></td>
    <td><%=rs.getString("Address")%></td>
  </tr>
<%
}
rs.close();
con.close();
%>
</table>
</body>
</html>出现的部分错误页面:type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: No data found
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:498)
at org.apache.jsp._06_01_jsp._jspService(_06_01_jsp.java:102)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:162)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:240)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)