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

  
我的连接程序如下：
———————————————-
<%@page contentType="text/html;charset=GB2312"%>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=questionnaire";

http://www.gaodaima.com/42098.html关于jsP数据库连接的问题？

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

欢迎大家阅读《关于JSP数据库连接的问题？》,跪求各位点评,若觉得好的话请收藏本文，by 搞代码

喜欢 (0)赏

[搞代码]

分享 (0)