站内搜索: 请输入搜索关键词

当前页面: 开发资料首页JSP 专题关于JSP数据库连接的问题?

关于JSP数据库连接的问题?

摘要: 关于JSP数据库连接的问题?

我的连接程序如下:
----------------------------------------------
<%@page contentType="text/html;charset=GB2312"%>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=questionnaire";
Connection con= DriverManager.getConnection(url,"sa","801208161");
Statement smt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs;
String sql;
%>
------------------------------------------------------

以下是出错信息:
An error occurred between lines: 1 and 7 in the jsp file: /opendata.jsp

Generated servlet error:
D:\tomcat\work\localhost\_\opendata$jsp.java:56: Class org.apache.jsp.Connection not found.
Connection con= DriverManager.getConnection(url,"sa","801208161");
^


An error occurred between lines: 1 and 7 in the jsp file: /opendata.jsp

Generated servlet error:
D:\tomcat\work\localhost\_\opendata$jsp.java:56: Undefined variable or class name: DriverManager
Connection con= DriverManager.getConnection(url,"sa","801208161");
^


An error occurred between lines: 1 and 7 in the jsp file: /opendata.jsp

Generated servlet error:
D:\tomcat\work\localhost\_\opendata$jsp.java:57: Class org.apache.jsp.Statement not found.
Statement smt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
^


An error occurred between lines: 1 and 7 in the jsp file: /opendata.jsp

Generated servlet error:
D:\tomcat\work\localhost\_\opendata$jsp.java:58: Class org.apache.jsp.ResultSet not found.
ResultSet rs;
^
4 errors, 1 warning



↑返回目录
前一篇: 配置Eclpise+tomcat并实现JSP的编写与部署
后一篇: 分页显示问题的解决方法(jsp,sqlserver,mysql,oracle)