newrecord.java

土地管理系统

package tdglxt;

import java.awt.*;
import javax.swing.*;
import java.awt.Rectangle;
import java.awt.BorderLayout;
import java.awt.Font;
import javax.swing.BorderFactory;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class NewRecord
    extends JDialog{
  JPanel panel1 = 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();
  JLabel jLabel6 = new JLabel();
  JTextField jTextField2 = new JTextField();
  JLabel jLabel7 = new JLabel();
  JComboBox jComboBox5 = new JComboBox();
  JLabel jLabel8 = new JLabel();
  JTextField jTextField3 = new JTextField();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JTextField jTextField4 = new JTextField();
  JButton jButton3 = new JButton();
  public  NewRecord(Frame owner, String title, boolean modal) {
    super(owner, title, modal);
    try {
      setDefaultCloseOperation(DISPOSE_ON_CLOSE);
      jbInit();
      pack();
    }
    catch (Exception exception) {
      exception.printStackTrace();
    }
  }

  public  NewRecord() {
    this(new Frame(), "Dialog", false);
  }

  private void jbInit() throws Exception {
    //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    java.util.Calendar c=java.util.Calendar.getInstance();
   panel1.setLayout(null);
    jComboBox1.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jComboBox1.setBorder(BorderFactory.createLoweredBevelBorder());
    jComboBox1.setBounds(new Rectangle(100, 55, 139, 21));
    jComboBox1.addActionListener(new NewRecord_jComboBox1_actionAdapter(this));
    jComboBox1.addItem("");
    jLabel2.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jLabel2.setBorder(BorderFactory.createLoweredBevelBorder());
    jLabel2.setText("乡镇");
    jLabel2.setBounds(new Rectangle(266, 57, 57, 22));
    jComboBox2.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jComboBox2.setBorder(BorderFactory.createLoweredBevelBorder());
    jComboBox2.setBounds(new Rectangle(324, 54, 144, 24));
    jComboBox2.addItem("");
    jLabel3.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jLabel3.setBorder(BorderFactory.createLoweredBevelBorder());
    jLabel3.setText("异动类别");
    jLabel3.setBounds(new Rectangle(40, 117, 60, 23));
    jComboBox3.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jComboBox3.setBorder(BorderFactory.createLoweredBevelBorder());
    jComboBox3.setBounds(new Rectangle(103, 116, 137, 24));
    jComboBox3.addItem("");
    jLabel4.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jLabel4.setBorder(BorderFactory.createLoweredBevelBorder());
    jLabel4.setText("异动时间");
    jLabel4.setBounds(new Rectangle(258, 117, 57, 23));
    jLabel5.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jLabel5.setBorder(BorderFactory.createLoweredBevelBorder());
    jLabel5.setText("土地代号");
    jLabel5.setBounds(new Rectangle(39, 176, 62, 24));
    jTextField1.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jTextField1.setBorder(BorderFactory.createLoweredBevelBorder());
    jTextField1.setBounds(new Rectangle(102, 178, 137, 24));
    jLabel6.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jLabel6.setBorder(BorderFactory.createLoweredBevelBorder());
    jLabel6.setText("土地名称");
    jLabel6.setBounds(new Rectangle(260, 180, 57, 25));
    jTextField2.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jTextField2.setBorder(BorderFactory.createLoweredBevelBorder());
    jTextField2.setBounds(new Rectangle(322, 181, 144, 24));
    jLabel7.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jLabel7.setBorder(BorderFactory.createLoweredBevelBorder());
    jLabel7.setText("土地单位");
    jLabel7.setBounds(new Rectangle(42, 236, 61, 23));
    jComboBox5.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jComboBox5.setBorder(BorderFactory.createLoweredBevelBorder());
    jComboBox5.setBounds(new Rectangle(101, 236, 139, 23));
    jComboBox5.addItem("");

    jLabel8.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jLabel8.setBorder(BorderFactory.createLoweredBevelBorder());
    jLabel8.setText("土地面积");
    jLabel8.setBounds(new Rectangle(253, 237, 57, 22));
    jTextField3.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jTextField3.setBorder(BorderFactory.createLoweredBevelBorder());
    jTextField3.setBounds(new Rectangle(321, 234, 146, 26));
    jButton1.setBounds(new Rectangle(99, 293, 73, 25));
    jButton1.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jButton1.setBorder(BorderFactory.createRaisedBevelBorder());
    jButton1.setText("存档");
    jButton1.addActionListener(new NewRecord_jButton1_actionAdapter(this));
    jButton2.setBounds(new Rectangle(387, 291, 66, 25));
    jButton2.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jButton2.setBorder(BorderFactory.createRaisedBevelBorder());
    jButton2.setText("取消");
    jButton2.addActionListener(new NewRecord_jButton2_actionAdapter(this));
    jTextField4.setBorder(BorderFactory.createLoweredBevelBorder());
    jTextField4.setBounds(new Rectangle(322, 114, 146, 24));
    this.setTitle("土地管理局土地管理 系统--土地基本信息新增视窗");
    jButton3.setBounds(new Rectangle(233, 293, 73, 24));
    jButton3.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jButton3.setBorder(BorderFactory.createRaisedBevelBorder());
    jButton3.setToolTipText("");
    jButton3.setText("重置");
    jButton3.addActionListener(new NewRecord_jButton3_actionAdapter(this));
    panel1.add(jLabel1);
    panel1.add(jComboBox1);
    panel1.add(jTextField3);
    panel1.add(jLabel8);
    panel1.add(jComboBox5);
    panel1.add(jLabel7);
    panel1.add(jLabel5);
    panel1.add(jTextField1);
    panel1.add(jLabel4);
    panel1.add(jTextField4);
    panel1.add(jComboBox2);
    panel1.add(jLabel2);
    panel1.add(jComboBox3);
    panel1.add(jLabel3);
    panel1.add(jLabel6);
    panel1.add(jTextField2);
    panel1.add(jButton2);
    panel1.add(jButton3);
    panel1.add(jButton1);
    this.getContentPane().add(panel1, java.awt.BorderLayout.CENTER);
    jLabel1.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
    jLabel1.setBorder(BorderFactory.createLoweredBevelBorder());
    jLabel1.setText("县市");
    jLabel1.setBounds(new Rectangle(39, 55, 58, 21));
    panel1.setBackground(Color.lightGray);
    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 sql2="select  DISTINCT Type from LandTb1";
    String sql3="select DISTINCT LandUnit from LandTb1 ";
    ResultSet rs=stmt.executeQuery(sql);
    while(rs.next()){
    jComboBox1.addItem(rs.getString("CityCode")+" - "+rs.getString("CityName"));
    }
    ResultSet rs2=stmt.executeQuery(sql2);
    while(rs2.next()){
    jComboBox3.addItem(rs2.getString("Type"));
    }
    ResultSet rs3=stmt.executeQuery(sql3);
    while(rs3.next()){
    jComboBox5.addItem(rs3.getString("LandUnit"));
    }
    }

  public void jButton2_actionPerformed(ActionEvent e) {
  this.dispose();
  }

  public void jButton1_actionPerformed(ActionEvent e) {
  try{
   if((jComboBox1.getSelectedItem()=="")||(jComboBox2.getSelectedItem()=="")||(jComboBox3.getSelectedItem()=="")||(jComboBox5.getSelectedItem()=="")||(jTextField1.getSelectionEnd() == 0)||(jTextField2.getSelectionEnd() == 0)||(jTextField3.getSelectionEnd() == 0)||(jTextField4.getSelectionEnd() == 0))
  {BK bk=new BK();
   bk.setVisible(true);
   bk.setSize(300,120);
   bk.show();
   bk.setLocation(500,300);
 }
 else{
    String source="jdbc:odbc:DMIS";
    Connection con=DriverManager.getConnection(source);
   String stm2="insert into LandTb1 values('"+jTextField1.getText()+"','"+jTextField2.getText()+"','"+jTextField3.getText()+"','"+jComboBox5.getSelectedItem()+"','"+jComboBox1.getSelectedIndex()+"','"+jComboBox2.getSelectedIndex()+"','"+jComboBox3.getSelectedItem()+"','"+jTextField4.getText()+"','"+"0'"+")";
    Statement st=con.createStatement();
    st.executeUpdate(stm2);
  }
    }catch(Exception ee){}
  }

  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"));
        }
  }
  }

  public void jButton3_actionPerformed(ActionEvent e) {
    jTextField1.setText("");
    jTextField2.setText("");
    jTextField3.setText("");
    jTextField4.setText("");
    jComboBox1.setSelectedIndex(0);
    jComboBox2.removeAllItems();
    jComboBox2.addItem("");
    jComboBox3.setSelectedIndex(0);
    jComboBox5.setSelectedIndex(0);
  }
}

class NewRecord_jButton3_actionAdapter
    implements ActionListener {
  private NewRecord adaptee;
  NewRecord_jButton3_actionAdapter(NewRecord adaptee) {
    this.adaptee = adaptee;
  }

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

class NewRecord_jComboBox1_actionAdapter
    implements ActionListener {
  private NewRecord adaptee;
  NewRecord_jComboBox1_actionAdapter(NewRecord adaptee) {
    this.adaptee = adaptee;
  }

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

class NewRecord_jButton1_actionAdapter
    implements ActionListener {
  private NewRecord adaptee;
  NewRecord_jButton1_actionAdapter(NewRecord adaptee) {
    this.adaptee = adaptee;
  }

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

class NewRecord_jButton2_actionAdapter
    implements ActionListener {
  private NewRecord adaptee;
  NewRecord_jButton2_actionAdapter(NewRecord adaptee) {
    this.adaptee = adaptee;
  }

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