realtorinfoframe.java~13~

来自「软件工程实践项目」· JAVA~13~ 代码 · 共 252 行

package homerealtysystem;

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

import com.borland.dx.sql.dataset.*;
import java.sql.ResultSet;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import com.borland.jbcl.layout.*;
import com.borland.dbswing.*;
import javax.swing.border.*;



/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2005</p>
 * <p>Company: </p>
 * @author 刘庆
 * @version 1.0
 */

public class RealtorInfoFrame extends JFrame {
  JPanel jPanel1 = new JPanel();
  JButton jButton2 = new JButton();
  JButton jButton1 = new JButton();
  XYLayout xYLayout1 = new XYLayout();
  DBbean db=new DBbean();       //实例化dbBean
  ResultSet rs=null;              //定义一结果集
  ErrorMessage em=new ErrorMessage();  //出错处理
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JLabel jLabel6 = new JLabel();
  JLabel jLabel8 = new JLabel();
 // JLabel jLabel16 = new JLabel(new ImageIcon(".\\test.jpg"));
  JTextField jTextField1 = new JTextField();
  JTextField jTextField2 = new JTextField();
  JTextField jTextField3 = new JTextField();
  JTextField jTextField4 = new JTextField();
  JTextField jTextField5 = new JTextField();
  JTextField jTextField6 = new JTextField();
  JPasswordField jPasswordField1 = new JPasswordField();
  String CurrentUser = new String();

  public RealtorInfoFrame(String Username) throws HeadlessException {
    CurrentUser = Username;
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  private void jbInit() throws Exception {
    this.getContentPane().setLayout(xYLayout1);
    jPanel1.setFont(new java.awt.Font("Dialog", 0, 16));
    jPanel1.setDebugGraphicsOptions(0);
    jPanel1.setLayout(null);
    jButton2.setBounds(new Rectangle(177, 424, 113, 31));
    jButton2.setFont(new java.awt.Font("Dialog", 0, 16));
    jButton2.setText("取消并返回");
    jButton2.addActionListener(new RealtorInfoFrame_jButton2_actionAdapter(this));
    jButton1.setBounds(new Rectangle(54, 424, 113, 31));
    jButton1.setFont(new java.awt.Font("Dialog", 0, 16));
    jButton1.setText("修改并保存");
    jButton1.addActionListener(new RealtorInfoFrame_jButton1_actionAdapter(this));
    this.setLocale(java.util.Locale.getDefault());
    xYLayout1.setWidth(349);
    xYLayout1.setHeight(480);
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel1.setText("经理人ID");
    jLabel1.setBounds(new Rectangle(28, 25, 68, 23));
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel2.setText("代理人名字");
    jLabel2.setBounds(new Rectangle(11, 57, 88, 17));
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel3.setText("密码");
    jLabel3.setBounds(new Rectangle(35, 83, 47, 17));
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel4.setText("客户留言");
    jLabel4.setBounds(new Rectangle(25, 108, 81, 22));
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel5.setText("EMail");
    jLabel5.setBounds(new Rectangle(25, 139, 91, 18));
    jLabel6.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel6.setText("信用等级");
    jLabel6.setBounds(new Rectangle(25, 165, 81, 23));
    jLabel8.setBounds(new Rectangle(6, 196, 110, 18));
    jLabel8.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel8.setText("所拥有房屋数");
    jTextField1.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextField1.setPreferredSize(new Dimension(11, 28));
    jTextField1.setEditable(false);
    jTextField1.setScrollOffset(0);
    jTextField1.setBounds(new Rectangle(115, 24, 207, 24));
    jTextField2.setBounds(new Rectangle(114, 192, 210, 24));
    jTextField2.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextField3.setBounds(new Rectangle(115, 51, 207, 24));
    jTextField3.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextField4.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextField4.setBounds(new Rectangle(114, 160, 209, 24));
    jTextField5.setBounds(new Rectangle(114, 107, 208, 24));
    jTextField5.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextField6.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextField6.setBounds(new Rectangle(114, 134, 209, 24));
    jPasswordField1.setFont(new java.awt.Font("Dialog", 0, 16));
    jPasswordField1.setBounds(new Rectangle(114, 78, 208, 24));
    jPanel1.add(jLabel1, null);
    jPanel1.add(jLabel2, null);
    jPanel1.add(jLabel4, null);
    jPanel1.add(jLabel5, null);
    jPanel1.add(jLabel3, null);
    jPanel1.add(jLabel6, null);
    jPanel1.add(jLabel8, null);
    jPanel1.add(jTextField1, null);
    jPanel1.add(jTextField3, null);
    jPanel1.add(jTextField4, null);
    jPanel1.add(jTextField6, null);
    jPanel1.add(jTextField5, null);
    jPanel1.add(jTextField2, null);
    jPanel1.add(jPasswordField1, null);
    jPanel1.add(jButton2, null);
    jPanel1.add(jButton1, null);
    this.getContentPane().add(jPanel1,    new XYConstraints(4, 4, 333, 457));
    pack();
    getInfo();
  }

  void getInfo()
  {
    try {
      rs = db.executeQuery("select * from 代理人信息表 where 代理人信息表.\"代理人名字\"='" +
                           CurrentUser + "'");
      if (!rs.next()) { //判断是否存在
        JOptionPane.showMessageDialog(RealtorInfoFrame.this, "内部错误：代理人名丢失",
                                      "内部错误：代理人名丢失", 1);
      }
      else {
        rs.previous(); // 使指针返回到ResultSet对象的开始
        ResultSetMetaData data = rs.getMetaData(); // 定义ResultSetMetaData对象data
        int col = data.getColumnCount(); // 获取列数
        while (rs.next()) { // 显示数据
          for (int i = 1; i <= col; i++) {
            switch(i)
            {
             case 1: jTextField1.setText(rs.getString(i));break;
             case 2: jTextField3.setText(rs.getString(i));break;
             case 3: jPasswordField1.setText(rs.getString(i));break;
             case 4: jTextField5.setText(rs.getString(i));break;
             case 5: jTextField6.setText(rs.getString(i));break;
             case 6: jTextField4.setText(rs.getString(i));break;
             case 7: jTextField2.setText(rs.getString(i));break;
             default:
               JOptionPane.showMessageDialog(RealtorInfoFrame.this, "内部错误：多余的数据库信息 : " + rs.getString(i),
                                      "内部错误：多余的数据库信息 : " + rs.getString(i), 1);
            }
          }
        }
        rs.close(); // 关闭结果集
      }
    }
    catch (SQLException ex) { // 捕捉异常
      System.out.println("\nERROR:----- SQLException -----\n");
      while (ex != null) {
        System.out.println("Message:   " + ex.getMessage());
        System.out.println("SQLState:  " + ex.getSQLState());
        System.out.println("ErrorCode: " + ex.getErrorCode());
        ex = ex.getNextException();
      }
    }
  }

  void jButton2_actionPerformed(ActionEvent e) {
    GetFrmLocation gfl=new GetFrmLocation();//实例化GetFrmLocatin
    RealtorMainFrame frame=new RealtorMainFrame(CurrentUser);//实例化下一个frame
    gfl.get_location(frame);                //让frame显示在屏幕中心
    frame.show();                          //frame的显示
    this.dispose();                        //本窗体的退出
  }

  void jButton1_actionPerformed(ActionEvent e) {
    try {
      rs = db.executeQuery("select * from 代理人信息表 where 代理人ID=" + Long.valueOf(jTextField1.getText()));
      if (!rs.next()) { //判断是否存在
        JOptionPane.showMessageDialog(RealtorInfoFrame.this, "内部错误：代理人ID错误 ：" + Long.valueOf(jTextField1.getText()),
                                      "内部错误：代理人ID错误 ：" + Long.valueOf(jTextField1.getText()), 1);
      }
      else {
        rs.close(); // 关闭结果集
        rs=db.executeQuery("update 代理人信息表 set 代理人名字 = '" + jTextField3.getText() + "'," +
                        "密码 = '" + jPasswordField1.getText() + "'," +
                        "客户留言 = '" + jTextField5.getText() + "'," +
                        "EMail = '" + jTextField6.getText() + "'," +
                        "信用等级 = '" + jTextField4.getText() + "'," +
                        "所拥有房屋数 = " + Long.valueOf(jTextField2.getText()) +" " +
                        "where 代理人ID = " + Long.valueOf(jTextField1.getText()));
        rs.close();
        JOptionPane.showMessageDialog(RealtorInfoFrame.this, "修改成功!",
                                      "修改成功!", 1);
      }
    }
    catch (SQLException ex) { // 捕捉异常
      System.out.println("\nERROR:----- SQLException -----\n");
      while (ex != null) {
        System.out.println("Message:   " + ex.getMessage());
        System.out.println("SQLState:  " + ex.getSQLState());
        System.out.println("ErrorCode: " + ex.getErrorCode());
        ex = ex.getNextException();
      }
    }


    GetFrmLocation gfl=new GetFrmLocation();//实例化GetFrmLocatin
    RealtorMainFrame frame=new RealtorMainFrame(CurrentUser);//实例化下一个frame
    gfl.get_location(frame);                //让frame显示在屏幕中心
    frame.show();                          //frame的显示
    this.dispose();                        //本窗体的退出
  }
}

class RealtorInfoFrame_jButton1_actionAdapter implements java.awt.event.ActionListener {
  RealtorInfoFrame adaptee;

  RealtorInfoFrame_jButton1_actionAdapter(RealtorInfoFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class RealtorInfoFrame_jButton2_actionAdapter implements java.awt.event.ActionListener {
  RealtorInfoFrame adaptee;

  RealtorInfoFrame_jButton2_actionAdapter(RealtorInfoFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}