Get the table row value and Display into Text Field Elements in Java

0
80

This tutorial is all about get table row value and display in any text field element in Java. This tutorial will help you understand on how your program gets a value from Java Table row.

This program will use jr2xml.jar library to make this program runnable.
The table row value will displayed in an element that support string or text. This element are jTextField, jPasswordField, jList, jTextArea, and jFormattedField.

Get the table row value and Display into Text Field Elements in Java Steps

1. Create a new Form inside your project.

2. Design your Form just look like the image below.

3. Insert the following imports to access the required libraries to run this program.

  1. import com.mysql.jdbc.Connection;
  2. import java.sql.PreparedStatement;
  3. import java.sql.ResultSet;
  4. import java.sql.SQLException;
  5. import javax.swing.JOptionPane;
  6. import net.proteanit.sql.DbUtils;

 

4. Insert the following codes inside your auto generated public class to load the data from you MySQL Database to your Table.

  1. try{
  2.  
  3. String sql="SELECT * FROM userinfo";
  4.  
  5. pst=conn.prepareStatement(sql);
  6.  
  7. rs = pst.executeQuery(sql);
  8.  
  9. jTable1.setModel(DbUtils.resultSetToTableModel(rs));
  10.  
  11. }catch(SQLException e) {
  12.  
  13. JOptionPane.showMessageDialog(this, e.getMessage());
  14.  
  15. }

5. Generate the mouse event of your Table. You can choose Mouse Click, Mouse Pressed, and Mouse Released event. In my case, I choose Mouse Pressed.

6. Inside your new created mouse event, insert this codes for variables declaration.

  1. String fname;
  2. String lname;
  3. String address;

7. Insert the following codes after step 6. This codes is use for getting the value of your table row. The row index started with 1 for first name, 2 for last name, and 3 for address. Be sure to identify the correct index that you want to load into any text field elements. Remember that the index is always start in 0.

  1. fname = (jTable1.getModel().getValueAt(row, 1).toString());
  2. lname = (jTable1.getModel().getValueAt(row, 2).toString());
  3. address = (jTable1.getModel().getValueAt(row, 3).toString());

8. Insert the following codes after step 7. This code is used for displaying the row value from selected table row.

  1. jTextField1.setText(fname);
  2. jTextField2.setText(lname);
  3. jTextField3.setText(address);

9. Run your program and the output should look like the image below.

10. Below are the complete source codes.

  1. //variables declaration
  2. String fname;
  3. String lname;
  4. String address;
  5. int row=jTable1.getSelectedRow();
  6. //get the table row value
  7. fname = (jTable1.getModel().getValueAt(row, 1).toString());
  8. lname = (jTable1.getModel().getValueAt(row, 2).toString());
  9. address = (jTable1.getModel().getValueAt(row, 3).toString());
  10. //display the table row value
  11. jTextField1.setText(fname);
  12. jTextField2.setText(lname);
  13. jTextField3.setText(address);

Get Table Row Value and Display into Text Field Elements in Java

After completing this tutorial, you now understand on how to load a specific table row value into any text field element in java. This feature is very helpful to our program especially when your program populated with Table and Database.

If you have comments and suggestion about this topic, feel free to contact us.

Related Articles You May Like:

Facebook Comments
(Visited 86 times, 1 visits today)

LEAVE A REPLY

Please enter your comment!
Please enter your name here