sql jsp 连接错误

ivy76 2007-05-22 08:47:03

出错的源码:

<%//变量声明
java.sql.ResultSet sqlRst; //结果集对象
java.lang.String strSQL; //SQL语句
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();

String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Subsidizes";

String user="sa";

String password="123456";

Connection conn= DriverManager.getConnection(url,user,password);

Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
strSQL = "select jxj,qgzx,zxdk,knbz,xfjm from manager ";

//执行SQL语句并获取结果集
sqlRst= stmt.executeQuery(strSQL);
String jxj=null,qgzx=null,zxdk=null,knbz=null,xfjm=null,type=null;
while(sqlRst.next()){
jxj=sqlRst.getString(1);
qgzx=sqlRst.getString(2);
zxdk=sqlRst.getString(3);
knbz=sqlRst.getString(4);
xfjm=sqlRst.getString(5);
}
%>

错误码:
type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 5 in the jsp file: /teacher/frame2.jsp
Generated servlet error:
Connection cannot be resolved to a type

An error occurred at line: 5 in the jsp file: /teacher/frame2.jsp
Generated servlet error:
DriverManager cannot be resolved

An error occurred at line: 5 in the jsp file: /teacher/frame2.jsp
Generated servlet error:
Statement cannot be resolved to a type

An error occurred at line: 5 in the jsp file: /teacher/frame2.jsp
Generated servlet error:
ResultSet.TYPE_SCROLL_SENSITIVE cannot be resolved to a type

An error occurred at line: 5 in the jsp file: /teacher/frame2.jsp
Generated servlet error:
ResultSet.CONCUR_UPDATABLE cannot be resolved to a type

org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 5 in the jsp file: /teacher/frame2.jsp
Generated servlet error:
Connection cannot be resolved to a type

An error occurred at line: 5 in the jsp file: /teacher/frame2.jsp
Generated servlet error:
DriverManager cannot be resolved

An error occurred at line: 5 in the jsp file: /teacher/frame2.jsp
Generated servlet error:
Statement cannot be resolved to a type

An error occurred at line: 5 in the jsp file: /teacher/frame2.jsp
Generated servlet error:
ResultSet.TYPE_SCROLL_SENSITIVE cannot be resolved to a type

An error occurred at line: 5 in the jsp file: /teacher/frame2.jsp
Generated servlet error:
ResultSet.CONCUR_UPDATABLE cannot be resolved to a type

我的manager表中那几个属性是用bit型的不能改变属性的情况下怎样弄好啊?

...全文