增加固定资产.java

第一学期编写的JAVA程序

package 固定资产管理系统;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.*;
import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class 增加固定资产 extends JFrame {
         连接 l = new 连接();
         Connection con = l.ver();
    public 增加固定资产() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);

        lbl大类编号.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lbl大类编号.setHorizontalAlignment(SwingConstants.CENTER);
        lbl大类编号.setText("大类编号");
        lbl大类编号.setBounds(new Rectangle(17, 78, 75, 32));
        lbl购入日期.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lbl购入日期.setHorizontalAlignment(SwingConstants.CENTER);
        lbl购入日期.setText("购入日期");
        lbl购入日期.setBounds(new Rectangle(17, 165, 75, 32));
        lbl购入人.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lbl购入人.setHorizontalAlignment(SwingConstants.CENTER);
        lbl购入人.setText("购入人");
        lbl购入人.setBounds(new Rectangle(24, 209, 75, 32));
        lbl资产名称.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lbl资产名称.setHorizontalAlignment(SwingConstants.CENTER);
        lbl资产名称.setText("资产名称");
        lbl资产名称.setBounds(new Rectangle(229, 34, 75, 32));
        lbl子类编号.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lbl子类编号.setHorizontalAlignment(SwingConstants.CENTER);
        lbl子类编号.setText("子类编号");
        lbl子类编号.setBounds(new Rectangle(232, 83, 75, 32));
        lbl价格.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lbl价格.setHorizontalAlignment(SwingConstants.CENTER);
        lbl价格.setText("价   格");
        lbl价格.setBounds(new Rectangle(240, 122, 75, 32));
        lbl状态.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lbl状态.setHorizontalAlignment(SwingConstants.CENTER);
        lbl状态.setText("状   态");
        lbl状态.setBounds(new Rectangle(240, 168, 75, 32));
        lbl备注.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lbl备注.setHorizontalAlignment(SwingConstants.CENTER);
        lbl备注.setText("备   注");
        lbl备注.setBounds(new Rectangle(239, 211, 75, 32));
        lbl资产编号.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lbl资产编号.setHorizontalAlignment(SwingConstants.CENTER);
        lbl资产编号.setText("资产编号");
        lbl资产编号.setBounds(new Rectangle(17, 37, 75, 32));
        txt资产名称.setText("");
        txt资产名称.setBounds(new Rectangle(305, 33, 116, 31));
        txt样式.setText("");
        txt样式.setBounds(new Rectangle(90, 122, 116, 31));
        txt价格.setText("");
        txt价格.setBounds(new Rectangle(305, 121, 116, 31));
        txt购入日期.setText("");
        txt购入日期.setBounds(new Rectangle(90, 166, 116, 31));
        txt购入人.setText("");
        txt购入人.setBounds(new Rectangle(90, 210, 116, 31));
        txt备注.setText("");
        txt备注.setBounds(new Rectangle(305, 210, 116, 31));
        txt资产编号.setText("");
        txt资产编号.setBounds(new Rectangle(90, 38, 116, 31));
        comb子类编号.setBounds(new Rectangle(303, 80, 118, 30));


        comb状态.setBounds(new Rectangle(303, 167, 118, 30));
        comb状态.addItem("0");
        comb状态.addItem("1");
        comb状态.addItem("2");
        comb大类编号.setBounds(new Rectangle(88, 81, 118, 30));


        btn删除.setBounds(new Rectangle(227, 274, 73, 34));
        btn删除.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btn删除.setBorder(BorderFactory.createLineBorder(Color.black));
        btn删除.setToolTipText("");
        btn删除.setActionCommand("btn删除");
        btn删除.setText("删除");
        btn查询.setBounds(new Rectangle(314, 275, 73, 34));
        btn查询.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btn查询.setBorder(BorderFactory.createLineBorder(Color.black));
        btn查询.setText("查询");
        btn增加.setBounds(new Rectangle(54, 275, 73, 34));
        btn增加.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btn增加.setBorder(BorderFactory.createLineBorder(Color.black));
        btn增加.setText("增加");
        btn增加.addActionListener(new 增加固定资产_btn增加_actionAdapter(this));
        btn修改.setBounds(new Rectangle(141, 275, 73, 34));
        btn修改.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btn修改.setBorder(BorderFactory.createLineBorder(Color.black));
        btn修改.setText("修改");



        this.getContentPane().add(lbl资产编号);
        this.getContentPane().add(lbl大类编号);
        this.getContentPane().add(lbl样式);
        this.getContentPane().add(lbl购入日期);
        this.getContentPane().add(lbl购入人);
        this.getContentPane().add(txt购入人);
        this.getContentPane().add(txt购入日期);
        this.getContentPane().add(txt样式);
        this.getContentPane().add(comb大类编号);
        this.getContentPane().add(txt资产编号);
        this.getContentPane().add(txt资产名称);
        this.getContentPane().add(lbl资产名称);
        this.getContentPane().add(comb子类编号);
        this.getContentPane().add(lbl子类编号);
        this.getContentPane().add(lbl价格);
        this.getContentPane().add(txt价格);
        this.getContentPane().add(comb状态);
        this.getContentPane().add(lbl状态);
        this.getContentPane().add(lbl备注);
        this.getContentPane().add(txt备注);
        this.getContentPane().add(btn删除);
        this.getContentPane().add(btn增加);
        this.getContentPane().add(btn修改);
        this.getContentPane().add(btn查询);
        lbl样式.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lbl样式.setHorizontalAlignment(SwingConstants.CENTER);
        lbl样式.setText("样    式");
        lbl样式.setBounds(new Rectangle(20, 125, 75, 32));
        this.setSize(450,350);
        this.setLocation(300,300);
        this.setVisible(true);
    }

    JLabel lbl大类编号 = new JLabel();
    JLabel lbl样式 = new JLabel();
    JLabel lbl购入日期 = new JLabel();
    JLabel lbl购入人 = new JLabel();
    JLabel lbl资产名称 = new JLabel();
    JLabel lbl子类编号 = new JLabel();
    JLabel lbl价格 = new JLabel();
    JLabel lbl状态 = new JLabel();
    JLabel lbl备注 = new JLabel();
    JLabel lbl资产编号 = new JLabel();
    JTextField txt资产名称 = new JTextField();
    JTextField txt样式 = new JTextField();
    JTextField txt价格 = new JTextField();
    JTextField txt购入日期 = new JTextField();
    JTextField txt购入人 = new JTextField();
    JTextField txt备注 = new JTextField();
    JTextField txt资产编号 = new JTextField();
    JComboBox comb子类编号 = new JComboBox();
    JComboBox comb状态 = new JComboBox();
    JComboBox comb大类编号 = new JComboBox();
    JButton btn删除 = new JButton();
    JButton btn查询 = new JButton();
    JButton btn增加 = new JButton();
    JButton btn修改 = new JButton();

    public void btn增加_actionPerformed(ActionEvent e) {
        try {
            String num=txt资产编号.getText();
            String name=txt资产名称.getText();
            String bignum=comb大类编号.getSelectedItem().toString();
            String snum=comb子类编号.getSelectedItem().toString();
            String yangshi=txt样式.getText();
            String price= txt价格.getText();
            String data=txt购入日期.getText();
            String status=comb状态.getSelectedItem().toString();
            String man=txt购入人.getText();
            String userby="";
            String remark=txt备注.getText();


            PreparedStatement pst = con.prepareStatement("insert into asset固定资产信息表 values(?,?,?,?,?,?,?,?,?,?,?)");
            pst.setString(1,num);
            pst.setString(2,name);
            pst.setString(3,bignum);
            pst.setString(4,snum);
            pst.setString(5,yangshi);
            pst.setString(6,price);
            pst.setString(7,status);
            pst.setString(8,data);
            pst.setString(9,man);
            pst.setString(10,userby);
            pst.setString(11,remark);
            pst.executeUpdate();
            pst.close();
            JOptionPane.showMessageDialog(this,"信息成功插入^_^");
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }
}


class 增加固定资产_btn增加_actionAdapter implements ActionListener {
    private 增加固定资产 adaptee;
    增加固定资产_btn增加_actionAdapter(增加固定资产 adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btn增加_actionPerformed(e);
    }
}