eventframe.java

土地管理系统

  private Object tep;
  private boolean NULL;
  public void jButton3_actionPerformed(ActionEvent e) {
 NewRecord Nrecord=new NewRecord();
 Nrecord.setVisible(true);
 Nrecord.setSize(520,444);
 Nrecord.setLocation(255,160);
  }
  public void jButton4_actionPerformed(ActionEvent e) {
    jdbTable1.repaint();
    jTextField1.setText("");
    jTextField2.setText("");
    jTextField3.setText("");
    jComboBox1.getItemAt(0);
    jComboBox2.getItemAt(0);
    jComboBox3.getItemAt(0);
    jButton1.setEnabled(true);
    jButton2.setEnabled(true);
    jButton4.setEnabled(false);
    jComboBox1.setEnabled(true);
    jComboBox2.setEnabled(true);
    jComboBox3.setEnabled(true);
    jTextField1.setEnabled(true);
    jTextField2.setEnabled(true);
    jTextField3.setEnabled(true);
    jRadioButton1.setEnabled(true);
    jRadioButton2.setEnabled(true);
    jRadioButton3.setEnabled(true);
    jRadioButton4.setEnabled(true);
  }
  public void jButton2_actionPerformed(ActionEvent e) {
    jTextField1.setText("");
    jTextField2.setText("");
    jTextField3.setText("");
    jComboBox1.setSelectedIndex(0);
    jComboBox2.setSelectedIndex(0);
    jComboBox3.setSelectedIndex(0);
    jRadioButton1.setSelected(true);
    queryDataSet1.close();
    jComboBox2.removeAllItems();
    jComboBox2.addItem(" 全 部");
    }
  /**
   * setSelectedCheckbox
   *
   * @param jRadioButton1 JRadioButton
   */
  private void setSelectedCheckbox(JRadioButton jRadioButton1) {
  }

  public void jButton5_actionPerformed(ActionEvent e) {
  YorN YN=new YorN();
  YN.setVisible(true);
  YN.setSize(300,120);
  YN.show();
  YN.setLocation(300,300);
  }
  public void jButton1_actionPerformed(ActionEvent e) {
try{
  String sele="select  LandCode ,LandName,CityName,TownName,LandQty,"+" case LandUnit when 1 then '公顷' else '亩' end as 'LandUnit' , "
            +" case Type when 1 then '农用' when 2 then '城建' else '待开发' end as Type "
            +" from LandTb1,CityTb1,TownTb1 "+" where  LandTb1.CityCode=CityTb1.CityCode and LandTb1.TownCode=TownTb1.TownCode and CityTb1.CityCode=TownTb1.CityCode";

          ResultSet r;
          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  String source="jdbc:odbc:DMIS";
  Connection con=DriverManager.getConnection(source);
  Statement stmt1=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);


String temp="";
   try{
     if (jComboBox1.getSelectedItem() == " 全 部")
       temp += "";
     //else temp+= " and CityTb1.CityName='" + jComboBox1.getSelectedItem() + "' ";
     else
       temp += " and CityTb1.CityCode='" + jComboBox1.getSelectedIndex() + "' ";
     if ( (jComboBox2.getSelectedItem() == " 全 部"))
       temp += "";
     else
       temp += " and TownTb1.TownCode='" + jComboBox2.getSelectedIndex() + "' ";
     if ( (jComboBox3.getSelectedItem() == " 全 部"))
       temp += "";
     else
       temp += " and LandTb1.Type='" + jComboBox3.getSelectedItem() + "' ";
     if (jTextField1.getSelectionEnd() == 0)
       temp += "";
     else
       temp += " and LandTb1.LandCode='" + jTextField1.getText() + "' ";
     if (jTextField2.getSelectionEnd() == 0)
       temp += "";
     else
       temp += " and LandTb1.LandName='" + jTextField2.getText() + "'";
     if (jTextField3.getSelectionEnd() == 0)
       temp += "";
     else
       temp += " and LandTb1.TranDate='" + jTextField3.getText() + "'";
     if (jRadioButton1.isSelected()) {
       temp += " order by LandCode ";
     }
     if (jRadioButton2.isSelected()) {
       temp += " order by LandName";
     }
     if (jRadioButton3.isSelected()) {
       temp += " order by CityName";
     }
     if (jRadioButton4.isSelected()) {
       temp += " order by LandQty";
     }
     String consult = sele + temp;
     database1.setConnection(new ConnectionDescriptor(
         "jdbc:odbc:DMIS",
         "sa", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));

     r=stmt1.executeQuery(consult);
     if(r.next()==false){
       AK ak=new AK();
       ak.setVisible(true);
       ak.setSize(300,120);
       ak.show();
       ak.setLocation(500,300);

     }
     queryDataSet1.setQuery(new QueryDescriptor(database1, consult, null, true,
                                                Load.ALL));
   }catch(Exception ex){ }

 queryDataSet1.refresh();

 jdbTable1.setDataSet(queryDataSet1);
 jdbTable1.repaint();
 jButton1.setEnabled(false);
 jButton2.setEnabled(false);
 jButton4.setEnabled(true);
 jComboBox1.setEnabled(false);
 jComboBox2.setEnabled(false);
 jComboBox3.setEnabled(false);
 jTextField1.setEnabled(false);
 jTextField2.setEnabled(false);
 jTextField3.setEnabled(false);
 jRadioButton1.setEnabled(false);
 jRadioButton2.setEnabled(false);
 jRadioButton3.setEnabled(false);
 jRadioButton4.setEnabled(false);
}catch(Exception dd)
    {
    cw CW=new cw();
    CW.setVisible(true);
    CW.setSize(300,120);
    CW.show();
    CW.setLocation(500,300);

    }
  }

  public void jComboBox1_actionPerformed(ActionEvent e) throws
      ClassNotFoundException, SQLException {
  if(jComboBox1.getSelectedItem()!=" 全 部"){
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    String source="jdbc:odbc:DMIS";
    Connection con=DriverManager.getConnection(source);
    Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
    String sql1="select * from TownTb1 where TownTb1.CityCode='" +jComboBox1.getSelectedIndex() + "'";
    ResultSet rs1=stmt.executeQuery(sql1);
     while(rs1.next()){
     jComboBox2.addItem(rs1.getString("TownCode")+"- "+rs1.getString("TownName"));
     //jComboBox2.addItem(rs1.getString("TownName"));
    }
    jComboBox2.setSelectedIndex(1);
  }
  }
}

class eventframe_jComboBox1_actionAdapter
    implements ActionListener {
  private eventframe adaptee;
  eventframe_jComboBox1_actionAdapter(eventframe adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    try {
      adaptee.jComboBox1_actionPerformed(e);
    }
    catch (SQLException ex) {
    }
    catch (ClassNotFoundException ex) {
    }
  }
}

class eventframe_jButton1_actionAdapter
    implements ActionListener {
  private eventframe adaptee;
  eventframe_jButton1_actionAdapter(eventframe adaptee) {
   this.adaptee = adaptee;
}

  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}
class eventframe_jButton5_actionAdapter
    implements ActionListener {
  private eventframe adaptee;
  eventframe_jButton5_actionAdapter(eventframe adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jButton5_actionPerformed(e);
  }
}

class eventframe_jButton2_actionAdapter
    implements ActionListener {
  private eventframe adaptee;
  eventframe_jButton2_actionAdapter(eventframe adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}

class eventframe_jButton4_actionAdapter
    implements ActionListener {
  private eventframe adaptee;
  eventframe_jButton4_actionAdapter(eventframe adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jButton4_actionPerformed(e);
  }
}

class eventframe_jButton3_actionAdapter
    implements ActionListener {
  private eventframe adaptee;
  eventframe_jButton3_actionAdapter(eventframe adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}