Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); Connection cn = DriverManager.getConnection("jdbc:microsoft:sqlserver://172.16.100.6:1433;databasename=DB;User=user;Password=password"); Statement st = cn.createStatement(); 以上是连接sqlserve的方法,其他的数据库类使,重要的是得到相应的驱动程序
使用类似下面连接实例即可:(下例已经实现)
import java.sql.*;
public class Test {
public static void main(String[] args) {
try {
String address = "jdbc:microsoft:sqlserver://192.168.0.118:1433";
//ip地址为目标数据库机器ip
String user="sa";
String passwd="";
String database = "TESTDB";//数据库名
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con = DriverManager.getConnection(address,user,passwd);
con.setCatalog(database);
Statement smt = con.createStatement();
String selCode = "SELECT TOP 1 ServerName,StartTime,ExitTime,ExitFlag FROM ServerLog";
ResultSet r = smt.executeQuery(selCode);
String ServerName = "";
String StartTime = "";
String ExitTime = "";
String ExitFlag = "";
while(r.next()) {
ServerName = r.getString("ServerName");
StartTime = r.getString("StartTime");
ExitTime = r.getString("ExitTime");
ExitFlag = r.getString("ExitFlag");
}
System.out.println("ServerName"+ServerName);
System.out.println("StartTime"+StartTime);
System.out.println("ExitTime"+ExitTime);
System.out.println("ExitFlag"+ExitFlag);
}
catch(Exception e) {
System.out.println(e);
}
}
} //
http://download.microsoft.com/download/SQLSVR2000/jdbc/2000/NT45XP/EN-US/setup.exe