addnewhorseframe.java~34~

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

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 AddNewHorseFrame 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 jLabel7 = new JLabel();
  JLabel jLabel8 = new JLabel();
  JLabel jLabel12 = new JLabel();
 // JLabel jLabel16 = new JLabel(new ImageIcon(".\\test.jpg"));
  JTextField jTextField2 = new JTextField();
  JTextField jTextField3 = new JTextField();
  JTextField jTextField4 = new JTextField();
  JTextField jTextField5 = new JTextField();
  JTextField jTextField6 = new JTextField();
  JTextField jTextField7 = new JTextField();
  JTextField jTextField9 = new JTextField();
  JTextArea jTextArea1 = new JTextArea();
  JTextField jTextField1 = new JTextField();
  String CurrentUser = new String();

  public AddNewHorseFrame(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(331, 425, 113, 31));
    jButton2.setFont(new java.awt.Font("Dialog", 0, 16));
    jButton2.setText("取消");
    jButton2.addActionListener(new AddNewHorseFrame_jButton2_actionAdapter(this));
    jButton1.setBounds(new Rectangle(200, 426, 113, 31));
    jButton1.setFont(new java.awt.Font("Dialog", 0, 16));
    jButton1.setText("增加");
    jButton1.addActionListener(new AddNewHorseFrame_jButton1_actionAdapter(this));
    this.setLocale(java.util.Locale.getDefault());
    xYLayout1.setWidth(655);
    xYLayout1.setHeight(480);
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel1.setText("房屋描述");
    jLabel1.setBounds(new Rectangle(23, 78, 68, 23));
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel2.setText("城市");
    jLabel2.setBounds(new Rectangle(35, 30, 73, 17));
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel3.setText("邮编");
    jLabel3.setBounds(new Rectangle(36, 53, 47, 17));
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel4.setText("地段");
    jLabel4.setBounds(new Rectangle(23, 220, 81, 22));
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel5.setText("户型");
    jLabel5.setBounds(new Rectangle(23, 251, 91, 18));
    jLabel6.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel6.setText("总面积");
    jLabel6.setBounds(new Rectangle(23, 277, 81, 23));
    jLabel7.setBounds(new Rectangle(23, 337, 81, 23));
    jLabel7.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel7.setText("所属经理人");
    jLabel8.setBounds(new Rectangle(23, 308, 91, 18));
    jLabel8.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel8.setText("售价(平方)");
    jLabel12.setBounds(new Rectangle(21, 370, 112, 18));
    jLabel12.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel12.setText("备注");
    jTextField2.setBounds(new Rectangle(112, 304, 133, 24));
    jTextField2.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextField2.setText("5600");
    jTextField3.setBounds(new Rectangle(114, 23, 133, 24));
    jTextField3.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextField3.setRequestFocusEnabled(true);
    jTextField3.setText("南京");
    jTextField4.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextField4.setText("86");
    jTextField4.setBounds(new Rectangle(112, 272, 133, 24));
    jTextField5.setBounds(new Rectangle(112, 219, 133, 24));
    jTextField5.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextField5.setText("珠江路5号");
    jTextField6.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextField6.setText("三室一厅");
    jTextField6.setBounds(new Rectangle(112, 246, 133, 24));
    jTextField7.setBounds(new Rectangle(111, 366, 133, 24));
    jTextField7.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextField7.setText("精装修");
    jTextField9.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextField9.setText("王洪");
    jTextField9.setBounds(new Rectangle(111, 334, 133, 24));
    jTextArea1.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextArea1.setText("");
    jTextArea1.setLineWrap(true);
    jTextArea1.setBounds(new Rectangle(111, 80, 504, 129));
    jTextField1.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextField1.setPreferredSize(new Dimension(62, 21));
    jTextField1.setToolTipText("");
    jTextField1.setText("210000");
    jTextField1.setBounds(new Rectangle(113, 50, 132, 28));
    jPanel1.add(jLabel1, null);
    jPanel1.add(jLabel3, null);
    jPanel1.add(jTextField3, null);
    jPanel1.add(jLabel2, null);
    jPanel1.add(jButton2, null);
    jPanel1.add(jButton1, null);
    jPanel1.add(jTextField5, null);
    jPanel1.add(jTextField7, null);
    jPanel1.add(jLabel7, null);
    jPanel1.add(jTextField9, null);
    jPanel1.add(jTextField2, null);
    jPanel1.add(jLabel8, null);
    jPanel1.add(jLabel6, null);
    jPanel1.add(jTextField4, null);
    jPanel1.add(jTextField6, null);
    jPanel1.add(jLabel5, null);
    jPanel1.add(jLabel4, null);
    jPanel1.add(jTextArea1, null);
    jPanel1.add(jTextField1, null);
    jPanel1.add(jLabel12, null);
    this.getContentPane().add(jPanel1,   new XYConstraints(4, 4, 642, 457));
    pack();
  }

  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 {
           if(jTextField3.getText()=="" || jTextField1.getText()=="" ||
             jTextArea1.getText()=="" || jTextField5.getText()=="" ||
             jTextField6.getText()=="" || jTextField4.getText()=="" ||
             jTextField2.getText()=="" || jTextField9.getText()=="" ||
             jTextField7.getText()=="" )
          {
            JOptionPane.showMessageDialog(AddNewHorseFrame.this, "请填写完所有条目！" ,
                                      "请填写完所有条目！" , 1);
        return;
          }
            rs=db.executeQuery("select 所拥有房屋数 from 经理人信息表 where 所属经理人 = " + jTextField9.getText());
            if(rs.next())
            {

              db.executeQuery("updata 经理人信息表 set = ")
              db.executeQuery("insert into 房屋信息表 " +
                                  "(城市,邮编,房屋描述,地段,户型,总面积,售价〈每平方〉,所属经理人,备注)" +
                                  "values ('" + jTextField3.getText() + "','" +
                                  jTextField1.getText() + "','" +
                                  jTextArea1.getText() + "','" +
                                  jTextField5.getText() + "','" +
                                  jTextField6.getText() + "'," +
                                  Long.valueOf(jTextField4.getText()) + "," +
                                  Long.valueOf(jTextField2.getText()) + ",'" +
                                  jTextField9.getText() + "','" +
                                  jTextField7.getText() + "')");

              JOptionPane.showMessageDialog(AddNewHorseFrame.this, "添加成功!");

            }
            else
            {
                JOptionPane.showMessageDialog(AddNewHorseFrame.this, "没有该经理人，请确认后重新输入!");
            }
            GetFrmLocation gfl=new GetFrmLocation();//实例化GetFrmLocatin
            RealtorMainFrame frame = new RealtorMainFrame(CurrentUser); //实例化下一个frame
            gfl.get_location(frame); //让frame显示在屏幕中心
            frame.show(); //frame的显示
            this.dispose(); //本窗体的退出

    }
    catch (Exception ex) { // 捕捉异常
      System.out.println("\nERROR:----- SQLException -----\n");
      while (ex != null) {
        System.out.println("Message:   " + ex.getMessage());
      }
   }
  }
}

class AddNewHorseFrame_jButton1_actionAdapter implements java.awt.event.ActionListener {
  AddNewHorseFrame adaptee;

  AddNewHorseFrame_jButton1_actionAdapter(AddNewHorseFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class AddNewHorseFrame_jButton2_actionAdapter implements java.awt.event.ActionListener {
  AddNewHorseFrame adaptee;

  AddNewHorseFrame_jButton2_actionAdapter(AddNewHorseFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}