Java连接SQL 2005数据库!...

import java.sql.Connection; //导入连接数据库类
 
import java.sql.DriverManager; //导入数据库驱动管理类
 import java.sql.SQLException; //导入连接数据库异常类


 public class ConnDb {


static Connection conn = null;
static String dbUrl  ="127.0.0.1",
  dbName ="friendanDB",
  dbUser ="sa",
  dbPass ="test";
public static void main(String[] args) {
//加载数据库驱动
//注意在加前在工程目录入引入连接数据库的驱动文件sqljdbc4.jar
//sqljdbc4.jar里面包含有类SQLServerDriver
try {

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
} 
catch (ClassNotFoundException e) {
System.out.println("未找到驱动文件,错误信息：" + e.toString());
return;
}

//连接数据库
try {


conn = DriverManager.getConnection("jdbc:sqlserver://" + dbUrl
+ ":1433;databaseName=" + dbName, dbUser, dbPass);
System.out.print(conn.getCatalog());
} 
catch (SQLException e) {
System.out.println("连接数据库失败，错误信息：" + e.toString());
return;
}
System.out.println("连接数据库成功!");
}
 
}