Class.forName(“com.microsoft.jdbc.sqlserver.SQLServerDriver”).newInstance();
String url=”jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=zhangtianxing”;
Sql2000DB为数据库名, localhost 为主机名/IP
String user=”sa”;
String password=”zhangtianxing”;
Connection conn=DriverManager.getConnection(url,user,password);
ConnStr = "Provider = Sqloledb; User ID = " & SqlUsername & "; Password = "zhangtianxing"; Initial Catalog = "zhangtianxing"; Data Source = "(local);"
SqlUsername:用记名.
没意义