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

package op;

import java.awt.*;

import javax.swing.*;import tools.DBConnection;import java.util.*;import java.awt.Rectangle;import java.awt.event.ActionListener;import java.awt.event.ActionEvent;

public class AssetReturn extends JDialog {    private String user;    private String userID;    private String assetid;    JLabel JBL_card = new JLabel();    private DBConnection dcon = null;    private HashMap perMap = new HashMap();    JLabel jLabel1 = new JLabel();    JTextField txtid = new JTextField();    JLabel jLabel2 = new JLabel();    JTextField txtname = new JTextField();    JLabel jLabel3 = new JLabel();    JLabel jLabel4 = new JLabel();    JTextField txttype = new JTextField();    JTextField txtprice = new JTextField();    JLabel jLabel5 = new JLabel();    JTextField txtbuytime = new JTextField();    JTextField txtstatus = new JTextField();    JLabel jLabel6 = new JLabel();    JTextField txtkinds = new JTextField();    JLabel jLabel7 = new JLabel();    JTextArea taremem = new JTextArea(3, 15);    JLabel jLabel8 = new JLabel();    JTextField txtdrawtime = new JTextField();    JLabel jLabel9 = new JLabel();    JTextField jTextField1 = new JTextField();    JTextArea txtdrawmem = new JTextArea(5, 5);    JTextArea tarused = new JTextArea(5, 5);    JLabel jLabel10 = new JLabel();    JButton btn_ok = new JButton();    JButton btn_no = new JButton();    JButton btnup = new JButton();    JButton btndown = new JButton();    JLabel jLabel11 = new JLabel();    private int down = 0;    private int currnet = 1;    public AssetReturn(Frame owner, String title, boolean modal, String user,                       String id, String UserID) {        super(owner, title, modal);        try {            this.userID = UserID;            this.user = user;            this.assetid = id;            setDefaultCloseOperation(DISPOSE_ON_CLOSE);            jbInit();            pack();        } catch (Exception exception) {            exception.printStackTrace();        }    }

    public AssetReturn(String user, String id, String UserID) {        this(new Frame(), "AssetReturn", false, user, id, UserID);    }

    private void jbInit() throws Exception {        this.getContentPane().setLayout(null);        JBL_card.setFont(new java.awt.Font("宋体", Font.BOLD, 24));        JBL_card.setForeground(new Color(0, 138, 0));        JBL_card.setText(user + "设备卡");        JBL_card.setBounds(new Rectangle(2, 0, 295, 47));        jLabel1.setText("单    价");        jLabel1.setBounds(new Rectangle(149, 73, 71, 27));        txtid.setText("");        txtid.setBounds(new Rectangle(62, 43, 81, 28));        jLabel2.setText("设备型号");        jLabel2.setBounds(new Rectangle(6, 74, 71, 27));        txtname.setText("");        txtname.setBounds(new Rectangle(207, 43, 81, 28));        jLabel3.setText("设备编号");        jLabel3.setBounds(new Rectangle(7, 41, 71, 27));        jLabel4.setText("设备名称");        jLabel4.setBounds(new Rectangle(149, 44, 71, 27));        txttype.setText("");        txttype.setBounds(new Rectangle(62, 74, 81, 28));        txtprice.setText("");        txtprice.setBounds(new Rectangle(207, 75, 81, 28));        jLabel5.setText("购置时间");        jLabel5.setBounds(new Rectangle(6, 102, 71, 27));        txtbuytime.setText("");        txtbuytime.setBounds(new Rectangle(62, 104, 81, 28));        txtstatus.setText("");        txtstatus.setBounds(new Rectangle(207, 108, 81, 28));        jLabel6.setText("状    态");        jLabel6.setBounds(new Rectangle(149, 105, 71, 27));        txtkinds.setText("");        txtkinds.setBounds(new Rectangle(62, 134, 81, 28));        jLabel7.setToolTipText("");        jLabel7.setText("用途");        jLabel7.setBounds(new Rectangle(171, 253, 30, 27));        taremem.setBounds(new Rectangle(17, 168, 286, 48));        jLabel8.setText("所属科目");        jLabel8.setBounds(new Rectangle(8, 134, 71, 27));        txtdrawtime.setText("");        txtdrawtime.setBounds(new Rectangle(62, 222, 81, 28));        jLabel9.setText("管理员");        jLabel9.setBounds(new Rectangle(164, 225, 71, 27));        jTextField1.setText("");        jTextField1.setBounds(new Rectangle(207, 226, 81, 28));        txtdrawmem.setBounds(new Rectangle(62, 259, 83, 74));        tarused.setBounds(new Rectangle(207, 259, 81, 75));        jLabel10.setToolTipText("");        jLabel10.setText("备注");        jLabel10.setBounds(new Rectangle(28, 257, 30, 27));        btn_ok.setBounds(new Rectangle(11, 358, 66, 29));        btn_ok.setText("归还");        btn_no.setBounds(new Rectangle(243, 356, 66, 29));        btn_no.setText("退出");        btnup.setBounds(new Rectangle(85, 358, 76, 29));        btnup.setText("上一条");        btndown.setBounds(new Rectangle(166, 358, 70, 29));        btndown.setText("下一条");        jLabel11.setText("借入时间");        jLabel11.setBounds(new Rectangle(10, 222, 71, 27));

        txtid.setEditable(false);        txtname.setEditable(false);        txttype.setEditable(false);        txtprice.setEditable(false);        txtbuytime.setEditable(false);        txtstatus.setEditable(false);        txtkinds.setEditable(false);        taremem.setEditable(false);        txtdrawtime.setEditable(false);        jTextField1.setEditable(false);        txtdrawmem.setEditable(false);        tarused.setEditable(false);

        this.getContentPane().add(jLabel3);        this.getContentPane().add(jLabel4);        this.getContentPane().add(txtid);        this.getContentPane().add(txtname);        this.getContentPane().add(jLabel1);        this.getContentPane().add(jLabel2);        this.getContentPane().add(txttype);        this.getContentPane().add(txtprice);        this.getContentPane().add(txtstatus);        this.getContentPane().add(JBL_card);        this.getContentPane().add(txtbuytime);        this.getContentPane().add(txtkinds);        this.getContentPane().add(jLabel8);        this.getContentPane().add(jLabel5);        this.getContentPane().add(txtdrawtime);        this.getContentPane().add(jLabel6);        this.getContentPane().add(tarused);        this.getContentPane().add(txtdrawmem);        this.getContentPane().add(jLabel10);        this.getContentPane().add(btnup);        this.getContentPane().add(btn_ok);        this.getContentPane().add(btn_no);        this.getContentPane().add(btndown);        this.getContentPane().add(taremem);        this.getContentPane().add(jLabel11);        this.setResizable(false);        this.getContentPane().add(jTextField1);        this.getContentPane().add(jLabel9);        this.getContentPane().add(jLabel7);        getAssetMessage();        btn_no.addActionListener(new ActionListener() {            public void actionPerformed(ActionEvent e) {                closedialog();            }        });        btnup.addActionListener(new ActionListener() {            public void actionPerformed(ActionEvent e) {                pageup();            }        });        btndown.addActionListener(new ActionListener() {            public void actionPerformed(ActionEvent e) {                pagedown();            }        });        btn_ok.addActionListener(new ActionListener() {            public void actionPerformed(ActionEvent e) {                returnAsset();            }        });    }

    public void hiden() {        btn_ok.setVisible(false);    }

    public void updownHiden() {        btn_ok.setVisible(false);        btnup.setVisible(false);        btndown.setVisible(false);    }

    //return    private void returnAsset() {        dcon = new DBConnection();        String sql = "delete from Action where asset_id='" +                     txtid.getText().trim() + "'";        dcon.update(1, sql);        String sql1 = "update Asset set asset_user ='' where asset_id = '" +                      txtid.getText().trim() + "'";        dcon.update(3, sql1);        Set set = perMap.entrySet();        Iterator it = set.iterator();        while (it.hasNext()) {            Map.Entry me = (Map.Entry) it.next();            MessageReturn mrt = (MessageReturn) me.getValue();            if (mrt.getId().equals(txtid.getText().trim())) {                perMap.remove(me.getKey());                break;            }        }        if (perMap.size() == 0) {            this.dispose();        }else        {            pagedown();        }    }

    //pagedown    private void pagedown() {        do {            currnet--;            if (currnet < 1) {                currnet = down;            }        } while (!perMap.containsKey(String.valueOf(currnet)));        MessageReturn mrt = (MessageReturn) perMap.get(String.valueOf(currnet));        txtid.setText(mrt.getId());        txtname.setText(mrt.getName());        txttype.setText(mrt.getType());        txtprice.setText(mrt.getPrice());        txtbuytime.setText(mrt.getBuytime());        txtstatus.setText(mrt.getStatus());        txtkinds.setText(getkindname(mrt.getKinds()));        taremem.setText(mrt.getRemark());        txtdrawtime.setText(mrt.getDrawtime());        jTextField1.setText(getManagerNaem(mrt.getManager()));        txtdrawmem.setText(mrt.getActionmark());        tarused.setText(mrt.getUsed());

    }

    //pageup    private void pageup() {        do {            currnet++;            if (currnet > down) {                currnet = 0;            }        } while (!perMap.containsKey(String.valueOf(currnet)));        MessageReturn mrt = (MessageReturn) perMap.get(String.valueOf(currnet));        txtid.setText(mrt.getId());        txtname.setText(mrt.getName());        txttype.setText(mrt.getType());        txtprice.setText(mrt.getPrice());        txtbuytime.setText(mrt.getBuytime());        txtstatus.setText(mrt.getStatus());        txtkinds.setText(getkindname(mrt.getKinds()));        taremem.setText(mrt.getRemark());        txtdrawtime.setText(mrt.getDrawtime());        jTextField1.setText(getManagerNaem(mrt.getManager()));        txtdrawmem.setText(mrt.getActionmark());        tarused.setText(mrt.getUsed());

    }

    //chushihua    private void closedialog() {        this.dispose();    }

    //获取科目名称    private String getkindname(String id) {        dcon = new DBConnection();        String sql =                "select childkind_name from ChildKind where childkind_id= '" +                id + "'";        Vector v = dcon.select(sql);        return ((Vector) v.get(0)).get(0).toString().trim();    }

    //获取管理员的名称    private String getManagerNaem(String id) {        dcon = new DBConnection();        String sql = "select manager_username from Manager where manager_id= '" +                     id + "'";        Vector v = dcon.select(sql);        return ((Vector) v.get(0)).get(0).toString().trim();

    }

    private void getAssetMessage() {        dcon = new DBConnection();        String sql = "select a.asset_id,a.asset_name,a.asset_type,a.asset_price,a.asset_buytime,a.asset_status,a.remark,a.childKind_id,b.action_time,b.manager_id,b.remark ,b.asset_use,a.asset_user from  Action as b,asset as a  where a.asset_id = b.asset_id and a.asset_user  = '" +                     userID + "'";        Vector v = dcon.select(sql);        int count = v.size();        if (count == 0) {            this.dispose();        }           down = count;        if (count > 0) {            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();                String type = ((Vector) v.get(i)).get(2).toString().trim();                String price = ((Vector) v.get(i)).get(3).toString().trim();                String buytime = ((Vector) v.get(i)).get(4).toString().trim();                String status = ((Vector) v.get(i)).get(5).toString().trim();                String remark;                if (((Vector) v.get(i)).get(6).toString().trim().length() == 0 ||                    ((Vector) v.get(i)).get(6) == null) {                    remark = "";                } else {                    remark = ((Vector) v.get(i)).get(6).toString().trim();                }                String kinds = ((Vector) v.get(i)).get(7).toString().trim();                String drawtime = ((Vector) v.get(i)).get(8).toString().trim();                String manager = ((Vector) v.get(i)).get(9).toString().trim();                String actionmark;                if (((Vector) v.get(i)).get(10).toString().trim().length() == 0 ||                    ((Vector) v.get(i)).get(10) == null) {                    actionmark = "";                } else {                    actionmark = ((Vector) v.get(i)).get(10).toString().trim();                }                String used;                if (((Vector) v.get(i)).get(11).toString().trim().length() == 0 ||                    ((Vector) v.get(i)).get(11) == null) {                    used = "";                } else {                    used = ((Vector) v.get(i)).get(11).toString().trim();                }                String user = ((Vector) v.get(i)).get(12).toString().trim();                MessageReturn mr = new MessageReturn(id, name, type, price,                        buytime, status, remark, kinds, drawtime, manager,                        actionmark, used);                down++;                perMap.put(String.valueOf(down), mr);

                if (id.equals(assetid)) {                    txtid.setText(id);                    txtname.setText(name);                    txttype.setText(type);                    txtprice.setText(price);                    txtbuytime.setText(buytime);                    txtstatus.setText(status);                    txtkinds.setText(getkindname(kinds));                    taremem.setText(remark);                    txtdrawtime.setText(drawtime);                    jTextField1.setText(getManagerNaem(manager));                    txtdrawmem.setText(actionmark);                    tarused.setText(used);                }            }        }    }}