Code used in video "Java prog#9. Get value from JTable and set it to jtextfield in Netbeans Java and Sqlite (mysql)"

HERE I AM PROVIDING THE downloadable CODE LINK OF  THE JAVA CODE I HAVE USED IN THE VIDEO  "Java prog#9. Get value from JTable and set it to jtextfield in Netbeans Java and Sqlite (mysql)"  OF MY YOUTUBE CHANNEL PROGRAMMINGKNOWLEDGE


Click Link to watch the video LINK


This code below is for the example of Table_EmployeeMouseClicked method action perform






  private void Table_EmployeeMouseClicked(java.awt.event.MouseEvent evt) {                                            
        
        int row =Table_Employee.getSelectedRow();
         String Table_click=(Table_Employee.getModel().getValueAt(row, 0).toString());
        
     
        try{
         
         String sql ="select * from Empoyeeinfo where empoyeeid='"+Table_click+"' ";
         pst=conn.prepareStatement(sql);
          rs=pst.executeQuery();
          if(rs.next()){
          
          String add1 =rs.getString("empoyeeid");
          txt_Empoyeeid.setText(add1);
          String add2 =rs.getString("name");
          txt_name.setText(add2);
          String add3 =rs.getString("surname");
          txt_surname.setText(add3);
          String add4 =rs.getString("age");
          combo_age.setSelectedItem(add4);
          
          
          int age= Integer.parseInt(add4);
    
          
          }
        
        }catch(Exception e){
        
        JOptionPane.showMessageDialog(null, e);
        }
        
        
        
    }                

Comments

Post a Comment