usermainframe.java~135~

软件工程实践项目

          rs.previous(); // 使指针返回到ResultSet对象的开始
          ResultSetMetaData data = rs.getMetaData(); // 定义ResultSetMetaData对象data
          //house_id_jtextfield.setText(""); // 清空房屋编号文本框
          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) + "    ";
            }
          }
          info_jTextArea.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, "查询不能为空，请按查询方式输入相应的查询条件");
    }
 }

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

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

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

  void jButton8_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 {
          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) + "    ";
            }
          }
          //rs.close(); // 关闭结果集

          JOptionPane.showMessageDialog(UserMainFrame.this, CurrentUser,"",1);
          rs=db.executeQuery("select 个人购房计划1,个人购房计划2,个人购房计划3 from 用户信息表 where 用户信息表.\"用户名字\" = '" + CurrentUser +"'");
          rs.previous();// 使指针返回到ResultSet对象的开始
          ResultSetMetaData data2 = rs.getMetaData(); // 定义ResultSetMetaData对象data
          int col2 = data2.getColumnCount(); // 获取列数
          JOptionPane.showMessageDialog(UserMainFrame.this, String.valueOf(col2),"", 1);
          JOptionPane.showMessageDialog(UserMainFrame.this, rs.getString(1)+ rs.getString(2)+ rs.getString(3),
                                        "", 1);
          int i;
          for(i=1;i<=3;i++)
          {
            if(rs.getString(i).matches(""))
              break;
          }
          if(i<4)//个人计划还有空
          {
            switch (i) {
              case 1:
                db.executeQuery("update 用户信息表 set " +
                                "个人购房计划1 = '" + info + "'" +
                                "where 用户名字 = '" + CurrentUser + "'");
                break;
              case 2:
                db.executeQuery("update 用户信息表 set " +
                                "个人购房计划2 = '" + info + "'" +
                                "where 用户名字 = '" + CurrentUser + "'");
                break;
              case 3:
                db.executeQuery("update 用户信息表 set " +
                                "个人购房计划3 = '" + info + "'" +
                                "where 用户名字 = '" + CurrentUser + "'");
                break;
            }
            JOptionPane.showMessageDialog(UserMainFrame.this, "增加成功!  增加到个人购房计划" + i + "中",
                                          "增加成功!   增加到个人购房计划" + i + "中", 1);

          }
          else
          {
              JOptionPane.showMessageDialog(UserMainFrame.this, "您的个人计划已经填满,请删除后在添加!",
                                        "您的个人计划已经填满,请删除后在添加！", 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();
        }
      }
      catch (Exception ex) {
        ex.printStackTrace();
      }
    }
    else{
      JOptionPane.showMessageDialog(null, "查询不能为空，请按查询方式输入相应的查询条件");
    }
  }

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

}

class UserMainFrame_jButton5_actionAdapter implements java.awt.event.ActionListener {
  UserMainFrame adaptee;

  UserMainFrame_jButton5_actionAdapter(UserMainFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton5_actionPerformed(e);
  }
}

class UserMainFrame_jButton6_actionAdapter implements java.awt.event.ActionListener {
  UserMainFrame adaptee;

  UserMainFrame_jButton6_actionAdapter(UserMainFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton6_actionPerformed(e);
  }
}

class UserMainFrame_jButton2_actionAdapter implements java.awt.event.ActionListener {
  UserMainFrame adaptee;

  UserMainFrame_jButton2_actionAdapter(UserMainFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}

class UserMainFrame_jButton7_actionAdapter implements java.awt.event.ActionListener {
  UserMainFrame adaptee;

  UserMainFrame_jButton7_actionAdapter(UserMainFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton7_actionPerformed(e);
  }
}

class UserMainFrame_jButton3_actionAdapter implements java.awt.event.ActionListener {
  UserMainFrame adaptee;

  UserMainFrame_jButton3_actionAdapter(UserMainFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}

class UserMainFrame_jButton4_actionAdapter implements java.awt.event.ActionListener {
  UserMainFrame adaptee;

  UserMainFrame_jButton4_actionAdapter(UserMainFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton4_actionPerformed(e);
  }
}

class UserMainFrame_jButton8_actionAdapter implements java.awt.event.ActionListener {
  UserMainFrame adaptee;

  UserMainFrame_jButton8_actionAdapter(UserMainFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton8_actionPerformed(e);
  }
}

class UserMainFrame_jButton9_actionAdapter implements java.awt.event.ActionListener {
  UserMainFrame adaptee;

  UserMainFrame_jButton9_actionAdapter(UserMainFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton9_actionPerformed(e);
  }
}

class UserMainFrame_jButton1_actionAdapter implements java.awt.event.ActionListener {
  UserMainFrame adaptee;

  UserMainFrame_jButton1_actionAdapter(UserMainFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class UserMainFrame_jButton10_actionAdapter implements java.awt.event.ActionListener {
  UserMainFrame adaptee;

  UserMainFrame_jButton10_actionAdapter(UserMainFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton10_actionPerformed(e);
  }
}