ownerinfo.java~22~

java房产管理系统

import javax.swing.*;
import java.awt.*;
import com.borland.jbcl.layout.*;
import java.awt.event.*;
import java.sql.*;

public class OwnerInfo
    extends JFrame {
  JButton btnExit = new JButton();
  JLabel jLabel8 = new JLabel();
  JButton btnAdd = new JButton();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JButton btnSave = new JButton();
  JTextField txtOrg = new JTextField();
  JTextField txtWorkTime = new JTextField();
  JLabel jLabel9 = new JLabel();
  JButton btnDelete = new JButton();
  JButton btnEdit = new JButton();
  JTextField txtBirthday = new JTextField();
  JTextField txtName = new JTextField();
  JPanel jPanel1 = new JPanel();
  XYLayout xYLayout2 = new XYLayout();
  JLabel jLabel10 = new JLabel();
  JComboBox cboGender = new JComboBox();
  XYLayout xYLayout1 = new XYLayout();

  DBManager db = new DBManager(); //数据库操作
  String operType = new String(); //操作类型
  String curID = new String();

  public OwnerInfo() {
    try {
      jbInit();
      initForm();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  public OwnerInfo(String ID) {
    try {
      jbInit();
      setCurID(ID);
      initForm();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  void jbInit() throws Exception {
    jPanel1.setBorder(BorderFactory.createEtchedBorder());
    jPanel1.setLayout(xYLayout2);
    txtName.setFont(new java.awt.Font("宋体", 0, 12));
    txtName.setText("");
    txtBirthday.setText("");
    txtBirthday.setFont(new java.awt.Font("宋体", 0, 12));
    btnEdit.setText("修改");
    btnEdit.setFont(new java.awt.Font("宋体", 0, 12));
    btnDelete.setText("删除");
    btnDelete.setFont(new java.awt.Font("宋体", 0, 12));
    jLabel9.setText("工作时间：");
    jLabel9.setFont(new java.awt.Font("宋体", 0, 12));
    txtWorkTime.setText("");
    txtWorkTime.setFont(new java.awt.Font("宋体", 0, 12));
    txtOrg.setFont(new java.awt.Font("宋体", 0, 12));
    txtOrg.setText("");
    btnSave.setText("保存");
    btnSave.addActionListener(new OwnerInfo_btnSave_actionAdapter(this));
    btnSave.setFont(new java.awt.Font("宋体", 0, 12));
    jLabel2.setText("单位：");
    jLabel2.setFont(new java.awt.Font("宋体", 0, 12));
    jLabel1.setFont(new java.awt.Font("宋体", 0, 12));
    jLabel1.setText("出生年月：");
    btnAdd.setFont(new java.awt.Font("宋体", 0, 12));
    btnAdd.setText("新增");
    btnAdd.addActionListener(new OwnerInfo_btnAdd_actionAdapter(this));
    jLabel8.setText("姓名：");
    jLabel8.setRequestFocusEnabled(true);
    jLabel8.setFont(new java.awt.Font("宋体", 0, 12));
    btnExit.setText("退出");
    btnExit.addActionListener(new OwnerInfo_btnExit_actionAdapter(this));
    btnExit.setFont(new java.awt.Font("宋体", 0, 12));
    this.getContentPane().setLayout(xYLayout1);
    jLabel10.setText("性别：");
    jLabel10.setFont(new java.awt.Font("宋体", 0, 12));
    cboGender.setFont(new java.awt.Font("宋体", 0, 12));
    xYLayout1.setWidth(435);
    xYLayout1.setHeight(218);
    this.setTitle("房主信息维护");
    jPanel1.add(jLabel1, new XYConstraints(13, 57, 68, 18));
    jPanel1.add(txtBirthday, new XYConstraints(75, 51, 112, 24));
    jPanel1.add(jLabel9, new XYConstraints(203, 54, 61, 17));
    jPanel1.add(jLabel2, new XYConstraints(13, 92, 53, 17));
    jPanel1.add(jLabel8, new XYConstraints(13, 20, 49, 18));
    jPanel1.add(txtName, new XYConstraints(75, 16, 111, 24));
    jPanel1.add(jLabel10, new XYConstraints(203, 22, 49, 18));
    jPanel1.add(txtOrg, new XYConstraints(75, 91, 305, 24));
    jPanel1.add(cboGender, new XYConstraints(267, 19, 112, 24));
    jPanel1.add(txtWorkTime, new XYConstraints(267, 51, 112, 24));
    jPanel1.add(btnEdit, new XYConstraints(78, 134, 61, 27));
    jPanel1.add(btnAdd, new XYConstraints(14, 134, 61, 27));
    jPanel1.add(btnDelete, new XYConstraints(143, 134, 61, 27));
    jPanel1.add(btnSave, new XYConstraints(254, 134, 61, 27));
    jPanel1.add(btnExit, new XYConstraints(319, 134, 61, 27));
    this.getContentPane().add(jPanel1, new XYConstraints(17, 19, 400, 180));
  }

  void btnExit_actionPerformed(ActionEvent e) {
    if (!operType.equals("none")) {
      int ir = CommonDialog.showDialog(3, "房产管理系统", "当前操作尚未保存，确定要退出吗？");
      if (ir == 2) {
        return;
      }
    }
    this.dispose();
  }

  void setCurID(String ID) {
    curID = ID;
  }

  void setOperType(String type) {
    operType = type;
  }

  void btnAdd_actionPerformed(ActionEvent e) {
    groupSetEnabled(true);
    btnSetEnabled(true, false, false, true);
    if (!operType.equals("none")) {
      int ir = CommonDialog.showDialog(3, "房产管理系统", "当前操作尚未保存，确定要新增吗？");
      if (ir == 2) {
        return;
      }
      clearData();
      operType = "add";
    }

  }

  void initForm() {
    groupSetEnabled(false);
    db.fullCombo(cboGender, "Gender");
    if (!curID.equals("")) {
      fullInfo(curID);
      btnSetEnabled(true, true, true, false);
    }
    else {
      btnSetEnabled(true, false, false, false);
    }
  }

  void fullInfo(String ID) {
    String sql = "select * from OwnerInfo where ID='" + ID + "'";
    try {
      ResultSet rs = db.getResult(sql);
      if (rs.first()) {
        txtName.setText(rs.getString("Name"));
        cboGender.setSelectedIndex(Integer.parseInt(rs.getString("Gender")));
        txtBirthday.setText(rs.getString("Birthday"));
        txtWorkTime.setText(rs.getString("WorkTime"));
        txtOrg.setText(rs.getString("Org"));
      }
      else {
        rs.close();
      }
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  void groupSetEnabled(boolean enabled) {
    txtName.setEnabled(enabled);
    cboGender.setEnabled(enabled);
    txtBirthday.setEnabled(enabled);
    txtWorkTime.setEnabled(enabled);
    txtOrg.setEnabled(enabled);
  }

  void btnSetEnabled(boolean add, boolean edit, boolean delete, boolean save) {
    btnAdd.setEnabled(add);
    btnEdit.setEnabled(edit);
    btnDelete.setEnabled(delete);
    btnSave.setEnabled(save);
  }

  void clearData() {
    txtName.setText("");
    cboGender.setSelectedItem(null);
    txtBirthday.setText("");
    txtWorkTime.setText("");
    txtOrg.setText("");
  }

  boolean checkData() {
    if (txtName.getText().trim().equals("")) {
      CommonDialog.showDialog(CommonDialog.OK, "房产管理系统", "姓名不能为空！");
      txtName.setFocusable(true);
      return false;
    }
    return true;
  }

  void btnSave_actionPerformed(ActionEvent e) {
    if (!checkData()) {
      return;
    }
    String sql = new String();
    String id = new String();
    String gender = new String();

    if (cboGender.getSelectedIndex() >= 0) {
      gender = db.CodeDesConvert("Gender", "",
                                 cboGender.getSelectedItem().toString(), 0);
    }
    if (operType.equals("add")) {
      id = db.getID("BuildInfo");
      setCurID(id);
      sql = "insert into OwnerInfo values('" + id + "','" + txtName.getText() +
          "','" + gender + "','" + txtBirthday.getText() + "','" +
          txtWorkTime.getText() + "','" + txtOrg.getText() + "')";
    }
    else if (operType.equals("edit")) {
      sql = "update OwnerInfo set Name='" + txtName.getText() + "',";
      sql = sql + " Gender='" + gender + "',";
      sql = sql + " Birthday='" + txtBirthday.getText() + "',";
      sql = sql + " WorkTime='" + txtWorkTime.getText() + "',";
      sql = sql + " Org='" + txtOrg.getText() + "'";
      sql = sql + " where ID='" + curID + "'";
    }

    if (db.executeSql(sql)) {
      CommonDialog.showDialog(CommonDialog.OK, "房产管理系统", "新增房主信息成功！");
      groupSetEnabled(false);
      btnSetEnabled(true, true, true, false);
      setOperType("none");
    }
    else {
      CommonDialog.showDialog(CommonDialog.OK, "房产管理系统", "新增房主信息失败！");
    }
  }

}

class OwnerInfo_btnExit_actionAdapter
    implements java.awt.event.ActionListener {
  OwnerInfo adaptee;

  OwnerInfo_btnExit_actionAdapter(OwnerInfo adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btnExit_actionPerformed(e);
  }
}

class OwnerInfo_btnAdd_actionAdapter
    implements java.awt.event.ActionListener {
  OwnerInfo adaptee;

  OwnerInfo_btnAdd_actionAdapter(OwnerInfo adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btnAdd_actionPerformed(e);
  }
}

class OwnerInfo_btnSave_actionAdapter
    implements java.awt.event.ActionListener {
  OwnerInfo adaptee;

  OwnerInfo_btnSave_actionAdapter(OwnerInfo adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btnSave_actionPerformed(e);
  }
}