java 如何连接sql server 2005

来源:百度知道 编辑:UC知道 时间:2024/06/04 08:54:22
我已经安装了sql server 2005驱动程序,并把包sqljdbc.jar放到了java的lib中,代码如下
import java.sql.*;
public class CONN {

/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
//String dbURL="jdbc:sqlserver://ratandhong:1433;DatabaseName=T;user=sa;password=rat6028456";
//Connection connection ;
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
System.out.println("驱动器加载成功");
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
System.out.println("驱动无法加载");;//驱动无法加载,非正常结束程序!
}
}

}
出错:驱动器无法加载
不知道是哪里出错了

最好还是这样连吧
import java.sql.*;
public class CONN {

public CONN() {
// TODO 自动生成构造函数存根
}
public static final String DRIVER_CLASS = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
public static final String URL = "jdbc:sqlserver://localhost:1433;databaseName=bbs";
public static final String USER = "sa";
public static final String PASSWORD = "aaa";
static
{
try {
Class.forName(DRIVER_CLASS);
} catch (Exception e) {
throw new RuntimeException(e);
}
}

public Connection getConnection() throws SQLException
{
return DriverManager.getConnection(URL, USER, PASSWORD);
}
public static void main(String[] args) {
CONN conn=new CONN();
Connection connection;
try {
connection=conn.getConnection();
if(connection!=null)
{
System.out.println("连接成功");