4학년인데 프밍실력이 없어서ㅜㅜ
저희가 연결시키고싶은건
jdbc:oracle:thin:@:1521:XE
아이디 scott
비번 tiger
인데 어디를 고쳐야할지 모르겠어요 도와주세요..

public String ConnectToDB() {
  String retval = "";
  String url, pass;
  try {
   try {
    Class.forName("org.postgresql.Driver");// get psql driver class
   } catch (ClassNotFoundException y) {
    lbStatus.setText(String.format("Class loading error: %s",
      y. toString()));
   }

   if (!jEnabled.isSelected())// ssh tunneling disabled
   {
    url = "jdbc:postgresql://" + lbServer.getText();
   
    pass = String.copyValueOf(lbPass.getPassword());
   } else// use ssh tunneling
   {
    if (retval != "")
     retval += "\\n";
    // attempt to portforward 5432 from ssh connection to the
    // localhost
    retval += PortForward();
    url = "jdbc:postgresql://localhost";
   
    pass = String.copyValueOf(lbPass.getPassword());
   }

   // connect to the psql database
   con = DriverManager.getConnection(url, lbUser.getText(), pass);

   if (retval != "")
    retval += "\\n";
   retval += "Connection Successful!";
   Connected = true; // set the connection state to true if all goes
        // well
   return retval;

  } catch (java.lang.Exception ex) {
   if (retval != "")
    retval += "\\n";
   retval += String.format("Connection Failed!: %s ", ex. toString());
   return retval;
  }
 }

 /**
  * Executes a sql query on the connected psql database
  *
  * @param Query
  *            a String representing the sql query to execute on the
  *            database.
  * @return A ResultSet object containing the results of executing the Query
  *         String on the psql database. It will return null if the
  *         dbConnection is not connected to a psql database or there is an
  *         error.
  */
 public ResultSet ExecuteQuery(String Query) {
  if (!Connected)
   return null;
  else {
   try {
    Statement stmt = con.createStatement();
    return stmt.executeQuery(Query);
   } catch (SQLException ex) {
    JOptionPane.showMessageDialog(null, ex.getMessage());
    return null;
   }
  }
 }

 /**
  * Attempts to connect to the ssh tunnel and forward the port 5432 (psql
  * server) from the secure connection to the localhost.
  *
  * @return error/status String
  */
 private String PortForward() {
  try {
   JSch jsch = new JSch();

   session = jsch.getSession(sshUser.getText(), sshHost.getText(), 22);

   int lport = 5432;
   String rhost = lbServer.getText();
   int rport = lport;

   // username and password will be given via UserInfo interface.
   UserInfo ui = new MyUserInfo();
   session.setUserInfo(ui);

   session.connect();

   session.setPortForwardingL(lport, rhost, rport);

   return "Port Forwarding Successful";
  } catch (Exception e) {
   return (String.format("SSH Tunneling error: %s", e. toString()));
  }
 }

 /**
  * An implementation of the UserInfo interface specified in the jsch library
  * used to implement ssh tunneling. The user info is taken from the form
  * itself so this is more or less just a stub of an implementation of the
  * interface.
  */
 public class MyUserInfo implements UserInfo {
  /**
   * Gets the password for the ssh tunnel connection
   *
   * @return A String representing the password for the ssh tunnel. It is
   *         taken from the dbConnection form sshPass password box.
   */
  public String getPassword() {
   return String.copyValueOf(sshPass.getPassword());
  }

  /**
   * supposed to get the passPhrase for the ssh tunnel
   *
   * @return returns null as this method is not really used in my program,
   *         but is necessary to complete implement the UserInfo interface
   *         from the jsch library
   */
  public String getPassphrase() {
   return null;
  }

  /**
   * prompts for password entry for ssh tunnel
   *
   * @param message
   *            password prompt String
   * @return true
   */
  public boolean promptPassword(String message) {
   return true;
  }

  /**
   * prompt with a yes/no response
   *
   * @param message
   *            String message to be displayed in the yes/no prompt
   * @return true
   */
  public boolean promptYesNo(String message) {
   return true;
  }

  /**
   * prompts for passphrase for ssh tunnel
   *
   * @param message
   *            message to be displayed in prompt
   * @return true
   */
  public boolean promptPassphrase(String message) {
   return true;
  }

  /**
   * supposed to diplay a message
   *
   * @param message
   *            message to display
   */
  public void showMessage(String message) {
   return;
  }
 }