数据库连接，困扰我三天了，高手救命啊！
SQL server的sp3和sp4补丁都装了，驱动的三个jar包也拷到jre/lib/ext下了，环境变量也改了，可就是通不过，什么原因啊？
import java.sql.*;
import java.awt.*;
public class SQLConnClass
{
public static void main(String[] args)
{
try
{
System.out.println( "aa ");
Connection Conn;
Class.forName( "net.sourceforge.jtds.jdbc.Driver ");
System.out.println( "bb ");
Conn = DriverManager.getConnection( "jdbc:jtds:sqlserver://localhost:1433/Test ", "sa ", "sa ");
System.out.println( "数据库驱动程序注册成功 ");
}
catch(Exception e)
{
System.out.println( "Error Message: ");
e.printStackTrace();
System.out.println( "数据库连接失败 ");
}
}
}
aa
bb
Error Message:java.sql.SQLException: Network error IOException: Connection refused: connect
at net.sourceforge.jtds.jdbc.ConnectionJDBC2. <init> (ConnectionJDBC2.java:372)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3. <init> (ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at SQLConnClass.main(SQLConnClass.java:16)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:289)
at net.sourceforge.jtds.jdbc.SharedSocket. <init> (SharedSocket.java:250)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2. <init> (ConnectionJDBC2.java:297)
... 5 more
数据库连接失败
[解决办法]
Error Message:java.sql.SQLException: Network error IOException: Connection refused: connect
你先看看你1433端口好没的 netstat -na
[解决办法]
net.sourceforge.jtds.jdbc.Driver 这个连接串没用过
一般都是用
public class conManager {
public conManager() {
}
public Connection GetCon() {
Connection con = null;
try {
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver ");
String url =
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=news ";
con = DriverManager.getConnection(url, "sa ", " ");
} catch (Exception ex) {
ex.printStackTrace();
return null;
}
return con;
}
public void CloseCon(Connection con1)
{
try {
con1.close();
} catch (Exception ex) {
ex.printStackTrace();
}
}
}
[解决办法]
你用的是applet来实现的，必须修改本地的安全策略，打开你要访问的本地的数据库使用的端口才可以，具体的修改方法，可以到google上搜一下
[解决办法]
用这个Driver試試 com.microsoft.jdbc.sqlserver.SQLServerDriver
[解决办法]
你是用Tomcat服务器吗？我以前也遇到过种情况，到最后竟然重装操作系统才行了。有时得全部重装一遍新的，qq:290695839，有问题请联系。
[解决办法]
我建議使用數據源，那樣比較好.
出錯率比較低