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

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();    }

}