Here I am providing the downloadable code link of the java code I have used in the video
"Java prog#21.Advanced search a particular data inSQLite (MySql) Database in Netbeans java jtable" of my YouTube channel ProgrammingKnowledge
Click Link to watch the video LINK
This code below is for the txt_searchKeyReleased method action perform
private void txt_searchKeyReleased(java.awt.event.KeyEvent evt) {
try{
String sql ="select * from Empoyeeinfo where name =?" ;
pst =conn.prepareStatement(sql);
pst.setString(1, txt_search.getText());
rs=pst.executeQuery();
//pst.execute();
Table_Employee.setModel(DbUtils.resultSetToTableModel(rs));
String sql3 ="select * from Empoyeeinfo where name =?" ;
pst=conn.prepareStatement(sql3);
pst.setString(1, txt_search.getText());
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);
}
String sql2 ="select * from Empoyeeinfo where empoyeeid =?" ;
pst=conn.prepareStatement(sql2);
pst.setString(1, txt_search.getText());
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);
}
String sql1 ="select * from Empoyeeinfo where surname =?" ;
pst=conn.prepareStatement(sql1);
pst.setString(1, txt_search.getText());
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);
}
}
catch(Exception e)
{
JOptionPane.showMessageDialog(null, e);
}
}
