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

王朝java/jsp·作者佚名  2006-01-09
窄屏简体版  字體: |||超大  

我的连接程序如下:

----------------------------------------------

<%@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

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航