eventframe.java

土地管理系统

package tdglxt;

import java.sql.*;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;

import com.borland.dbswing.*;
import com.borland.dx.sql.dataset.*;
//import sun.font.TrueTypeFont;
import java.awt.Rectangle;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class eventframe
    extends JFrame {
  public eventframe() {
    try {
      jbInit();
    }
    catch (Exception exception) {
      exception.printStackTrace();
    }
  }
  private void jbInit() throws Exception {
    java.util.Calendar c=java.util.Calendar.getInstance();
    getContentPane().setLayout(null);
    jSplitPane1.setOrientation(JSplitPane.VERTICAL_SPLIT);
    jSplitPane1.setBounds(new Rectangle(1, 0, 511, 412));
    jLabel5.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jLabel5.setBorder(BorderFactory.createLoweredBevelBorder());
    jLabel5.setText("土地代号");
    jLabel5.setBounds(new Rectangle(5, 2, 58, 22));
    jTextField1.setBorder(BorderFactory.createLoweredBevelBorder());
    jTextField1.setBounds(new Rectangle(65, 2, 80, 22));
    jLabel6.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jLabel6.setBorder(BorderFactory.createLoweredBevelBorder());
    jLabel6.setText("土地名称");
    jLabel6.setBounds(new Rectangle(148, 2, 62, 23));
    jTextField2.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jTextField2.setBorder(BorderFactory.createLoweredBevelBorder());
    jTextField2.setBounds(new Rectangle(209, 3, 95, 22));
    jTextField3.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jTextField3.setBorder(BorderFactory.createLoweredBevelBorder());
    jTextField3.setBounds(new Rectangle(390, 3, 112, 22));
    jButton1.setBounds(new Rectangle(6, 3, 63, 21));
    jButton1.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jButton1.setBorder(BorderFactory.createRaisedBevelBorder());
    jButton1.setText("查询");
    jButton1.addActionListener(new eventframe_jButton1_actionAdapter(this));
    jButton2.setBounds(new Rectangle(89, 3, 70, 21));
    jButton2.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jButton2.setBorder(BorderFactory.createRaisedBevelBorder());
    jButton2.setText("清空条件");
    jButton2.addActionListener(new eventframe_jButton2_actionAdapter(this));
    jButton3.setBounds(new Rectangle(189, 4, 72, 20));
    jButton3.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jButton3.setBorder(BorderFactory.createRaisedBevelBorder());
    jButton3.setText("新增");
    jButton3.addActionListener(new eventframe_jButton3_actionAdapter(this));
    jButton4.setBounds(new Rectangle(297, 4, 68, 20));
    jButton4.setEnabled(false);
    jButton4.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jButton4.setBorder(BorderFactory.createRaisedBevelBorder());
    jButton4.setText("取消");
    jButton4.addActionListener(new eventframe_jButton4_actionAdapter(this));
    jButton5.setBounds(new Rectangle(401, 4, 73, 20));
    jButton5.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jButton5.setBorder(BorderFactory.createRaisedBevelBorder());
    jButton5.setText("关闭");
    jButton5.addActionListener(new eventframe_jButton5_actionAdapter(this));
    jLabel7.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jLabel7.setBorder(BorderFactory.createLoweredBevelBorder());
    jLabel7.setText("排序");
    jLabel7.setBounds(new Rectangle(4, 3, 32, 23));
    jPanel6.setBackground(Color.lightGray);
    jPanel6.setBorder(BorderFactory.createLineBorder(Color.black));
    jPanel6.setBounds(new Rectangle(38, 2, 463, 24));
    jPanel6.setLayout(null);
    jRadioButton1.setBackground(Color.lightGray);
    jRadioButton1.setText("土地编号");
    jRadioButton1.setBounds(new Rectangle(4, 4, 81, 17));
    jRadioButton2.setBackground(Color.lightGray);
    jRadioButton2.setText("土地名称");
    jRadioButton2.setBounds(new Rectangle(140, 3, 83, 19));
    jRadioButton3.setBackground(Color.lightGray);
    jRadioButton3.setText("县市");
    jRadioButton3.setBounds(new Rectangle(253, 2, 76, 20));
    jRadioButton4.setBackground(Color.lightGray);
    jRadioButton4.setText("土地面积");
    jRadioButton4.setBounds(new Rectangle(357, 2, 90, 20));
    jComboBox1.setToolTipText("");
    jComboBox1.addActionListener(new eventframe_jComboBox1_actionAdapter(this));
    tableScrollPane1.getViewport().setBackground(Color.lightGray);
    this.getContentPane().setBackground(SystemColor.inactiveCaption);
    this.setForeground(Color.lightGray);
    this.setTitle("广州市土地管理局土地管理系统--土地基本信息查询视窗");
    jdbTable1.setBackground(Color.lightGray);
    this.getContentPane().add(jSplitPane1);
    jPanel1.setLayout(null);
    jPanel1.setBackground(Color.white);
    jPanel2.setBackground(Color.lightGray);
    jPanel2.setBorder(BorderFactory.createLineBorder(Color.black));
    jPanel2.setBounds(new Rectangle( -1, 0, 508, 28));
    jPanel2.setLayout(null);
    jPanel3.setBackground(Color.lightGray);
    jPanel3.setBorder(BorderFactory.createLineBorder(Color.black));
    jPanel3.setBounds(new Rectangle(1, 31, 505, 27));
    jPanel3.setLayout(null);
    jPanel4.setBackground(Color.lightGray);
    jPanel4.setBorder(BorderFactory.createLineBorder(Color.black));
    jPanel4.setBounds(new Rectangle(1, 60, 506, 27));
    jPanel4.setLayout(null);
    jPanel5.setBackground(Color.lightGray);
    jPanel5.setBorder(BorderFactory.createLineBorder(Color.black));
    jPanel5.setBounds(new Rectangle(1, 90, 506, 28));
    jPanel5.setLayout(null);
    jLabel1.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jLabel1.setBorder(BorderFactory.createLoweredBevelBorder());
    jLabel1.setText("县市");
    jLabel1.setBounds(new Rectangle(6, 2, 30, 24));
    jComboBox1.setBorder(BorderFactory.createLoweredBevelBorder());
    jComboBox1.setBounds(new Rectangle(37, 3, 110, 23));
    jComboBox1.getItemAt(0);
    jLabel2.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jLabel2.setBorder(BorderFactory.createLoweredBevelBorder());
    jLabel2.setText("乡镇");
    jLabel2.setBounds(new Rectangle(154, 3, 34, 21));
    jComboBox2.setBorder(BorderFactory.createLoweredBevelBorder());
    jComboBox2.setBounds(new Rectangle(193, 2, 113, 22));
    jComboBox2.getItemAt(0);
    jLabel3.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jLabel3.setBorder(BorderFactory.createLoweredBevelBorder());
    jLabel3.setText("异动类别");
    jLabel3.setBounds(new Rectangle(323, 4, 61, 22));
    jComboBox3.setBorder(BorderFactory.createLoweredBevelBorder());
    jComboBox3.setBounds(new Rectangle(392, 2, 109, 22));
    jComboBox3.getItemAt(0);
    jLabel4.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jLabel4.setBorder(BorderFactory.createLoweredBevelBorder());
    jLabel4.setText("异动时间");
    jLabel4.setBounds(new Rectangle(323, 1, 59, 24));
    jSplitPane1.add(jPanel1, JSplitPane.TOP);
    jPanel1.add(jPanel2);
    jPanel2.add(jLabel1);
    jPanel2.add(jComboBox1);
    jPanel2.add(jComboBox3);
    jPanel2.add(jLabel3);
    jPanel2.add(jComboBox2);
    jPanel2.add(jLabel2);
    jPanel1.add(jPanel3);
    jPanel3.add(jLabel5);
    jPanel3.add(jTextField1);
    jPanel3.add(jTextField3);
    jPanel3.add(jTextField2);
    jPanel3.add(jLabel6);
    jPanel3.add(jLabel4);
    jPanel1.add(jPanel4);
    jPanel4.add(jButton2);
    jPanel4.add(jButton3);
    jPanel4.add(jButton1);
    jPanel4.add(jButton4);
    jPanel4.add(jButton5);
    jPanel1.add(jPanel5);
    jPanel5.add(jLabel7);
    jPanel5.add(jPanel6);
    jPanel6.add(jRadioButton1);
    jPanel6.add(jRadioButton4);
    jPanel6.add(jRadioButton3);
    jPanel6.add(jRadioButton2);
    jSplitPane1.add(tableScrollPane1, JSplitPane.BOTTOM);
    tableScrollPane1.getViewport().add(jdbTable1);
    jSplitPane1.setDividerLocation(120);
    buttonGroup1.add(jRadioButton1);
    buttonGroup1.add(jRadioButton2);
    buttonGroup1.add(jRadioButton3);
    buttonGroup1.add(jRadioButton4);
    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 sql="select * from CityTb1";
    String sql1="select * from TownTb1,CityTb1 where CityTb1.CityCode=TownTb1.CityCode";
    String sql2="select DISTINCT Type from LandTb1  ";
    ResultSet rs2=stmt.executeQuery(sql2);
    jComboBox3.addItem(" 全 部");
    while(rs2.next()){
    jComboBox3.addItem(rs2.getString("Type"));
    }
    rs2.first();
    ResultSet rs=stmt.executeQuery(sql);
    jComboBox1.addItem(" 全 部");
    while(rs.next()){
    jComboBox1.addItem(rs.getString("CityCode")+"- "+rs.getString("CityName"));
    }
    rs.first();
    jComboBox1.getItemAt(0);
    ResultSet rs1=stmt.executeQuery(sql1);
    jComboBox2.addItem(" 全 部");
      jComboBox2.getItemAt(0);
    this.setVisible(true);
  }
  JSplitPane jSplitPane1 = new JSplitPane();
  JPanel jPanel1 = new JPanel();
  JPanel jPanel2 = new JPanel();
  JPanel jPanel3 = new JPanel();
  JPanel jPanel4 = new JPanel();
  JPanel jPanel5 = new JPanel();
  JLabel jLabel1 = new JLabel();
  JComboBox jComboBox1 = new JComboBox();
  JLabel jLabel2 = new JLabel();
  JComboBox jComboBox2 = new JComboBox();
  JLabel jLabel3 = new JLabel();
  JComboBox jComboBox3 = new JComboBox();
  JLabel jLabel4 = new JLabel();
  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;