jbuilderX 写jsp时怎么连接sql2005(sql2005在服务器上)

如题，在服务器上装有sql2005，而我的机子上装有jbuilder x ，现在我要在我机子上用写jsp访问sql2005 ,而sql2005的驱动的都下载安装了，就是运行不了，向问问大家，是怎么连接的？
我的代码如下：
1.连接数据的类sql2005dba：
package sql2005jsp;
import java.sql.*;
import java.sql.Connection;
public class sql2005dba {
  public Connection con;
  public sql2005dba() {
    String CLASSFORNAME = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
     String url = "jdbc:sqlserver://188.18.8.12:1433; DatabaseName=tongxin";
    String uid="sa";
    String pwd="sa"; try{
      Class.forName(CLASSFORNAME);
      con=DriverManager.getConnection(url,uid,pwd);
    }
   catch(Exception e)
   {
     e.printStackTrace();
    }  }
  public ResultSet getall()
    {
      try{         String sql="select * from txshouji";         Statement stmt=con.createStatement(  ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
         ResultSet result=stmt.executeQuery(sql);
        return result;
      }catch(Exception e) {}
      return null;
    }
}2.jsp代码：
  <%@ page contentType="text/html; charset=GBK" %>
<%@ page language="java" import="java.sql.*"%>
<%@ page import="java.lang.Math.*" import="sql2005jsp.*" %>
<html>
<head>
<title>
index
</title>
</head>
<body bgcolor="#ffffff">
<h1>
<%
    ResultSet sqlRst=null;
     sql2005dba contact=new sql2005dba() ;
     sqlRst=contact.getall();%>
</h1>
</body>
</html>

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

  String   url   =   "jdbc:sqlserver://188.18.8.12:1433;   DatabaseName=tongxin";
這句寫錯了,應該是
String   url   =  "jdbc:microsoft:sqlserver://188.18.8.12:1433;DatabaseName=tongxin"
这是我的连接语句driverClassName="net.sourceforge.jtds.jdbc.Driver";
url="jdbc:jtds:sqlserver://localhost/wz";
username="sa";
password="sa";
C:\JBuilderX\jdk1.4\bin\javaw -classpath "C:\JBuilderX\thirdparty\jakarta-tomcat-4.0.6-LE-jdk14\bin\bootstrap.jar;C:\JBuilderX\jdk1.4\lib\tools.jar"  -Dcatalina.home="C:/JBuilderX/thirdparty/jakarta-tomcat-4.0.6-LE-jdk14"  org.apache.catalina.startup.Bootstrap -config "C:\Documents and Settings\new\jbproject\sql2005jsp\Tomcat\conf\server8080.xml" start
HttpConnector Opening server socket on all host IP addressesStarting service Tomcat-StandaloneApache Tomcat/4.0.6WebappLoader[/sql2005web]: Deploying class repositories to work directory C:\Documents and Settings\new\jbproject\sql2005jsp\Tomcat\work\sql2005webWebappLoader[/sql2005web]: Reloading checks are enabled for this ContextStandardManager[/sql2005web]: Seeding random number generator class java.security.SecureRandomStandardManager[/sql2005web]: Seeding of random number generator has been completedContextConfig[/sql2005web]: Added certificates -> request attribute ValveStandardWrapper[/sql2005web:default]: Loading container servlet defaultStandardWrapper[/sql2005web:invoker]: Loading container servlet invokerHttpConnector[8080] Starting background threadjava.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1406) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1254) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:141) at sql2005jsp.sql2005dba.<init>(sql2005dba.java:16) at org.apache.jsp.index$jsp._jspService(index$jsp.java:71) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:201) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027) at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125) at java.lang.Thread.run(Thread.java:534)
我用的是jbuilder x  我现在估计问题出现在JB里面加载SQL2005驱动出现问题，但我好像已经设置好了，就是不知道怎么回事。String       url       =     "jdbc:microsoft:sqlserver://188.18.8.12:1433;DatabaseName=tongxin"
也不行哦
java.lang.ClassNotFoundException:   com.microsoft.sqlserver.jdbc.SQLServerDriver
你應該沒有導入驅動包吧
你用import 導入看能不能正確導入成功,如果不能的話就代表你的驅動放的位置錯誤
谢谢各位了，问题已经解决了，是我在JBX里面设置数据库驱动不对。