eventframe.java~777~

土地管理系统

  JLabel jLabel5 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JTextField jTextField2 = new JTextField();
  JLabel jLabel6 = new JLabel();
  JTextField jTextField3 = new JTextField();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();
  JButton jButton4 = new JButton();
  JButton jButton5 = new JButton();
  JLabel jLabel7 =new JLabel();
  JPanel jPanel6 = new JPanel();
  ButtonGroup buttonGroup1 = new ButtonGroup();
  JRadioButton jRadioButton1 = new JRadioButton();
  JRadioButton jRadioButton2 = new JRadioButton();
  JRadioButton jRadioButton3 = new JRadioButton();
  JRadioButton jRadioButton4 = new JRadioButton();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  JdbTable jdbTable1 = new JdbTable();
  Database database1 = new Database();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  private Object queyDataSet1;
  private Object jRaioButton2;
  private Object jTextFeld3;
  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";
String temp="";
       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"));
 queryDataSet1.setQuery(new QueryDescriptor(database1,
                                            consult,null,true,Load.ALL));
 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);
  }
}