mainframe.java~50~

代码是自己我的代码不是网上down的。是自己写的。里面有很多值得学习的知识点。还有一些javabean组件。不算自己写的JAR文件

package zcgl;

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import javax.swing.*;
import java.awt.Font;
import java.awt.Rectangle;
import javax.swing.border.TitledBorder;
import java.awt.FlowLayout;
import com.borland.jbcl.layout.VerticalFlowLayout;
import javax.swing.border.Border;
import com.borland.jbcl.layout.PaneLayout;
import com.borland.jbcl.layout.*;
import java.awt.GridBagLayout;
import java.awt.*;
import javax.swing.table.DefaultTableModel;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class MainFrame extends JFrame {
    JPanel jPanel1 = new JPanel();
      JMenuBar jMenuBar1 = new JMenuBar();
      TitledBorder titledBorder1 = new TitledBorder("详细信息");
      VerticalFlowLayout verticalFlowLayout1 = new VerticalFlowLayout();
      JLabel jLabel1 = new JLabel();
      JTextField txtFindId = new JTextField();
      JButton jButton1 = new JButton();
      JLabel jLabel2 = new JLabel();
      JTextField txtFindName = new JTextField();
      JButton jButton2 = new JButton();
      JButton jButton3 = new JButton();
      JScrollPane jScrollPane1 = new JScrollPane();
      JTable table ;
      DefaultTableModel tm;
      TitledBorder titledBorder2 = new TitledBorder("详细信息");
      JPanel jPanel2 = new JPanel();
      JLabel jLabel6 = new JLabel();
      JTextField txtZcId = new JTextField();
      Connection con=null;
      Statement smt=null;
      ResultSet rs=null;
    JLabel jLabel3 = new JLabel();
    JTextField txtName = new JTextField();
    JLabel jLabel4 = new JLabel();
    JTextField txtDlId = new JTextField();
    JLabel jLabel5 = new JLabel();
    JTextField txtZlId = new JTextField();
    JLabel jLabel7 = new JLabel();
    JTextField txtStyle = new JTextField();
    JLabel jLabel8 = new JLabel();
    JTextField txtPrice = new JTextField();
    JLabel jLabel9 = new JLabel();
    JTextField txtGrDate = new JTextField();
    JLabel jLabel10 = new JLabel();
    JTextField txtStatus = new JTextField();
    JLabel jLabel11 = new JLabel();
    JTextField txtGrR = new JTextField();
    JLabel jLabel12 = new JLabel();
    JTextField txtContent = new JTextField();
    JLabel jLabel13 = new JLabel();
    JTextField txtJyR = new JTextField();
    JLabel jLabel14 = new JLabel();
    JTextField txtJyDate = new JTextField();
    JLabel jLabel15 = new JLabel();
    JTextField txtGhDate = new JTextField();
    JLabel jLabel16 = new JLabel();
    JTextField txtReturn = new JTextField();
    JMenu jMenu1 = new JMenu();
    JMenuItem jMenuItem1 = new JMenuItem();
    JMenuItem jMenuItem2 = new JMenuItem();
    JMenuItem jMenuItem3 = new JMenuItem();
    JMenu jMenu2 = new JMenu();
    JMenuItem jMenuItem4 = new JMenuItem();
    JMenuItem jMenuItem5 = new JMenuItem();
    JMenuItem jMenuItem6 = new JMenuItem();
    JMenu jMenu3 = new JMenu();
    JMenuItem jMenuItem7 = new JMenuItem();
    JMenuItem jMenuItem8 = new JMenuItem();
    JMenuItem jMenuItem9 = new JMenuItem();


    public MainFrame() {


        try {
            Object[] o = {"资产编号", "资产名称", "大类编号", "子类编号", "样式", "价格", "购入日期",
                        "状态", "购入人", "备注"};
           tm = new DefaultTableModel(o, 0);

           table = new JTable(tm);

            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        setSize(new Dimension(622, 492));
        setTitle("资产管理系统");
        jPanel1.setBorder(titledBorder1);
        jPanel1.setBounds(new Rectangle(6, 8, 177, 261));
        jPanel1.setLayout(verticalFlowLayout1);
        jLabel1.setText("以资产编号查询");
        jButton1.setText("查询");
        jButton1.addActionListener(new MainFrame_jButton1_actionAdapter(this));
        jLabel2.setText("以资产名称查询");
        jButton2.setText("查询");
        jButton2.addActionListener(new MainFrame_jButton2_actionAdapter(this));
        jButton3.setText("查询所有记录");
        jButton3.addActionListener(new MainFrame_jButton3_actionAdapter(this));
        jScrollPane1.setBounds(new Rectangle(6, 286, 607, 203));
        jScrollPane1.addMouseListener(new MainFrame_jScrollPane1_mouseAdapter(this));
        jPanel2.setBorder(titledBorder2);
        jPanel2.setBounds(new Rectangle(178, 10, 434, 263));
        jPanel2.setLayout(null);
        jLabel6.setText("资产编号");
        jLabel6.setBounds(new Rectangle(12, 22, 56, 19));
        txtZcId.setBounds(new Rectangle(67, 22, 123, 21));
        this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        this.setJMenuBar(jMenuBar1);
        table.addMouseListener(new MainFrame_table_mouseAdapter(this));
        jLabel3.setText("资产名称");
        jLabel3.setBounds(new Rectangle(236, 24, 58, 15));
        txtName.setBounds(new Rectangle(298, 21, 110, 21));
        jLabel4.setText("大类编号");
        jLabel4.setBounds(new Rectangle(12, 61, 51, 15));
        txtDlId.setBounds(new Rectangle(67, 57, 122, 21));
        jLabel5.setText("子类编号");
        jLabel5.setBounds(new Rectangle(235, 59, 55, 15));
        txtZlId.setBounds(new Rectangle(298, 54, 111, 21));
        jLabel7.setText("样    式");
        jLabel7.setBounds(new Rectangle(10, 95, 62, 15));
        txtStyle.setBounds(new Rectangle(67, 90, 123, 21));
        jLabel8.setText("价    格");
        jLabel8.setBounds(new Rectangle(235, 93, 55, 15));
        txtPrice.setBounds(new Rectangle(298, 87, 110, 21));
        jLabel9.setText("购入日期");
        jLabel9.setBounds(new Rectangle(9, 132, 54, 15));
        txtGrDate.setBounds(new Rectangle(67, 128, 121, 21));
        jLabel10.setText("状    态");
        jLabel10.setBounds(new Rectangle(235, 132, 48, 15));
        txtStatus.setBounds(new Rectangle(299, 126, 111, 21));
        jLabel11.setText("购 入 人");
        jLabel11.setBounds(new Rectangle(10, 167, 48, 15));
        txtGrR.setBounds(new Rectangle(70, 164, 120, 21));
        jLabel12.setText("备    注");
        jLabel12.setBounds(new Rectangle(235, 165, 48, 15));
        txtContent.setBounds(new Rectangle(299, 162, 111, 21));
        jLabel13.setText("借 用 人");
        jLabel13.setBounds(new Rectangle(10, 206, 48, 15));
        txtJyR.setBounds(new Rectangle(67, 202, 123, 21));
        jLabel14.setText("借用日期");
        jLabel14.setBounds(new Rectangle(238, 200, 48, 15));
        txtJyDate.setBounds(new Rectangle(298, 197, 109, 21));
        jLabel15.setText("归还日期");
        jLabel15.setBounds(new Rectangle(12, 239, 48, 15));
        txtGhDate.setBounds(new Rectangle(66, 238, 125, 21));
        jLabel16.setText("是否归还");
        jLabel16.setBounds(new Rectangle(239, 239, 48, 15));
        txtReturn.setBounds(new Rectangle(299, 234, 108, 21));
        jMenu1.setText("固定资产管理");
        jMenuItem1.setText("增加");
        jMenuItem1.addActionListener(new MainFrame_jMenuItem1_actionAdapter(this));
        jMenuItem2.setText("修改");
        jMenuItem2.addActionListener(new MainFrame_jMenuItem2_actionAdapter(this));
        jMenuItem3.setText("删除");
        jMenuItem3.addActionListener(new MainFrame_jMenuItem3_actionAdapter(this));
        jMenu2.setText("职工管理");
        jMenuItem4.setText("添加");
        jMenuItem4.addActionListener(new MainFrame_jMenuItem4_actionAdapter(this));
        jMenuItem5.setText("修改");
        jMenuItem5.addActionListener(new MainFrame_jMenuItem5_actionAdapter(this));
        jMenuItem6.setText("删除");
        jMenuItem6.addActionListener(new MainFrame_jMenuItem6_actionAdapter(this));
        jMenu3.setText("资产类别管理");
        jMenuItem7.setText("添加");
        jMenuItem7.addActionListener(new MainFrame_jMenuItem7_actionAdapter(this));
        jMenuItem8.setText("修改");
        jMenuItem8.addActionListener(new MainFrame_jMenuItem8_actionAdapter(this));
        jMenuItem9.setText("删除");
        jMenuItem9.addActionListener(new MainFrame_jMenuItem9_actionAdapter(this));
        this.getContentPane().add(jPanel1);
        this.getContentPane().add(jPanel2);
        this.getContentPane().add(jScrollPane1);
        jScrollPane1.getViewport().add(table);
        jPanel2.add(jLabel6);
        jPanel2.add(txtZcId);
        jPanel2.add(txtName);
        jPanel2.add(jLabel3);
        jPanel2.add(jLabel4);
        jPanel2.add(txtDlId);
        jPanel2.add(jLabel5);
        jPanel2.add(txtZlId);
        jPanel2.add(txtStyle);
        jPanel2.add(jLabel7);
        jPanel2.add(jLabel8);
        jPanel2.add(txtPrice);
        jPanel2.add(jLabel9);
        jPanel2.add(txtGrDate);
        jPanel2.add(jLabel10);
        jPanel2.add(txtStatus);
        jPanel2.add(txtGrR);
        jPanel2.add(jLabel11);
        jPanel2.add(jLabel12);
        jPanel2.add(txtContent);
        jPanel2.add(txtJyR);
        jPanel2.add(jLabel13);
        jPanel2.add(jLabel14);
        jPanel2.add(txtJyDate);
        jPanel2.add(jLabel15);
        jPanel2.add(txtGhDate);
        jPanel2.add(jLabel16);
        jPanel2.add(txtReturn);
        jPanel1.add(jLabel1);
        jPanel1.add(txtFindId);
        jPanel1.add(jButton1);
        jPanel1.add(jLabel2);
        jPanel1.add(txtFindName);
        jPanel1.add(jButton2);
        jPanel1.add(jButton3);
        jMenuBar1.add(jMenu1);
        jMenuBar1.add(jMenu2);
        jMenuBar1.add(jMenu3);
        jMenu1.add(jMenuItem1);
        jMenu1.add(jMenuItem2);
        jMenu1.add(jMenuItem3);
        jMenu2.add(jMenuItem4);
        jMenu2.add(jMenuItem5);
        jMenu2.add(jMenuItem6);
        jMenu3.add(jMenuItem7);
        jMenu3.add(jMenuItem8);
        jMenu3.add(jMenuItem9);
    }


    public void jButton3_actionPerformed(ActionEvent actionEvent) {

        if (table.getRowCount() > 0) {
            for (int i = 0; table.getRowCount() > 0; i++) {
                tm.removeRow(0);
            }
        }


        try
        {
            con= new DBConn().getConnection();
             smt=con.createStatement();

             rs = smt.executeQuery("select * from ASSET");
             while(rs.next())
             {
                 String id=String.valueOf(rs.getInt("assetid")).trim();
                 String name = rs.getString("asset_name").trim();
                String DlId = String.valueOf(rs.getInt("cateid")).trim();
                String ZlId = String.valueOf(rs.getInt("subcateid")).trim();
                String style = rs.getString("model").trim();
                String price = String.valueOf(rs.getFloat("price")).trim();
                String d = rs.getString("purchase_date").trim();
                d = d.substring(0, d.indexOf(" "));
                String gdate = d;
                String status = rs.getString("status").trim();
                String grr = rs.getString("useby").trim();
                String context = rs.getString("remarks").trim();
                String[] info = {id, name, DlId, ZlId, style, price, gdate,
                                status, grr, context};
                tm.addRow(info);


             }

        }
     catch(Exception ex)
     {
         ex.printStackTrace();
     }

    }

    public void jButton1_actionPerformed(ActionEvent actionEvent)  {
        if (table.getRowCount() > 0) {
           for (int i = 0; table.getRowCount() > 0; i++) {
               tm.removeRow(0);
           }
       }


       try
       {
           con= new DBConn().getConnection();
            smt=con.createStatement();

            rs = smt.executeQuery("select * from ASSET where assetid=" +
                                  txtFindId.getText());
            while(rs.next())
            {
                String id=String.valueOf(rs.getInt("assetid")).trim();
                String name = rs.getString("asset_name").trim();
               String DlId = String.valueOf(rs.getInt("cateid")).trim();
               String ZlId = String.valueOf(rs.getInt("subcateid")).trim();
               String style = rs.getString("model").trim();
               String price = String.valueOf(rs.getFloat("price")).trim();
               String d = rs.getString("purchase_date").trim();
               d = d.substring(0, d.indexOf(" "));
               String gdate = d;
               String status = rs.getString("status").trim();
               String grr = rs.getString("useby").trim();
               String context = rs.getString("remarks").trim();
               String[] info = {id, name, DlId, ZlId, style, price, gdate,
                               status, grr, context};
               tm.addRow(info);


            }

       }
    catch(Exception ex)
    {
        ex.printStackTrace();
    }


    }

    public void jButton2_actionPerformed(ActionEvent actionEvent) {
        if (table.getRowCount() > 0) {
                  for (int i = 0; table.getRowCount() > 0; i++) {
                      tm.removeRow(0);
                  }
              }


              try
              {
                  con= new DBConn().getConnection();
                   smt=con.createStatement();

                   rs = smt.executeQuery("select * from ASSET where asset_name='" +
                                         txtFindName.getText()+"'");
                   while(rs.next())