Question

java怎样连接 SQL Server 2005

Answer 1

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class ToSQL {
public static void main(String args[]){
new ToSQL();
}
public ToSQL(){
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=XXX","sa","XXXXXX");
System.out.println("数据库连接成功！！！");
} catch (Exception e) {
System.out.println("数据库连接失败！！！");
e.printStackTrace();
}
}
}

Answer 2

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://主机:端口号;DatabaseName=数据库名称","用户名","密码");