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

public String getmanager_id( { return manager_id; }

public void setmanager_id(String manager_id { this.manager_id= manager_id; }

public String getlocation_id( { return location_id; }

public void setlocation_id(String location_idn { this.location_id = location_id; } } } 3实现方法

package tuxinghua; import java.awt.Color;

import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.io.Serializable; import java.sql.DriverManager; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List; import javax.swing.JButton; import javax.swing.JFrame;

import javax.swing.JLabel; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.JTextField;

import javax.swing.table.DefaultTableModel; import java.awt.event.MouseAdapter; import java.awt.event.MouseEvent; public class AppStudent extends JFrame{ private JTextField department_idField; private JTextField department_nameField; private JTextField manager_idField; private JTextField location_idField; private JTable table;

private DefaultTableModel model;

private String[] columns = { \\private List data; private Student tmp; public AppStudent( { data = new ArrayList(; getContentPane(.setLayout(null;

JLabel lblemployee = new JLabel(\lblemployee.setBounds(12, 10, 220, 13; getContentPane(.add(lblemployee; department_idField = new JTextField(; department_idField.setBounds(100, 7, 96, 19;

getContentPane(.add(department_idField; department_idField.setColumns(10;

JLabel lblAge = new JLabel(\lblAge.setBounds(252, 10, 220, 13; getContentPane(.add(lblAge;

department_nameField = new JTextField(; department_nameField.setBounds(365, 7, 96, 19; getContentPane(.add(department_nameField; department_nameField.setColumns(10; JLabel lblStuno = new JLabel(\lblStuno.setBounds(12, 36, 220, 13; getContentPane(.add(lblStuno; manager_idField = new JTextField(; manager_idField.setColumns(10;

manager_idField.setBounds(100, 33, 96, 19; getContentPane(.add(manager_idField; JLabel lblClass = new JLabel(\lblClass.setBounds(252, 36, 220, 13; getContentPane(.add(lblClass; location_idField = new JTextField(; location_idField.setColumns(10;

location_idField.setBounds(365, 33, 96, 19; getContentPane(.add(location_idField; JButton btnAdd = new JButton(\增加\

btnAdd.addActionListener(new ActionListener( {

public void actionPerformed(ActionEvent e { add(; } } ;

btnAdd.setBounds(75, 59, 77, 21; getContentPane(.add(btnAdd; JButton btnDel = new JButton(\删除\

btnDel.addActionListener(new ActionListener( { public void actionPerformed(ActionEvent e { del(; } } ;

btnDel.setBounds(180, 59, 77, 21; getContentPane(.add(btnDel;

JButton btnUpdate = new JButton(\更新\

btnUpdate.addActionListener(new ActionListener( { public void actionPerformed(ActionEvent e { update(; } } ;

btnUpdate.setBounds(280, 59, 77, 21; getContentPane(.add(btnUpdate;