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

package op;

/**
 * <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 javax.swing.*;
import tools.*;

public class MarkAsset 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();
    String user;
    JButton btnDraw = new JButton();
    JTextField choice = new JTextField();
    public MarkAsset(String _user) {
        try {
            this.user = _user;
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        model = new Mytable(4);
        model.setTitle(getTitle());
        model.setContent(getContents());
        table = new JTable(model);
        table.setRowSelectionAllowed(false);
        this.setLayout(null);
        jScrollPane1.setBounds(new Rectangle(11, 54, 475, 231));
        btnDraw.setBounds(new Rectangle(296, 14, 84, 32));
        btnDraw.setText("标记");
        choice.setBounds(new Rectangle(39, 11, 122, 32));
        choice.setEditable(false);
        this.add(jScrollPane1);
        this.add(btnDraw);
        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();
                    choice.setText(tempID);

                } else {
                    tempID = "";
                }
            }

            public void mousePressed(MouseEvent e) {
            }

            public void mouseReleased(MouseEvent e) {
            }

            public void mouseEntered(MouseEvent e) {
            }

            public void mouseExited(MouseEvent e) {
            }
        });
        btnDraw.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                if (tempID.trim().length() != 0) {
                    MarkDialog md = new MarkDialog(tempID.trim());
                    Dimension frmsize = getSize();
                    Point loc = getLocation();
                    md.setLocation((frmsize.width - md.WIDTH) / 2 + loc.x,
                                   (frmsize.height - md.HEIGHT) / 2 + loc.y);
                    md.setSize(200, 200);
                    md.setModal(true);
                    md.setVisible(true);
                    tempID = "";

                    tempID = "";
                    model.setContent(getContents());
                    table.updateUI();
                    choice.setText(tempID);
                } else {
                    JOptionPane.showMessageDialog(table, "请选择要操作的记录");
                }
            }
        });
    }

//获取choice列表
    private String[] getChoiceList() {
        dcon = new DBConnection();
        String sql = "select b.childkind_id,a.childKind_name from childkind as a,(select childkind_id from Asset group by childkind_id) as b where ( b.childkind_id = a.childkind_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) {
        return chMap.get(name).toString().trim();
    }

//获取表格的列表
    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 where((asset_user is null or len(asset_user)=0) ) order by asset_id asc";
        return dcon.getColumnname(sql);
    }

//获取表格的内容
    private Vector getContents() {
        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 null or len(asset_user)=0) ) order by asset_id asc";
        return dcon.select(sql);
    }

    public void fresh() {

        model.setContent(getContents());

        table.updateUI();
    }

}