我正在创建loginsystem以使用java fx登录到oracle db . 我在这里遇到了两个问题,1 . 我无法连接到DB 2.我不确定我是否将ojdbc jar放到正确的位置 .
所以我的代码是Util / ConnectionDB.java
package Util;
import java.sql.*;
/**
* Created by engineering09 on 12/3/2015.
*/
public class ConnectionDB {
private static final String DB_USER = "WELTESMIN";
private static final String DB_PASS = "123pass";
private static final String DB_NAME = "WEN";
public boolean openConnection(){
boolean result;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = null;
conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:"+DB_NAME+"",DB_USER,DB_PASS);
if (conn != null){
System.out.println("CONNECTION DONE");
}
result = true;
} catch (Exception e) {
e.printStackTrace();
result = false;
}
return result;
}
}
和主要的,
package Controller;
import Util.ConnectionDB;
import javafx.application.Application;
import javafx.fxml.FXMLLoader;
import javafx.scene.Parent;
import javafx.scene.Scene;
import javafx.stage.Stage;
public class Main extends Application {
@Override
public void start(Stage primaryStage) throws Exception{
Parent root = FXMLLoader.load(getClass().getResource("../View/login.fxml"));
primaryStage.setTitle("Weltes Oxygen Management");
primaryStage.setScene(new Scene(root));
primaryStage.show();
testConnection();
}
public void testConnection(){
ConnectionDB connect = new ConnectionDB();
connect.openConnection();
}
public static void main(String[] args) {
launch(args);
}
}
请帮帮我,这是我的错误消息
java.sql.SQLRecoverableException:IO错误:网络适配器无法在oracle.jdbc.driver.PhysicalConnection的oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)上 Build 连接 . (PhysicalConnection.java:553 )oracle.jdbc.driver.T4CConnection . (T4CConnection.java:254)at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528) )java.sql.DriverManager.getConnection(DriverManager.java:664)at java.sql.DriverManager.getConnection(DriverManager.java:247)位于Controller.Main.testConnection的Util.ConnectionDB.openConnection(ConnectionDB.java:30) (Main.java:23)位于com.sun.javafx.application的com.sun.javafx.application.LauncherImpl.lambda $ launchApplication1 $ 163(LauncherImpl.java:863)的Controller.Main.start(Main.java:18) .platformImpl.lambda $ runAndWait $ 176(PlatformImpl.java:326)at com.sun.javafx.application.PlatformImpl.lambda $ null $ 174(PlatformImpl.java:295)at java.secur位于com.sun.javafx.application.PlatformImpl.lambda的ity.AccessController.doPrivileged(Native Method)$ comLun $ 175(PlatformImpl.java:294)com.sun.glass.ui.InvokeLaterDispatcher $ Future.run(InvokeLaterDispatcher.java: 95)at com.sun.glass.ui.win.WinApplication._runLoop(Native Method)at com.sun.glass.ui.win.WinApplication.lambda $ null $ 149(WinApplication.java:191)at java.lang.Thread .run(Thread.java:745)引起:oracle.net.ns.NetException:网络适配器无法在oracle.net的oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:439) Build 连接 . 在oracle.net.nsdb上的oracle.net.ns.n.RSPR.L. .driver.T4CConnection.connect(T4CConnection.java:1140)at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:340)... 18更多引起:java.net.ConnectException:连接被拒绝:连接java .net.DualStackP位于java.net.AbstractPlainSocketImpl.mplConnect(AbstractPlainSocketImpl.java:350)的java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)中的lainSocketImpl.waitForConnect(Native Method),位于java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java: 206)在Java.net.SocksSocketImpl.connect(PlainSocketImpl.java:172)的java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) . oracle.net上的oracle.net.nt.ConnOption.connect(ConnOption.java:133)的oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:149)上的net.Socket.connect(Socket.java:589) .nt.ConnStrategy.execute(ConnStrategy.java:405)