xueshengzonehexinxi.java

中小学校园的教师

package untitled2;

import java.sql.*;
import java.util.*;
import java.util.Date;

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

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

public class xueshengZoneheXinxi extends JFrame {
  //ResourceBundle sqlRes = ResourceBundle.getBundle("untitled2.SqlRes");
  JTextField jdbTextField1 = new JTextField();
  JTextField jdbTextField2 = new JTextField();
  JTextField jdbTextField5 = new JTextField();
  JTextField jdbTextField7 = new JTextField();
  JTextField jdbTextField9 = new JTextField();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel8 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel7 = new JLabel();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();
  JLabel jLabel11 = new JLabel();
  JButton jButton4 = new JButton();
  JButton jButton5 = new JButton();
  JTextArea jTextArea1 = new JTextArea();
  JButton jButton6 = new JButton();
  JButton jButton7 = new JButton();

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

  void jbInit() throws Exception {
    this.setSize(600,400);
    this.getContentPane().setLayout(null);
    jdbTextField1.setAlignmentX( (float) 0.5);
    jdbTextField1.setText("");
    jdbTextField1.setBounds(new Rectangle(85, 62, 78, 22));
    jdbTextField2.setAlignmentX( (float) 0.5);
    jdbTextField2.setText("");
    jdbTextField2.setBounds(new Rectangle(85, 103, 78, 22));
    jdbTextField5.setAlignmentX( (float) 0.5);
    jdbTextField5.setText("");
    jdbTextField5.setBounds(new Rectangle(273, 104, 79, 22));
    jdbTextField7.setText("");
    jdbTextField7.setBounds(new Rectangle(88, 170, 259, 22));
    jdbTextField9.setText("");
    jdbTextField9.setBounds(new Rectangle(269, 63, 79, 22));
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel4.setText("记录日期");
    jLabel4.setBounds(new Rectangle(214, 106, 52, 19));
    jLabel8.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel8.setText("备注");
    jLabel8.setBounds(new Rectangle(44, 171, 26, 19));
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel2.setText("记录编号");
    jLabel2.setBounds(new Rectangle(24, 104, 58, 19));
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel1.setText("学籍卡号");
    jLabel1.setBounds(new Rectangle(27, 65, 53, 13));
    jLabel7.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel7.setText("记录名");
    jLabel7.setBounds(new Rectangle(226, 65, 40, 19));
    jButton1.setBounds(new Rectangle(375, 32, 81, 26));
    jButton1.setText("查询");
    jButton1.addActionListener(new xueshengZoneheXinxi_jButton1_actionAdapter(this));
    jButton2.setBounds(new Rectangle(375, 159, 81, 26));
    jButton2.setText("取消");
    jButton2.addActionListener(new xueshengZoneheXinxi_jButton2_actionAdapter(this));
    jButton3.setBounds(new Rectangle(375, 126, 81, 26));
    jButton3.setText("清空");
    jButton3.addActionListener(new xueshengZoneheXinxi_jButton3_actionAdapter(this));
    jLabel11.setFont(new java.awt.Font("黑体", 0, 13));
    jLabel11.setText("请输入学生学籍卡号");
    jLabel11.setBounds(new Rectangle(15, 16, 150, 31));
    jButton4.setBounds(new Rectangle(376, 63, 81, 26));
    jButton4.setText("修改");
    jButton4.addActionListener(new xueshengZoneheXinxi_jButton4_actionAdapter(this));
    jButton5.setBounds(new Rectangle(376, 94, 81, 26));
    jButton5.setText("删除");
    jButton5.addActionListener(new xueshengZoneheXinxi_jButton5_actionAdapter(this));
   // jdbTextField2.setEditable(false);
    jdbTextField5.setEditable(false);
    jdbTextField7.setEditable(false);
    jdbTextField9.setEditable(false);
    jTextArea1.setBounds(new Rectangle(0, 226, 594, 178));
    jButton6.setBounds(new Rectangle(375, 3, 81, 26));
    jButton6.setText("添加");
    jButton6.addActionListener(new xueshengZoneheXinxi_jButton6_actionAdapter(this));
    jButton7.setBounds(new Rectangle(462, 62, 81, 26));
    jButton7.setText("确定");
    jButton7.addActionListener(new xueshengZoneheXinxi_jButton7_actionAdapter(this));
    this.getContentPane().add(jdbTextField7, null);
    this.getContentPane().add(jdbTextField1, null);
    this.getContentPane().add(jLabel1, null);
    this.getContentPane().add(jLabel8, null);
    this.getContentPane().add(jLabel7, null);
    this.getContentPane().add(jLabel11, null);
    this.getContentPane().add(jButton4, null);
    this.getContentPane().add(jButton5, null);
    this.getContentPane().add(jButton2, null);
    this.getContentPane().add(jButton1, null);
    this.getContentPane().add(jButton6, null);
    this.getContentPane().add(jButton3, null);
    this.getContentPane().add(jLabel2, null);
    this.getContentPane().add(jdbTextField2, null);
    this.getContentPane().add(jLabel4, null);
    this.getContentPane().add(jdbTextField5, null);
    this.getContentPane().add(jdbTextField9, null);
    this.getContentPane().add(jTextArea1, null);
    this.getContentPane().add(jButton7, null);
    jTextArea1.setEditable(false);
    jButton7.setVisible(false);
  }

  void jButton3_actionPerformed(ActionEvent e) {
    jTextArea1.setText("");
    jdbTextField1.setText("");
    jdbTextField2.setText("");

    jdbTextField5.setText("");

    jdbTextField7.setText("");

    jdbTextField9.setText("");


  }



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

  void jButton1_actionPerformed(ActionEvent e) {
     Connection con = null;
     jTextArea1.setText("记录号\t学籍号\t\t记录名\t\t记录日期\t\t记录内容\n");
     String columnName="card_id";
     try{
        con = DBConnection.getConnection();
         int s=Integer.parseInt(jdbTextField1.getText().trim());
         String sql ="select * from dbo.student_manage  where " + columnName + "='" + s +
          "'";
        PreparedStatement ps = con.prepareStatement(sql);
        ResultSet rs = ps.executeQuery();
        int counter=0;
        boolean more=rs.next();
        if(!more)
              JOptionPane.showMessageDialog(null,"对应学籍号为'"+jdbTextField1.getText().trim()+"'的数据不存在");
        while(more)
        {
          counter++;
          int i=1;
          // jCBGrade.addItem(rs.getString("grade_name"));
         while(i<=5)
          jTextArea1.append(rs.getString(i++)+"\t");
          jTextArea1.append("\n");
          more=rs.next();
        }
jTextArea1.append("\n\n共找到\t"+Integer.toString(counter)+"\t条记录");
        DbUtil.close(rs);
        DbUtil.close(ps);
      }catch(NumberFormatException eee)
      {JOptionPane.showMessageDialog(null,"输入的学籍号必须为数字");}
      catch(Exception ee){
        ee.printStackTrace();
      }finally{
        DbUtil.close(con);
      }

  }

  void jButton6_actionPerformed(ActionEvent e) {
       jdbTextField2.setEditable(true);

       jdbTextField5.setEditable(true);

       jdbTextField7.setEditable(true);

       jdbTextField9.setEditable(true);


       if(jdbTextField1.getText().trim().length()==0||jdbTextField2.getText().trim().length()==0)
        JOptionPane.showMessageDialog(null,"学生学籍卡号||记录编号   不可为空");

        Connection con = null;
             try{
               con = DBConnection.getConnection();

             int p;
              p=Integer.parseInt(jdbTextField2.getText().trim());
               p=Integer.parseInt(jdbTextField1.getText().trim());
               if(jdbTextField2.getText().trim().length()==0)
               {
                 JOptionPane.showMessageDialog(null," 请完善数据后提交");
               }

               String sql = "INSERT INTO student_manage values ('" +Integer.parseInt(jdbTextField2.getText().trim() )+ "'";
               sql += ",'" + Integer.parseInt(jdbTextField1.getText().trim() )+ "'";
               sql += ",'" + jdbTextField9.getText().trim() + "'";
               sql += ",'" + jdbTextField5.getText().trim() + "'";
               sql += ",'" + jdbTextField7.getText().trim() + "')";

               PreparedStatement ps = con.prepareStatement(sql);
               ps.executeQuery();
               JOptionPane.showMessageDialog(null,"数据存储成功");
               DbUtil.close(ps);
             }catch(NumberFormatException ex)
             {
               JOptionPane.showMessageDialog(null,"输入的学籍卡号||记录编号    必须为数字");
             }
              catch(SQLException ee){
                JOptionPane.showMessageDialog(null,".......");;
              }finally{
                DbUtil.close(con);
              }

            }//

             /*还有问题等待解决：输入数据后可以成功存储，
             但是回截取到SQL异常，成功存储的信息不回显示*/


  void jButton4_actionPerformed(ActionEvent e) {
       jdbTextField1.setEditable(false);
       jdbTextField2.setEditable(true);

       jdbTextField5.setEditable(true);

       jdbTextField7.setEditable(true);

       jdbTextField9.setEditable(true);
       Connection con = null;
        jTextArea1.setText("\t*******当前的记录为：******\n\n");
       jTextArea1.append("记录号\t学籍号\t\t记录名\t\t记录日期\t\t记录内容\n");
        String columnName="card_id";
        try{
          con = DBConnection.getConnection();
          int s=Integer.parseInt(jdbTextField1.getText().trim());
          String sql ="select * from dbo.student_manage  where " + columnName + "='" + s +
              "'";
          PreparedStatement ps = con.prepareStatement(sql);
          ResultSet rs = ps.executeQuery();
          boolean more=rs.next();
          int counter=0;

          if(!more)
            JOptionPane.showMessageDialog(null,"对应学籍号为'"+jdbTextField1.getText().trim()+"'的数据不存在");
          while(more)
          {
            counter++;
            int i=1;
            // jCBGrade.addItem(rs.getString("grade_name"));
            while(i<=5)
            {
              jTextArea1.append(rs.getString(i) + "\t");
               i++;
            }
            jTextArea1.append("\n");
            more=rs.next();
          }
          jTextArea1.append("\n\n共找到\t"+Integer.toString(counter)+"\t条记录");
          JOptionPane.showMessageDialog(null,"请在文本框中输入欲更新的内容!");
         jButton7.setVisible(true);
          DbUtil.close(rs);
          DbUtil.close(ps);
        }catch(NumberFormatException eee)
        {
          JOptionPane.showMessageDialog(null,"输入的学籍号必须为数字");
        }
        catch(Exception ee){
          ee.printStackTrace();
        }finally{
          DbUtil.close(con);
        }


      }

  void jButton7_actionPerformed(ActionEvent e) {
    Connection con=null;
    String sql="update student_manage set student_manage_name='"+jdbTextField9.getText().trim()+"',student_manage_time='"+jdbTextField5.getText().trim()+"',student_manage_comtent='"+jdbTextField7.getText().trim()+ "' where student_manage_id="+Integer.parseInt(jdbTextField2.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,"更新失败");
    }
  }


  void jButton5_actionPerformed(ActionEvent e) {
   // jTextArea1.setText("");
   // jdbTextField2.setEditable(true);
         Connection con = null;
         try{
             String id=jdbTextField1.getText().trim();
           con = DBConnection.getConnection();
           String columnName="card_id";
           String columnName2="student_manage_id";
           String sql = "delete student_manage  where " + columnName + "=" + id +" and "+columnName2+"="+Integer.parseInt(jdbTextField2.getText().trim())+"";
           PreparedStatement ps = con.prepareStatement(sql);
           ps.executeQuery();
           JOptionPane.showMessageDialog(null,"成功删除数据");
           DbUtil.close(ps);

         }catch(Exception ee){
           JOptionPane.showMessageDialog(null,"删除失败");
                   }finally{
                     DbUtil.close(con);
                   }

  }
}





class xueshengZoneheXinxi_jButton3_actionAdapter implements java.awt.event.ActionListener {
  xueshengZoneheXinxi adaptee;

  xueshengZoneheXinxi_jButton3_actionAdapter(xueshengZoneheXinxi adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}

class xueshengZoneheXinxi_jButton2_actionAdapter implements java.awt.event.ActionListener {
  xueshengZoneheXinxi adaptee;

  xueshengZoneheXinxi_jButton2_actionAdapter(xueshengZoneheXinxi adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}

class xueshengZoneheXinxi_jButton1_actionAdapter implements java.awt.event.ActionListener {
  xueshengZoneheXinxi adaptee;

  xueshengZoneheXinxi_jButton1_actionAdapter(xueshengZoneheXinxi adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }

}

class xueshengZoneheXinxi_jButton6_actionAdapter implements java.awt.event.ActionListener {
  xueshengZoneheXinxi adaptee;

  xueshengZoneheXinxi_jButton6_actionAdapter(xueshengZoneheXinxi adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton6_actionPerformed(e);
  }
}

class xueshengZoneheXinxi_jButton4_actionAdapter implements java.awt.event.ActionListener {
  xueshengZoneheXinxi adaptee;

  xueshengZoneheXinxi_jButton4_actionAdapter(xueshengZoneheXinxi adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton4_actionPerformed(e);
  }
}

class xueshengZoneheXinxi_jButton7_actionAdapter implements java.awt.event.ActionListener {
  xueshengZoneheXinxi adaptee;

  xueshengZoneheXinxi_jButton7_actionAdapter(xueshengZoneheXinxi adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton7_actionPerformed(e);
  }
}

class xueshengZoneheXinxi_jButton5_actionAdapter implements java.awt.event.ActionListener {
  xueshengZoneheXinxi adaptee;

  xueshengZoneheXinxi_jButton5_actionAdapter(xueshengZoneheXinxi adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton5_actionPerformed(e);
  }
}