|
sqlserver2005获取连接失败：com.microsoft.sqlserver.jdbc.SQLServerException: 到主机 的 TCP/IP 连接失败，解决办法： 安装完数据库后设置ICP/IP协议启动，具体如下：
? 命令行输入：telnet localhost 1433进行检查，这时会报错：正在连接到localhost...
? 不能打开到主机的连接，在端口 1433: 连接失败
（1）打开SQL Server Configuration Manager
（2）转到SQL Server 2005 Network Configuration->Protocols for MAHAIBO
（3）将TCP/IP设置为Enabled（启用）
（4）双击TCP/IP项，转到IP Addresses页
（5）IP All中设置TCP Port为1433
（6）重新启动服务 这一项尤其重要！！！摄取量sql 2005服务里面右键，，重启服务！！！
Java代码
package org.test.db;???
??
import java.sql.Connection;???
import java.sql.DriverManager;???
??
public class Conn {???
???????
??? private static? String url = "jdbc:sqlserver://localhost:1433;DatabaseName=frame";???
??? private static? String username = "sa";???
??? private static? String password = "123456";???
??? private static? String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";???
???????
??? public static Connection getConnection(){???
??????? Connection conn = null;???
??????? try{???
??????????? Class.forName(driver);???
??????????? conn = DriverManager.getConnection(url,username,password);???
??????? }catch(Exception e){???
??????????? e.printStackTrace();???
??????? }???
??????? return conn;???
??? }???
??
}??
package org.test.db;
import java.sql.Connection;
import java.sql.DriverManager;
public class Conn {
?
?private static? String url = "jdbc:sqlserver://localhost:1433;DatabaseName=frame";
?private static? String username = "sa";
?private static? String password = "123456";
?private static? String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
?
?public static Connection getConnection(){
??Connection conn = null;
??try{
???Class.forName(driver);
???conn = DriverManager.getConnection(url,password);
??}catch(Exception e){
???e.printStackTrace();
??}
??return conn;
?}
}
用JUnit单元测试如下：
Java代码
package org.test.db;???
??
import java.sql.Connection;???
??
import org.junit.Assert;???
import org.junit.Test;???
??
public class ConnTest {???
??
??? @Test??
??? public void testGetConnection() {???
??????? Connection conn = Conn.getConnection();???
??????? Assert.assertNotNull(conn);???
??? }???
??
}??
本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/awsqsh/archive/2010/11/02/5981234.aspx
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
