fclasssong.java

中小学校园的教师

package untitled2;

import javax.swing.*;
import java.awt.*;
import com.borland.jbcl.layout.*;
import java.awt.event.*;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

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

public class Fclasssong extends JFrame {
  XYLayout xYLayout1 = new XYLayout();
  JComboBox jComboBox1 = new JComboBox();
  JLabel jLabel1 = new JLabel();
  JButton jButton1 = new JButton();
  Connection con;
 Statement st;
 PreparedStatement ps;
 ResultSet rs;
 String sql;
  private boolean flag= true;

  public Fclasssong() {
    try {
      jbInit();
      jComboBox1.addItem("一年级");
      jComboBox1.addItem("初一");
      jComboBox1.addItem("高一");
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  void jbInit() throws Exception {
    this.setSize(new Dimension(800, 600));
    this.getContentPane().setLayout(xYLayout1);
    jLabel1.setText("年级 ");
    jButton1.setText("自动 分班");
    jButton1.addActionListener(new Fclasssong_jButton1_actionAdapter(this));
    this.getContentPane().add(jComboBox1,  new XYConstraints(106, 18, 96, -1));
    this.getContentPane().add(jLabel1,  new XYConstraints(31, 22, 59, 24));
    this.getContentPane().add(jButton1,    new XYConstraints(323, 23, -1, -1));
  }

  void jButton1_actionPerformed(ActionEvent e)
  {
    Connection con1;
    Statement st1;
    PreparedStatement ps1;
   ResultSet rs1;
     String sql1;

    String classid[]  = new String[20];
    int i = 0;
    sql =  "SELECT dbo.class.class_id FROM dbo.class INNER JOIN  dbo.grade ON dbo.class.grade_name = dbo.grade.grade_name where dbo.grade.grade_name = '"+jComboBox1.getSelectedItem()+"'";
     con = null;
     try{
      con = DBConnection.getConnection();
       PreparedStatement ps = con.prepareStatement(sql);
        //ps.setString(1,"");
         rs = ps.executeQuery();


 while (rs.next())
        {
          classid[i++] = rs.getString(1);
         }
    closeP.close(ps);
   }catch(Exception ex)
   {
   ex.printStackTrace();
    }finally
    {
      closeP.close(con);
  }

  sql =  "SELECT card_id  FROM dbo.student  where student_sex = '女' and class_id = "+jComboBox1.getSelectedIndex()+1+"  ORDER BY student_name ";
      con = null;
 try{
       con = DBConnection.getConnection();
        ps = con.prepareStatement(sql);
         //ps.setString(1,"");
          rs = ps.executeQuery();
 int id= 0;
  while (rs.next())
  {
    sql =
        "UPDATE dbo.student  SET class_id = ?   WHERE card_id =? ";
        con1 = DBConnection.getConnection();
        ps1 = con1.prepareStatement(sql);
        ps1.setString(1,classid[id]);
         ps1.setString(2,rs.getString(1));
         ps1.executeUpdate();
         if(flag)
         {
           if(id <i-1)
           {
             id++;


           }
           else
           {
               flag =false;

           }
         }
         else
         {
             if(id>0)
             {
               id--;
             }
             else
             {
                 flag = true;
                 //id++;
             }
             }
             closeP.close(ps1);
        closeP.close(con1);
      }

     closeP.close(ps);

     /////////////////
     sql =  "SELECT card_id  FROM dbo.student  where student_sex = '男' and class_id = "+jComboBox1.getSelectedIndex()+1+" ORDER BY student_name ";
      con = null;

       con = DBConnection.getConnection();
        ps = con.prepareStatement(sql);
         //ps.setString(1,"");
          rs = ps.executeQuery();
 //int id= 0;
  while (rs.next())
  {
    sql =
        "UPDATE dbo.student  SET class_id = ?   WHERE card_id =? ";
        con1 = DBConnection.getConnection();
        ps1 = con1.prepareStatement(sql);
        ps1.setString(1,classid[id]);
         ps1.setString(2,rs.getString(1));
         ps1.executeUpdate();
         if(flag)
         {
           if(id <i-1)
           {
             id++;


           }
           else
           {
               flag =false;

           }
         }
         else
         {
             if(id>0)
             {
               id--;
             }
             else
             {
                 flag = true;
                 //id++;
             }
             }
             closeP.close(ps1);
        closeP.close(con1);
      }

     closeP.close(ps);



    }catch(Exception ex)
    {
    ex.printStackTrace();
     }finally
     {
       closeP.close(con);
       jButton1.setEnabled(false);
   }



  }
}

class Fclasssong_jButton1_actionAdapter implements java.awt.event.ActionListener {
  Fclasssong adaptee;

  Fclasssong_jButton1_actionAdapter(Fclasssong adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}