Friday, September 5, 2014

JTable > how to display the database to automatically based on time








Dear All,








I have made a program to display data from a database using netbeans. In the netbeans I created a JFrame Form. Here's a snippet of code that I created:








===============












Java Code:











public class Back extends javax.swing.JFrame {

public Back() {
initComponents();

loadDataPrefix();

}

....................

public void loadDataPrefix(){
DefaultTableModel dtmPrefix = new DefaultTableModel();
dtmPrefix.addColumn("Id");
dtmPrefix.addColumn("Operator");
dtmPrefix.addColumn("Prefix");
try {
String queryPrefix = "SELECT * FROM prefix ORDER BY prefix_name";
statementPrefix = connection.createStatement();
resultSetPrefix = statementPrefix.executeQuery(queryPrefix);
int size = 0;
while(resultSetPrefix.next()){
size++;
dtmPrefix.addRow(new Object[]{
size,
resultSetPrefix.getString(3),
resultSetPrefix.getString(2)
});
jTable4.setModel(dtmPrefix);
}
} catch (SQLException preEr) {
JOptionPane.showMessageDialog(null, preEr,"Peringatan !",JOptionPane.WARNING_MESSAGE);
}
}
......................
}









===============



I created a button to update the database in JTable display as follows:







===============












Java Code:











private void jButton8ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
loadDataPrefix();
}









===============







Everything went as desired.



What I need is to make a checkbox, which when select the checkbox in JTable will display data based on the data that is in my mySQL database automatically.








For example, when I enter data or edit data to MySQL (via DOS or phpmyadmin or other applications) then changes to a JTable data is displayed automatically.








And when chexkBox not select it to display the database changes have to click a button.








Kindly enlighten and sample code completion. Thank you ....















No comments:

Post a Comment