JDBC连接SQL Server 2000出错,但连接MySQL就没出错?是什么原因啊!
下面是错误信息如下:
D:\JAVA\ex>javac ConnectionFactory.javaD:\JAVA\ex>java ConnectionFactory
SqlServer database ...
SQL2000SServer for JDBC 有效,并且已经成功注册!
Connection can not be established.
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
null
MySQL database ...
SQL2000SServer for JDBC 有效,并且已经成功注册!
Connection is established.
com.mysql.jdbc.Connection@7d8483D:\JAVA\ex>
下面是错误信息如下:
D:\JAVA\ex>javac ConnectionFactory.javaD:\JAVA\ex>java ConnectionFactory
SqlServer database ...
SQL2000SServer for JDBC 有效,并且已经成功注册!
Connection can not be established.
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
null
MySQL database ...
SQL2000SServer for JDBC 有效,并且已经成功注册!
Connection is established.
com.mysql.jdbc.Connection@7d8483D:\JAVA\ex>
→ 1、一边上网,一边赚钱!
→ 2、及时了解最新信息;
→ 3、自由参加各种网络拍卖,赢得巨大乐趣;
→ 4、免费参与多个广告商随时开展的各种抽奖活动...
心动?立刻行动!点击这里,免费注册:http://www.ads4cn.com/newsbar/refferer.asp?elflovebobo
下面是原代码:import java.io.*;
import java.sql.*;
import java.util.Properties;public class ConnectionFactory
{ public static Connection Conn(){
Connection conn=null; String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://local:1433;DatabaseName=pubs";
String userName="sa";
String passWord=null;
System.out.println("SqlServer database ..."); conn=ConnectionFactory.getConn(driver,url,userName,passWord);
return conn;
}
public static Connection Conn1(){
Connection conn=null; String driver="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost/test";
String userName="root";
String passWord="";
System.out.println("MySQL database ..."); conn=ConnectionFactory.getConn(driver,url,
userName,passWord);
return conn;
}
public static Connection getConn (String driver,String url, String userName,String passWord){
Connection con=null;
try {
Class.forName(driver);
System.out.println("SQL2000SServer for JDBC 有效,并且已经成功注册!");
con=DriverManager.getConnection(url,userName,passWord);
System.out.println("Connection is established."); }
catch(ClassNotFoundException e){
System.out.println("Driver can not be found.");
}
catch (SQLException e){
System.out.println("Connection can not be established.");
System.out.println(e.getMessage()); }
return con;
}
public static void main(String[] args) throws Exception
{
Connection con = ConnectionFactory.Conn();
System.out.println(con); Connection con1 = ConnectionFactory.Conn1();
System.out.println(con1); }
}
jdbc:microsoft:sqlserver://local:1433;DatabaseName=pubs
这个里面的local可能是localhost,试试看另外passWord=null我不知道对不对,试试看passWord=""
passWord=null
没问题,我把local改为localhost就通过了。