网吧管理系统的设计与实现

package com.bu3g.Internet.Frame; import java.awt.Color; import java.awt.Component; import java.awt.GridLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.FocusAdapter; import java.awt.event.FocusEvent; import java.awt.event.MouseAdapter; import java.awt.event.MouseEvent; import java.sql.ResultSet; import java.sql.SQLException; import java.util.Date; import javax.swing.ImageIcon; import javax.swing.JButton; import javax.swing.JComboBox; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JPanel; import javax.swing.JPasswordField; import javax.swing.JScrollPane; import javax.swing.JTabbedPane; import javax.swing.JTable; import javax.swing.JTextField; import com.bu3g.Internet.db.DbUtil; class AddPanel extends JPanel { JLabel tishi, lab9, lab10, lab11, lab12, lab13, lab14, lab15, lab16, lab17; JTextField jt, jt3, jt4, jt5, jt6, jt7; JPasswordField jt2; Date d = new Date(); String name; JComboBox jc, jc2; int age; public AddPanel() { this.setLayout(null); JPanel p2 = new JPanel(); ImageIcon image = new ImageIcon("res/NewCardBackground.gif"); p2.setLayout(null); p2.setBounds(350, 0, 250, 400); JLabel bgcolor = new JLabel(image); bgcolor.setBounds(0, 0, 250, 400); JLabel bgcolor2 = new JLabel(image); bgcolor2.setBounds(0, 0, 350, 400); JLabel lab = new JLabel("用 户:"); lab.setForeground(Color.blue); lab.setBounds(30, 10, 70, 20); this.add(lab); jt = new JTextField(); jt.setBounds(100, 10, 120, 20); this.add(jt); JLabel lab2 = new JLabel("密 码:"); lab2.setForeground(Color.blue); lab2.setBounds(30, 40, 70, 20); this.add(lab2); jt2 = new JPasswordField(); jt2.setBounds(100, 40, 120, 20); this.add(jt2); JLabel lab21 = new JLabel("姓 名:"); lab21.setForeground(Color.blue); lab21.setBounds(30, 70, 70, 20); this.add(lab21); jt7 = new JTextField(); jt7.setBounds(100, 70, 120, 20); this.add(jt7); JLabel lab3 = new JLabel("性 别:"); lab3.setForeground(Color.blue); lab3.setBounds(30, 110, 70, 20); this.add(lab3); jc = new JComboBox(); jc.addItem("男"); jc.addItem("女"); jc.setBounds(100, 110, 120, 20); this.add(jc); JLabel lab4 = new JLabel("身份证:"); lab4.setForeground(Color.blue); lab4.setBounds(30, 150, 70, 20); this.add(lab4); tishi = new JLabel("*"); tishi.setForeground(Color.red); tishi.setBounds(220, 150, 180, 20); this.add(tishi); jt3 = new JTextField(); jt3.setBounds(100, 150, 120, 20); this.add(jt3); jt3.addFocusListener(new FocusAdapter() { public void focusGained(FocusEvent e) { tishi.setText("正确输入可获得年龄！"); } }); JLabel lab5 = new JLabel("年 龄:"); lab5.setForeground(Color.blue); lab5.setBounds(30, 180, 70, 20); this.add(lab5); jt4 = new JTextField(); jt4.setBounds(100, 180, 120, 20); this.add(jt4); JButton jb = new JButton("自动获取年龄"); jb.setBounds(220, 180, 120, 20); jb.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { if (!jt3.getText().trim().equals("") || jt3.getText() == null) { String str = jt3.getText(); String str2 = str.substring(6, 10); int year = d.getYear() + 1900; System.out.println(year); Integer i = new Integer(str2); System.out.println(i); age = year - i; System.out.println(age); jt4.setText("" + age + ""); } else { jt3.requestFocus(); JOptionPane.showMessageDialog(new JPanel(), "身份证不能为空！"); } } }); this.add(jb); JLabel lab6 = new JLabel("注册时间:"); lab6.setForeground(Color.blue); lab6.setBounds(30, 210, 70, 20); this.add(lab6); jt5 = new JTextField(); jt5.setBounds(100, 210, 120, 20); this.add(jt5); JButton jb2 = new JButton("自动获取时间"); jb2.setBounds(220, 210, 120, 20); jb2.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { jt5.setText((d.getYear() + 1900) + "-" + (d.getMonth() + 1) + "-" + d.getDate()); } }); this.add(jb2); JLabel lab7 = new JLabel("充值金额:"); lab7.setForeground(Color.blue); lab7.setBounds(30, 240, 70, 20); this.add(lab7); jc2 = new JComboBox(); jc2.addItem("100"); jc2.addItem("50"); jc2.addItem("30"); jc2.addItem("20"); jc2.addItem("10"); jc2.addItem("5"); jc2.setBounds(100, 240, 120, 20); this.add(jc2); JLabel lab8 = new JLabel("积 分:"); lab8.setForeground(Color.blue); lab8.setBounds(30, 270, 70, 20); this.add(lab8); lab9 = new JLabel("用 户:"); lab9.setForeground(Color.red); lab9.setBounds(30, 20, 200, 20); p2.add(lab9); lab10 = new JLabel("密 码:"); lab10.setForeground(Color.red); lab10.setBounds(30, 40, 200, 20); p2.add(lab10); lab17 = new JLabel("姓 名:"); lab17.setForeground(Color.red); lab17.setBounds(30, 70, 200, 20); p2.add(lab17); lab11 = new JLabel("性 别:"); lab11.setForeground(Color.red); lab11.setBounds(30, 100, 200, 20); p2.add(lab11); lab12 = new JLabel("身份证:"); lab12.setForeground(Color.red); lab12.setBounds(30, 130, 200, 20); p2.add(lab12); lab13 = new JLabel("年 龄:"); lab13.setForeground(Color.red); lab13.setBounds(30, 160, 200, 20); p2.add(lab13); lab14 = new JLabel("注册时间:"); lab14.setForeground(Color.red); lab14.setBounds(30, 190, 200, 20); p2.add(lab14); lab15 = new JLabel("充值金额:"); lab15.setForeground(Color.red); lab15.setBounds(30, 220, 200, 20); p2.add(lab15); lab16 = new JLabel("积 分:"); lab16.setForeground(Color.red); lab16.setBounds(30, 250, 200, 20); p2.add(lab16); jt6 = new JTextField(); jt6.setBounds(100, 270, 120, 20); this.add(jt6); JButton jb3 = new JButton("增加"); jb3.setBounds(50, 300, 70, 30); jb3.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { DbUtil db = new DbUtil(); String age1 = jt4.getText(); System.out.println(age1); int age2 = new Integer(age1); System.out.println(age2); String select = "select m_users from member where m_users='" + jt.getText() + "'"; System.out.println(select); try { ResultSet rs = db.query(select); while (rs.next()) { name = rs.getString(1); } rs.close(); } catch (SQLException e1) { } if (jt.getText().trim().equals("") || jt.getText() == null) { jt.requestFocus(); JOptionPane.showMessageDialog(new JPanel(), "用户名不能为空！"); } else if (jt2.getText().trim().equals("") || jt2.getText() == null) { jt2.requestFocus(); JOptionPane.showMessageDialog(new JPanel(), "密码不能为空！"); } else if (jt.getText().trim().equals(name)) { jt.setText(""); jt.requestFocus(); JOptionPane.showMessageDialog(new JPanel(), "用户名重复！"); } else if (age2 < 18 ){ System.out.println("age" + age); System.out.println("age2" + age2); JOptionPane.showMessageDialog(new JPanel(), "年龄不满18！"); } else { String insert = "insert into member values('" + jt.getText() + "','" + jt2.getText() + "','" + jt7.getText() + "','" + jc.getSelectedItem() + "','" + jt3.getText() + "'," + jt4.getText() + ",'" + jt5.getText() + "'," + jc2.getSelectedItem() + "," + jt6.getText() + ",2)"; System.out.println(insert); try { db.update(insert); lab9.setText(lab9.getText() + " " + jt.getText()); lab10.setText(lab10.getText() + " " + jt2.getText()); lab17.setText(lab17.getText() + " " + jt7.getText()); lab11.setText(lab11.getText() + " " + jc.getSelectedItem())