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

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