代码如下：
package com.JDBC;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
/**
*/
public class GetConn {
public static void main(String args[]) {
GetConn c = new GetConn();
c.getconn();
}
/**
@param args
*/
public void getconn() {
// TODO Auto-generated method stub
// Create a variable for the connection string.
// Declare the JDBC objects.
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String connectionUrl = "jdbc:sqlserver://127.0.0.1:1434;database=CMDB" ;
String user = "sa";
String pass = "password1234";
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
System.out.println("con");
con = DriverManager.getConnection(connectionUrl,user,pass);
System.out.println("
// Create and execute an SQL statement that returns some data.
String SQL = "select * from test";
stmt = con.createStatement();
rs = stmt.executeQuery(SQL);
// Iterate through the data in the result set and display it.
while (rs.next()) {
System.out.println("【SUCC】获取 SQL-SERVER 的连接已成功。[1]="+rs.getString(2));
}
}
// Handle any errors that may have occurred.
catch (Exception e) {
System.out.println("【ERROR】打开 SQL-SERVER 的连接失败。");
e.printStackTrace();
}
finally {
if (rs != null)
try {
rs.close();
} catch (Exception e) {
}
if (stmt != null)
try {
stmt.close();
} catch (Exception e) {
}
if (con != null)
try {
con.close();
} catch (Exception e) {
}
}
}
}
运行的时候，con能输出，sql不会输出，卡在 con = DriverManager.getConnection(connectionUrl,user,pass); 这段代码，也不报错。如果改了配置信息，就会马上报错。想问下这是什么问题？
目测是你连接字符串有问题，或者sql的配置有问题，你确认是1434端口么？一般是1433
应该是SQL配置有问题，麻烦确认下端口
这是连接数据库有问题 抛异常你抛两个 一个驱动连接不成功 一个是数据库连接不成功
确定连接、用户名密码、jar包正确
也不报错。应该还会报错的你这又不是写的死循环