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日