admadd.java

这是一个用jbuilder2005编写的图书管理系统

package bookmanage;

import java.awt.*;
import javax.swing.*;
import java.awt.Rectangle;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import java.sql.SQLException;
import java.sql.ResultSet;

/**
 * <p>Title: 图书管理系统</p>
 *
 * <p>Description: AdmAdd类继承JDialog，主要是用来增加管理员</p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: 浙江工业大学信息学院计算机系</p>
 *
 * @author 曾文秋
 * @version 1.0
 */
public class AdmAdd
    extends JDialog {
  TextVerifier tv=new TextVerifier(10);//限制文本框中最多只能输入10个字符
  TextVerifier tv1=new TextVerifier(15);
  TextVerifier tv2=new TextVerifier(15);
  TextVerifier tv3=new TextVerifier(2);
  JLabel jLabel1 = new JLabel();
  JTextField jTextFieldName = new JTextField();//用户名
  JLabel jLabel2 = new JLabel();
  JComboBox jComboBoxType = new JComboBox();//用户类型
  JPasswordField jTextFieldPassword = new JPasswordField();//密码
  JLabel jLabel3 = new JLabel();
  JPasswordField jTextFieldAffirmPassword = new JPasswordField();//确认密码
  JButton jButtonAdd = new JButton();
  JButton jButtonCancel = new JButton();

  //定义结果集
  ResultSet rs;
  //定义数据库操作对象
  private DBManager db = new DBManager();
  JTextField jTextFieldWorkTime = new JTextField();
  JLabel jLabel5 = new JLabel();
  JTextField jTextFieldTelphone = new JTextField();
  JLabel jLabel6 = new JLabel();
  JLabel jLabel8 = new JLabel();
  JLabel jLabel11 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JTextField jTextFieldXingMing = new JTextField();
  public AdmAdd(Frame owner, String title, boolean modal) {
    super(owner, title, modal);
    try {
      setDefaultCloseOperation(DISPOSE_ON_CLOSE);
      jbInit();
      pack();
    }
    catch (Exception exception) {
      exception.printStackTrace();
    }
  }

  public AdmAdd() {
    this(new Frame(), "AdmAdd", false);
  }

  /**
   * 初始化界面
   * @throws Exception
   */
  private void jbInit() throws Exception {
    this.getContentPane().setLayout(null);
    jLabel1.setText("用户名：");
    jLabel1.setBounds(new Rectangle(56, 24, 56, 23));
    jTextFieldName.setDocument(tv);
    jTextFieldName.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButtonAdd_actionPerformed(e);
      }
    });
    jLabel2.setText("用户类型：");
    jLabel2.setBounds(new Rectangle(56, 66, 62, 23));
    jComboBoxType.setBounds(new Rectangle(145, 66, 89, 23));
    //jComboBoxType.addItem("超级管理员");
    jComboBoxType.addItem("管理员");
    jTextFieldPassword.setDocument(tv1);
    jTextFieldPassword.setBounds(new Rectangle(145, 108, 89, 23));
    jTextFieldPassword.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButtonAdd_actionPerformed(e);
      }
    });
    jLabel3.setText("密码：");
    jLabel3.setBounds(new Rectangle(56, 108, 56, 23));
    jTextFieldAffirmPassword.setDocument(tv2);
    jTextFieldAffirmPassword.setBounds(new Rectangle(145, 150, 89, 23));
    jTextFieldAffirmPassword.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButtonAdd_actionPerformed(e);
      }
    });
    jButtonAdd.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButtonAdd_actionPerformed(e);
      }
    });
    jButtonCancel.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButtonCancel_actionPerformed(e);
      }
    });
    this.setTitle("增加管理员");
    jButtonCancel.setBounds(new Rectangle(152, 319, 81, 23));
    jButtonCancel.setText("取消");
    jButtonAdd.setBounds(new Rectangle(56, 319, 81, 23));
    jButtonAdd.setText("增加");
    jTextFieldWorkTime.setDocument(tv3);
    jTextFieldWorkTime.setBounds(new Rectangle(145, 224, 89, 23));
    jTextFieldWorkTime.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButtonAdd_actionPerformed(e);
      }
    });
    jLabel5.setText("工作时间：");
    jLabel5.setBounds(new Rectangle(56, 224, 65, 23));
    jTextFieldTelphone.setBounds(new Rectangle(145, 266, 89, 23));
    jTextFieldTelphone.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButtonAdd_actionPerformed(e);
      }
    });
    jLabel6.setText("电话号码：");
    jLabel6.setBounds(new Rectangle(56, 266, 62, 23));
    jLabel8.setText("确认密码：");
    jLabel8.setBounds(new Rectangle(56, 150, 76, 23));
    jLabel4.setText("姓名：");
    jLabel4.setBounds(new Rectangle(54, 186, 76, 23));
    jTextFieldXingMing.setBounds(new Rectangle(146, 186, 89, 23));
    jTextFieldXingMing.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButtonAdd_actionPerformed(e);
      }
    });
    this.getContentPane().add(jTextFieldName);
    this.getContentPane().add(jTextFieldAffirmPassword);
    this.getContentPane().add(jLabel3);
    this.getContentPane().add(jTextFieldPassword);
    this.getContentPane().add(jComboBoxType);
    this.getContentPane().add(jLabel2);
    this.getContentPane().add(jLabel1);
    this.getContentPane().add(jLabel8);
    this.getContentPane().add(jButtonAdd);
    this.getContentPane().add(jButtonCancel);
    this.getContentPane().add(jTextFieldWorkTime);
    this.getContentPane().add(jLabel5);
    this.getContentPane().add(jLabel6);
    this.getContentPane().add(jTextFieldTelphone);
    this.getContentPane().add(jLabel4);
    this.getContentPane().add(jTextFieldXingMing);
    jTextFieldName.setBounds(new Rectangle(145, 24, 89, 23));
  }

  public void jButtonAdd_actionPerformed(ActionEvent e) {
    String Name=null;
    String Password=null;
    String AffirmPassword=null;
    String Type=null;
    String XingMing=null;
    String WorkTime=null;
    String Telephone=null;
    Name=jTextFieldName.getText().trim();
    Password=new String(jTextFieldPassword.getPassword()).trim();
    AffirmPassword=new String(jTextFieldAffirmPassword.getPassword()).trim();
    Type=jComboBoxType.getSelectedItem().toString().trim();
    XingMing=jTextFieldXingMing.getText().trim();
    WorkTime=jTextFieldWorkTime.getText().trim();
    Telephone=jTextFieldTelphone.getText().trim();
    String strSQL;
    //校验用户名是否为空
    if (Name.equals("")) {
      JOptionPane.showMessageDialog(AdmAdd.this, "用户名不许为空！");
      return;
    }
    //校验密码是否为空
    if (Password.equals("")) {
      JOptionPane.showMessageDialog(AdmAdd.this, "密码不许为空！");
      return;
    }
    //校验两次输入的密码是否一致
    if (!Password.equals(AffirmPassword)) {
      JOptionPane.showMessageDialog(AdmAdd.this, "两次输入的密码不一致，请重新输入密码和确认密码！");
      jTextFieldPassword.setText("");
      jTextFieldAffirmPassword.setText("");
      return;
    }
    //校验姓名是否为空
    if(XingMing.equals("")){
      JOptionPane.showMessageDialog(AdmAdd.this, "姓名不许为空！");
      return;
    }
    //生成sql操作语句，查询要添加的用户名是否已经存在，若存在执行删除，若不存在提示并返回
    strSQL = "select * from administrator where id='" + Name + "'";
    rs = db.getResult(strSQL);
    boolean isexist = false;
    try {
      isexist = rs.first();
    }
    catch (SQLException ex1) {
    }
    //若用户名存在，提示警告信息
    if (isexist){
      JOptionPane.showMessageDialog(AdmAdd.this, "用户名已存在,请重新写一个用户名！");
      jTextFieldName.setText("");
      return;
    }
    else {
      //然后执行插入操作
      strSQL="insert into administrator values('" + Name + "','"+Password+"','"+XingMing+"','"
          +Type+"','"+WorkTime+"','"+Telephone+"')";
      //由数据库操作对象执行数据库操作，并返回操作成功失败的提示信息
      if (db.executeSql(strSQL)) {
        JOptionPane.showMessageDialog(AdmAdd.this, "成功添加！");
        this.dispose();
      }
      else {
        JOptionPane.showMessageDialog(AdmAdd.this, " 添加失败，请重新操作！");
      }
    }
    db.close();
  }

  public void jButtonCancel_actionPerformed(ActionEvent e) {
    this.dispose();
  }

}