写在类里面可以运行··在jsp里面就不能运行···
<%@ page contentType="text/html;charset=UTF-8"%>
<%@ page import="java.sql.*"%><html>
<head> <title>My JSP 'studnet.jsp' starting page</title> </head> <body>
<table>
<tr>
<td>
用户id
</td>
<td>
用户名
</td>
<td>
住址
</td>
</tr>
<%
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/myschool", "root", "123456");
Statement ps = con.createStatement();
ResultSet rs = ps.executeQuery("select * from student");
while (rs.next()) {
%>
<tr>
<td><%=rs.getString(1)%></td>
<td><%=rs.getString(3)%></td>
<td><%=rs.getString(7)%></td>
</tr>
<%
}
rs.close();
ps.close();
con.close();
%> </table> </body>
</html>
<%@ page contentType="text/html;charset=UTF-8"%>
<%@ page import="java.sql.*"%><html>
<head> <title>My JSP 'studnet.jsp' starting page</title> </head> <body>
<table>
<tr>
<td>
用户id
</td>
<td>
用户名
</td>
<td>
住址
</td>
</tr>
<%
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/myschool", "root", "123456");
Statement ps = con.createStatement();
ResultSet rs = ps.executeQuery("select * from student");
while (rs.next()) {
%>
<tr>
<td><%=rs.getString(1)%></td>
<td><%=rs.getString(3)%></td>
<td><%=rs.getString(7)%></td>
</tr>
<%
}
rs.close();
ps.close();
con.close();
%> </table> </body>
</html>
还有就是servlet配置问题
1,是你的服务器没有正常启动。
2,你的URL写错了。注意大小写。