Question

java中遇到问题：到主机 的 TCP/IP 连接失败java.net.ConnectException: Connection refused: connect

java编程中遇到问题：到主机 的 TCP/IP 连接失败。 java.net.ConnectException: Connection refused: connect

这里是源代码：
package lx1;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class shujuku {

/**
* @param args
*/
public static void main(String[] args) throws SQLException,ClassNotFoundException{

String user = "sa";
String pwd = "123456";
String myjdbc = "jdbc:sqlserver://localhost:1433;DatabaseName=Mysql";

//创建Mysql驱动
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
//创建连接会话

Connection myConnection = DriverManager.getConnection(myjdbc,user,pwd);
//创建语句块对象
Statement Myoperation =myConnection.createStatement();

//获取结果集对象
ResultSet record = Myoperation.executeQuery("SELSECT * FROM Mysql");
while (record.next()){
System.out.println(record.getString("姓名") + "," + record.getString("性别") + "," + record.getInt("年龄"));
}
try{
if (record !=null)
//关闭结果集是需要处理异常
record.close();

}catch(Exception e){
e.printStackTrace();
}finally{
try{
if(myConnection != null)
myConnection.close();
}catch(Exception e){
e.printStackTrace();
}
}

}

}

Answer 1

检查：数据库名，IP，端口，用户名，密码连接拒绝基本上都是ip,端口不对

Answer 2

数据库服务没有开