Search value in table using MySQL search query Java Tutorial

0
23

Search value in table using MySQL search query Java Tutorial

Search value in table using MySQL search query Java Tutorial

This tutorial is all about Search value in table using MySQL search query Java Tutorial. In this tutorial you will learn how to search a value from database that’s populated in table java component using MySQL search query. This tutorial uses one text field and one table component. Please follow all the steps below to complete this tutorial.

Search value in table using MySQL search query Java Tutorial steps

 

Create your project by clicking file at the top left of your project and then click new project, you can name your project whatever you want. After creating the project, right click on the Source Packages and the select New Frame Form, and the default form will be created. And then drag 1 text field component and 1 table component in your form. After that, you need to right click your text field and select Events – Key – key Released and the key released event will be created, copy paste the code below

  1. try {
  2.  
  3. String sq = "SELECT  product_name as 'Product Name',company_name as 'Company Name',product_category as 'Product Category',quantity as 'Quantity',price_per_unit as 'Price Per Unit' FROM products WHERE product_name LIKE '%"+ searchTxt.getText() +"%'";
  4.  
  5. pst = conn.prepareStatement(sql);
  6.  
  7. rs = pst.executeQuery();
  8.  
  9. medicineTable.setModel(DbUtils.resultSetToTableModel(rs));
  10.  
  11. }catch(Exception e){
  12.  
  13. JOptionPane.showMessageDialog(null, e.getMessage());
  14.  
  15. }

Note: In the query string we use LIKE wildcard. To fetch the value that you want to search.

Then you’re done. Run your project and see if it works.

 

For questions or any other concerns or thesis/capstone creation with documentation, you can contact me through the following:

E-Mail: ryansalem221996@gmail.com

Facebook: facebook.com/RyyanSalem

Contact No.: +639098911050

Ryan A. Salem

BSIT Graduate, soon to be MIT.

System Analyst / System Developer

Related topic(s) that you make like:

1.) Common String Methods in Java Tutorial using Netbeans IDE
2.) Delete Confirmation Dialog in Java Tutorial using Netbeans IDE

Facebook Comments
(Visited 25 times, 1 visits today)

LEAVE A REPLY

Please enter your comment!
Please enter your name here