[视图技术相关] JSP中连接数据库sqlServer2000的问题

瓜皮

<%--测试连接数据库SQLServer2000--%>
<%@ page language ="java" import ="java.sql.*" contentType ="text/html;charset=gbk" %>
<%!
   public final static String DBDriver ="com.microsoft.sqlserver.jdbc.SQLServerDriver";//驱动器
   public final static String url ="jdbc:microsoft:sqlserver://1433;DatabaseName =pubs";//数据库
   public final static String user ="sa";//访问数据库的用户名
   public final static String password ="sa";//访问数据库的密码
%>
<%
   Class.forName(DBDriver);//加载数据库驱动器
   Connection con =DriverManager.getConnection(url,user,password);//创建数据库的连接
   String sql ="select title_id,type,price from titles";//查询语句
   PreparedStatement stat =con.prepareStatement(sql);//预编译查询语句
   ResultSet rs =stat.executeQuery();//执行查询语句
%>
<center>
  <h1>书籍管理</h1>
     <table border =1 width ="80%" >
        <tr>
           <td>title_id</td>
     <td>type</td>
     <td>price</td>
        </tr>
<%
   //处理查询的结果集
   while(rs.next()){
%>
        <tr>
     <td><%=rs.getString(1)%></td>
     <td><%=rs.getString(2)%></td>
     <td><%=rs.getString(3)%></td>
  </tr>
<%
   }
%>
<%
   //断开数据库的连接
   rs.close();
   stat.close();
   con.close();
%>
     </table>
</center>

瓜皮

org.apache.jasper.JasperException: An exception occurred processing JSP page /index.jsp at line 11

8: %>
9: <%
10:    Class.forName(DBDriver).newInstance();//加载数据库驱动器
11:    Connection con =DriverManager.getConnection(url,user,password);//创建数据库的连接
12:    String sql ="select title_id,type,price from titles";//查询语句
13:    PreparedStatement stat =con.prepareStatement(sql);//预编译查询语句
14:    ResultSet rs =stat.executeQuery();//执行查询语句


Stacktrace:
        org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
        org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)
        org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
        org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:803)


root cause

javax.servlet.ServletException: java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver://1433;DatabaseName =pubs
        org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:850)
        org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
        org.apache.jsp.index_jsp._jspService(index_jsp.java:116)
        org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
        org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
        org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:803)


root cause

java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver://1433;DatabaseName =pubs
        java.sql.DriverManager.getConnection(DriverManager.java:602)
        java.sql.DriverManager.getConnection(DriverManager.java:185)
        org.apache.jsp.index_jsp._jspService(index_jsp.java:66)
        org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
        org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
        org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

heyitang

注意两点
一.sql server2000的三个jar包有没有导入？
二.sql server的版本，要求使用sp3或以上的版本

[ 本帖最后由 heyitang 于 2009-12-31 22:08 编辑 ]

lijia245235993

你连接sqlserver2000的数据库，要给sqlserver2000数据库打上sq4补丁，把sql驱动放到web应用的lib文件夹下！！你如果没有sp4补丁的话，你加我qq:245235993 我给你发过去，我平时也用sql2000的数据库把sp4补丁打上,没问题能连上的！