痛苦的一天 完全没有连接上 数据库 望高手解答 谢谢了
package myclass;
import java.sql.*;
public class Jdbc{
public Connection getConnection()
{
String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=stuDB";
Connection con=null;
Statement st;
ResultSet rs;
try {
Class.forName(driver);
con=DriverManager.getConnection(url,"sa","");
}
catch(
ClassNotFoundException ex){
System.out.println("DriverError");
ex.printStackTrace();
}
catch(
SQLException ex){
System.out.println( "Connection error");
ex.printStackTrace();
}
return con ;
}
}
-----
package myclass;
import java.sql.*;
public class Jdbctest{
Jdbc con=new Jdbc();
void dispaly(){
try{
Connection cn = con.getConnection();
String sql="Select * from SC";
Statement s = cn.createStatement();
ResultSet rs = s.executeQuery(sql);
while(rs.next()){
System.out.print(rs.getString(1));
System.out.print(rs.getString(2));
System.out.print(rs.getString(3));
}
}
catch(SQLException ce){
System.out.print(ce);
}
}
public static void main(String [] args){
Jdbctest jt = new Jdbctest();
jt.dispaly();
}
}
------
报错
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)
Connection error 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 myclass.Jdbc.getConnection(Jdbc.java:15)
at myclass.Jdbctest.dispaly(Jdbctest.java:10)
at myclass.Jdbctest.main(Jdbctest.java:30)
Exception in thread "main"
java.lang.NullPointerException at myclass.Jdbctest.dispaly(Jdbctest.java:12)
at myclass.Jdbctest.main(Jdbctest.java:30)
----
我是在 eclipse 下写的代码 3个驱动也装在了D:\apache-tomcat-5.5.23\common\lib下 但是就是连接不上去 找了一天了 没找到 我用的是SQL2000 我基本上都是用最新的补丁了
请问大家 这个问题是出在那里啊 谢谢了
------解决方案--------------------我也遇到同样的错误,关注中,希望高手来解答!
------解决方案--------------------装了三个驱动,还要打sp3或sp4补丁~
关于读取PDF的有关问题~大神