JDBC连接SQLserver2000数据库类
import java.sql.*;

public class Database {
Connection conn;
Statement stmt;
ResultSet rs;
public Database() {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").
newInstance();
} catch (ClassNotFoundException e) {

} catch (IllegalAccessException ex) {

} catch (InstantiationException ex) {

}

try {
String url =
"jdbc:microsoft:sqlserver://localhost:1433;databasename=testDb";
String user = "";
String password = "";

conn = DriverManager.getConnection(url, user, password); //获得连接
stmt = conn.createStatement(); //获得执行SQL语言的容器
String sql = "select * from testTable";
rs = stmt.executeQuery(sql); //获得结果集
while (rs.next()) {
System.out.println(rs.getString(1)); //拿到结果集中的第一列
}

} catch (SQLException e) {

}
}
}