edit_deleteteacher.java

中小学校园的教师

package untitled2;

import javax.swing.*;
import java.awt.*;
import com.borland.jbcl.layout.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.border.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class edit_deleteTeacher extends JFrame {
  XYLayout xYLayout1 = new XYLayout();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();
  JButton jButton4 = new JButton();
  JButton jButton5 = new JButton();
  JLabel jLabel1 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JTextField jTextField2 = new JTextField();
  JTextField jTextField3 = new JTextField();
  JTextField jTextField4 = new JTextField();
  JTextField jTextField5 = new JTextField();
  JTextField jTextField6 = new JTextField();
  JTextField jTextField7 = new JTextField();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JLabel jLabel6 = new JLabel();
  JLabel jLabel7 = new JLabel();
  JTextField jTextField8 = new JTextField();
  JLabel jLabel8 = new JLabel();
  JLabel jLabel9 = new JLabel();
  JTextField jTextField9 = new JTextField();
  JComboBox jComboBox1 = new JComboBox();
  JLabel jLabel10 = new JLabel();
  JScrollPane jScrollPane1 = new JScrollPane();
  Object columnnames[]={"教师编号","部门编号","职务","姓名","性别","电话","状态","生日","学历"};
    Object rowteacher[][]=new Object[15][9];
  JTable jTable1 = new JTable(rowteacher,columnnames);
  Border border1;

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

  void jbInit() throws Exception {
    border1 = new EtchedBorder(EtchedBorder.RAISED,Color.white,SystemColor.desktop);
    jButton1.setFont(new java.awt.Font("幼圆", 0, 13));
    jButton1.setText("查询");
    jButton1.addActionListener(new edit_deleteTeacher_jButton1_actionAdapter(this));
    this.getContentPane().setBackground(SystemColor.controlLtHighlight);
    this.setDefaultCloseOperation(HIDE_ON_CLOSE);
    this.setResizable(false);
    this.setSize(new Dimension(800, 580));
    this.setTitle("添加/删除教师记录");
    this.getContentPane().setLayout(xYLayout1);
    jButton2.setText("修改");
    jButton2.addActionListener(new edit_deleteTeacher_jButton2_actionAdapter(this));
    jButton3.setText("删除");
    jButton3.addActionListener(new edit_deleteTeacher_jButton3_actionAdapter(this));
    jButton4.setFont(new java.awt.Font("幼圆", 0, 13));
    jButton4.setText("清空");
    jButton4.addActionListener(new edit_deleteTeacher_jButton4_actionAdapter(this));
    jButton5.setFont(new java.awt.Font("幼圆", 0, 13));
    jButton5.setText("取消");
    jButton5.addActionListener(new edit_deleteTeacher_jButton5_actionAdapter(this));
    jLabel1.setEnabled(true);
    jLabel1.setFont(new java.awt.Font("幼圆", 0, 13));
    jLabel1.setHorizontalAlignment(SwingConstants.LEADING);
    jLabel1.setText("在下面文本框输入教师编号");
    jTextField1.setBorder(border1);
    jTextField1.setText("");
    jLabel2.setFont(new java.awt.Font("幼圆", 1, 12));
    jLabel2.setForeground(SystemColor.desktop);
    jLabel2.setText("部门编号");
    jLabel3.setFont(new java.awt.Font("幼圆", 1, 12));
    jLabel3.setForeground(SystemColor.desktop);
    jLabel3.setText("电话");
    jLabel4.setFont(new java.awt.Font("幼圆", 1, 12));
    jLabel4.setForeground(SystemColor.desktop);
    jLabel4.setText("生日");
    jLabel5.setFont(new java.awt.Font("幼圆", 1, 12));
    jLabel5.setForeground(SystemColor.desktop);
    jLabel5.setText("状态");
    jLabel6.setFont(new java.awt.Font("幼圆", 1, 12));
    jLabel6.setForeground(SystemColor.desktop);
    jLabel6.setText("姓名");
    jLabel7.setFont(new java.awt.Font("幼圆", 1, 12));
    jLabel7.setForeground(SystemColor.desktop);
    jLabel7.setText("学历");
    jLabel8.setFont(new java.awt.Font("幼圆", 1, 12));
    jLabel8.setForeground(SystemColor.desktop);
    jLabel8.setText("籍      贯");
    jLabel9.setFont(new java.awt.Font("幼圆", 1, 12));
    jLabel9.setForeground(SystemColor.desktop);
    jLabel9.setText("职务");
    jTextField9.setText("");
    jLabel10.setFont(new java.awt.Font("幼圆", 1, 12));
    jLabel10.setForeground(SystemColor.desktop);
    jLabel10.setText("性     别");
    this.getContentPane().add(jTextField2, new XYConstraints(308, 53, 135, 30));
    this.getContentPane().add(jTextField4, new XYConstraints(308, 102, 135, 30));
    this.getContentPane().add(jTextField6, new XYConstraints(308, 154, 135, 30));
    this.getContentPane().add(jLabel2, new XYConstraints(198, 60, 86, 23));
    this.getContentPane().add(jTextField3, new XYConstraints(567, 54, 135, 30));
    this.getContentPane().add(jTextField5, new XYConstraints(569, 104, 135, 30));
    this.getContentPane().add(jLabel6, new XYConstraints(194, 106, 86, 23));
    this.getContentPane().add(jLabel3,  new XYConstraints(461, 107, 86, 23));
    this.getContentPane().add(jLabel4, new XYConstraints(459, 156, 86, 23));
    this.getContentPane().add(jLabel8, new XYConstraints(458, 196, 86, 23));
    this.getContentPane().add(jLabel9,     new XYConstraints(461, 58, 86, 23));
    this.getContentPane().add(jLabel7, new XYConstraints(194, 201, 86, 23));
    this.getContentPane().add(jLabel5, new XYConstraints(193, 157, 86, 23));
    this.getContentPane().add(jTextField7,  new XYConstraints(568, 149, 135, 30));
    this.getContentPane().add(jTextField8, new XYConstraints(309, 193, 135, 30));
    this.getContentPane().add(jTextField9,  new XYConstraints(568, 193, 135, 30));
    this.getContentPane().add(jButton2, new XYConstraints(52, 323, 83, 26));
    this.getContentPane().add(jButton3, new XYConstraints(149, 323, 83, 26));
    this.getContentPane().add(jComboBox1,  new XYConstraints(499, 241, 87, 27));
    this.getContentPane().add(jLabel10,  new XYConstraints(388, 242, 86, 23));
    this.getContentPane().add(jScrollPane1,              new XYConstraints(43, 140, 719, 403));
    this.getContentPane().add(jLabel1, new XYConstraints(25, 15, 202, 38));
    this.getContentPane().add(jTextField1, new XYConstraints(162, 58, 178, 30));
    this.getContentPane().add(jButton1,  new XYConstraints(422, 61, 83, -1));
    this.getContentPane().add(jButton4,  new XYConstraints(687, 95, 83, 26));
    this.getContentPane().add(jButton5,    new XYConstraints(555, 59, 83, 29));
    jScrollPane1.getViewport().add(jTable1, null);
    jComboBox1.addItem("男");
    jComboBox1.addItem("女");
    jComboBox1.addItem(" ");
    jComboBox1.setSelectedIndex(2);
    jButton2.setVisible(false);
    jButton3.setVisible(false);
    jLabel2.setVisible(false);
    jLabel3.setVisible(false);
    jLabel4.setVisible(false);
    jLabel5.setVisible(false);
    jLabel6.setVisible(false);
    jLabel7.setVisible(false);
    jLabel8.setVisible(false);
    jTextField2.setVisible(false);
    jTextField3.setVisible(false);
    jTextField4.setVisible(false);
    jTextField5.setVisible(false);
    jTextField6.setVisible(false);
    jTextField7.setVisible(false);
    jTextField8.setVisible(false);
    jComboBox1.setVisible(false);
     jLabel9.setVisible(false);
     jTextField9.setVisible(false);
   jLabel10.setVisible(false);
  }

  void jButton1_actionPerformed(ActionEvent e) {
     jLabel2.setVisible(true);
    jLabel3.setVisible(true);
    jLabel4.setVisible(true);
    jLabel5.setVisible(true);
    jLabel6.setVisible(true);
    jLabel7.setVisible(true);
    jLabel8.setVisible(true);
    jLabel9.setVisible(true);
    jTextField2.setVisible(true);
    jTextField3.setVisible(true);
    jTextField4.setVisible(true);
    jTextField5.setVisible(true);
    jTextField6.setVisible(true);
    jTextField7.setVisible(true);
    jTextField8.setVisible(true);
    jTextField9.setVisible(true);
    jComboBox1.setVisible(true);
    jLabel10.setVisible(true);
    Connection con = null;
    jButton2.setVisible(true);
    jButton3.setVisible(true);
   String sql=null;
    try{
   con = DBConnection.getConnection();
   sql = " SELECT * "+
         "FROM dbo.teacher "+
         "WHERE (teacher_id = '"+jTextField1.getText()+"')  ";

   System.out.print(sql);
   PreparedStatement ps = con.prepareStatement(sql);
   ResultSet rs = ps.executeQuery();
   rs = ps.executeQuery();
   int i=0;
   while(rs.next())
   {
     if(i<rowteacher.length)
        {
          rowteacher[i][0] = rs.getString("teacher_id");
          rowteacher[i][1] = rs.getString("department_id");
          rowteacher[i][2] = rs.getString("teacher_tyee");
          rowteacher[i][3] = rs.getString("teacher_name");
          rowteacher[i][4] = rs.getString("teacher_sex");
          rowteacher[i][5] = rs.getString("teacher_telephone");
          rowteacher[i][6] = rs.getString("teacher_status");
          rowteacher[i][7] = rs.getString("teacher_birth");
          rowteacher[i][8] = rs.getString("educate_levele");
          i++;
        }

   }
   DbUtil.close(rs);
   DbUtil.close(ps);
 }catch(Exception ee){

 }finally{
   DbUtil.close(con);
 }
 jTable1.repaint();

 }


  void jButton4_actionPerformed(ActionEvent e) {
    //jTextArea1.setText("");
    jTextField1.setText("");
    jTextField2.setText("");
    jTextField3.setText("");
    jTextField4.setText("");
    jTextField5.setText("");
    jTextField6.setText("");
    jTextField7.setText("");
    jTextField8.setText("");
    jTextField9.setText("");
    jComboBox1.setSelectedIndex(2);
   jButton2.setVisible(false);
   jButton3.setVisible(false);
   jLabel2.setVisible(false);
   jLabel3.setVisible(false);
   jLabel4.setVisible(false);
   jLabel5.setVisible(false);
   jLabel6.setVisible(false);
   jLabel7.setVisible(false);
   jLabel8.setVisible(false);
   jTextField2.setVisible(false);
   jTextField3.setVisible(false);
   jTextField4.setVisible(false);
   jTextField5.setVisible(false);
   jTextField6.setVisible(false);
   jTextField7.setVisible(false);
   jTextField8.setVisible(false);
   jComboBox1.setVisible(false);
    jLabel9.setVisible(false);
    jTextField9.setVisible(false);
  jLabel10.setVisible(false);

  }

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

  void jButton3_actionPerformed(ActionEvent e) {
       Connection con = null;
        try{
          con = DBConnection.getConnection();

          String sql = "delete teacher  where teacher_id='" + jTextField1.getText().trim() +"'";
          PreparedStatement ps = con.prepareStatement(sql);
          ps.executeQuery();
          JOptionPane.showMessageDialog(null,"成功删除数据");
          DbUtil.close(ps);
        }catch(SQLException ee){
          JOptionPane.showMessageDialog(null,"删除失败,由于存在数据约束！");
                  }finally{
                    DbUtil.close(con);
                  }


  }

  void jButton2_actionPerformed(ActionEvent e) {
    Connection con=null;
        String sql="update teacher set department_id="+Integer.parseInt(jTextField2.getText().trim())+",teacher_tyee='"+jTextField3.getText().trim()+"',teacher_name='"+jTextField4.getText().trim()+ "',teacher_sex='"+jComboBox1.getSelectedItem().toString()+"',teacher_telephone='"+jTextField5.getText().trim()+"',teacher_status='"+jTextField6.getText().trim()+"',teacher_birth='"+jTextField7.getText().trim()+"',educate_level='"+jTextField8.getText().trim()+"' where teacher_id='"+jTextField1.getText().trim()+"'";
       System.out.println(sql);
        try{
          con = DBConnection.getConnection();
          PreparedStatement ps2 = con.prepareStatement(sql);
         ps2.executeUpdate();
          JOptionPane.showMessageDialog(null,"更新成功");
          DbUtil.close(ps2);
        }catch(SQLException e22)
       {
        e22.printStackTrace();
          JOptionPane.showMessageDialog(null,"更新失败");
        }
      }

}

class edit_deleteTeacher_jButton1_actionAdapter implements java.awt.event.ActionListener {
  edit_deleteTeacher adaptee;

  edit_deleteTeacher_jButton1_actionAdapter(edit_deleteTeacher adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class edit_deleteTeacher_jButton4_actionAdapter implements java.awt.event.ActionListener {
  edit_deleteTeacher adaptee;

  edit_deleteTeacher_jButton4_actionAdapter(edit_deleteTeacher adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton4_actionPerformed(e);
  }
}

class edit_deleteTeacher_jButton5_actionAdapter implements java.awt.event.ActionListener {
  edit_deleteTeacher adaptee;

  edit_deleteTeacher_jButton5_actionAdapter(edit_deleteTeacher adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton5_actionPerformed(e);
  }
}

class edit_deleteTeacher_jButton3_actionAdapter implements java.awt.event.ActionListener {
  edit_deleteTeacher adaptee;

  edit_deleteTeacher_jButton3_actionAdapter(edit_deleteTeacher adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}

class edit_deleteTeacher_jButton2_actionAdapter implements java.awt.event.ActionListener {
  edit_deleteTeacher adaptee;

  edit_deleteTeacher_jButton2_actionAdapter(edit_deleteTeacher adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}