findrealtorframe.java~21~

软件工程实践项目

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 not attributable
 * @version 1.0
 */

public class FindRealtorFrame extends JFrame {
  JPanel jPanel1 = new JPanel();
  JLabel jLabel1 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JButton jButton1 = new JButton();
  JTextArea jTextArea1 = new JTextArea();
  JButton jButton2 = new JButton();
  XYLayout xYLayout1 = new XYLayout();
  JdbTextArea jdbTextArea1 = new JdbTextArea();
  DBbean db=new DBbean();       //实例化dbBean
  ResultSet rs=null;              //定义一结果集
  ErrorMessage em=new ErrorMessage();  //出错处理

  public FindRealtorFrame() throws HeadlessException {
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  private void jbInit() throws Exception {
    this.getContentPane().setLayout(xYLayout1);
    jPanel1.setLayout(null);
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel1.setRequestFocusEnabled(true);
    jLabel1.setText("输入经理人姓名：");
    jLabel1.setBounds(new Rectangle(23, 107, 133, 29));
    jTextField1.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextField1.setText("");
    jTextField1.setBounds(new Rectangle(169, 109, 151, 23));
    jButton1.setBounds(new Rectangle(344, 106, 153, 27));
    jButton1.setFont(new java.awt.Font("Dialog", 0, 16));
    jButton1.setText("查看经理人信息");
    jButton1.addActionListener(new FindRealtorFrame_jButton1_actionAdapter(this));
    jTextArea1.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextArea1.setForeground(Color.black);
    jTextArea1.setDoubleBuffered(false);
    jTextArea1.setMinimumSize(new Dimension(60, 18));
    jTextArea1.setOpaque(true);
    jTextArea1.setEditable(false);
    jTextArea1.setSelectedTextColor(Color.white);
    jTextArea1.setText("");
    jTextArea1.setLineWrap(false);
    jTextArea1.setBounds(new Rectangle(26, 150, 471, 233));
    jButton2.setBounds(new Rectangle(170, 410, 172, 37));
    jButton2.setFont(new java.awt.Font("Dialog", 0, 16));
    jButton2.setText("返回");
    jButton2.addActionListener(new FindRealtorFrame_jButton2_actionAdapter(this));
    xYLayout1.setWidth(561);
    xYLayout1.setHeight(496);
    jdbTextArea1.setEnabled(true);
    jdbTextArea1.setFont(new java.awt.Font("Dialog", 0, 16));
    jdbTextArea1.setEditable(false);
    jdbTextArea1.setText("");
    jdbTextArea1.setBounds(new Rectangle(28, 21, 468, 69));
    jPanel1.add(jTextArea1, null);
    jPanel1.add(jButton2, null);
    jPanel1.add(jdbTextArea1, null);
    jPanel1.add(jButton1, null);
    jPanel1.add(jLabel1, null);
    jPanel1.add(jTextField1, null);
    this.getContentPane().add(jPanel1,  new XYConstraints(4, 7, 532, 494));
    pack();

    try {
    rs=db.executeQuery("select 代理人名字 from 代理人信息表");
    String name_str = new String();
    if(rs.next()){               //判断是否存在
      name_str = "现有代理人 ： ";
      rs.previous(); // 使指针返回到ResultSet对象的开始
      ResultSetMetaData data = rs.getMetaData(); // 定义ResultSetMetaData对象data
      int col = data.getColumnCount(); // 获取列数
      while (rs.next()) { // 显示数据
        for (int i = 1; i <= col; i++) {
          name_str += rs.getString(i) + "  ";
        }
      }
      rs.close(); // 关闭结果集
    }
    else
    {
       name_str = "对不起，暂无代理人信息！";
    }
    jdbTextArea1.setText(name_str);
    }
    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
    UserMainFrame frame=new UserMainFrame();            //实例化下一个frame
    gfl.get_location(frame);                //让frame显示在屏幕中心
    frame.show();                          //frame的显示
    this.dispose();                        //本窗体的退出
  }

  void jButton1_actionPerformed(ActionEvent e) {
    if (!em.isEmpty(jTextField1.getText())) { //判断输入是否为空
      try {
        rs = db.executeQuery("select 代理人ID,代理人名字,EMail,信用等级,所拥有房屋数 from 代理人信息表 where 代理人信息表.\"代理人名字\"='" +
                             String.valueOf(jTextField1.getText()) + "'" );
        if (!rs.next()) { //判断是否存在
          JOptionPane msg = new JOptionPane();
          JOptionPane.showMessageDialog(FindRealtorFrame.this, "数据库中没有您查询的代理人姓名",
                                        "数据库中没有您查询的代理人姓名！", 1);
        }
        else {
          rs.previous(); // 使指针返回到ResultSet对象的开始
          ResultSetMetaData data = rs.getMetaData(); // 定义ResultSetMetaData对象data
          int col = data.getColumnCount(); // 获取列数
          String info = new String();
          while (rs.next()) { // 显示数据
            for (int i = 1; i <= col; i++) {
              info += data.getColumnName(i) + " : ";
              info += rs.getString(i) + "\n";
            }
          }
          jTextArea1.setText(info);
          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();
        }
      }
      catch (Exception ex) {
        ex.printStackTrace();
      }
    }
    else {
      JOptionPane.showMessageDialog(null, "查询不能为空，请按查询方式输入相应的查询条件");
    }

  }

}

class FindRealtorFrame_jButton2_actionAdapter implements java.awt.event.ActionListener {
  FindRealtorFrame adaptee;

  FindRealtorFrame_jButton2_actionAdapter(FindRealtorFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}

class FindRealtorFrame_jButton1_actionAdapter implements java.awt.event.ActionListener {
  FindRealtorFrame adaptee;

  FindRealtorFrame_jButton1_actionAdapter(FindRealtorFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}