我正在创建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);
    }
}

Project Sctructure

请帮帮我,这是我的错误消息

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)