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

package quary;

import tools.Mytable;
import tools.DBConnection;
import java.util.*;
import java.awt.event.*;
import javax.swing.*;
import java.awt.*;
import op.*;

public class employee extends JPanel {
    private JButton btn_mx = new JButton();
    private JScrollPane jScrollPane1 = new JScrollPane();
    private DBConnection dcon = null;
    private JTable table;
    private Mytable model;
    private String tempID = "";
    HashMap hashmap = new HashMap();
    private String user = "";
    JTabbedPane jTabbedPane1 = new JTabbedPane();
    JComboBox cbmkind;
    JButton btn_return = new JButton();
    public employee() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        model = new Mytable(4);
        model.setTitle(getTitle());
        if (getKindsList() != null) {
            cbmkind = new JComboBox(getKindsList());
            if (cbmkind.getSelectedItem() != null) {
                model.setContent(getContents(cbmkind.getSelectedItem().toString().
                                             trim()));
            } else {
                model.setContent(getContents(""));
            }

        }

        table = new JTable(model);
        table.setRowSelectionAllowed(false);
        this.setLayout(null);
        btn_mx.setBounds(new Rectangle(229, 22, 92, 32));
        btn_mx.setToolTipText("");
        btn_mx.setText("详细情况");

        jScrollPane1.setBounds(new Rectangle(15, 71, 477, 223));
        jTabbedPane1.setBounds(new Rectangle( -44, 86, 5, 5));
        cbmkind.setBounds(new Rectangle(42, 21, 148, 33));
        btn_return.setBounds(new Rectangle(359, 22, 90, 31));
        btn_return.setText("返回");
        this.add(jScrollPane1);
        this.add(jTabbedPane1);
        this.add(cbmkind);
        this.add(btn_mx);
        this.add(btn_return);
        this.setSize(500, 400);
        jScrollPane1.getViewport().add(table);
        //行选择编号改变
        table.addMouseListener(new MouseListener() {
            public void mouseClicked(MouseEvent e) {
                if (table.getSelectedRow() != -1 &&
                    table.getSelectedColumn() != -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_mx.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                if(tempID.trim().length()!=0)
                {
                    mxCard();
                }else
                {
                    JOptionPane.showMessageDialog(jScrollPane1,"请选择要操作的编号");
                }
            }
        });
        btn_return.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                returnQuary();
            }
        });
        cbmkind.addItemListener(new ItemListener() {
            public void itemStateChanged(ItemEvent e) {

                    choice();

            }
        });
    }
    //mxCard
    private void mxCard()
    {
        AssetReturn ar = new AssetReturn(cbmkind.getSelectedItem().toString().
                                        trim(), tempID,
                                        getID(cbmkind.getSelectedItem().
                                              toString().
                                              trim()));
       Dimension frmsize = getSize();
       Point loc = getLocation();
       ar.setLocation((frmsize.width - ar.WIDTH) / 2 + loc.x,
                      (frmsize.height - ar.HEIGHT) / 2 + loc.y);
       ar.setSize(350, 450);
       ar.hiden();
       ar.setModal(true);
       ar.setVisible(true);

    }
    //changed
    private void choice() {
        model.setContent(getContents(cbmkind.getSelectedItem().toString().
                                     trim()));
        table.updateUI();
        this.updateUI();
    }

    private String[] getKindsList() {
        dcon = new DBConnection();
        String sql = "select a.Asset_user,b.employee_name from asset as a, employee as b where(a.Asset_user = b.employee_id) group by a.Asset_user,b.employee_name";
        Vector v = dcon.select(sql);
        int count = v.size();
        String[] s = new String[count];
        for (int i = 0; i < count; i++) {
            String id = ((Vector) v.get(i)).get(0).toString().trim();
            String name = ((Vector) v.get(i)).get(1).toString().trim();
            s[i] = name;
            hashmap.put(name,id);
        }
        return s;
    }
    //getid
    private String getID(String name)
    {
       return hashmap.get(name).toString().trim();
    }

    //return Quarry
    private void returnQuary() {
        this.removeAll();
        quary q = new quary();
        this.add(q);
        this.updateUI();
    }

    //获取表格的列表
    private String[] getTitle() {

        dcon = new DBConnection();
        String sql = "select a.asset_id as 编号, a.asset_name as 名称,a.asset_type as 类型,a.asset_price as 单价,a.asset_buytime as 购买时间,a.asset_status as 状态,b.employee_name as 用户,a.remark as 备注,a.childkind_id as 科目 from asset as a left join  employee as b on a.asset_user = b.employee_id  order by a.asset_id asc ";
        return dcon.getColumnname(sql);
    }

//获取表格的内容
    private Vector getContents(String name) {
        dcon = new DBConnection();
        String sql = "select a.asset_id as 编号, a.asset_name as 名称,a.asset_type as 类型,a.asset_price as 单价,a.asset_buytime as 购买时间,a.asset_status as 状态,b.employee_name as 用户,a.remark as 备注,a.childkind_id as 科目 from asset as a left join  employee as b on a.asset_user = b.employee_id where b.employee_name = '"+name+"'  order by a.asset_id asc ";
        return dcon.select(sql);
    }

}