Sabtu, 20 Juni 2015

Java And MySQL - Populate JTable Depending On JCombobox Selected Value

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 .

*Java Courses : Java Complete Course

Java Swing Course

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
}