uerinpanel.java

来自「一个网吧管理系统程序」· Java 代码 · 共 162 行

package bar;

import java.awt.*;
import javax.swing.*;
import java.sql.*;
import java.awt.event.*;
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class uerInPanel extends JPanel {
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JComboBox jComboBox1 = new JComboBox();
  JTextField jTextField1 = new JTextField();
  JTextField jTextField2 = new JTextField();
  JPasswordField jPasswordField1 = new JPasswordField();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();

  public uerInPanel(mainFrame mFrame) {
    try {
           Frame1=mFrame;
      jbInit();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }
  void jbInit() throws Exception {
    jLabel1.setFont(new java.awt.Font("Serif", 1, 15));
    jLabel1.setHorizontalAlignment(SwingConstants.CENTER);
    jLabel1.setText("机器号码：");
    jLabel1.setBounds(new Rectangle(29, 22, 86, 37));
    this.setLayout(null);
    jLabel2.setFont(new java.awt.Font("Serif", 1, 15));
    jLabel2.setHorizontalAlignment(SwingConstants.CENTER);
    jLabel2.setText("卡号：");
    jLabel2.setBounds(new Rectangle(21, 72, 80, 35));
    jLabel3.setFont(new java.awt.Font("Serif", 1, 15));
    jLabel3.setHorizontalAlignment(SwingConstants.CENTER);
    jLabel3.setText("密码：");
    jLabel3.setBounds(new Rectangle(20, 127, 87, 36));
    jLabel4.setFont(new java.awt.Font("Serif", 1, 15));
    jLabel4.setHorizontalAlignment(SwingConstants.CENTER);
    jLabel4.setText("开始时间：");
    jLabel4.setBounds(new Rectangle(16, 190, 94, 36));
    jComboBox1.setBounds(new Rectangle(113, 21, 167, 30));
    jTextField1.setText("");
    jTextField1.setBounds(new Rectangle(118, 73, 168, 34));
    jTextField2.setBounds(new Rectangle(114, 191, 182, 30));
    jPasswordField1.setText("");
    jPasswordField1.setBounds(new Rectangle(117, 131, 173, 36));
    jButton1.setBounds(new Rectangle(61, 245, 100, 34));
    jButton1.setFont(new java.awt.Font("Serif", 1, 13));
    jButton1.setText("确定");
    jButton1.addActionListener(new uerInPanel_jButton1_actionAdapter(this));
    jButton2.setBounds(new Rectangle(213, 243, 89, 32));
    jButton2.setFont(new java.awt.Font("Serif", 1, 13));
    jButton2.setText("重置");
    jButton2.addActionListener(new uerInPanel_jButton2_actionAdapter(this));
    this.add(jLabel1, null);
    this.add(jLabel2, null);
    this.add(jLabel3, null);
    this.add(jLabel4, null);
    this.add(jTextField1, null);
    this.add(jTextField2, null);
    this.add(jPasswordField1, null);
    this.add(jComboBox1, null);
    this.add(jButton1, null);
    this.add(jButton2, null);

     Connection con=barConnect.getconn();
    Statement stmt=con.createStatement();
    query="select * from ComputerIDView order by ComputerID";
    ResultSet rs=stmt.executeQuery(query);
    jComboBox1.addItem("");
    while(rs.next())
    {jComboBox1.addItem(rs.getString("ComputerID"));}
    con.close();
  }
  private String CardID;
  private Connection con;
  private ResultSet rs1;
  private Statement querystmt;
  private String query;
  private String loginquery;
  private String passwordtemp;
  private Statement insertStmt;
  private String insertstring;
  private mainFrame Frame1;

  void jButton1_actionPerformed(ActionEvent e) {
    try{
    String passwordtemp = "";
    for(int i=0;i<jPasswordField1.getPassword().length;i++){
      passwordtemp += jPasswordField1.getPassword()[i];
    }
    if(jTextField2.getText().trim() != ""){
     querystmt = con.createStatement();
      loginquery = "select * from Card where CardID = " +
          Integer.parseInt(jTextField2.getText().trim()) +
          " and password = " + passwordtemp;
      ResultSet rs1 =querystmt.executeQuery(loginquery);
      if (rs1.next()) {
        insertStmt = con.createStatement();
        insertstring =
            "INSERT INTO Event (CardID, ComputerID, BeginTime) VALUES (" +
            Integer.parseInt(jTextField2.getText().trim()) + ", " +
            Integer.parseInt(jComboBox1.getSelectedItem().toString()) + ", '" +
            jTextField2.getText() + ":00')";
        int rs2 = insertStmt.executeUpdate(insertstring);
      }
      else {
        jTextField1.setText("卡号或者密码不对。");
      }
      rs1.close();
    }
    con.close();
  }
  catch(SQLException ex){
    System.out.print("系统错误，请检测数据库。");
  }

}

  void jButton2_actionPerformed(ActionEvent e) {
    jComboBox1.setSelectedIndex(0);
    jTextField1.setText("");
    jPasswordField1.setText("");
    jTextField2.setText("");

  }
}
class uerInPanel_jButton1_actionAdapter implements java.awt.event.ActionListener {
  uerInPanel adaptee;

  uerInPanel_jButton1_actionAdapter(uerInPanel adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
   }

class uerInPanel_jButton2_actionAdapter implements java.awt.event.ActionListener {
  uerInPanel adaptee;

  uerInPanel_jButton2_actionAdapter(uerInPanel adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}