JAVAswing界面实现数据库增删改查（精）

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;