sql2008 初学者 用JAVA连接不上
/*
* 日期:2011年11月2日
* 作用:jdbc与数据库的连接(不需要配置数据源)
* 作者:张鹏飞
* 注意:使用jdbc必须引入3个jar包
* */
import java.sql.*;
public class first {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
PreparedStatement ps=null;
Connection ct=null;
ResultSet rs=null;
try {
//加载驱动
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//得到连接
ct=DriverManager.getConnection
("jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=平时练习","wanglijunn","290079626");
ps=ct.prepareStatement("select *from 产品信息");
rs=ps.executeQuery();//修改 删除信息用:executeUpdate 查询信息用:executeQuery()
while(rs.next()){
int a=rs.getInt(1);
int b=rs.getInt(4);
System.out.println(a+" "+b);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
提示:
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 first.main(first.java:24)
弄了一晚上了 高人求救!!