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