java jdbc连sql2005

来源：百度知道 编辑：UC知道 时间：2024/09/25 05:53:43
从没用jdbc连过sql2005,网上查了一下,和连sql2000区别很大,希望高人们详细介绍一下java连接sql2005的步骤
小弟在此先跪谢了

package ch03;

import java.sql.Connection;
import java.sql.DriverManager;

public class DBConnection {
private static final String DRIVER_CLASS = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static final String DATABASE_URL = "jdbc:sqlserver://localhost:1035;databaseName=restrant";
private static final String DATABASE_USER = "niuli";
private static final String DATABASE_PASSWORD = "123456";

private Connection con = null;

public Connection getConnection() {
try {
Class.forName(DRIVER_CLASS);
con=DriverManager.getConnection(DATABASE_URL,DATABASE_USER,DATABASE_PASSWORD);
System.out.println("SQL2005 连接成功!");
} catch (Exception ex) {
System.out.println("2:"+ex.getMessage());
}
return con;
}
}

由于JDBC在连接SQL Server2005数据库时与SQL Server2000有些不同，配置要复杂一点。所以特意在此介绍连接方法！