Mohammed Adamu

Mohammed Adamu

  • NA
  • 107
  • 48.3k

Database application in java

Jul 20 2015 1:25 PM

Please Good people I have been able to create a database and application so now I can used the app interface to populate data into the database and also retrieve them into the jframe but am unable to retrieve the image from the database when I do a search. pls help.

below is the code I used to retrieve the data from the database.

try {
            String str = jTextField1.getText();
            Class.forName("org.apache.derby.jdbc.ClientDriver");
           
            con = DriverManager.getConnection("jdbc:derby://localhost:1527/EmployeeDB","administrator","weert");
            PreparedStatement st = con.prepareStatement("select* from administrator.employees where employeeid = ?");
            st.setString(1, jTextField1.getText());
            re = st.executeQuery();
             if(re.next()){
                  //String s = re.getString(1);
                  String s1 = re.getString(2);
                  String s2 = re.getString(3);
                  String s3 = re.getString(4);
                  String s4 = re.getString(5);
                  String s5 = re.getString(6);
                  String s6 = re.getString(7);
                  String s7 = re.getString(8);
                  String s8 = re.getString(9);
                  String s9 = re.getString(10);
                  String s10 = re.getString(11);
                  String s11 = re.getString(12);
                  String s12 = re.getString(13);
                  String s13 = re.getString(14);
                 
                 jLabel2.setText("First Name:");
                 jLabel3.setText(s1);
                 jLabel4.setText("Last Name:");
                 jLabel5.setText(s2);
                 jLabel6.setText("SSNIT No.");
                 jLabel7.setText(s3);
                 jLabel8.setText("Phone Number:");
                 jLabel9.setText(s4);
                 jLabel10.setText("Date of Employment:");
                 jLabel11.setText(s5);
                 jLabel12.setText("Salary:");
                 jLabel13.setText(s6);
                 jLabel14.setText("Gender:");
                 jLabel15.setText(s7);
                 jLabel16.setText("Birth Date:");
                 jLabel17.setText(s8);
                 jLabel18.setText("Department:");
                 jLabel19.setText(s9);
                 jLabel20.setText("Email Address:");
                 jLabel21.setText(s10);
                 jLabel22.setText("Address:");
                 jLabel23.setText(s11);
                 jLabel24.setText("Residence:");
                 jLabel25.setText(s12);              
                 jLabel27.setText("Person to Contact");
                 jTextField11.setText(s13);
             
               
             }else{
                 JOptionPane.showMessageDialog(null, "Name not Found");
             }
              
            } catch (Exception ex) {
                System.out.println(ex);
        }