连接数据库的问题！！

必须保证你的jdbc类文件在你的web_inf->lib目录下

解决方案 »

  1.   

    1、你的jdbc驱动程序安装好了吗？
    2、把你的jsp文件贴出来，要不然怎么判断
      

  2.   

    昨天我没把代码带回来，所以没说清楚，今天我就把我的代码贴出来，大家帮我看看是出了什么问题吧，谢谢了！！！！
    <%@ page contentType="text/html;charset=gb2312" %>
    <%@ page import="java.sql.*"%>
    <% 
       java.sql.Connection sqlConn;//数据库连接对象 
       java.sql.Statement sqlStmt;//语句对象 
       java.sql.ResultSet sqlRst;//结果集对象 
      Class.forName("net.sourceforge.jtds.jdbc.Driver"); 
      sqlConn= java.sql.DriverManager.getConnection("jdbc:jtds:sqlserver://192.168.0.68/live;USER=sa;PASSWORD=1"); 
      sqlStmt=sqlConn.createStatement(); 
      sqlRst =sqlStmt.executeQuery("select * from typestyle");
     
      
    %>
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
    <title>数据库连接</title>
    </head>
    <body>
    <table border="1" cellspacing="0" cellpadding="0" align="center">
    <tr>
       <th>id</th>
       <th>typename</th>
    </tr>
    <% while(sqlRst.next()){%>
    <tr>
       <td><%=sqlRst.getInt(1) %></td>
       <td><%=sqlRst.getString(2) %></td>
    </tr>
    <% } %>
    </table>
    </body>
    </html>
    <%
    sqlRst.close();sqlStmt.close();sqlConn.close();
    %>
      

  3.   

    出现的是这样的错误页面
    HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: Socket is not connected: connect
    org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)
    org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:795)
    org.apache.jsp.link_jsp._jspService(link_jsp.java:102)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    root cause java.sql.SQLException: Socket is not connected: connect
    net.sourceforge.jtds.jdbc.TdsConnection.(TdsConnection.java:196)
    net.sourceforge.jtds.jdbc.Driver.getConnection(Driver.java:112)
    net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:96)
    java.sql.DriverManager.getConnection(Unknown Source)
    java.sql.DriverManager.getConnection(Unknown Source)
    org.apache.jsp.link_jsp._jspService(link_jsp.java:50)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    note The full stack trace of the root cause is available in the Tomcat logs.