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

 package op;

import java.awt.*;
import java.awt.event.*;
import java.util.*;
import javax.swing.*;
import tools.*;

public class ReturnAsset extends JPanel {
    private JScrollPane jScrollPane1 = new JScrollPane();
    private DBConnection dcon = null;
    private JTable table;
    private Mytable model;
    private String tempID = "";
    private HashMap chMap = new HashMap();
    JButton btnturn = new JButton();
    JComboBox choice = new JComboBox();
    String user;
    public ReturnAsset(String _user) {
        try {
            this.user = _user;
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    //init choice
    private void setChoice() {
        if (getChoiceList() != null || getChoiceList().length != 0) {
            btnturn.setEnabled(true);
            String[] s = getChoiceList();
            for (int i = 0; i < s.length; i++) {
                choice.addItem(s[i]);
            }
        } else {
            btnturn.setEnabled(false);
        }
        if(choice.getItemCount()==0)
        {
             btnturn.setEnabled(false);
        }
    }

    private void jbInit() throws Exception {
        setChoice();
        model = new Mytable(4);
        model.setTitle(getTitle());
        if (choice.getSelectedItem() != null) {
            model.setContent(getContents(choice.getSelectedItem().toString().
                                         trim()));
        } else {
            model.setContent(getContents(""));
        }
        table = new JTable(model);
        table.setRowSelectionAllowed(false);
        this.setLayout(null);
        jScrollPane1.setBounds(new Rectangle(11, 54, 475, 231));
        btnturn.setBounds(new Rectangle(296, 14, 84, 32));
        btnturn.setText("详细");
        choice.setBounds(new Rectangle(39, 11, 122, 32));
        this.add(jScrollPane1);
        this.add(btnturn);
        this.add(choice);
        jScrollPane1.getViewport().add(table);
        this.setSize(500, 400);
        //行选择编号改变
        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) {
            }
        });
        btnturn.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                if (tempID.trim().length() != 0) {

                    returnAsset();
                } else {
                    JOptionPane.showMessageDialog(table, "请选择要操作的记录");
                }
            }
        });

        choice.addItemListener(new ItemListener() {
            public void itemStateChanged(ItemEvent e) {
                model.setContent(getContents(choice.getSelectedItem().toString().
                                             trim()));
                table.updateUI();
            }
        });
    }

    private void returnAsset() {
        AssetReturn ar = new AssetReturn(choice.getSelectedItem().toString().
                                         trim(), tempID,
                                         getID(choice.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.setModal(true);
        ar.setVisible(true);
        model.setContent(getContents(choice.getSelectedItem().toString().
                                     trim()));
        table.updateUI();
        this.updateUI();
        tempID = "";
    }

    //获取choice列表
    private String[] getChoiceList() {
        dcon = new DBConnection();
        String sql = "select b.asset_user,a.employee_name from employee as a,(select asset_user from Asset group by  asset_user) as b where ( b.asset_user = a.employee_id)";
        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;
            chMap.put(name, id);
        }
        return s;
    }

    //getid
    private String getID(String name) {
        if (chMap.get(name) != null) {
            return chMap.get(name).toString().trim();
        } else {
            return "12221111111111111111112";
        }
    }

    //获取表格的列表
    private String[] getTitle() {
        dcon = new DBConnection();
        String sql = "select asset_id as 编号, asset_name as 名称,asset_type as 类型,asset_price as 单价,asset_buytime as 购买时间,asset_status as 状态,remark as 备注 from asset order by asset_id asc";
        return dcon.getColumnname(sql);
    }

//获取表格的内容
    private Vector getContents(String con1) {
        String con = getID(con1);
        dcon = new DBConnection();
        // String sql  = "select asset_id as 编号, asset_name as 名称,asset_type as 类型,asset_price as 单价,asset_buytime as 购买时间,asset_status as 状态,remark as 备注 from asset where(asset_user is null or len(asset_user)=0) order by asset_id asc";
        String sql = "select asset_id as 编号, asset_name as 名称,asset_type as 类型,asset_price as 单价,asset_buytime as 购买时间,asset_status as 状态,remark as 备注 from asset where((asset_user is not  null or len(Ltrim(rtrim(asset_user)))<>0  ) and (asset_user='" +
                     con + "')) order by asset_id asc";
        return dcon.select(sql);
    }
    public void fresh()
      {
          if(choice.getSelectedItem()!=null){
              model.setContent(getContents(choice.getSelectedItem().toString().
                                           trim()));
          }else
          {
              model.setContent(getContents(""));
          }
          table.updateUI();
   }

}