usermainframe.java~135~

软件工程实践项目

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 UserMainFrame extends JFrame {
  private JButton jButton2 = new JButton();
  private JButton jButton4 = new JButton();
  private JButton jButton3 = new JButton();
  private QueryDataSet queryDataSet = new QueryDataSet();
  private Database mydatabase = new Database();
  private JPanel Search_a_house_jPanel = new JPanel();
  private String[] s_QueryMode={"城市","邮编"};       //定义一数组，加载到jComboBox中
  private JComboBox querymode_CmbBx = new JComboBox(s_QueryMode);
  private JLabel jLabel1 = new JLabel();
  private JButton jButton5 = new JButton();
  private XYLayout xYLayout1 = new XYLayout();
  private JTextField query_txt = new JTextField();
  private JdbTable jdbTable1 = new JdbTable();
  JButton jButton6 = new JButton();
  JButton jButton7 = new JButton();
  JButton jButton8 = new JButton();
  JButton jButton9 = new JButton();
  JButton jButton1 = new JButton();
  JTextField house_id_jtextfield = new JTextField();
  JLabel jLabel2 = new JLabel();
  DBbean db=new DBbean();       //实例化dbBean
  ResultSet rs=null;              //定义一结果集
  ErrorMessage em=new ErrorMessage();  //出错处理
  JScrollPane table_scroll;
  TitledBorder titledBorder1;
  JTextArea info_jTextArea = new JTextArea();
  String CurrentUser = new String();
  JButton jButton10 = new JButton();

  public UserMainFrame(String Username) throws HeadlessException {
    CurrentUser = Username;
    pack();
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  private void jbInit() throws Exception {
    titledBorder1 = new TitledBorder("");
    this.getContentPane().setLayout(xYLayout1);

    mydatabase.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:HomeRealtySystemDB", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    queryDataSet.setReadOnly(true);
    queryDataSet.setEditable(false);
    queryDataSet.setEnableInsert(false);
    queryDataSet.setEnableUpdate(false);
    queryDataSet.setEnableDelete(false);
    queryDataSet.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(mydatabase,
        "SELECT 房屋信息表.\"房屋ID\",房屋信息表.\"城市\",房屋信息表.\"邮编\",房屋信息表.\"房屋描述\",房屋信息表.\"户型\",房屋信息表.\"总面积\",房屋信息表.\"售价(平方)\",房屋信息表.\"所属经理人\" " +
        "FROM 房屋信息表", null, true, Load.ALL));

    jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_NEXT_COLUMN);
    jdbTable1.setDataSet(queryDataSet);
    jdbTable1.setEditable(false);

    jButton2.setText("维持个人计划");
    jButton2.addActionListener(new UserMainFrame_jButton2_actionAdapter(this));
    jButton2.setFont(new java.awt.Font("Dialog", 0, 16));
    jButton3.setFont(new java.awt.Font("Dialog", 0, 16));
    jButton3.setMaximumSize(new Dimension(129, 31));
    jButton3.setMinimumSize(new Dimension(129, 31));
    jButton3.setText("寻找经理人");
    jButton3.addActionListener(new UserMainFrame_jButton3_actionAdapter(this));
    jButton4.setText("申请住房贷款");
    jButton4.addActionListener(new UserMainFrame_jButton4_actionAdapter(this));
    jButton4.setFont(new java.awt.Font("Dialog", 0, 16));
    Search_a_house_jPanel.setLayout(null);
    querymode_CmbBx.setFont(new java.awt.Font("Dialog", 0, 16));
    querymode_CmbBx.setBounds(new Rectangle(225, 180, 61, 23));
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel1.setText("选择搜索方式");
    jLabel1.setBounds(new Rectangle(123, 183, 102, 18));
    jButton5.setBounds(new Rectangle(438, 179, 74, 27));
    jButton5.setFont(new java.awt.Font("Dialog", 0, 16));
    jButton5.setText("搜索");
    jButton5.addActionListener(new UserMainFrame_jButton5_actionAdapter(this));
    this.setDefaultCloseOperation(HIDE_ON_CLOSE);
    this.setLocale(java.util.Locale.getDefault());
    this.setTitle("欢迎使用");
    query_txt.setFont(new java.awt.Font("Dialog", 0, 16));
    query_txt.setText("");
    query_txt.setBounds(new Rectangle(301, 181, 117, 24));
    jdbTable1.setFont(new java.awt.Font("Dialog", 0, 16));
    jdbTable1.setMinimumSize(new Dimension(1000, 200));
    jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_NEXT_COLUMN);
    jdbTable1.setDataSet(queryDataSet);
    jdbTable1.setBounds(new Rectangle(9, 16, 767, 126));
    jButton6.setBounds(new Rectangle(522, 180, 101, 25));
    jButton6.setFont(new java.awt.Font("Dialog", 0, 16));
    jButton6.setText("所有房屋");
    jButton6.addActionListener(new UserMainFrame_jButton6_actionAdapter(this));
    jButton7.setBounds(new Rectangle(463, 212, 173, 34));
    jButton7.setFont(new java.awt.Font("Dialog", 0, 16));
    jButton7.setText("获取详细信息");
    jButton7.addActionListener(new UserMainFrame_jButton7_actionAdapter(this));
    jButton8.setText("");
    xYLayout1.setWidth(807);
    xYLayout1.setHeight(615);
    jButton8.setBounds(new Rectangle(272, 402, 198, 34));
    jButton8.setFont(new java.awt.Font("Dialog", 0, 16));
    jButton8.setText("加入我的个人计划");
    jButton8.addActionListener(new UserMainFrame_jButton8_actionAdapter(this));
    jButton9.setFont(new java.awt.Font("Dialog", 0, 16));
    jButton9.setText("发送邮件给经理人");
    jButton9.addActionListener(new UserMainFrame_jButton9_actionAdapter(this));
    Search_a_house_jPanel.setMaximumSize(new Dimension(33000, 33000));
    jButton1.setBounds(new Rectangle(681, 434, 98, 37));
    jButton1.setFont(new java.awt.Font("Dialog", 0, 16));
    jButton1.setText("退出");
    jButton1.setVerticalAlignment(javax.swing.SwingConstants.CENTER);
    jButton1.addActionListener(new UserMainFrame_jButton1_actionAdapter(this));
    house_id_jtextfield.setFont(new java.awt.Font("Dialog", 0, 16));
    house_id_jtextfield.setText("");
    house_id_jtextfield.setBounds(new Rectangle(259, 215, 167, 29));
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel2.setText("请输入房屋编号：");
    jLabel2.setBounds(new Rectangle(100, 216, 136, 28));
    table_scroll = new JScrollPane(jdbTable1);
    table_scroll.setBounds(new Rectangle(9, 16, 767, 126));
    info_jTextArea.setFont(new java.awt.Font("Dialog", 0, 16));
    info_jTextArea.setDebugGraphicsOptions(0);
    info_jTextArea.setColumns(2);
    info_jTextArea.setLineWrap(true);
    info_jTextArea.setBounds(new Rectangle(10, 262, 759, 132));
    jButton10.setBounds(new Rectangle(572, 436, 102, 34));
    jButton10.setFont(new java.awt.Font("Dialog", 0, 16));
    jButton10.setMaximumSize(new Dimension(97, 31));
    jButton10.setText("重新登陆");
    jButton10.addActionListener(new UserMainFrame_jButton10_actionAdapter(this));
    this.getContentPane().add(Search_a_house_jPanel,      new XYConstraints(14, 128, 787, 478));
    Search_a_house_jPanel.add(jdbTable1, null);
    Search_a_house_jPanel.add(jButton5, null);
    Search_a_house_jPanel.add(jButton6, null);
    Search_a_house_jPanel.add(querymode_CmbBx, null);
    Search_a_house_jPanel.add(query_txt, null);
    Search_a_house_jPanel.add(jLabel1, null);
    Search_a_house_jPanel.add(jButton7, null);
    Search_a_house_jPanel.add(jLabel2, null);
    Search_a_house_jPanel.add(house_id_jtextfield, null);
    Search_a_house_jPanel.add(table_scroll,null);
    Search_a_house_jPanel.add(jButton8, null);
    this.getContentPane().add(jButton2, new XYConstraints(191, 38, 190, 42));
    this.getContentPane().add(jButton3,  new XYConstraints(417, 38, 192, 42));
    this.getContentPane().add(jButton9, new XYConstraints(190, 86, 191, 42));
    this.getContentPane().add(jButton4, new XYConstraints(417, 85, 192, 43));
    Search_a_house_jPanel.add(info_jTextArea, null);
    Search_a_house_jPanel.add(jButton1, null);
    Search_a_house_jPanel.add(jButton10, null);
    pack();
  }

  void jButton1_actionPerformed(ActionEvent e) {
    System.exit(0);
  }

  void jButton5_actionPerformed(ActionEvent e) {
   String s_txt=query_txt.getText();
   String s_cmbbx=(String)querymode_CmbBx.getSelectedItem();
   if (!em.isEmpty(s_txt))            //判断输入是否为空
     {
       if(s_cmbbx.equals("城市"))      //按城市查询方式查询
       {
           try{
                                        //查询输入城市
           rs=db.executeQuery("select \"城市\" from 房屋信息表 where 房屋信息表.\"城市\"='"+s_txt+"'");
           if(rs.next()){               //判断是否存在
             queryDataSet.close();     //清空jdbTable1中存放的结果集queryDataSet1
                                        //按城市查询得到的新的结果集，放入queryDataSet1中
             queryDataSet.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
      mydatabase, "SELECT 房屋信息表.\"房屋ID\",房屋信息表.\"城市\",房屋信息表.\"邮编\",房屋信息表.\"房屋描述\",房屋信息表.\"户型\",房屋信息表.\"总面积\",房屋信息表.\"售价(平方)\",房屋信息表.\"所属经理人\" " +
        "FROM 房屋信息表 where 房屋信息表.\"城市\"='"+s_txt+"'", null, true, Load.ALL));

        jdbTable1.setDataSet(queryDataSet);  //将queryDataSet装入jdbTable中
         rs.close();
           }
           else{
             JOptionPane.showMessageDialog(null, "查无此项纪录");
           }
           }catch(Exception ee){}

        }
       else{
         try{

         rs=db.executeQuery("select \"邮编\" from 房屋信息表 where \"邮编\"='"+s_txt+"'");
        if(rs.next()){         //判断查询的邮编是否存在
         queryDataSet.close();     //将结果集queryDataSet清空
                               //按输入的邮编查询并返回结果集存入queryDataSet中
       queryDataSet.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(mydatabase,
           "SELECT 房屋信息表.\"房屋ID\",房屋信息表.\"城市\",房屋信息表.\"邮编\",房屋信息表.\"房屋描述\",房屋信息表.\"户型\",房屋信息表.\"总面积\",房屋信息表.\"售价(平方)\",房屋信息表.\"所属经理人\" " +
        "FROM 房屋信息表 where 房屋信息表.\"邮编\"='"+s_txt+"' ", null, true, Load.ALL));
            jdbTable1.setDataSet(queryDataSet);   ////将queryDataSet1装入jdbTable中
            rs.close();
             }else{
             JOptionPane.showMessageDialog(null, "查无此项纪录");
             }
         }
             catch(Exception ee){}
                   }
     }
     else{
       JOptionPane.showMessageDialog(null, "查询不能为空，请按查询方式输入相应的查询条件");
     }

  }

  void jButton6_actionPerformed(ActionEvent e) {
    queryDataSet.close();            //清空
                                      //进行新的查询
     queryDataSet.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(mydatabase,
         "SELECT 房屋信息表.\"房屋ID\",房屋信息表.\"城市\",房屋信息表.\"邮编\",房屋信息表.\"房屋描述\",房屋信息表.\"户型\",房屋信息表.\"总面积\",房屋信息表.\"售价(平方)\",房屋信息表.\"所属经理人\" " +
        "FROM 房屋信息表", null, true, Load.ALL));
       jdbTable1.setDataSet(queryDataSet);
  }

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

  void jButton7_actionPerformed(ActionEvent e) {
    if (!em.isEmpty(house_id_jtextfield.getText()))            //判断输入是否为空
    {
      try {
        rs=db.executeQuery("select * from 房屋信息表 where 房屋信息表.\"房屋ID\"="+Long.valueOf(house_id_jtextfield.getText()));
        if(!rs.next()){               //判断是否存在
          JOptionPane.showMessageDialog(UserMainFrame.this, "数据库中没有您查询的房屋编号",
                                        "数据库中没有您查询的房屋编号！", 1);
        }
        else {