How To Populate JTable Depending On JCombobox Selected Value In Java NetBeans

In this java Tutorial we will see How To Fill data Into JTable from Mysql database
Depending On A JCombobox Selected Value In Java NetBeans .

Project Source Code:

// Step 1 Create A Class Named "Product"

package javaapp;

public class Product {

private String id;
private String name;
private int qte;
private String price;
private int catId;

public Product(){}

public Product(String Id, String Name, int Qte, String Price, int CatId){

this.id = Id;
this.name = Name;
this.qte = Qte;
this.price = Price;
this.catId = CatId;
}

public String getID(){
return id;
}

public void setID(String ID){
this.id = ID;
}

public String getName(){
return name;
}

public void setName(String Name){
this.name = Name;
}

public int getQte(){
return qte;
}

public void setQte(int Qte){
this.qte = Qte;
}

public String getPrice(){
return price;
}

public void setPrice(String Price){
this.price = Price;
}

public int getCatID(){
return catId;
}

public void setCatID(int CatID){
this.catId = CatID;
}

}

// Step 2 Create A Class Named "MyQuery"

package javaapp;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.logging.Level;

import java.util.logging.Logger;

/**

* @author 1bestcsharp.blogspot.com

public class MyQuery {

public Connection getConnection(){

Connection con = null;

try {

con = DriverManager.getConnection("jdbc:mysql://localhost/project", "root","");

} catch (SQLException ex) {

Logger.getLogger(Query.class.getName()).log(Level.SEVERE, null, ex);

}

return con;

}

public ArrayList<Product> getData(int catID){

ArrayList<Product> list = new ArrayList<Product>();

Connection con = getConnection();

Statement st;

ResultSet rs;

try {

st = con.createStatement();

rs = st.executeQuery("SELECT `ID_PRO`, `PRO_NAME`, `QTE_IN_STOCK`, `PRICE`, `ID_CAT` FROM `products` WHERE `ID_CAT` = "+ catID);

Product p;

while(rs.next()){

p = new Product(

rs.getString("ID_PRO"),

rs.getString("PRO_NAME"),

rs.getInt("QTE_IN_STOCK"),

rs.getString("PRICE"),

rs.getInt("ID_CAT")

);

list.add(p);

}

} catch (SQLException ex) {

Logger.getLogger(MyQuery.class.getName()).log(Level.SEVERE, null, ex);

}

return list;

}

// Step 3 Create A JFrame Named "JComboAndJTable"

package javaapp;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.table.DefaultTableModel;

public class JComboAndJTable extends javax.swing.JFrame {

public JComboAndJTable() {
initComponents();
BindCombo();
}

// create a methode to set data to a jcombobox from mysql database
public void BindCombo(){
MyQuery mq = new MyQuery();
Connection con = mq.getConnection();
Statement st;
ResultSet rs;

try {
st = con.createStatement();
rs = st.executeQuery("SELECT `CAT_ID`, `CAT_NAME` FROM `categories`");
while(rs.next()){
jComboBox1.addItem(rs.getInt(1));
}
} catch (SQLException ex) {
Logger.getLogger(JComboTutorial.class.getName()).log(Level.SEVERE, null, ex);
}

}


@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {

jComboBox1 = new javax.swing.JComboBox();
jScrollPane1 = new javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

jComboBox1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jComboBox1ActionPerformed(evt);
}
});

jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null, null, null},
{null, null, null, null},
{null, null, null, null},
{null, null, null, null}
},
new String [] {
"Title 1", "Title 2", "Title 3", "Title 4"
}
));
jScrollPane1.setViewportView(jTable1);

javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 528, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createSequentialGroup()
.addGap(194, 194, 194)
.addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, 153, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(35, 35, 35)
.addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, 37, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 342, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);

pack();
}// </editor-fold>

private void jComboBox1ActionPerformed(java.awt.event.ActionEvent evt) {

MyQuery mq = new MyQuery();
ArrayList<Product> list = mq.getData((int)jComboBox1.getSelectedItem());
DefaultTableModel model = new DefaultTableModel();
model.setColumnIdentifiers(new Object[]{"Id","Name","Qte","Price","Categorie"});
Object[] row = new Object[5];
for(int i = 0; i < list.size(); i++){
row[0] = list.get(i).getID();
row[1] = list.get(i).getName();
row[2] = list.get(i).getID();
row[3] = list.get(i).getName();
row[4] = list.get(i).getName();
model.addRow(row);
}
jTable1.setModel(model);
}

public static void main(String args[]) {

try {
for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
if ("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}
} catch (ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(JComboAndJTable.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(JComboAndJTable.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(JComboAndJTable.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(JComboAndJTable.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}

java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new JComboAndJTable().setVisible(true);
}
});
}

// Variables declaration - do not modify
private javax.swing.JComboBox jComboBox1;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTable jTable1;
// End of variables declaration
}

///////////////OUTPUT:

Bind JTable Depending On JCombobox Value

Populate JTable Depending On JCombobox Selected Value

More JAVA

➜ Java Courses

➜ Java Projects

C#, JAVA,PHP, Programming ,Source Code

Java And MySQL - Populate JTable Depending On JCombobox Selected Value

How To Populate JTable Depending On JCombobox Selected Value In Java NetBeans

Author : 1bestCsharp Blog

Share this

C#, JAVA,PHP, Programming ,Source Code

Java And MySQL - Populate JTable Depending On JCombobox Selected Value

How To Populate JTable Depending On JCombobox Selected Value In Java NetBeans

Author : 1bestCsharp Blog

Share this

Related Posts