operatorconfig.java

以一个酒店的进销存系统为例

package com.csbook.restaurant;

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
import com.csbook.restaurant.utility.*;
import com.borland.dbswing.*;
import com.borland.dx.sql.dataset.*;
import com.borland.dx.dataset.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author pengtao
 * @version 1.0
 */

public class OperatorConfig extends JInternalFrame {

  JPanel jPanel1 = new JPanel();
  JPanel jPanel3 = new JPanel();
  JTextField PICNo = new JTextField();
  JPasswordField password = new JPasswordField();
  JLabel jLabel4 = new JLabel();
  JTextField userID = new JTextField();
  JComboBox userType = new JComboBox();
  JTextField address = new JTextField();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel7 = new JLabel();
  GridLayout gridLayout1 = new GridLayout(4,4);
  JLabel jLabel2 = new JLabel();
  JLabel jLabel6 = new JLabel();
  JTextField username = new JTextField();
  JPanel panel1 = new JPanel();
  JLabel jLabel9 = new JLabel();
  JTextField tel = new JTextField();
  JLabel jLabel5 = new JLabel();
  JLabel jLabel8 = new JLabel();
  JPanel jPanel2 = new JPanel();
  BorderLayout borderLayout1 = new BorderLayout();
  Database database1 = new Database();
  JPanel jPanel4 = new JPanel();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  BorderLayout borderLayout2 = new BorderLayout();
  JButton cancel = new JButton();

  JPanel jPanel5 = new JPanel();
  FlowLayout flowLayout1 = new FlowLayout();
  JButton ok = new JButton();
  JButton deleteUser = new JButton();
  JdbNavToolBar DBNavToolBar = new JdbNavToolBar();
  JTextField remark = new JTextField();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  JdbTable jdbTable1 = new JdbTable();
  Column column1 = new Column();
  Column column2 = new Column();
  Column column3 = new Column();
  Column column4 = new Column();
  Column column5 = new Column();
  Column column6 = new Column();
  Column column7 = new Column();
  JButton modify = new JButton();
  DBDisposeMonitor dBDisposeMonitor1 = new DBDisposeMonitor();

  public OperatorConfig(String title,boolean resizable,boolean closable,boolean maximizable,boolean iconifiable) {
    super(title,resizable,closable,maximizable,iconifiable);
    try {
      jbInit();
      pack();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    PICNo.setText("");
    password.setText("");
    jLabel4.setRequestFocusEnabled(true);
    jLabel4.setText("用户初始密码：");
    userID.setText("");
    address.setText("");
    jLabel1.setText("用户ID：");
    jLabel3.setText("联系电话：");
    jLabel7.setText("身份证号：");
    jLabel2.setText("联系地址：");
    jLabel6.setText("用户姓名：");
    username.setText("");
    panel1.setLayout(gridLayout1);
    jLabel9.setText("备注");
    tel.setText("");
    jLabel5.setText("用户类型：");
    jLabel8.setText("请输入新用户的信息");
    jPanel3.setLayout(borderLayout1);
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Restaurant", "user", "user", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
    jPanel4.setLayout(borderLayout2);
    cancel.setText("关闭窗口");
    cancel.addActionListener(new OperatorConfig_cancel_actionAdapter(this));
    jPanel5.setLayout(flowLayout1);
    ok.setText("增加用户");
    ok.addActionListener(new OperatorConfig_ok_actionAdapter(this));
    deleteUser.setActionCommand("jButton1");
    deleteUser.setText("删除用户");
    deleteUser.addActionListener(new OperatorConfig_deleteUser_actionAdapter(this));
    remark.setText("");
    queryDataSet1.setMetaDataUpdate(MetaDataUpdate.NONE);
    queryDataSet1.setTableName("operator");
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT operator.id,operator.name,operator.type,operator.tel,operator.addr,operator.PICNo,operator.rem" +
      "ark FROM Restaurant.dbo.operator", null, true, Load.ALL));
    jdbTable1.setDataSet(queryDataSet1);
    column1.setColumnName("id");
    column1.setDataType(com.borland.dx.dataset.Variant.STRING);
    column1.setPrecision(25);
    column1.setRowId(true);
    column1.setSchemaName("dbo");
    column1.setTableName("operator");
    column1.setServerColumnName("id");
    column1.setSqlType(1);
    column2.setColumnName("name");
    column2.setDataType(com.borland.dx.dataset.Variant.STRING);
    column2.setPrecision(25);
    column2.setSchemaName("dbo");
    column2.setTableName("operator");
    column2.setServerColumnName("name");
    column2.setSqlType(1);
    column3.setColumnName("type");
    column3.setDataType(com.borland.dx.dataset.Variant.STRING);
    column3.setPrecision(10);
    column3.setSchemaName("dbo");
    column3.setTableName("operator");
    column3.setServerColumnName("type");
    column3.setSqlType(1);
    column4.setColumnName("tel");
    column4.setDataType(com.borland.dx.dataset.Variant.STRING);
    column4.setPrecision(15);
    column4.setSchemaName("dbo");
    column4.setTableName("operator");
    column4.setServerColumnName("tel");
    column4.setSqlType(1);
    column5.setColumnName("addr");
    column5.setDataType(com.borland.dx.dataset.Variant.STRING);
    column5.setPrecision(50);
    column5.setSchemaName("dbo");
    column5.setTableName("operator");
    column5.setServerColumnName("addr");
    column5.setSqlType(1);
    column6.setColumnName("PICNo");
    column6.setDataType(com.borland.dx.dataset.Variant.STRING);
    column6.setPrecision(18);
    column6.setSchemaName("dbo");
    column6.setTableName("operator");
    column6.setServerColumnName("PICNo");
    column6.setSqlType(1);
    column7.setColumnName("remark");
    column7.setDataType(com.borland.dx.dataset.Variant.STRING);
    column7.setPrecision(255);
    column7.setSchemaName("dbo");
    column7.setTableName("operator");
    column7.setServerColumnName("remark");
    column7.setSqlType(1);
    queryDataSet1.setColumns(new Column[] {column1, column2, column3, column4, column5, column6, column7});
    modify.setText("修改用户信息");
    modify.addActionListener(new OperatorConfig_modify_actionAdapter(this));
    DBNavToolBar.setVisible(false);
    DBNavToolBar.setButtonStatePost(JdbNavToolBar.AUTO_ENABLED);
    this.getContentPane().add(jPanel1,  BorderLayout.SOUTH);
    jPanel1.add(modify, null);
    jPanel1.add(cancel, null);
    this.getContentPane().add(jPanel3,  BorderLayout.NORTH);
    jPanel3.add(jPanel2,  BorderLayout.NORTH);
    jPanel2.add(jLabel8, null);
    jPanel3.add(panel1, BorderLayout.CENTER);
    panel1.add(jLabel1, null);
    panel1.add(userID, null);
    panel1.add(jLabel6, null);
    panel1.add(username, null);
    panel1.add(jLabel5, null);
    panel1.add(userType, null);
    panel1.add(jLabel4, null);
    panel1.add(password, null);
    panel1.add(jLabel3, null);
    panel1.add(tel, null);
    panel1.add(jLabel2, null);
    panel1.add(address, null);
    panel1.add(jLabel7, null);
    panel1.add(PICNo, null);
    panel1.add(jLabel9, null);
    panel1.add(remark, null);
    this.getContentPane().add(jPanel4, BorderLayout.CENTER);
    jPanel4.add(tableScrollPane1,  BorderLayout.CENTER);
    tableScrollPane1.getViewport().add(jdbTable1, null);
    jPanel4.add(jPanel5, BorderLayout.NORTH);
    jPanel5.add(ok, null);
    jPanel5.add(deleteUser, null);
    jPanel4.add(DBNavToolBar,  BorderLayout.SOUTH);
    userType.addItem("operator");
    userType.addItem("manager");
    userType.addItem("sa");
   }

  void ok_actionPerformed(ActionEvent e) {
    String id = userID.getText();
    //检查用户名是否为空,如为空,提示用户输入用户名
    if(id.trim().equals("")){
      JOptionPane.showMessageDialog(this, "用户名不能为空！", "警告",
                                    JOptionPane.ERROR_MESSAGE);
      return;
    }
    String name = username.getText();
    String userT = (String) userType.getSelectedItem();
    String telephone = tel.getText();
    String addr = address.getText();
    char temp[]=password.getPassword();
    String pass=new String(temp);
    String PIC = PICNo.getText();
    String note = remark.getText();
    CheckUser cUser = new CheckUser();
    boolean userExist=cUser.userExist(id);
    if(userExist)
    {
      JOptionPane.showMessageDialog(this, "系统中已存在该用户！", "错误",
                                    JOptionPane.ERROR_MESSAGE);
      return;
    }
    //调用CheckUser类中的方法添加用户
    cUser.addOperator(id,name,userT,pass,PIC,telephone,addr,note);
    //刷新列表显示
    JButton refreshButton=DBNavToolBar.getRefreshButton();
    refreshButton.doClick();
    //提示用户添加成功
    JOptionPane.showMessageDialog(this,"该用户已成功添加","提示",JOptionPane.PLAIN_MESSAGE);
  }

  void cancel_actionPerformed(ActionEvent e) {
     this.dispose();
  }

  void deleteUser_actionPerformed(ActionEvent e) {
    String id = userID.getText();
    //检查用户名是否为空,如为空,提示用户输入用户名
    if(id.trim().equals("")){
      JOptionPane.showMessageDialog(this, "用户名不能为空！", "警告",
                                    JOptionPane.ERROR_MESSAGE);
      return;
    }
    CheckUser cUser = new CheckUser();
    //检查系统中是否存在该用户
    if(!cUser.userExist(id))
    {
      JOptionPane.showMessageDialog(this, "系统中不存在该用户！", "错误",
                                    JOptionPane.ERROR_MESSAGE);
      return;
    }
    //调用CheckUser类中的方法删除用户
    boolean succeed=cUser.deleteOperator(id);
    if(!succeed)
      JOptionPane.showMessageDialog(this, "系统中存在与该用户相关的信息，现在不能删除该用户！", "错误",
                                    JOptionPane.ERROR_MESSAGE);
    else
    {
      //刷新列表显示
      JButton refreshButton=DBNavToolBar.getRefreshButton();
      refreshButton.doClick();
      JOptionPane.showMessageDialog(this, "已成功删除该用户！", "提示",
                                    JOptionPane.PLAIN_MESSAGE);
    }
  }

  void modify_actionPerformed(ActionEvent e) {
   JButton postButton=DBNavToolBar.getPostButton();
   postButton.doClick();
   JButton saveButton=DBNavToolBar.getSaveButton();
   saveButton.doClick();
   JOptionPane.showMessageDialog(this, "已成功提交修改信息！", "提示",
                                    JOptionPane.PLAIN_MESSAGE);
  }
}

class OperatorConfig_cancel_actionAdapter implements java.awt.event.ActionListener {
  OperatorConfig adaptee;

  OperatorConfig_cancel_actionAdapter(OperatorConfig adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.cancel_actionPerformed(e);
  }
}

class OperatorConfig_ok_actionAdapter implements java.awt.event.ActionListener {
  OperatorConfig adaptee;

  OperatorConfig_ok_actionAdapter(OperatorConfig adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.ok_actionPerformed(e);
  }
}

class OperatorConfig_deleteUser_actionAdapter implements java.awt.event.ActionListener {
  OperatorConfig adaptee;

  OperatorConfig_deleteUser_actionAdapter(OperatorConfig adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.deleteUser_actionPerformed(e);
  }
}

class OperatorConfig_modify_actionAdapter implements java.awt.event.ActionListener {
  OperatorConfig adaptee;

  OperatorConfig_modify_actionAdapter(OperatorConfig adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.modify_actionPerformed(e);
  }
}