网吧计费管理系统

package halftoneintend; import java.awt.Dimension; import javax.swing.JFrame; import javax.swing.JPanel; import javax.swing.JMenuBar; import javax.swing.JMenu; import javax.swing.JMenuItem; import javax.swing.JLabel; import java.awt.*; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import javax.swing.JTextField; import javax.swing.JComboBox; import javax.swing.JButton; import javax.swing.JPasswordField; import java.sql.SQLException; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import javax.swing.JOptionPane; import java.awt.event.WindowEvent; import java.awt.event.WindowAdapter; /** * <p>Title: </p> * * <p>Description: 网吧计费系统</p> * * <p>Copyright: Copyright (c) 2007</p> * * <p>Company: JAVA项目第七组</p> * * @author JAVA项目第七组组长---杨金龙 * @version 1.0 */ public class Frame extends JFrame { int a , b; JPanel contentPane; JMenuBar mnuHalftone = new JMenuBar(); JMenu mnuUse = new JMenu(); JMenu mnuHelp = new JMenu(); JMenu mnuExit = new JMenu(); JMenuItem mnuGo = new JMenuItem(); JMenuItem mnuOut = new JMenuItem(); JMenuItem mnuAbout = new JMenuItem(); JMenuItem mnuQuit = new JMenuItem(); JLabel lblWelcome = new JLabel(); JLabel lblAuthor = new JLabel(); JPanel pnlRecord = new JPanel(); JLabel lblCmpID = new JLabel(); JLabel lblBeginTime = new JLabel(); JLabel lblCardID = new JLabel(); JLabel lblEndTime = new JLabel(); JLabel lblFee = new JLabel(); JLabel lblBalance = new JLabel(); JTextField txtCmpID = new JTextField(); JTextField txtCardID = new JTextField(); JTextField txtBeginTime = new JTextField(); JTextField txtEndTime = new JTextField(); JTextField txtFee = new JTextField(); JTextField txtBalance = new JTextField(); JPanel pnlWelcome = new JPanel(); JPanel pnlBegin = new JPanel(); JLabel lblOutID = new JLabel(); JLabel lblCardId = new JLabel(); JLabel lblPassword = new JLabel(); JLabel lblBegintime = new JLabel(); JComboBox cboCmpId = new JComboBox(); JTextField txtCardId = new JTextField(); JTextField txtBegintime = new JTextField(); JButton btnOk = new JButton(); JButton btnReSet = new JButton(); JPasswordField txtPassword = new JPasswordField(); JMenuItem mnuRwkCode = new JMenuItem(); JMenuItem mnuAddMoney = new JMenuItem(); JPanel pnlRwkCode = new JPanel(); JLabel lblOldPW = new JLabel(); JLabel lblNewPW = new JLabel(); JLabel lblAffirmPW = new JLabel(); JButton btnOkOk = new JButton(); JButton btnClear = new JButton(); JLabel lblCard = new JLabel(); JPasswordField txtOldPW = new JPasswordField(); JPasswordField txtNewPW = new JPasswordField(); JPasswordField txtAffirmPW = new JPasswordField(); JTextField txtCard = new JTextField(); JPanel pnlAddMoney = new JPanel(); JLabel lblWel = new JLabel(); JLabel lblYouCard = new JLabel(); JLabel lblMoney = new JLabel(); JTextField txtYouCard = new JTextField(); JTextField txtMoney = new JTextField(); JButton btnOKOKOK = new JButton(); JButton btnClearAll = new JButton(); JMenuItem mnuSeeBalance = new JMenuItem(); JPanel pnlSeeBalance = new JPanel(); JLabel lblSeeCard = new JLabel(); JLabel lblYouBalance = new JLabel(); JComboBox cboSeeCard = new JComboBox(); JTextField txtYouBalance = new JTextField(); JButton btnSeeOk = new JButton(); JButton btnSeeReset = new JButton(); JPanel pnlAddCard = new JPanel(); JLabel lblAddCard = new JLabel(); JLabel lblName = new JLabel(); JLabel lblAddPW = new JLabel(); JLabel lblRepeatPW = new JLabel(); JLabel lblAddMoney = new JLabel(); JTextField txtAddCard = new JTextField(); JTextField txtName = new JTextField(); JTextField txtAddMoney = new JTextField(); JButton btnAddOk = new JButton(); JButton btnAddReset = new JButton(); JLabel lblAddWelcome = new JLabel(); JMenuItem mnuAdd = new JMenuItem(); JLabel lblStudents = new JLabel(); JPasswordField txtAddPW = new JPasswordField(); JPasswordField txtRepeatPW = new JPasswordField(); JPanel pnlReportLoss = new JPanel(); JLabel lblSsName = new JLabel(); JLabel lblLossCard = new JLabel(); JLabel lblLossCode = new JLabel(); JTextField txtLossCard = new JTextField(); JPasswordField txtLossCode = new JPasswordField(); JButton btnReportOk = new JButton(); JButton btnReportReset = new JButton(); JMenuItem mnuReLoss = new JMenuItem(); /** * Frame构造方法 */ public Frame() { try { setDefaultCloseOperation(EXIT_ON_CLOSE); jbInit(); } catch (Exception exception) { exception.printStackTrace(); } } /** * Component initialization. * * @throws java.lang.Exception */ private void jbInit() throws Exception { contentPane = (JPanel) getContentPane(); contentPane.setLayout(null); this.getContentPane().setBackground(Color.white); this.setJMenuBar(mnuHalftone); setSize(new Dimension(468, 344)); setTitle("网吧计费管理系统"); this.addWindowListener(new Frame_this_windowAdapter(this)); mnuUse.setText("使用"); mnuGo.setText("上机"); mnuGo.addActionListener(new Frame_mnuGo_actionAdapter(this)); mnuOut.setText("下机"); mnuOut.addActionListener(new Frame_mnuOut_actionAdapter(this)); mnuHelp.setText("帮助"); mnuAbout.setText("关于"); mnuAbout.addActionListener(new Frame_mnuAbout_actionAdapter(this)); mnuExit.setText("退出"); mnuQuit.setText("退出"); mnuQuit.addActionListener(new Frame_mnuQuit_actionAdapter(this)); lblWelcome.setFont(new java.awt.Font("华文新魏", Font.BOLD, 30)); lblWelcome.setText("欢迎使用网吧计费管理系统"); lblWelcome.setBounds(new Rectangle(37, 60, 396, 30)); lblAuthor.setFont(new java.awt.Font("华文行楷", Font.BOLD, 18)); lblAuthor.setText("北大青鸟APTECH制作"); lblAuthor.setBounds(new Rectangle(137, 107, 196, 26)); mnuHalftone.setBackground(Color.lightGray); contentPane.setBackground(Color.lightGray); pnlRecord.setBounds(new Rectangle( -1, 0, 470, 344)); pnlRecord.setLayout(null); lblCmpID.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15)); lblCmpID.setText("机 器 号："); lblCmpID.setBounds(new Rectangle(90, 45, 93, 23)); lblBeginTime.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15)); lblBeginTime.setText("上机时间："); lblBeginTime.setBounds(new Rectangle(90, 105, 93, 23)); lblCardID.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15)); lblCardID.setText("卡 号："); lblCardID.setBounds(new Rectangle(90, 75, 93, 23)); lblEndTime.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15)); lblEndTime.setText("结束时间："); lblEndTime.setBounds(new Rectangle(90, 134, 93, 23)); lblFee.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15)); lblFee.setText("本次消费："); lblFee.setBounds(new Rectangle(90, 164, 93, 23)); lblBalance.setBackground(Color.white); lblBalance.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15)); lblBalance.setText("此卡余额："); lblBalance.setBounds(new Rectangle(90, 194, 93, 23)); txtCmpID.setEnabled(false); txtCmpID.setText(""); txtCmpID.setBounds(new Rectangle(211, 45, 116, 23)); txtCardID.setEnabled(false); txtCardID.setText(""); txtCardID.setBounds(new Rectangle(211, 75, 116, 23)); txtBeginTime.setEnabled(false);