designing embeded java database

Please am trying to retrieve data from the database from one form to another form

first I pull the data from the database into a jframe form.

next one of the data is placed into a jTextField which when I click a jbutton2 it suppose to perform the code below which also pull data from the database and placed the data in another jframe form call relative. But I when I click the jbutton2 I get this error "java.lang.UnsupportedOperationException: Not supported yet."

private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
       relative focus = new relative();
        focus.setVisible(rootPaneCheckingEnabled);

         //new relative().setVisible(true);

        try {
        String strr = jTextField11.getText();
            Class.forName("org.apache.derby.jdbc.ClientDriver");

            conn = DriverManager.getConnection("jdbc:derby://localhost:1527/EmployeeDB","administrator","weert");
            PreparedStatement stt = conn.prepareStatement("select* from administrator.personofcontact where id = ?");
            stt.setString(1, jTextField11.getText());
            ree = stt.executeQuery();
             if(ree.next()){
                  String r1 = ree.getString(2);
                  String r2 = ree.getString(3);
                  String r3 = ree.getString(4);
                  String r4 = ree.getString(5);
                  String r5 = ree.getString(6);
                  String r6 = ree.getString(7);
                  String r7 = ree.getString(8);
                  String r8 = ree.getString(9);
                  String r9 = ree.getString(10);
                  //String r10 = re.getString(11);

             relative.setText(jTextField10,r1);
             relative.setText(jTextField6,r2);
              relative.setText(jTextField2,r3);
             relative.setText(jTextField7,r4);
              relative.setText(jTextField3,r5);
             relative.setText(jTextField8,r6);
              relative.setText(jTextField4,r7);
             relative.setText(jTextField9,r8);
              relative.setText(jTextField5,r9);
             //relative.setText(jTextField6,r2);
             }else{
                 JOptionPane.showMessageDialog(null, "Name not Found");
             }

            } catch (Exception ex) {
            //Logger.getLogger(searchDB.class.getName()).log(Level.SEVERE, null, ex);
                System.out.println(ex);
               // System.out.println(session.getClass().getName());
        }
    }

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mohammed Adamu11y ago
ok thanks
Afzaal Ahmad Zeeshan11y ago
I would like to suggest that you set a breakpoint at the initial line of this function (that handles the jButton2 click event) and then manage to see through the line that throws the exception.

We cannot check up your code, because we do not have required assemblies and libraries that are required to run the project. But you have. You can run the application in debug context and check for a solution.

I suggest that you debug and share the line number that throws this exception. Once you have found which lines throw the exception, even Google would be able to help you out. :)
Mohammed Adamu11y ago
Please am trying to retrieve data from the database from one form to another form
first I pull the data from the database into a jframe form.
next one of the data is placed into a jTextField which when I click a jbutton2 it suppose to perform the code below which also pull data from the database and placed the data in another jframe form call relative. But I when I click the jbutton2 I get this error   "java.lang.UnsupportedOperationException: Not supported yet."

private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
       relative focus = new relative();
        focus.setVisible(rootPaneCheckingEnabled);
         //new relative().setVisible(true);

        try {
        String strr = jTextField11.getText();
            Class.forName("org.apache.derby.jdbc.ClientDriver");

            conn = DriverManager.getConnection("jdbc:derby://localhost:1527/EmployeeDB","administrator","weert");
            PreparedStatement stt = conn.prepareStatement("select* from administrator.personofcontact where id = ?");
            stt.setString(1, jTextField11.getText());
            ree = stt.executeQuery();
             if(ree.next()){
                  String r1 = ree.getString(2);
                  String r2 = ree.getString(3);
                  String r3 = ree.getString(4);
                  String r4 = ree.getString(5);
                  String r5 = ree.getString(6);
                  String r6 = ree.getString(7);
                  String r7 = ree.getString(8);
                  String r8 = ree.getString(9);
                  String r9 = ree.getString(10);
                  //String r10 = re.getString(11);

             relative.setText(jTextField10,r1);
             relative.setText(jTextField6,r2);
              relative.setText(jTextField2,r3);
             relative.setText(jTextField7,r4);
              relative.setText(jTextField3,r5);
             relative.setText(jTextField8,r6);
              relative.setText(jTextField4,r7);
             relative.setText(jTextField9,r8);
              relative.setText(jTextField5,r9);
             //relative.setText(jTextField6,r2);
             }else{
                 JOptionPane.showMessageDialog(null, "Name not Found");
             }

            } catch (Exception ex) {
            //Logger.getLogger(searchDB.class.getName()).log(Level.SEVERE, null, ex);
                System.out.println(ex);
               // System.out.println(session.getClass().getName());
        }
    }
Afzaal Ahmad Zeeshan11y ago
This means that the operation is invalid; your system doesn't support it. I cannot give you a solution because I don't know your system specifications. You can try to check Java documentations. I can tip you that the problem is somewhere with you JDBC. Check the drivers for database.