jbuilder9连接sql2000数据库

[hxnet]

在windows2000系统下，如何将jbuilder9和sql2000数据库相连接。（最好是详细的说明）
谢谢

[XTZM]

package test;

import java.sql.*;
import java.lang.*;
import java.sql.DriverManager;

public class DataBase
{
private Connection Conn = null;
private ResultSet Rs = null;
public DataBase(String UrlConn,String UserName,String PassWord)
{
Conn = DbConn(UrlConn,UserName,PassWord);
}

//连接的数据库
private Connection DbConn(String UrlConn,String UserName,String PassWord)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//指定使用的驱动程序
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println(e.getMessage());
}

try
{
Conn = DriverManager.getConnection(UrlConn,UserName,PassWord);
}
catch(java.sql.SQLException e)
{
System.err.println(e.getMessage());
}
return Conn;
}

//执行没有返回的SQL
public boolean ExecuteSql(String SQL)
{
boolean Result = false;
try
{
Statement Stmt = Conn.createStatement();
Result = Stmt.execute(SQL);
Stmt.close();
}
catch(java.sql.SQLException e)
{
System.err.println(e.getMessage());
}
return Result;
}

//执行SQL返回记录集
public ResultSet ExecuteQuery(String SQL)
{
try
{
Statement Stmt = Conn.createStatement();
Rs = Stmt.executeQuery(SQL);
}
catch(java.sql.SQLException e)
{
System.err.println(e.getMessage());
}
return Rs;
}

//查询数据记录
public boolean QueryRecord(String SQL)
{
boolean Result = false;
try
{
Statement Stmt = Conn.createStatement();
ResultSet Rs = Stmt.executeQuery(SQL);
Rs.next();
if (Rs.getRow()!= 0)
{
Result = true;
}
Stmt.close();
Rs.close();
}
catch(java.sql.SQLException e)
{
System.err.println(e.getMessage());
}
return Result;
}

}

[weastsea]

在CSDN里搜索
一大堆