当前位置:编程学习 > 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: omcatworklocalhost_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: omcatworklocalhost_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
补充:Jsp教程,Jsp/Servlet开发工具
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,