JBuilder2005直连数据库(sql2000)配置方案

来源：互联网发布：windows的快捷方式编辑：程序博客网时间：2024/05/21 18:43

1 下载Microsoft SQL Server 2000 JDBC 驱动程序(要的找我就是了).
2 安装上面这个东东,装好后它的路径在系统默认盘的(C:/Program Files/Microsoft SQL Server 2000 Driver for JDBC),在这个(E:/Program Files/Microsoft SQL Server 2000 Driver for JDBC/lib)路径下去拷三个文件了:msbase.jar,mssqlserver.jar,msutil.jar.把它放到JBuilder的lib目录下.(E:/Borland/JBuilder2005/lib).
3.配置环境变量了,把在E:/Program Files/Microsoft SQL Server 2000 Driver for JDBC/lib下的三个jar文件路径加到CLASSPATH 变量(以下是一个配置好的 CLASSPATH 变量的示例：
CLASSPATH=.;c:/program files/Microsoft SQL Server 2000 Driver for JDBC/lib/msbase.jar;c:/program files/Microsoft SQL Server 2000 Driver for JDBC/lib/msutil.jar;c:/program files/Microsoft SQL Server 2000 Driver for JDBC/lib/mssqlserver.jar
).
4 打开jBuilder设置一些参数,具体如下所示了,我不写了,粘贴过来的哟:
{
打开Jbuilder，
选择Tools-->Configure-->Libraries，
然后在左边的列表框下选择New，填入：Name:sql，Location:User Home，然后点击Add，
加入目录C:/Program Files/Microsoft SQL Server 2000 JDBC/lib，确定
三、Project-->Prject Properties-->Paths-->Required Libraries-->Add
加入刚才添加的User Home/sql确定
四、Enterprise-->Enterprise Setup-->Database Drivers-->Add，加入User Home/sql，
添加之后在列表框中显示的是sql.config，确定，重新启动JBuilder
五、Tools-->Database
Pilot-->View-->Options-->Drivers-->Add
填入
Driver class:com.microsoft.jdbc.sqlserver.SQLServerDriver
Simple [url=microsoft:sqlserver://localhost:1433;DatabaseName=mybase]URL:microsoft:sqlserver://localhost:1433;DatabaseName=mybase[/url]
确定之后，Tools-->Database Pilot-->New的Driver里选择
com.microsoft.jdbc.sqlserver.SQLServerDriver
在URL里填入：
microsoft:sqlserver://服务器Ip地址或主机名:1433;DatabaseName=数据库名，确定！
双击或点击+号输入sql数据库的用户名和密码，就完成了JB与sql的连接！
}.
5,开发1433端口号,从开始菜打开Microsoft SQL Server 选择服务器网络实用工具,启用TCP/IP,在属性里可改端口号哟. ,还要到管理工具里去看一个服务项,在服务里找到Telnet,看他是否启动了的,要把它启动开.
6 可以测试了,提醒一下,每建一个工程,连的数据库不同,那么在设置JBuilder的:Simple [url=microsoft:sqlserver://localhost:1433;DatabaseName=mybase]URL:microsoft:sqlserver://localhost:1433;DatabaseName=mybase[/url] 项时,最后的DatabaseName=数据库名.
7 ,我提供测测代码:

import java.*;
public class Connect{
     private java.sql.Connection con = null;
     private final String url = "jdbc:microsoft:sqlserver://";
     private final String serverName= "localhost";
     private final String portNumber = "1433";
     private final String databaseName= "pubs";
     private final String userName = "user";
     private final String password = "password";
     // Informs the driver to use server a side-cursor,
     // which permits more than one active statement
     // on a connection.
     private final String selectMethod = "cursor";

// Constructor
public Connect(){}

     private String getConnectionUrl(){
          return url+serverName+":"+portNumber+";databaseName="+databaseName+";selectMethod="+selectMethod+";";
     }

     private java.sql.Connection getConnection(){
          try{
               Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
               con = java.sql.DriverManager.getConnection(getConnectionUrl(),userName,password);
               if(con!=null) System.out.println("Connection Successful!");
          }catch(Exception e){
               e.printStackTrace();
               System.out.println("Error Trace in getConnection() : " + e.getMessage());
         }
          return con;
      }

     /*
          Display the driver properties, database details
     */

     public void displayDbProperties(){
          java.sql.DatabaseMetaData dm = null;
          java.sql.ResultSet rs = null;
          try{
               con= this.getConnection();
               if(con!=null){
                    dm = con.getMetaData();
                    System.out.println("Driver Information");
                    System.out.println("/tDriver Name: "+ dm.getDriverName());
                    System.out.println("/tDriver Version: "+ dm.getDriverVersion ());
                    System.out.println("/nDatabase Information ");
                    System.out.println("/tDatabase Name: "+ dm.getDatabaseProductName());
                    System.out.println("/tDatabase Version: "+ dm.getDatabaseProductVersion());
                    System.out.println("Avalilable Catalogs ");
                    rs = dm.getCatalogs();
                    while(rs.next()){
                         System.out.println("/tcatalog: "+ rs.getString(1));
                    }
                    rs.close();
                    rs = null;
                    closeConnection();
               }else System.out.println("Error: No active Connection");
          }catch(Exception e){
               e.printStackTrace();
          }
          dm=null;
     }

     private void closeConnection(){
          try{
               if(con!=null)
                    con.close();
               con=null;
          }catch(Exception e){
               e.printStackTrace();
          }
     }
     public static void main(String[] args) throws Exception
       {
          Connect myDbTest = new Connect();
          myDbTest.displayDbProperties();
       }
}

---------------------------------------------
如果此代码运行成功，其输出结果应类似于以下内容： Connection Successful!Driver InformationDriver Name:SQLServerDriver Version: 2.2.0022Database InformationDatabase Name:Microsoft SQL ServerDatabase Version:Microsoft SQL Server 2000 - 8.00.384 (Intel X86)May 23 2001 00:02:52Copyright (c) 1988-2000 Microsoft CorporationDesktop Engine on Windows NT 5.1 (Build 2600: )Avalilable Catalogscatalog:mastercatalog:msdbcatalog:pubscatalog:tempdb
补充说明下了: 先建好工程并写好了代码,才设置jbuilder配置参数.
小凡稿
08年9月12日