JDBC+ Interface graphique

Question

Salut tout le monde,
J'ai un serieux problème, qui m'a bloqué ça fait 10 jours déjà...Je tiens à ce que vous sachiez que j'ai essayé mais finalement je me suis décidé de vous poser la question.
Le projet consiste à établir tout simplement (à extraire et à manipuler)la connexion avec Oracle(10g)  avec Java(JVM 1.6) via Eclipse.Voici le code que j'ai mis en place(je me suis inspiré d'un code que j'ai trouvé ici!):
public class LoginJFrame extends javax.swing.JFrame {
   public LoginJFrame() {
     initComponents(); 
  }

/**à ne pas modifier* */
private void initComponents() {//GEN-BEGIN:initComponents
    CONNECT = new javax.swing.JButton();
    CANCEL = new javax.swing.JButton();
    user = new javax.swing.JComboBox();
    password = new javax.swing.JTextArea();
    driver = new javax.swing.JTextArea();
    url = new javax.swing.JTextArea();
    jLabelUser = new javax.swing.JLabel();
    jLabelPassword = new javax.swing.JLabel();
    jLabelDriver = new javax.swing.JLabel();
    jLabelDBUrl = new javax.swing.JLabel();
    jLabelWelcome = new javax.swing.JLabel();
    getContentPane().setLayout(null);
    setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
    setTitle("LOGIN");
    setCursor(new java.awt.Cursor(java.awt.Cursor.HAND_CURSOR));
    CONNECT.setFont(new java.awt.Font("Verdana", 1, 14));
    CONNECT.setText("CONNECT");
    CONNECT.setDoubleBuffered(true);
    CONNECT.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            CONNECTActionPerformed(evt);
        }
    });

    getContentPane().add(CONNECT);
    CONNECT.setBounds(200, 230, 120, 27);

    CANCEL.setFont(new java.awt.Font("Verdana", 1, 14));
    CANCEL.setText("CANCEL");
    CANCEL.setDoubleBuffered(true);
    CANCEL.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            CANCELActionPerformed(evt);
        }
    });

    getContentPane().add(CANCEL);
    CANCEL.setBounds(350, 230, 120, 27);

    user.setFont(new java.awt.Font("Verdana", 1, 14));
    user.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "hr", "Anouar", "Ali"}));
    user.setBorder(new javax.swing.border.LineBorder(new java.awt.Color(0, 0, 0), 1, true));
    user.setDoubleBuffered(true);
    getContentPane().add(user);
    user.setBounds(180, 60, 440, 30);
    
    password.setEditable(true);
    password.setFont(new java.awt.Font("Verdana", 1, 14));
    password.setText("");
    password.setBorder(new javax.swing.border.LineBorder(new java.awt.Color(0, 0, 0), 1, true));
    password.setDoubleBuffered(true);
    getContentPane().add(password);
    password.setBounds(180, 100, 440, 30);

    driver.setEditable(false);
    driver.setFont(new java.awt.Font("Verdana", 1, 14));
    driver.setText("oracle.jdbc.driver.OracleDriver");
    driver.setBorder(new javax.swing.border.LineBorder(new java.awt.Color(0, 0, 0), 1, true));
    driver.setDoubleBuffered(true);
    getContentPane().add(driver);
    driver.setBounds(180, 140, 440, 30);

    url.setEditable(false);
    url.setFont(new java.awt.Font("Verdana", 1, 14));
    url.setText("jdbc:oracle:thin:@//localhost:8080:HR");
    url.setBorder(new javax.swing.border.LineBorder(new java.awt.Color(0, 0, 0), 1, true));
    url.setDoubleBuffered(true);
    getContentPane().add(url);
    url.setBounds(180, 180, 440, 30);

    jLabelUser.setFont(new java.awt.Font("Verdana", 1, 14));
    jLabelUser.setText("USER :");
    jLabelUser.setDoubleBuffered(true);
    getContentPane().add(jLabelUser);
    jLabelUser.setBounds(40, 60, 130, 18);

    jLabelPassword.setFont(new java.awt.Font("Verdana", 1, 14));
    jLabelPassword.setText("PASSWORD :");
    jLabelPassword.setDoubleBuffered(true);
    getContentPane().add(jLabelPassword);
    jLabelPassword.setBounds(40, 100, 130, 18);

    jLabelDriver.setFont(new java.awt.Font("Verdana", 1, 14));
    jLabelDriver.setText("DRIVER :");
    jLabelDriver.setDoubleBuffered(true);
    getContentPane().add(jLabelDriver);
    jLabelDriver.setBounds(40, 140, 130, 18);

    jLabelDBUrl.setFont(new java.awt.Font("Verdana", 1, 14));
    jLabelDBUrl.setText("DATABASE URL :");
    jLabelDBUrl.setDoubleBuffered(true);
    getContentPane().add(jLabelDBUrl);
    jLabelDBUrl.setBounds(40, 180, 140, 18);

    jLabelWelcome.setFont(new java.awt.Font("Verdana", 1, 14));
    jLabelWelcome.setText("WELCOME");
    jLabelWelcome.setDoubleBuffered(true);
    getContentPane().add(jLabelWelcome);
    jLabelWelcome.setBounds(40, 20, 580, 18);

    java.awt.Dimension screenSize = java.awt.Toolkit.getDefaultToolkit().getScreenSize();
    setBounds((screenSize.width-680)/2, (screenSize.height-337)/2, 680, 337);
}//GEN-END:initComponents

private void CANCELActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_CANCELActionPerformed
    // TODO add your handling code here:
    this.dispose();
}//GEN-LAST:event_CANCELActionPerformed

   private void CONNECTActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_CONNECTActionPerformed
    // TODO add your handling code here:
     boolean result = true;
     try {
        if (user.getSelectedItem().equals("hr"))
           ConnectionHandler.isConnectionPossible(driver.getText().trim(),
              url.getText().trim(), (String) user.getSelectedItem(), "hr");
        else if (user.getSelectedItem().equals("Ali"))
           ConnectionHandler.isConnectionPossible(driver.getText().trim(),
              url.getText().trim(), (String) user.getSelectedItem(), "Ali");
        else if (user.getSelectedItem().equals("Anouar"))
           ConnectionHandler.isConnectionPossible(driver.getText().trim(),
              url.getText().trim(), (String) user.getSelectedItem(), "Anouar");
 
     }
         catch (Exception ex) {
           result = false;
           System.out.println(ex.getMessage());
           javax.swing.JOptionPane.showMessageDialog(this,ex.getMessage(),"ATTENTION",
              javax.swing.JOptionPane.WARNING_MESSAGE);
        }
     System.out.println(result);
     if (result == true)
         this.dispose();
             System.out.println("Still in LoginJFrame");
  }//GEN-LAST:event_CONNECTActionPerformed

   private void jComboBox1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jComboBox1ActionPerformed
    // TODO add your handling code here:
  }//GEN-LAST:event_jComboBox1ActionPerformed

  // Variables declaration - do not modify//GEN-BEGIN:variables
private javax.swing.JButton CANCEL;
private javax.swing.JButton CONNECT;
private javax.swing.JTextArea driver;
private javax.swing.JLabel jLabelDBUrl;
private javax.swing.JLabel jLabelDriver;
private javax.swing.JLabel jLabelPassword;
private javax.swing.JLabel jLabelUser;
private javax.swing.JLabel jLabelWelcome;
private javax.swing.JTextArea password;
private javax.swing.JTextArea url;
private javax.swing.JComboBox user;
// End of variables declaration//GEN-END:variables
  private java.sql.Connection con;
  private boolean connectionStatus;
  public static void main (String [] args) {
         new LoginJFrame().setVisible(true);               
      }
  
}

JJohnny · Answer

après execution il m'affiche soit qu'il ne trouve pas la Base, soit qu'il y a un problème E/S...
Je pense que c'est mon URL qui ne cole pas...quelqu'un peut il m'éclairer?
la classe ConnectionHandler ici est de la forme:
package dBJava;

public class ConnectionHandler {
    
    /** Creates a new instance of ConnectionHandler */
    public ConnectionHandler() {
    }
    
    public static boolean isConnectionPossible(String driver, String url, String user, String password) throws Exception {
        boolean result = true;
        Class.forName(driver);
        java.sql.Connection conx = java.sql.DriverManager.getConnection(url, user, password);
        return result;
        
    }
    
}

JDBC+ Interface graphique

1 réponse

Votre réponse

Discussions similaires