useoutdialog.java~4~

来自「一个网吧管理系统程序」· JAVA~4~ 代码 · 共 115 行

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 useOutDialog extends JDialog {
  JPanel panel1 = new JPanel();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JComboBox jComboBox1 = new JComboBox();
  JTextField jTextField1 = new JTextField();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();

  public useOutDialog(Frame frame, String title, boolean modal) {
    super(frame, title, modal);
    try {
      jbInit();
      pack();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  public useOutDialog() {
    this(null, "", false);
  }
  private void jbInit() throws Exception {
    panel1.setLayout(null);
    jLabel1.setFont(new java.awt.Font("Serif", 1, 13));
    jLabel1.setHorizontalAlignment(SwingConstants.CENTER);
    jLabel1.setText("机器号：");
    jLabel1.setBounds(new Rectangle(61, 42, 88, 30));
    jLabel2.setEnabled(true);
    jLabel2.setFont(new java.awt.Font("Serif", 1, 13));
    jLabel2.setForeground(Color.black);
    jLabel2.setHorizontalAlignment(SwingConstants.CENTER);
    jLabel2.setText("结束时间");
    jLabel2.setBounds(new Rectangle(50, 89, 95, 30));
    jComboBox1.setBounds(new Rectangle(150, 45, 113, 24));
    jTextField1.setText("");
    jTextField1.setBounds(new Rectangle(147, 91, 116, 26));
    jButton1.setBounds(new Rectangle(68, 138, 87, 29));
    jButton1.setFont(new java.awt.Font("Serif", 1, 12));
    jButton1.setText("确定");
    jButton1.addActionListener(new useOutDialog_jButton1_actionAdapter(this));
    jButton2.setBounds(new Rectangle(172, 137, 90, 28));
    jButton2.setFont(new java.awt.Font("Serif", 1, 12));
    jButton2.setText("重置");
    getContentPane().add(panel1);
    panel1.add(jLabel1, null);
    panel1.add(jLabel2, null);
    panel1.add(jComboBox1, null);
    panel1.add(jTextField1, null);
    panel1.add(jButton1, null);
    panel1.add(jButton2, null);

    con=barConnect1.getconn();
    stmt=con.createStatement();
    queryCID="select * from Event where EndTime is null order by ComputerID";
    rs=stmt.executeQuery(queryCID);
    jComboBox1.addItem("");
    while(rs.next())
         {  jComboBox1.addItem(rs.getString("ComputerID"));
         }
         rs.close();
         con.close();
       }
  private barConnect barConnect1;
  private Connection con;
  private Statement stmt;
  private ResultSet rs;
  private String queryCID;
  private Statement insertStmt;
  private String insertString;
  private  int rs1;
  private mainFrame Frame1;

  void jButton1_actionPerformed(ActionEvent e) {
try{
      insertString="update Event set EndTime='"+jTextField1.getText()+":00'where ComputerID="+Integer.parseInt(jComboBox1.getSelectedItem().toString())+" and EndTime is null";
    rs1=insertStmt.executeUpdate(insertString);
    if(rs1==1)
       {Frame1.SetComputerID(Integer.parseInt(jComboBox1.getSelectedItem().toString()));
         this.hide();
        }
        }
    catch (SQLException ex)
        {Frame1.SetComputerID(0);}
  }

}

class useOutDialog_jButton1_actionAdapter implements java.awt.event.ActionListener {
  useOutDialog adaptee;

  useOutDialog_jButton1_actionAdapter(useOutDialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}