import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryRecord {
private Connection conn=null;
private Statement st=null;
private ResultSet rs=null;
public QueryRecord(){
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
}catch(ClassNotFoundException e){
e.printStackTrace();
}
}
public void showRecord(){
try{
String url="jdbc:sqlserver://localhost:1433;databaseName=db_test";
String username="";
String password="dingshaohua";
conn=DriverManager.getConnection(url,username,password);
st=conn.createStatement();
String sql="select * from tb_employee";
rs=st.executeQuery(sql);
while(rs.next()){
System.out.print(rs.getInt(1)+"\t");
System.out.print(rs.getString(2)+"\t");
System.out.print(rs.getString(3)+"\t");
System.out.print(rs.getInt(4)+"\t");
System.out.print(rs.getString(5)+"\t");
System.out.print(rs.getString(6)+"\t");
System.out.println(rs.getString(7)+"\t");
}
}catch(SQLException e){
e.printStackTrace();
}finally{
try{
rs.close();
st.close();
conn.close();
}catch(SQLException e){
e.printStackTrace();
}
}
}
public static void main(String[] args){
QueryRecord query=new QueryRecord();
query.showRecord();
}
}
报这个错误:
com.microsoft.sqlserver.jdbc.SQLServerException: 到主机 的 TCP/IP 连接失败。 java.net.ConnectException: Connection refused: connect
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at QueryRecord.showRecord(QueryRecord.java:22)
at QueryRecord.main(QueryRecord.java:49)
Exception in thread "main" java.lang.NullPointerException
at QueryRecord.showRecord(QueryRecord.java:39)
at QueryRecord.main(QueryRecord.java:49)
什么原因?
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryRecord {
private Connection conn=null;
private Statement st=null;
private ResultSet rs=null;
public QueryRecord(){
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
}catch(ClassNotFoundException e){
e.printStackTrace();
}
}
public void showRecord(){
try{
String url="jdbc:sqlserver://localhost:1433;databaseName=db_test";
String username="";
String password="dingshaohua";
conn=DriverManager.getConnection(url,username,password);
st=conn.createStatement();
String sql="select * from tb_employee";
rs=st.executeQuery(sql);
while(rs.next()){
System.out.print(rs.getInt(1)+"\t");
System.out.print(rs.getString(2)+"\t");
System.out.print(rs.getString(3)+"\t");
System.out.print(rs.getInt(4)+"\t");
System.out.print(rs.getString(5)+"\t");
System.out.print(rs.getString(6)+"\t");
System.out.println(rs.getString(7)+"\t");
}
}catch(SQLException e){
e.printStackTrace();
}finally{
try{
rs.close();
st.close();
conn.close();
}catch(SQLException e){
e.printStackTrace();
}
}
}
public static void main(String[] args){
QueryRecord query=new QueryRecord();
query.showRecord();
}
}
报这个错误:
com.microsoft.sqlserver.jdbc.SQLServerException: 到主机 的 TCP/IP 连接失败。 java.net.ConnectException: Connection refused: connect
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at QueryRecord.showRecord(QueryRecord.java:22)
at QueryRecord.main(QueryRecord.java:49)
Exception in thread "main" java.lang.NullPointerException
at QueryRecord.showRecord(QueryRecord.java:39)
at QueryRecord.main(QueryRecord.java:49)
什么原因?
楼主。 右键我的电脑-管理-服务和应用程序。。 这有个一TCP/IP sql服务 默认是禁用的。 你把它启用就可以了。 这个问题可能是你刚装的sql2005 希望可以帮到你。。
但是我知道你访问数据库至少要一个用户名吧!你的代码里的用户名一直没有赋值。你就连你的数据库,它如果让你连了。那个server2005数据库,就跨了。什么都可以去连他。
还要一点,注意你的server2005数据库开启了没?
就这么多。
String username="";
不好意思,没看到url写了
String url="jdbc:sqlserver://localhost:1433";
String username="db_test";
试试
1)是否允许Windwos和SQL身份验证同时开启。这个在manager studio右键服务器,安全性里面可以设置
2)如果是sa账户,默认是禁止登陆的。要启用以上两个在manager studio中就可以试出来。如果已经OK了,再考虑6L的
并 重启sqlserver
windows2000在服务里面开启你的数据库还有楼上的databaseName不是用户名,是数据库名
原先的url是对的
那个我已经启用了可是还是报这个错误:
com.microsoft.sqlserver.jdbc.SQLServerException: 到主机 的 TCP/IP 连接失败。 java.net.ConnectException: Connection refused: connect
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at QueryRecord.showRecord(QueryRecord.java:22)
at QueryRecord.main(QueryRecord.java:49)
Exception in thread "main" java.lang.NullPointerException
at QueryRecord.showRecord(QueryRecord.java:39)
at QueryRecord.main(QueryRecord.java:49)