s1(java)项目实战（固定资产管理）（set_ Asset_kinds_set_father ）

 package set;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
import java.awt.*;
import java.awt.event.*;
import java.util.*;
import tools.*;
import javax.swing.*;
import javax.swing.event.*;
import javax.swing.table.*;

public class Asset_kinds_set_father extends JPanel {
    private JButton Asset_manager_set_modi = new JButton("修改");
    private JButton Asset_manager_set_add = new JButton("增加");
    private JButton Asset_manager_set_del = new JButton("删除");
    private TableModel tmd;
    private String user;
    private HashMap fathermap = new HashMap();
    private HashMap fathermaptemp = new HashMap();
    private DBConnection dcon = null;
    private JButton btn_return = new JButton();
    private JScrollPane table_pan = new JScrollPane();
    private Mytable model;
    private JTable table;
    private String tempID = "";
    public Asset_kinds_set_father(String _user) {
        try {
            this.user = _user;
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.setSize(new Dimension(500, 350));
        this.setLayout(null);
        Asset_manager_set_modi.setBounds(new Rectangle(171, 37, 65, 32));
        Asset_manager_set_add.setBounds(new Rectangle(57, 35, 70, 31));
        Asset_manager_set_del.setBounds(new Rectangle(264, 36, 64, 32));
        btn_return.setBounds(new Rectangle(369, 37, 62, 31));
        btn_return.setToolTipText("");
        btn_return.setText("返回");
        table_pan.setBounds(new Rectangle(6, 84, 491, 265));
        this.add(table_pan);
        this.add(btn_return);
        this.add(Asset_manager_set_add);
        this.add(Asset_manager_set_modi);
        this.add(Asset_manager_set_del);
        model = new Mytable(1);
        model.setTitle(getTitle());
        model.setContent(getContents());
        table = new JTable(model);
        table.setRowSelectionAllowed(false);
        table_pan.getViewport().add(table);
        table.setRowSelectionAllowed(false);
        tmd = table.getModel();
        table.setFont(new Font("宋体", 1, 17));
        initfathermaptemp();
        tempID = "";

        //表格行选择的变更
        table.addMouseListener(new MouseListener() {
            public void mouseClicked(MouseEvent e) {
                if (table.getSelectedColumn() != -1 &&
                    table.getSelectedRow() != -1) {
                    tempID = table.getValueAt(table.getSelectedRow(), 0).
                             toString();
                } else {
                    tempID = "";
                }
            }

            public void mousePressed(MouseEvent e) {
            }

            public void mouseReleased(MouseEvent e) {
            }

            public void mouseEntered(MouseEvent e) {
            }

            public void mouseExited(MouseEvent e) {
            }
        });
        btn_return.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                closeAsset_kinds_set();
            }
        });
        //表格的变动
        tmd.addTableModelListener(new TableModelListener() {
            public void tableChanged(TableModelEvent e) {
                String table_id = table.getValueAt(table.getSelectedRow(), 0).
                                  toString().trim();
                String table_name = table.getValueAt(table.getSelectedRow(), 1).
                                    toString().trim();
                String temp_name = returnTemp(table_id).trim();
                if (!temp_name.equals(table_name)) {
                    if (fathermap.containsKey(table_id)) {
                        Set set = fathermap.entrySet();
                        Iterator it = set.iterator();
                        while (it.hasNext()) {
                            Map.Entry me = (Map.Entry) it.next();
                            if (me.getKey().toString().trim().equals(
                                    table_id)) {
                                me.setValue(table_name);
                                break;
                            }
                        }
                    } else {
                        fathermap.put(table_id, table_name);
                    }
                    modifathertempMap(table_id, table_name);
                }
            }
        });
        Asset_manager_set_modi.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                if (fathermap.size() != 0) {
                    dcon = new DBConnection();
                    Set set = fathermap.entrySet();
                    Iterator it = set.iterator();
                    while (it.hasNext()) {
                        Map.Entry me = (Map.Entry) it.next();
                        String id = me.getKey().toString().trim();
                        String name = me.getValue().toString().trim();
                        String sql =
                                "update FatherKind set fatherkind_name = '" +
                                name + "' where fatherkind_id='" + id + "'";
                        dcon.update(1, sql);
                    }
                    JOptionPane.showMessageDialog(table_pan,
                                                  "修改了" + fathermap.size() +
                                                  "条记录");
                    fathermap.clear();
                    fathermaptemp.clear();
                    initfathermaptemp();
                }
            }
        });
        Asset_manager_set_del.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                if (tempID.trim().length() == 0) {
                    JOptionPane.showMessageDialog(table_pan, "还没有选择要操作的记录");
                } else {
                    dcon = new DBConnection();
                    String sql =
                            "select * from ChildKind where fatherkind_id='" +
                            tempID.trim() + "'";
                    if (dcon.isNull(sql)) {
                        JOptionPane.showMessageDialog(table_pan,
                                "下级科目有该类型的记录,不能删除");
                    } else {
                        sql =
                                "delete from FatherKind where fatherkind_id='" +
                                tempID.trim() + "'";
                        dcon.update(1, sql);
                        JOptionPane.showMessageDialog(table_pan,
                                "ID是" + tempID + "被删除");
                        model.setContent(getContents());
                        table.updateUI();
                        fathermap.clear();
                        fathermaptemp.clear();
                        initfathermaptemp();

                    }
                }
                tempID = "";
            }
        });
        Asset_manager_set_add.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                add();
            }
        });
    }

//增加
    private void add() {
        fatherkindadd fkm = new fatherkindadd();
        Dimension frmsize = getSize();
        Point loc = getLocation();
        fkm.setLocation((frmsize.width - fkm.WIDTH) / 2 + loc.x,
                        (frmsize.height - fkm.HEIGHT) / 2 + loc.y);
        fkm.setSize(250, 250);
        fkm.setModal(true);
        fkm.setVisible(true);
        model.setContent(getContents());
        table.updateUI();
        this.updateUI();
        fathermap.clear();
        fathermaptemp.clear();
        initfathermaptemp();

    }

//初始化一级科目的临时表
    private void initfathermaptemp() {
        dcon = new DBConnection();
        String sql =
                "select fatherkind_id as 科目编号 ,fatherkind_name as 科目名称 from FatherKind";
        Vector v = dcon.select(sql);
        for (int i = 0; i < v.size(); i++) {
            String id = ((Vector) v.get(i)).get(0).toString();
            String name = ((Vector) v.get(i)).get(1).toString();
            fathermaptemp.put(id, name);
        }
    }

//修改临时的一级科目的临时表
    private void modifathertempMap(String id, String m) {
        Set set = fathermaptemp.entrySet();
        Iterator it = set.iterator();
        while (it.hasNext()) {
            Map.Entry me = (Map.Entry) it.next();
            if (me.getKey().toString().equals(id)) {
                me.setValue(m);
                break;
            }
        }
    }

//返回修改的
    private String returnTemp(String id) {
        Set set = fathermaptemp.entrySet();
        Iterator it = set.iterator();
        String s = "";
        while (it.hasNext()) {
            Map.Entry me = (Map.Entry) it.next();
            if (me.getKey().toString().equals(id)) {
                s = me.getValue().toString();
                break;
            }
        }
        return s;
    }

//获取表格的列表
    private String[] getTitle() {
        dcon = new DBConnection();
        String sql =
                "select fatherkind_id as 科目编号 ,fatherkind_name as 科目名称 from FatherKind";
        return dcon.getColumnname(sql);
    }

//获取表格的内容
    private Vector getContents() {
        dcon = new DBConnection();
        String sql =
                "select fatherkind_id as 科目编号 ,fatherkind_name as 科目名称 from FatherKind";
        return dcon.select(sql);
    }

//关闭Asset_manager_set
    private void closeAsset_kinds_set() {
        this.removeAll();
        Asset_OP asp = new Asset_OP(user);
        this.add(asp);
        this.updateUI();
    }
}