Mar 14, 2021 8:54:54 AM ketnoisqlsever.KetNoiSQL <init>
SEVERE: null
java.sql.SQLException: Network error IOException: Connection refused: connect
at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:436)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:251)
at ketnoisqlsever.KetNoiSQL.<init>(KetNoiSQL.java:48)
at ketnoisqlsever.KetNoiSQL.main(KetNoiSQL.java:84)
Caused by: java.net.ConnectException: Connection refused: connect
at java.base/sun.nio.ch.Net.connect0(Native Method)
at java.base/sun.nio.ch.Net.connect(Net.java:574)
at java.base/sun.nio.ch.Net.connect(Net.java:563)
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:588)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:333)
at java.base/java.net.Socket.connect(Socket.java:648)
at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:288)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:251)
at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:331)
... 5 more
Mar 14, 2021 8:54:54 AM ketnoisqlsever.KetNoiSQL main
SEVERE: null
java.lang.NullPointerException: Cannot invoke "java.sql.Connection.createStatement()" because "this.con" is null
at ketnoisqlsever.KetNoiSQL.GetResultSet(KetNoiSQL.java:66)
at ketnoisqlsever.KetNoiSQL.main(KetNoiSQL.java:88)
BUILD SUCCESSFUL (total time: 2 seconds)
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package ketnoisqlsever;
/**
*
* @author ASUS
*/
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;
/**
*
* @author DOTNETGROUP
*/
public class KetNoiSQL {
private Connection con = null;
public KetNoiSQL() {
String url = "net.sourceforge.jtds.jdbc.Driver";
try {
Class.forName(url);
String dbUrl = "jdbc:jtds:sqlserver://DESKTOP-TEFAAAK:1433/ketnoisql";
con = DriverManager.getConnection(dbUrl);
} catch (ClassNotFoundException ex) {
Logger.getLogger(KetNoiSQL.class.getName()).log(Level.SEVERE, null, ex);
} catch (SQLException ex) {
Logger.getLogger(KetNoiSQL.class.getName()).log(Level.SEVERE, null, ex);
}
}
public ResultSet GetResultSet(String tableName) throws SQLException {
ResultSet rs = null;
Statement stmt = con.createStatement();
String sql = "select * from " + tableName;
rs = stmt.executeQuery(sql);
return rs;
}
public void Close() throws Exception {
con.close();
}
public static void main(String[] args) {
KetNoiSQL kn = new KetNoiSQL();
try {
ResultSet rs= kn.GetResultSet("Account");//Table Name
while(rs.next())
{
System.out.println(rs.getString("accName"));//Field Name
}
kn.Close();
} catch (SQLException ex) {
Logger.getLogger(KetNoiSQL.class.getName()).log(Level.SEVERE, null, ex);
} catch (Exception ex) {
Logger.getLogger(KetNoiSQL.class.getName()).log(Level.SEVERE, null, ex);
}
}
}
mọi người người giúp em lỗi này với :((
83% thành viên diễn đàn không hỏi bài tập, còn bạn thì sao?