Wednesday, March 22, 2017
Delete with CheckBox Java swing gui Xóa dữ liệu bảng bằng ChẹckBox trong Java Swing
Delete with CheckBox Java swing gui Xóa dữ liệu bảng bằng ChẹckBox trong Java Swing
by: http://www.thaicreate.com/java/java-gui-workshop-delete-multiple-rows-checkbox.html
Delete with CheckBox Java swing
Java 2016
package com.java.myapp;
import java.awt.EventQueue;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JTable;
import javax.swing.JScrollPane;
import javax.swing.table.DefaultTableModel;
import javax.swing.JLabel;
import javax.swing.JButton;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
public class MyForm extends JFrame {
static JTable table;
/**
* Launch the application.
*/
public static void main(String[] args) {
EventQueue.invokeLater(new Runnable() {
public void run() {
MyForm frame = new MyForm();
frame.setVisible(true);
}
});
}
/**
* Create the frame.
*/
public MyForm() {
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setBounds(100, 100, 516, 319);
setTitle("ThaiCreate.Com Java GUI Tutorial");
getContentPane().setLayout(null);
// Customer List
JLabel lblCustomerList = new JLabel("Customer List");
lblCustomerList.setBounds(207, 44, 87, 14);
getContentPane().add(lblCustomerList);
// ScrollPane
JScrollPane scrollPane = new JScrollPane();
scrollPane.setBounds(28, 84, 440, 89);
getContentPane().add(scrollPane);
// Table
table = new JTable();
scrollPane.setViewportView(table);
// Button Delete
JButton btnDelete = new JButton("Delete");
btnDelete.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
Object[] options = { "Yes", "No" };
int n = JOptionPane
.showOptionDialog(null, "Do you want to Delete data?",
"Confirm to Delete?",
JOptionPane.YES_NO_CANCEL_OPTION,
JOptionPane.QUESTION_MESSAGE, null, options,
options[1]);
if (n == 0) // Confirm Delete = Yes
{
for (int i = 0; i < table.getRowCount(); i++) {
Boolean chkDel = Boolean.valueOf(table.getValueAt(i, 0).toString()); // Checked
if(chkDel) // Checked to Delete
{
String strCustomerID = table.getValueAt(i, 1)
.toString(); // get CustomerID
DeleteData(strCustomerID); // Delete Data
}
}
JOptionPane.showMessageDialog(null, "Delete Data Successfully");
PopulateData(); // Reload Table
}
}
});
btnDelete.setBounds(205, 202, 89, 23);
getContentPane().add(btnDelete);
PopulateData();
}
private void PopulateData() {
// Clear table
table.setModel(new DefaultTableModel());
// Model for Table
DefaultTableModel model = new DefaultTableModel() {
public Class<?> getColumnClass(int column) {
switch (column) {
case 0:
return Boolean.class;
case 1:
return String.class;
case 2:
return String.class;
case 3:
return String.class;
case 4:
return String.class;
case 5:
return String.class;
case 6:
return String.class;
default:
return String.class;
}
}
};
table.setModel(model);
// Add Column
model.addColumn("Select");
model.addColumn("CustomerID");
model.addColumn("Name");
model.addColumn("Email");
model.addColumn("CountryCode");
model.addColumn("Budget");
model.addColumn("Used");
Connection connect = null;
Statement s = null;
try {
Class.forName("com.mysql.jdbc.Driver");
connect = DriverManager
.getConnection("jdbc:mysql://localhost/mydatabase"
+ "?user=root&password=root");
s = connect.createStatement();
String sql = "SELECT * FROM customer ORDER BY CustomerID ASC";
ResultSet rec = s.executeQuery(sql);
int row = 0;
while ((rec != null) && (rec.next())) {
model.addRow(new Object[0]);
model.setValueAt(false, row, 0); // Checkbox
model.setValueAt(rec.getString("CustomerID"), row, 1);
model.setValueAt(rec.getString("Name"), row, 2);
model.setValueAt(rec.getString("Email"), row, 3);
model.setValueAt(rec.getString("CountryCode"), row, 4);
model.setValueAt(rec.getFloat("Budget"), row, 5);
model.setValueAt(rec.getFloat("Used"), row, 6);
row++;
}
} catch (Exception e) {
e.printStackTrace();
}
}
// Delete
private void DeleteData(String strCustomerID) {
Connection connect = null;
Statement s = null;
try {
Class.forName("com.mysql.jdbc.Driver");
connect = DriverManager
.getConnection("jdbc:mysql://localhost/mydatabase"
+ "?user=root&password=root");
s = connect.createStatement();
String sql = "DELETE FROM customer WHERE " + "CustomerID = "
+ strCustomerID + " ";
s.execute(sql);
} catch (Exception e) {
e.printStackTrace();
}
}
}
Go to link Download
