服务器遭遇内部错误,阻碍了请求
本人在练习一个javaBean查询数据库的习题!
以下是Query.java和javaBeanQuery.jsp的代码:
package chapter08.Box;
import java.sql.*;
public class Query
{
public String querySQLString;
public ResultSet rs = null;
public Connection conn;
public void setQuerySQLString(String querySQLString)
{
this.querySQLString = querySQLString;
}
public void setConnection(String driverName, String jdbcURL, String userName, String password) throws Exception
{
Connection conn1;
Class.forName(driverName);
conn1 = DriverManager.getConnection(jdbcURL,userName,password);
conn1.setAutoCommit(false);
this.conn = conn1;
}
public ResultSet getRs()
{
try
{
PreparedStatement selectSQL = conn.prepareStatement(querySQLString,java.sql.ResultSet.TYPE_SCROLL_SENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
rs = selectSQL.executeQuery();
}
catch(Exception e)
{
System.out.println(e);
}
return rs;
}
}
javaBeanQuery.jsp的代码如下:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="chapter08.Box.*"%>
<jsp:useBean id="query" class="Query" scope="page">
</jsp:useBean>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>javaBean查询数据</title>
</head>
<body>
<%
ResultSet result = null;
String SQLString = "select * from student";
try
{
query.setConnection("com.microsoft.jdbc.sqlserver.SQLServerDriver","jdbc:microsoft:sqlserver//suiyuan:1433;DatabaseName=samples","sa","sa");
query.setQuerySQLString(SQLString);
result = query.getRs();
}
catch(SQLException e)
{
out.print("SQL异常!");
}
%>
<%
out.print("<table Border width='900'>");
out.print("<tr><td colspan ='6' align='center'>用QueryBean查询得到的学生数据</td></tr>");
out.print("<tr>");
out.print("<td width='100'>学生ID号</td>");
out.print("<td width='100'>学生姓名</td>");
out.print("<td width='100'>学生性别</td>");
out.print("<td width='100'>学生班级</td>");
out.print("<td width='100'>学生年级</td>");
out.print("<td width='400'>联系地址</td>");
out.print("</tr>");
while(result.next())
{
out.print("<tr>");
out.print("<td width='100'>"+result.getLong("student_id")+"</td>");
out.print("<td width='100'>"+result.getString("student_name")+"</td>");
out.print("<td width='100'>"+result.getString("student_sex")+"</td>");
out.print("<td width='100'>"+result.getLong("student_class")+"</td>");
out.print("<td width='100'>"+result.getLong("student_grade")+"</td>");
out.print("<td width='400'>"+result.getString("student_address")+"</td>");
out.print("</tr>");
}
out.print("</table>");
%>
</body>
</html>
麻烦各位帮忙查查原因!