tianjiaxueshengxinxi.java

中小学校园的教师

package untitled2;

import javax.swing.*;
import java.awt.*;
import com.borland.jbcl.layout.*;
import com.borland.dbswing.*;
import java.awt.event.*;
import com.borland.dx.sql.dataset.*;
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 tianJiaXueShengXinXi extends JFrame {
  XYLayout xYLayout1 = new XYLayout();
  JTextField jTextField4 = new JTextField();
  JTextField jTextField5 = new JTextField();
  JTextField jTextField6 = new JTextField();
  JTextField jTextField7 = new JTextField();
  JTextField jTextField8 = new JTextField();
  JTextField jTextField9 = new JTextField();
  JTextField jTextField11 = new JTextField();
  JTextField jTextField12 = new JTextField();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();
  JButton jButton4 = new JButton();
  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 jLabel9 = new JLabel();
  JLabel jLabel10 = new JLabel();
  JTextField jTextField14 = new JTextField();
  JPanel jPanel1 = new JPanel();
  JLabel jLabel11 = new JLabel();
  JComboBox jComboBox1 = new JComboBox();
  Database database1 = new Database();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  JTextArea jTextArea1 = new JTextArea();

  public tianJiaXueShengXinXi() {
    try {
      jbInit();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  void jbInit() throws Exception {
    this.getContentPane().setLayout(xYLayout1);
    jButton1.setFont(new java.awt.Font("Dialog", 0, 13));
    jButton1.setText("清空");
    jButton1.addActionListener(new tianJiaXueShengXinXi_jButton1_actionAdapter(this));
    jButton2.setFont(new java.awt.Font("Dialog", 0, 13));
    jButton2.setText("取消");
    jButton2.addActionListener(new tianJiaXueShengXinXi_jButton2_actionAdapter(this));
    xYLayout1.setWidth(800);
    xYLayout1.setHeight(600);
    jButton3.setFont(new java.awt.Font("Dialog", 0, 13));
    jButton3.setText("确定");
    jButton3.addActionListener(new tianJiaXueShengXinXi_jButton3_actionAdapter(this));
    jButton4.setFont(new java.awt.Font("Dialog", 0, 13));
    jButton4.setText("添加照片");
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel1.setText("学籍卡号");
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel2.setText("班级编号");
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel3.setText("学生编号");
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel4.setText("入学日期");
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel5.setText("性别");
    jLabel6.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel6.setRequestFocusEnabled(true);
    jLabel6.setText("生日");
    jLabel7.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel7.setText("姓名");
    jLabel8.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel8.setText("住址");
    jLabel9.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel9.setToolTipText("");
    jLabel9.setText("民族");
    jLabel10.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel10.setText("籍贯");
    jTextField4.setText("");
    jTextField6.setText("");
    jTextField9.setText("");
    jTextField5.setText("");
    jTextField11.setText("");
    jTextField7.setText("");
    jTextField8.setText("");
    jTextField12.setText("");
    jTextField14.setText("");
    jPanel1.setBackground(Color.white);
    jPanel1.setBorder(BorderFactory.createRaisedBevelBorder());
    this.setLocale(java.util.Locale.getDefault());
    this.setSize(new Dimension(800, 600));
    jLabel11.setFont(new java.awt.Font("Dialog", 0, 14));
    jLabel11.setText("请输入以下信息");
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:digit_campus", "dbw", null, true, "sun.jdbc.odbc.JdbcOdbcDriver"));
    database1.setDatabaseName("");
    queryDataSet1.setDisplayErrors(true);
    queryDataSet1.setReadOnly(false);
    queryDataSet1.setAccumulateResults(false);
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "", null, true, Load.ALL));
    this.getContentPane().add(jLabel11, new XYConstraints(19, 9, -1, -1));
    this.getContentPane().add(jTextField4,         new XYConstraints(91, 44, 107, -1));
    this.getContentPane().add(jLabel2, new XYConstraints(24, 79, -1, -1));
    this.getContentPane().add(jLabel1, new XYConstraints(24, 48, 53, 13));
    this.getContentPane().add(jTextField6,         new XYConstraints(90, 77, 110, -1));
    this.getContentPane().add(jTextField9,     new XYConstraints(91, 113, 111, -1));
    this.getContentPane().add(jLabel3, new XYConstraints(26, 114, -1, -1));
    this.getContentPane().add(jTextField5,     new XYConstraints(91, 151, 110, -1));
    this.getContentPane().add(jTextField8,   new XYConstraints(89, 192, 419, -1));
    this.getContentPane().add(jLabel8, new XYConstraints(26, 191, -1, -1));
    this.getContentPane().add(jTextField14,   new XYConstraints(88, 226, 418, -1));
    this.getContentPane().add(jLabel10, new XYConstraints(25, 228, -1, -1));
    this.getContentPane().add(jLabel4, new XYConstraints(23, 152, -1, -1));
    this.getContentPane().add(jButton2, new XYConstraints(256, 284, 101, -1));
    this.getContentPane().add(jButton3, new XYConstraints(456, 283, 98, -1));
    this.getContentPane().add(jPanel1, new XYConstraints(610, 30, 159, 211));
    this.getContentPane().add(jTextField12,  new XYConstraints(406, 41, 132, -1));
    this.getContentPane().add(jTextField11,   new XYConstraints(406, 114, 129, -1));
    this.getContentPane().add(jTextField7,  new XYConstraints(407, 76, 128, -1));
    this.getContentPane().add(jComboBox1, new XYConstraints(406, 148, 48, -1));
    this.getContentPane().add(jLabel5, new XYConstraints(346, 151, -1, -1));
    this.getContentPane().add(jLabel6, new XYConstraints(343, 81, -1, -1));
    this.getContentPane().add(jLabel7, new XYConstraints(344, 43, -1, -1));
    this.getContentPane().add(jLabel9, new XYConstraints(344, 116, 32, 21));
    this.getContentPane().add(jButton4,  new XYConstraints(656, 281, -1, -1));
    this.getContentPane().add(jButton1, new XYConstraints(53, 288, 102, -1));
    this.getContentPane().add(jTextArea1,      new XYConstraints(-1, 332, 801, 269));
    jComboBox1.addItem("男");
    jComboBox1.addItem("女");
    jComboBox1.addItem(" ");
    jComboBox1.setSelectedIndex(2);
  }

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

  void jButton1_actionPerformed(ActionEvent e) {
     jTextField4.setText("");
        jTextField6.setText("");
        jTextField9.setText("");
        jTextField5.setText("");
        jTextField11.setText("");
        jTextField7.setText("");
        jTextField8.setText("");
        jTextField12.setText("");
        jTextField14.setText("");

  }

  void jButton3_actionPerformed(ActionEvent e) {
         Connection con = null;
              try{
                if(jTextField4.getText().trim().length()==0)
                  JOptionPane.showMessageDialog(null,"学生学籍卡号 不可为空");
                int p;
                p=Integer.parseInt(jTextField4.getText().trim());
                con = DBConnection.getConnection();
                String sql = "insert into student (card_id, class_id, student_id, student_year_in, student_sex, student_birthday,student_name, student_address, student_rational, student_hometown)values ('" +Integer.parseInt(jTextField4.getText() )+ "'";
                sql += ",'" + Integer.parseInt(jTextField6.getText())+ "'";
                sql += ",'" + Integer.parseInt(jTextField9.getText() )+ "'";
                sql += ",'" + jTextField5.getText()+ "'";
                sql += ",'" + jComboBox1.getSelectedItem().toString() + "'";
                sql += ",'" + jTextField7.getText() + "'";
                sql += ",'" + jTextField12.getText() + "'";
                sql += ",'" + jTextField8.getText() + "'";
                sql += ",'" + jTextField11.getText() + "'";
                sql += ",'" + jTextField14.getText() + "')";
                //sql += "'" + jPanel1.getGraphics() + "')";
                //System.out.print(sql);

                PreparedStatement ps = con.prepareStatement(sql);
                ps.executeUpdate();
                JOptionPane.showMessageDialog(null,"已成功添加数据!");
                jTextArea1.setText("学籍卡号\t班级号\t学生编号\t入学时间\t性别\t生日\t\t姓名\t住址\t民族\t籍贯\n");
                jTextArea1.append(jTextField4.getText()+"\t"+jTextField6.getText()+"\t");
                jTextArea1.append(jTextField5.getText()+"\t"+jComboBox1.getSelectedItem().toString()+"\t");
                jTextArea1.append(jTextField7.getText()+"  "+jTextField12.getText()+"  ");
                jTextArea1.append(jTextField12.getText()+"  "+jTextField8.getText()+"  ");
                jTextArea1.append(jTextField11.getText()+"  "+jTextField14.getText()+"\n");
              // DbUtil.close(rs);
                DbUtil.close(ps);
              }catch(NumberFormatException exc)
              {
                  JOptionPane.showMessageDialog(null,"输入的学籍卡号 |学生编号 |班级号  必须为数字");
              }
              catch(Exception ee){
                ee.printStackTrace();
              }finally{
                DbUtil.close(con);
              }

  }
}

class tianJiaXueShengXinXi_jButton2_actionAdapter implements java.awt.event.ActionListener {
  tianJiaXueShengXinXi adaptee;

  tianJiaXueShengXinXi_jButton2_actionAdapter(tianJiaXueShengXinXi adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}

class tianJiaXueShengXinXi_jButton1_actionAdapter implements java.awt.event.ActionListener {
  tianJiaXueShengXinXi adaptee;

  tianJiaXueShengXinXi_jButton1_actionAdapter(tianJiaXueShengXinXi adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class tianJiaXueShengXinXi_jButton3_actionAdapter implements java.awt.event.ActionListener {
  tianJiaXueShengXinXi adaptee;

  tianJiaXueShengXinXi_jButton3_actionAdapter(tianJiaXueShengXinXi adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}