请大家写一个连接SQLServer的代码？

ConnStr = "Provider = Sqloledb; User ID = " & SqlUsername & "; Password = "zhangtianxing"; Initial Catalog = "zhangtianxing"; Data Source = "(local);"

SqlUsername:用记名.

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);

没意义