我机器的环境有SQLSERVER2000和SQLSERVER2005
一个简单的JDBC连数据的过程,为什么会有错,个人觉得应该是端口的问题import java.sql.*;public class JDBCTEST {
public static void main(String[] args) {
Connection con;
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url =
"jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=BBS_DB;";
try {
Class.forName(driver);
con=DriverManager.getConnection(url);
if (con != null) {
System.out.println("连接成功");
}
}
catch (Exception e) {
e.printStackTrace();
System.out.print("数据库连接失败");
}
finally {
}
System.out.println("连接数据库成功");
}
}java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at JDBCTEST.main(JDBCTEST.java:11)
数据库连接失败连接数据库成功
一个简单的JDBC连数据的过程,为什么会有错,个人觉得应该是端口的问题import java.sql.*;public class JDBCTEST {
public static void main(String[] args) {
Connection con;
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url =
"jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=BBS_DB;";
try {
Class.forName(driver);
con=DriverManager.getConnection(url);
if (con != null) {
System.out.println("连接成功");
}
}
catch (Exception e) {
e.printStackTrace();
System.out.print("数据库连接失败");
}
finally {
}
System.out.println("连接数据库成功");
}
}java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at JDBCTEST.main(JDBCTEST.java:11)
数据库连接失败连接数据库成功
XP SP2?
补丁打了没?
驱动安装正确不?
連個局域網裏別的SQL SERVER服務器試試。
public class JDBCTEST {
public static void main(String[] args) {
Connection con;
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String user ="abc";//这里替换成你自已的数据库用户名
String password = "abc";//这里替换成你自已的数据库用户密码
String url =
"jdbc:microsoft:sqlserver://192.168.0.3:1433;DatabaseName=NorthWind;";
try {
Class.forName(driver);
con=DriverManager.getConnection(url,user,password);
Statement st = con.createStatement();
if (con != null) {
System.out.println("连接成功");
}
}
catch (Exception e) {
e.printStackTrace();
System.out.print("数据库连接失败");
}
finally {
}
System.out.println("连接数据库成功");
}
}
String user ="sa"
String password = ""
密码是空
telnet 127.0.0.1 1433看下服务器开了没有
我是在该成ODBC+JDBC的时候输掉的加上了还是这个错误。。
import java.sql.*;public class Jdbctest {
private static final String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
private static final String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=BBS_DB;user=sa;password=;";
protected Jdbctest()
{}
public static void main(String[] args) {
try{
Class.forName(driver);
}catch(Exception ce){
System.out.println(ce);
}
try{
Connection con=DriverManager.getConnection(url);
CallableStatement cs = con.prepareCall("exec BBS_UserReg ?,?,?,?,?,?,?,?,?,?,?");
cs.registerOutParameter(11,Types.INTEGER);
cs.setString(1,"lyz");
cs.setString(2,"123");
cs.setString(3,"TTT");
cs.setString(4,"男");
cs.setString(5,"1984-03-30");
cs.setInt(6,1);
cs.setString(7,"nimenhao");
cs.setString(8,"[email protected]");
cs.setString(9,"tTT");
cs.setString(10,"fadkfjakd");
cs.execute();
int i=cs.getInt(11);
System.out.println(i);
}catch(Exception ce)
{
ce.printStackTrace();
System.out.println(ce);
}
}
}
真厉害,果然升级到SP3就没事了