level 1
_偏_飞
楼主
这是我写的JSP页面
<body>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=student";
String user="sa";
String password="sa";
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select top5 stuInfo.学号,stuInfo.姓名,数学 from stuInfo,stuScore where stuInfo.学号 order by 数学 desc";
ResultSet rs=stmt.executeQuery(sql);
out.print("数学成绩排在前五位的同学名单");
out.print("<table border>");
out.print("<tr>");
out.print("<th width=100>"+"学号");
out.print("<th width=100>"+"姓名");
out.print("<th width=100>"+"数学成绩");
out.print("</tr>");
while(rs.next()){
%>
<tr>
<td><%=rs.getString(1) %></td>
<td><%=rs.getString(2) %></td>
<td><%=rs.getString(3) %></td>
</tr><%}out.print("</table>"); %>
<%
rs.close();
stmt.close();
conn.close();
%>
</body>
结果报错:
org.apache.jasper.JasperException: Exception in JSP: /sqlDriverWay.jsp:12
9: </head>
10: <body>
11: <%
12: Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
13: String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=student";
14: String user="sa";
15: String password="sa";
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:451)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
哪个大哥大姐帮我解决一下!!
2009年03月25日 01点03分
1
<body>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=student";
String user="sa";
String password="sa";
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select top5 stuInfo.学号,stuInfo.姓名,数学 from stuInfo,stuScore where stuInfo.学号 order by 数学 desc";
ResultSet rs=stmt.executeQuery(sql);
out.print("数学成绩排在前五位的同学名单");
out.print("<table border>");
out.print("<tr>");
out.print("<th width=100>"+"学号");
out.print("<th width=100>"+"姓名");
out.print("<th width=100>"+"数学成绩");
out.print("</tr>");
while(rs.next()){
%>
<tr>
<td><%=rs.getString(1) %></td>
<td><%=rs.getString(2) %></td>
<td><%=rs.getString(3) %></td>
</tr><%}out.print("</table>"); %>
<%
rs.close();
stmt.close();
conn.close();
%>
</body>
结果报错:
org.apache.jasper.JasperException: Exception in JSP: /sqlDriverWay.jsp:12
9: </head>
10: <body>
11: <%
12: Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
13: String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=student";
14: String user="sa";
15: String password="sa";
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:451)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
哪个大哥大姐帮我解决一下!!