assertselpanel.java

固定资产管理

package stage_project;

import java.awt.*;

import javax.swing.*;
import javax.swing.table.JTableHeader;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.ArrayList;
import javax.swing.table.DefaultTableModel;
import java.io.*;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class AssertSelPanel extends JPanel {
    public AssertSelPanel() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.setLayout(null);
        setSize(new Dimension(960, 600));

        jLabel1.setText("请选择要查找的资产编号：");
        jLabel1.setBounds(new Rectangle(113, 150, 140, 30));
        txtAssertId.setText("");
        txtAssertId.setBounds(new Rectangle(260, 150, 140, 30));
        jLabel2.setText("请选择要查找的资产名称：");
        jLabel2.setBounds(new Rectangle(469, 150, 140, 30));
        txtAssertName.setText("");
        txtAssertName.setBounds(new Rectangle(619, 150, 140, 30));
        btnSel.setBounds(new Rectangle(820, 150, 70, 25));
        btnSel.setText("查  询");
        btnSel.addActionListener(new AssertSelPanel_btnSel_actionAdapter(this));
        jLabel3.setText("资产编号：");
        jLabel3.setBounds(new Rectangle(163, 210, 90, 30));
        jLabel4.setText("大类编号：");
        jLabel4.setBounds(new Rectangle(163, 260, 90, 30));
        jLabel5.setText("样        式：");
        jLabel5.setBounds(new Rectangle(163, 310, 90, 30));
        jLabel6.setText("购入日期：");
        jLabel6.setBounds(new Rectangle(163, 360, 90, 30));
        jLabel7.setText("购  入  人：");
        jLabel7.setBounds(new Rectangle(163, 410, 90, 30));
        jLabel8.setText("资产名称：");
        jLabel8.setBounds(new Rectangle(519, 210, 90, 30));
        jLabel9.setText("子类编号：");
        jLabel9.setBounds(new Rectangle(519, 260, 90, 30));
        jLabel10.setText("价       格：");
        jLabel10.setBounds(new Rectangle(519, 310, 90, 30));
        jLabel11.setText("状        态：");
        jLabel11.setBounds(new Rectangle(519, 360, 90, 30));
        jLabel12.setText("备        注：");
        jLabel12.setBounds(new Rectangle(519, 410, 90, 30));
        jLabel13.setText("借用日期：");
        jLabel13.setBounds(new Rectangle(519, 460, 90, 30));
        jLabel14.setText("是否归还：");
        jLabel14.setBounds(new Rectangle(519, 510, 90, 30));
        jLabel15.setText("借  用  人：");
        jLabel15.setBounds(new Rectangle(163, 460, 90, 30));
        jLabel16.setText("归还日期：");
        jLabel16.setBounds(new Rectangle(163, 510, 90, 30));
        txtAssertId1.setText("");
        txtAssertId1.setBounds(new Rectangle(260, 210, 140, 30));
        txtMainId.setText("");
        txtMainId.setBounds(new Rectangle(260, 260, 140, 30));
        txtType.setText("");
        txtType.setBounds(new Rectangle(260, 310, 140, 30));
        txtBuyDate.setText("");
        txtBuyDate.setBounds(new Rectangle(260, 360, 140, 30));
        txtBuyer.setText("");
        txtBuyer.setBounds(new Rectangle(260, 410, 140, 30));
        txtLendMan.setText("");
        txtLendMan.setBounds(new Rectangle(260, 460, 140, 30));
        txtReturnDate.setText("");
        txtReturnDate.setBounds(new Rectangle(260, 510, 140, 30));
        txtAssertName1.setText("");
        txtAssertName1.setBounds(new Rectangle(619, 210, 140, 30));
        txtSortId.setText("");
        txtSortId.setBounds(new Rectangle(619, 260, 140, 30));
        txtPrice.setText("");
        txtPrice.setBounds(new Rectangle(619, 310, 140, 30));
        txtStatus.setText("");
        txtStatus.setBounds(new Rectangle(619, 360, 140, 30));
        txtRemark.setText("");
        txtRemark.setBounds(new Rectangle(619, 410, 140, 30));
        txtLandDate.setText("");
        txtLandDate.setBounds(new Rectangle(619, 460, 140, 30));
        txtReturnYorN.setText("");
        txtReturnYorN.setBounds(new Rectangle(619, 510, 140, 30));
        lblBeijing.setIcon(img);
        lblBeijing.setBounds(new Rectangle(0, 0, 960, 600));
        this.add(jLabel1);
        this.add(txtAssertName);
        this.add(txtAssertId);
        this.add(txtAssertId1);
        this.add(jLabel3);
        this.add(jLabel15);
        this.add(jLabel7);
        this.add(jLabel6);
        this.add(jLabel5);
        this.add(jLabel4);
        this.add(txtMainId);
        this.add(txtType);
        this.add(txtBuyDate);
        this.add(txtBuyer);
        this.add(jLabel16);
        this.add(txtLendMan);
        this.add(txtReturnDate);
        this.add(jLabel14);
        this.add(txtReturnYorN);
        this.add(txtLandDate);
        this.add(jLabel13);
        this.add(jLabel12);
        this.add(txtRemark);
        this.add(txtStatus);
        this.add(jLabel11);
        this.add(jLabel10);
        this.add(txtPrice);
        this.add(jLabel9);
        this.add(txtSortId);
        this.add(txtAssertName1);
        this.add(btnSel);
        this.add(jLabel2);
        this.add(jLabel8);
        this.add(lblBeijing);
    }

    JLabel jLabel1 = new JLabel();
    JTextField txtAssertId = new JTextField();
    JLabel jLabel2 = new JLabel();
    JTextField txtAssertName = new JTextField();
    JButton btnSel = new JButton();


    JLabel jLabel3 = new JLabel();

    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JLabel jLabel8 = new JLabel();
    JLabel jLabel9 = new JLabel();
    JLabel jLabel10 = new JLabel();
    JLabel jLabel11 = new JLabel();
    JLabel jLabel12 = new JLabel();
    JLabel jLabel13 = new JLabel();
    JLabel jLabel14 = new JLabel();
    JLabel jLabel15 = new JLabel();
    JLabel jLabel16 = new JLabel();
    JTextField txtAssertId1 = new JTextField();
    JTextField txtMainId = new JTextField();
    JTextField txtType = new JTextField();
    JTextField txtBuyDate = new JTextField();
    JTextField txtBuyer = new JTextField();
    JTextField txtLendMan = new JTextField();
    JTextField txtReturnDate = new JTextField();
    JTextField txtAssertName1 = new JTextField();
    JTextField txtSortId = new JTextField();
    JTextField txtPrice = new JTextField();
    JTextField txtStatus = new JTextField();
    JTextField txtRemark = new JTextField();
    JTextField txtLandDate = new JTextField();
    JTextField txtReturnYorN = new JTextField();
    ImageIcon img = new ImageIcon("xiubei.gif");
    JLabel lblBeijing = new JLabel(img);
    public void btnSel_actionPerformed(ActionEvent e) {
        //文本信息

        String assertid = txtAssertId.getText(); //资产编号
        String assertname = txtAssertName.getText(); //资产名称
        String maincateid = txtMainId.getText(); // "主类编号"
        String sortid = txtSortId.getText(); //"子类编号"
        String type = txtType.getText(); //样式
        String price = txtPrice.getText(); //价格
        String status = txtStatus.getText(); //状   态
        String buyDate = txtBuyDate.getText(); //购入日期
        String buyer = txtBuyer.getText(); //购入人
        String remark = txtRemark.getText(); //备注

        String lendman = txtLendMan.getText(); //借  用  人
        String lenddate = txtLandDate.getText(); //借用日期
        String returndate = txtReturnDate.getText(); // 归还日期
        String returnYorN = txtReturnYorN.getText(); //是否归还
        DBAccess db = new DBAccess();