guding.java

学习java 自己开发的企业管理系统,适合初学者

package zhican;



import java.awt.*;
import javax.swing.*;
import java.sql.*;
import java.awt.event.*;
import java.util.ArrayList;





public class guding extends JFrame {
  public guding() {
    try {
      jbInit();
    } catch (Exception exception) {
      exception.printStackTrace();
    }
  }



    private void jbInit() throws Exception {
      this.setDefaultCloseOperation(DISPOSE_ON_CLOSE);
      this.setSize(new Dimension(401, 382));

      setTitle("增加固定资产");

      getContentPane().setLayout(null);
      jTextField1.setText("");
      jTextField1.setBounds(new Rectangle(57, 9, 125, 27));
      jTextField8.setText("");
      jTextField8.setBounds(new Rectangle(263, 200, 125, 27));
      jTextField7.setText("");
      jTextField7.setBounds(new Rectangle(57, 200, 125, 27));
      jLabel10.setFont(new java.awt.Font("Dialog", 0, 12));
      jLabel10.setText("备        注");
      jLabel10.setBounds(new Rectangle(10, 250, 53, 27));
      jLabel9.setFont(new java.awt.Font("Dialog", 0, 12));
      jLabel9.setText("使  用  者");
      jLabel9.setBounds(new Rectangle(10, 200, 53, 27));
      jLabel8.setFont(new java.awt.Font("Dialog", 0, 12));
      jLabel8.setText("状        态");
      jLabel8.setBounds(new Rectangle(196, 144, 53, 27));
      jLabel7.setFont(new java.awt.Font("Dialog", 0, 12));
      jLabel7.setText("购入时间");
      jLabel7.setBounds(new Rectangle(10, 144, 80, 27));
      jLabel6.setFont(new java.awt.Font("Dialog", 0, 12));
      jLabel6.setText("价        格");
      jLabel6.setBounds(new Rectangle(196, 102, 53, 27));
      jLabel5.setFont(new java.awt.Font("Dialog", 0, 12));
      jLabel5.setText("型        号");
      jLabel5.setBounds(new Rectangle(10, 102, 53, 27));
      jLabel4.setFont(new java.awt.Font("Dialog", 0, 12));
      jLabel4.setText("小  类  别");
      jLabel4.setBounds(new Rectangle(196, 53, 53, 27));
      jLabel3.setFont(new java.awt.Font("Dialog", 0, 12));
      jLabel3.setText("大  类  别");
      jLabel3.setBounds(new Rectangle(10, 53, 53, 27));
      jLabel2.setFont(new java.awt.Font("Dialog", 0, 12));
      jLabel2.setText("资产名称");
      jLabel2.setBounds(new Rectangle(196, 9, 53, 27));
      jLabel1.setFont(new java.awt.Font("Dialog", 0, 12));
      jLabel1.setText("资产编号");
      jLabel1.setBounds(new Rectangle(10, 9, 53, 27));
      jTextField5.setText("");
      jTextField5.setBounds(new Rectangle(57, 144, 125, 27));
      jTextField4.setText("");
      jTextField4.setBounds(new Rectangle(263, 102, 125, 27));
      jTextField3.setText("");
      jTextField3.setBounds(new Rectangle(57, 102, 125, 27));
      jComboBox2.setBounds(new Rectangle(263, 53, 125, 27));
      jComboBox1.setBounds(new Rectangle(57, 53, 125, 27));
      jButton1.setBounds(new Rectangle(8, 333, 73, 30));
      jButton1.setFont(new java.awt.Font("隶书", 0, 20));
      jButton1.setText("增加");
    jButton1.addActionListener(new guding_jButton1_actionAdapter(this));
      jButton2.setBounds(new Rectangle(102, 333, 73, 30));
      jButton2.setFont(new java.awt.Font("隶书", 0, 20));
      jButton2.setText("删除");
        jButton2.addActionListener(new guding_jButton2_actionAdapter(this));
        jButton3.setBounds(new Rectangle(207, 334, 73, 30));
      jButton3.setFont(new java.awt.Font("隶书", 0, 20));
      jButton3.setText("修改");
        jButton3.addActionListener(new guding_jButton3_actionAdapter(this));
        jButton4.setBounds(new Rectangle(304, 333, 73, 30));
      jButton4.setFont(new java.awt.Font("隶书", 0, 20));
      jButton4.setText("查询");
        jButton4.addActionListener(new guding_jButton4_actionAdapter(this));
        jComboBox3.setBounds(new Rectangle(263, 144, 125, 27));
      jLabel11.setFont(new java.awt.Font("Dialog", 0, 12));
      jLabel11.setText("图片名称");
      jLabel11.setBounds(new Rectangle(196, 205, 51, 16));
      jTextField9.setText("");
      jTextField9.setBounds(new Rectangle(57, 250, 329, 60));
      this.getContentPane().add(jLabel3);
      this.getContentPane().add(jComboBox1);
      this.getContentPane().add(jLabel4);
      this.getContentPane().add(jLabel5);
      this.getContentPane().add(jLabel6);
      this.getContentPane().add(jLabel7);
      this.getContentPane().add(jTextField7);
      this.getContentPane().add(jTextField5);
      this.getContentPane().add(jLabel9);
      this.getContentPane().add(jLabel10);
      this.getContentPane().add(jTextField9);
      this.getContentPane().add(jLabel1);
      this.getContentPane().add(jTextField1);
      this.getContentPane().add(jTextField3);
      this.getContentPane().add(jLabel2);
      this.getContentPane().add(jComboBox2);
      this.getContentPane().add(jTextField2);
      this.getContentPane().add(jTextField4);
      this.getContentPane().add(jComboBox3);
      this.getContentPane().add(jTextField8);
      this.getContentPane().add(jLabel11, null);
      this.getContentPane().add(jLabel8);
      this.getContentPane().add(jButton1);
      this.getContentPane().add(jButton4);
      this.getContentPane().add(jButton3);
      this.getContentPane().add(jButton2);
      jTextField2.setText("");
      jTextField2.setBounds(new Rectangle(263, 9, 125, 27));
      jComboBox1.addItem("办公外设");
      jComboBox1.addItem("数码产品");
      jComboBox1.addItem("计算机");
      jComboBox1.addItem("交通工具");

      //
  ArrayList jiang=new ArrayList();
  String gr=this.jComboBox1.getSelectedItem().toString();
  sql obj=new sql();
  jiang=(ArrayList) obj.qq();
  for(int i=0;i<jiang.size();i++){
  this.jComboBox2.addItem(jiang.get(i));
}
       jComboBox2.addItem(" ");

        jComboBox3.addItem("正常");
        jComboBox3.addItem("维修中");
        jComboBox3.addItem("已报废");
        String gass = jComboBox1.getSelectedItem().toString();
        String gass1 = jComboBox2.getSelectedItem().toString();
        String gass2 = jComboBox3.getSelectedItem().toString();

        }

    JTextField jTextField1 = new JTextField();
    JTextField jTextField2 = new JTextField();
    JComboBox jComboBox1 = new JComboBox();
    JComboBox jComboBox2 = new JComboBox();
    JTextField jTextField3 = new JTextField();
    JTextField jTextField4 = new JTextField();
    JTextField jTextField5 = new JTextField();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    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();
    JTextField jTextField7 = new JTextField();
    JTextField jTextField8 = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    JButton jButton4 = new JButton();
    JComboBox jComboBox3 = new JComboBox();
  JLabel jLabel11 = new JLabel();
  JTextField jTextField9 = new JTextField();

  void jButton1_actionPerformed(ActionEvent e) {
         String aaa=jTextField2.getText();
       String gr1=this.jComboBox1.getSelectedItem().toString();
       String bbb=jTextField3.getText();
       String ccc=jTextField4.getText();
       String ddd=jTextField5.getText();
       String gr2=this.jComboBox2.getSelectedItem().toString();
       String fff=jTextField7.getText();
       String ggg=jTextField8.getText();
       String gr3=this.jComboBox3.getSelectedItem().toString();
       String hhh=jTextField9.getText();
       sql obj=new sql();
       obj.getsta();
       if(obj.zzc(aaa,bbb,ccc,ddd,fff,gr1,gr2,gr3,hhh,ggg)){
            javax.swing.JOptionPane.showMessageDialog(this,"增加成功");
       }else{
            javax.swing.JOptionPane.showMessageDialog(this,"增加失败");
       }
  }

    public void jButton2_actionPerformed(ActionEvent e) {//del
      String a=jTextField1.getText();
      sql obj=new sql();
      obj.getsta();
      obj.delgd(a);
      javax.swing.JOptionPane.showMessageDialog(this,"删除成功");
    }

    public void jButton3_actionPerformed(ActionEvent e) {   //update
          String aaaa=jTextField1.getText();
          String bbbb=jTextField2.getText();
          String gr11=this.jComboBox1.getSelectedItem().toString();
          String gr22=this.jComboBox2.getSelectedItem().toString();
          String cccc=jTextField3.getText();
          String dddd=jTextField4.getText();
          String eeee=jTextField5.getText();
          String gr33=this.jComboBox3.getSelectedItem().toString();
          String ffff=jTextField7.getText();
          String gggg=jTextField8.getText();
          String hhhh=jTextField9.getText();
          sql obj=new sql();
          obj.getsta();
          if(obj.updateg(aaaa,bbbb,gr11,gr22,cccc,dddd,eeee,gr33,ffff,gggg,hhhh)){
                javax.swing.JOptionPane.showMessageDialog(this,"更新成功");
           }else{
                javax.swing.JOptionPane.showMessageDialog(this,"更新失败");
           }

        }


    public void jButton4_actionPerformed(ActionEvent e) {//select
        String abc=jTextField1.getText();
        sql obj=new sql();
        obj.getsta();
        ArrayList aoo=new ArrayList();
        aoo=obj.zhi(abc);
        jTextField2.setText(aoo.get(0).toString());
        jComboBox1.addItem(aoo.get(1).toString());
        jComboBox2.addItem(aoo.get(2).toString());
        jTextField3.setText(aoo.get(3).toString());
        jTextField4.setText(aoo.get(4).toString());
        jTextField5.setText(aoo.get(5).toString());
        jComboBox3.addItem(aoo.get(6).toString());
        jTextField7.setText(aoo.get(7).toString());
        jTextField8.setText(aoo.get(8).toString());
        jTextField9.setText(aoo.get(9).toString());
    }


}


class guding_jButton3_actionAdapter implements ActionListener {
    private guding adaptee;
    guding_jButton3_actionAdapter(guding adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton3_actionPerformed(e);
    }
}


class guding_jButton4_actionAdapter implements ActionListener {
    private guding adaptee;
    guding_jButton4_actionAdapter(guding adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton4_actionPerformed(e);
    }
}


class guding_jButton2_actionAdapter implements ActionListener {
    private guding adaptee;
    guding_jButton2_actionAdapter(guding adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton2_actionPerformed(e);
    }
}


class guding_jButton1_actionAdapter implements java.awt.event.ActionListener {
  guding adaptee;

  guding_jButton1_actionAdapter(guding adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}