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
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);
}
}
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);
}
}