发布时间 : 星期一 文章JAVAswing界面实现数据库增删改查（精）更新完毕开始阅读8ff20a29178884868762caaedd3383c4ba4cb46d
JButton btnFind = new JButton(\查找\
btnFind.addActionListener(new ActionListener( { public void actionPerformed(ActionEvent e { find(; } } ;
btnFind.setBounds(380, 59, 77, 21; getContentPane(.add(btnFind;
model = new DefaultTableModel(columns, 0; table = new JTable(model;
table.addMouseListener(new MouseAdapter( {
public void mouseClicked(MouseEvent e {
int row = table.getSelectedRow(;
department_idField.setText((String table.getValueAt(row, 0; department_nameField.setText((String table.getValueAt(row, 2; manager_idField.setText((String table.getValueAt(row, 3; location_idField.setText((String table.getValueAt(row, 4; tmp = getInput(; } };
JScrollPane scrollPane = new JScrollPane(table; scrollPane.setBounds(12, 100, 571, 248;
getContentPane(.add(scrollPane;
setDefaultCloseOperation(EXIT_ON_CLOSE; setLocationRelativeTo(null; setLocation(350,200; setSize(601, 380; setResizable(false; setVisible(true; }
private Student getInput( { Student stu = new Student(;
stu.department_id= department_idField.getText(; stu.department_name = department_nameField.getText(; stu.manager_id = manager_idField.getText(; stu.location_id = location_idField.getText(; return stu; }
private void add( { data.add(getInput(; showTable(; }
private void del( {
for (int i = 0; i < data.size(; i++ {
if (tmp.equals(data.get(i {
data.remove(i;break; } }
showTable(; }
private void update( { Student stu = getInput(; for (int i = 0; i < data.size(; i++ {
if (tmp.equals(data.get(i { data.remove(i; data.add(i, stu; break; } }
showTable(; }
private void find( { removeRows(; Student stu = getInput(; for (int i = 0; i < data.size(; i++ { Student tmp = (Student data.get(i; if (tmp.equals(stu {
model.addRow(tmp.toArray(; break;
} } }
private void showTable( { removeRows(;
for (int i = 0; i < data.size(; i++ {
Student stu = (Student data.get(i; model.addRow(stu.toArray(; } }
private void removeRows( { while (model.getRowCount( > 0 { model.removeRow(0; } }
public static void main(String[] args { new AppStudent(; } }
class Student
implements Serializable { public String department_id; public String department_name; public String manager_id;