JAVA固定资产管理系统源码

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; import javax.swing.event.AncestorEvent; import javax.swing.event.AncestorListener; /** * <p>Title: </p> * * <p>Description: </p> * * <p>Copyright: Copyright (c) 2006</p> * * <p>Company: </p> * * @author not attributable * @version 1.0 */ public class MainFrame extends JFrame { JPanel contentPane; JMenuBar jMenuBar1 = new JMenuBar(); JMenu jMenuFile = new JMenu(); JMenuItem jMenuFileExit = new JMenuItem(); JMenuItem jMenuItem1 = new JMenuItem(); JMenuItem jMenuItem2 = new JMenuItem(); JMenu jMenu1 = new JMenu(); JMenuItem jMenuItem3 = new JMenuItem(); JMenuItem jMenuItem4 = new JMenuItem(); JMenuItem jMenuItem5 = new JMenuItem(); JMenu jMenu2 = new JMenu(); JMenuItem jMenuItem6 = new JMenuItem(); JMenuItem jMenuItem7 = new JMenuItem(); JMenuItem jMenuItem8 = new JMenuItem(); JPanel jPanel1 = new JPanel(); TitledBorder titledBorder1 = new TitledBorder(""); JLabel jLabel1 = new JLabel(); JTextField txtFindId = new JTextField(); VerticalFlowLayout verticalFlowLayout1 = new VerticalFlowLayout(); JLabel jLabel2 = new JLabel(); JTextField txtFindName = new JTextField(); JButton jButton1 = new JButton(); JButton jButton2 = new JButton(); JPanel jPanel2 = new JPanel(); JLabel jLabel3 = new JLabel(); JTextField txtJyDate = new JTextField(); JLabel jLabel4 = new JLabel(); JTextField txtName = new JTextField(); JLabel jLabel5 = new JLabel(); JTextField txtZcId = new JTextField(); JLabel jLabel6 = new JLabel(); JTextField txtStyle = new JTextField(); JLabel jLabel7 = new JLabel(); JTextField txtDlId = new JTextField(); JLabel jLabel8 = new JLabel(); JTextField txtZlId = new JTextField(); JLabel jLabel9 = new JLabel(); JTextField txtGhDate = new JTextField(); JLabel jLabel10 = new JLabel(); JTextField txtPrice = new JTextField(); JLabel jLabel11 = new JLabel(); JTextField txtGrDate = new JTextField(); JLabel jLabel12 = new JLabel(); JTextField txtStatus = new JTextField(); JLabel jLabel13 = new JLabel(); JTextField txtGrR = new JTextField(); JLabel jLabel14 = new JLabel(); JTextField txtContent = new JTextField(); JLabel jLabel15 = new JLabel(); JTextField txtJyR = new JTextField(); JLabel jLabel16 = new JLabel(); JTextField txtReturn = new JTextField(); JScrollPane jScrollPane1 = new JScrollPane(); JTable table; DefaultTableModel tm; JMenu jMenu3 = new JMenu(); JMenuItem jMenuItem9 = new JMenuItem(); JMenuItem jMenuItem10 = new JMenuItem(); Connection con = null; Statement smt = null; ResultSet rs = null; JButton jButton3 = new JButton(); JMenu jMenu4 = new JMenu(); JMenuItem jMenuItem11 = new JMenuItem(); public MainFrame() { try { setDefaultCloseOperation(EXIT_ON_CLOSE); Object[] o = {"资产编号", "资产名称", "大类编号", "子类编号", "样式", "价格", "购入日期", "状态", "购入人", "备注"}; tm = new DefaultTableModel(o, 0); table = new JTable(tm); jbInit(); } catch (Exception exception) { exception.printStackTrace(); } } /** * Component initialization. * * @throws java.lang.Exception */ private void jbInit() throws Exception { titledBorder1 = new TitledBorder("详细信息"); contentPane = (JPanel) getContentPane(); contentPane.setLayout(null); setSize(new Dimension(753, 554)); setTitle("资产管理系统"); jMenuFile.setFont(new java.awt.Font("宋体", Font.BOLD, 13)); jMenuFile.setText("固定资产管理"); jMenuFileExit.setFont(new java.awt.Font("宋体", Font.PLAIN, 12)); jMenuFileExit.setText("增加"); jMenuFileExit.addActionListener(new MainFrame_jMenuFileExit_ActionAdapter(this)); jMenuItem1.setFont(new java.awt.Font("宋体", Font.PLAIN, 12)); jMenuItem1.setText("删除"); jMenuItem1.addActionListener(new MainFrame_jMenuItem1_actionAdapter(this)); jMenuItem2.setFont(new java.awt.Font("宋体", Font.PLAIN, 12)); jMenuItem2.setText("修改"); jMenuItem2.addActionListener(new MainFrame_jMenuItem2_actionAdapter(this)); jMenu1.setFont(new java.awt.Font("宋体", Font.BOLD, 13)); jMenu1.setText("职工管理"); jMenuItem3.setFont(new java.awt.Font("宋体", Font.PLAIN, 12)); jMenuItem3.setText("增加"); jMenuItem3.addActionListener(new MainFrame_jMenuItem3_actionAdapter(this)); jMenuItem4.setFont(new java.awt.Font("宋体", Font.PLAIN, 12)); jMenuItem4.setText("删除"); jMenuItem4.addActionListener(new MainFrame_jMenuItem4_actionAdapter(this)); jMenuItem5.setFont(new java.awt.Font("宋体", Font.PLAIN, 12)); jMenuItem5.setText("修改"); jMenuItem5.addActionListener(new MainFrame_jMenuItem5_actionAdapter(this)); jMenu2.setFont(new java.awt.Font("宋体", Font.BOLD, 13)); jMenu2.setText("资产类别管理"); jMenuItem6.setFont(new java.awt.Font("宋体", Font.PLAIN, 12)); jMenuItem6.setText("增加"); jMenuItem6.addActionListener(new MainFrame_jMenuItem6_actionAdapter(this)); jMenuItem7.setFont(new java.awt.Font("宋体", Font.PLAIN, 12)); jMenuItem7.setText("删除"); jMenuItem7.addActionListener(new MainFrame_jMenuItem7_actionAdapter(this)); jMenuItem8.setFont(new java.awt.Font("宋体", Font.PLAIN, 12)); jMenuItem8.setText("修改"); jMenuItem8.addActionListener(new MainFrame_jMenuItem8_actionAdapter(this)); jPanel1.setBorder(titledBorder1); jPanel1.setPreferredSize(new Dimension(110, 79)); jPanel1.setBounds(new Rectangle(9, 13, 169, 322)); jPanel1.setLayout(verticalFlowLayout1); jLabel1.setText("以资产编号查询"); jLabel2.setText("以资产名称查询"); jButton1.setText("查 询"); jButton1.addActionListener(new MainFrame_jButton1_actionAdapter(this)); jButton2.setText("查 询"); jButton2.addActionListener(new MainFrame_jButton2_actionAdapter(this)); jPanel2.setBorder(titledBorder1); jPanel2.setBounds(new Rectangle(192, 13, 536, 323)); jPanel2.setLayout(null); jLabel3.setText("资产名称"); jLabel3.setBounds(new Rectangle(315, 24, 52, 21)); jLabel4.setText("资产编号"); jLabel4.setBounds(new Rectangle(40, 25, 66, 15)); txtJyDate.setBounds(new Rectangle(375, 221, 124, 22)); txtName.setBounds(new Rectangle(375, 23, 124, 22)); jLabel5.setText("大类编号"); jLabel5.setBounds(new Rectangle(40, 61, 63, 26)); txtZcId.setBounds(new Rectangle(98, 22, 91, 22)); jLabel6.setText("子类编号"); jLabel6.setBounds(new Rectangle(315, 67, 77, 15)); txtStyle.setBounds(new Rectangle(98, 101, 91, 22)); jLabel7.setText("样式"); jLabel7.setBounds(new Rectangle(40, 91, 63, 36)); txtDlId.setBounds(new Rectangle(98, 62, 91, 22)); jLabel8.setText("价格"); jLabel