fweektable.java

中小学校园的教师

package untitled2;


import javax.swing.*;
import java.awt.*;
import javax.swing.border.*;
import com.borland.dbswing.*;
import java.awt.event.*;
import java.sql.SQLException;
import java.sql.DriverManager;
import java.sql.Connection;
import com.borland.dbswing.*;
import Digital_Campus_DataModule.*;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;

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

public class FWeekTable extends JFrame {
  String num[]=new String[]{"1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20"};
  JPanel jPanel1 = new JPanel();
  Border border1;
  TitledBorder titledBorder1;
  Border border2;
  JLabel jLTerm = new JLabel();
  JLabel jLTermSet = new JLabel();
  JLabel jLWeek = new JLabel();
  JComboBox jCBTermSet = new JComboBox(num);
  JPanel jPanel2 = new JPanel();
  Border border3;
  TitledBorder titledBorder2;
  JButton jBTermAdd = new JButton();
  JButton jBiWeek = new JButton();
  JPanel jPanel3 = new JPanel();
  Border border4;
  TitledBorder titledBorder3;
  JScrollPane jScrollPane1 = new JScrollPane();
  JTextArea jTAText = new JTextArea();
  JdbComboBox jdbComboBox1 = new JdbComboBox();
  JdbComboBox jCBWeek = new JdbComboBox();
  JdbComboBox jCBTerm = new JdbComboBox();
  JButton Reset = new JButton();

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

  void jbInit() throws Exception {
    border1 = new EtchedBorder(EtchedBorder.RAISED,Color.white,new Color(148, 145, 140));
    titledBorder1 = new TitledBorder(BorderFactory.createEtchedBorder(Color.white,new Color(148, 145, 140)),"周历设置");
    border3 = BorderFactory.createEmptyBorder();
    titledBorder2 = new TitledBorder(BorderFactory.createEtchedBorder(Color.white,new Color(148, 145, 140)),"周例设置");
    border4 = BorderFactory.createEtchedBorder(Color.white,new Color(148, 145, 140));
    titledBorder3 = new TitledBorder(border4,"内容查看");
    border2 = BorderFactory.createCompoundBorder(new TitledBorder(BorderFactory.createEtchedBorder(Color.white,new Color(148, 145, 140)),"设置学期周数"),BorderFactory.createEmptyBorder(0,5,0,0));
    this.setLocale(java.util.Locale.getDefault());
    this.setSize(new Dimension(800, 600));
    this.addWindowListener(new FWeekTable_this_windowAdapter(this));
    this.getContentPane().setLayout(null);
    jPanel1.setFont(new java.awt.Font("Dialog", 0, 12));
    jPanel1.setAlignmentY((float) 0.5);
    jPanel1.setAutoscrolls(false);
    jPanel1.setBorder(border2);
    jPanel1.setBounds(new Rectangle(15, 62, 466, 75));
    jPanel1.setLayout(null);
    jLTerm.setFont(new java.awt.Font("Dialog", 0, 12));
    jLTerm.setText("学期：");
    jLTerm.setBounds(new Rectangle(18, 33, 61, 24));
    jLTermSet.setFont(new java.awt.Font("Dialog", 0, 12));
    jLTermSet.setToolTipText("");
    jLTermSet.setText("设置周数：");
    jLTermSet.setBounds(new Rectangle(187, 28, 65, 30));
    jLWeek.setFont(new java.awt.Font("Dialog", 0, 12));
    jLWeek.setPreferredSize(new Dimension(22, 16));
    jLWeek.setText("周次：");
    jLWeek.setBounds(new Rectangle(17, 26, 58, 29));
    jCBTermSet.setBounds(new Rectangle(264, 32, 38, 21));
    jPanel2.setBorder(titledBorder2);
    jPanel2.setBounds(new Rectangle(496, 63, 275, 71));
    jPanel2.setLayout(null);
    jBTermAdd.setBounds(new Rectangle(312, 33, 56, 19));
    jBTermAdd.setHorizontalAlignment(SwingConstants.CENTER);
    jBTermAdd.setText("添加");
    jBTermAdd.addActionListener(new FWeekTable_jBTermAdd_actionAdapter(this));
    jBiWeek.setBounds(new Rectangle(193, 31, 68, 19));
    jBiWeek.setEnabled(false);
    jBiWeek.setText("添加");
    jBiWeek.addActionListener(new FWeekTable_jBiWeek_actionAdapter(this));
    jPanel3.setBorder(titledBorder3);
    jPanel3.setDebugGraphicsOptions(0);
    jPanel3.setBounds(new Rectangle(14, 157, 755, 295));
    jPanel3.setLayout(null);
    jScrollPane1.setBounds(new Rectangle(63, 51, 622, 202));
    jTAText.setText("");
    jdbComboBox1.setBounds(new Rectangle(78, 17, 90, 16));
    jCBWeek.setBounds(new Rectangle(73, 31, 95, 21));
    jCBWeek.addActionListener(new FWeekTable_jCBWeek_actionAdapter(this));
    jCBTerm.setBounds(new Rectangle(61, 33, 114, 21));
    jCBTerm.addActionListener(new FWeekTable_jCBTerm_actionAdapter(this));
    Reset.setBounds(new Rectangle(380, 34, 61, 20));
    Reset.setToolTipText("");
    Reset.setText("重置");
    Reset.addActionListener(new FWeekTable_Reset_actionAdapter(this));
    jPanel1.add(jLTerm, null);
    jPanel1.add(jCBTerm, null);
    jPanel1.add(jLTermSet, null);
    jPanel1.add(jCBTermSet, null);
    jPanel1.add(jBTermAdd, null);
    jPanel1.add(Reset, null);
    this.getContentPane().add(jPanel2, null);
    jPanel2.add(jBiWeek, null);
    jPanel2.add(jLWeek, null);
    jPanel2.add(jCBWeek, null);
    this.getContentPane().add(jPanel1, null);
    this.getContentPane().add(jPanel3, null);
    jPanel3.add(jScrollPane1, null);
    jScrollPane1.getViewport().add(jTAText, null);
  }

  public static void main(String[] args) {
    FWeekTable FWeekTable = new FWeekTable();
  }

  void this_windowActivated(WindowEvent e) {





        String sql =  "SELECT * "+
                   "FROM term ";
           Connection con = null;
        try{
          con = DBConnection.getConnection();
          PreparedStatement ps = con.prepareStatement(sql);
          ResultSet rs = ps.executeQuery();
          while(rs.next())
          {
            jCBTerm.addItem(rs.getString("term_id"));
          }
          DbUtil.close(rs);
          DbUtil.close(ps);
        }catch(Exception ee){
          ee.printStackTrace();
        }finally{
          DbUtil.close(con);
        }

  }

  void jBTermAdd_actionPerformed(ActionEvent e) {
    Connection con = null;
        PreparedStatement ps =null;
        String sql =null;
        ResultSet rs=null;
        try{
          con = DBConnection.getConnection();


          for(int i=0;i<=jCBTermSet.getSelectedIndex();i++){


            if(i==0){
                  sql = "SELECT * "+
                  "FROM week_plan "+
                  "WHERE (term_id  = '"+jCBTerm.getSelectedItem().toString()+"'  )";

              ps = con.prepareStatement(sql);
               System.out.print(jCBTerm.getSelectedItem().toString() ) ;
              System.out.print(sql) ;
              System.out.print(jCBTerm.getSelectedItem().toString()) ;
              rs = ps.executeQuery();
              if(rs.next()){
                JOptionPane.showMessageDialog(null," 该学期已设置计划");
                break;
              }
            }
      //int x= Integer.valueOf(gjCBTermSet.etSelectedItem());
            sql = "INSERT INTO dbo.week_plan"+
                   "(term_id, week_plan_weekno)"+
                   "VALUES (?,?)";


            ps = con.prepareStatement(sql);
             System.out.print(jCBTermSet.getSelectedItem().toString()) ;
            ps.setString(1, jCBTerm.getSelectedItem().toString() );
            ps.setInt(2, i+1);

            System.out.print(sql) ;
           System.out.print(jCBTermSet.getSelectedItem().toString()) ;
            System.out.print(jCBTermSet.getSelectedItem().toString()) ;
            ps.executeUpdate();
          }
          //jTGrade;
          DbUtil.close(ps);
        }catch(Exception ee){
          ee.printStackTrace();
        }finally{
          DbUtil.close(con);
        }

  }

  void jCBTerm_actionPerformed(ActionEvent e) {


       jCBWeek.setItems(null);





       String sql = " SELECT *"+
              "  FROM week_plan"+
              "  WHERE (term_id = '"+jCBTerm.getSelectedItem().toString()+"'  )";

          Connection con = null;
       try{
         con = DBConnection.getConnection();
         PreparedStatement ps = con.prepareStatement(sql);
         System.out.print(sql);
         // System.out.print(jCBTerm.getSelectedItem().toString());

         //ps.setString(1, jCBTerm.getSelectedItem().toString()  );
         ResultSet rs = ps.executeQuery();
         int i=1;
         while(rs.next())
         {

           jCBWeek.addItem("第"+String.valueOf(i)+"周计划");
           i++;
           //"第"+"week_plan_weekno"+"周计划"
         }
         DbUtil.close(rs);
         DbUtil.close(ps);
       }catch(Exception ee){
         ee.printStackTrace();
       }finally{
         DbUtil.close(con);
       }
          System.out.print(jCBWeek.getItemCount());
       if(jCBWeek.getItemCount()==0)
    {
    jBiWeek.setEnabled(false);
    }
    else jBiWeek.setEnabled(true);


  }

  void jBiWeek_actionPerformed(ActionEvent e) {
      String text=null;
      text=jTAText.getText();

      Connection con = null;
  PreparedStatement ps =null;
  String sql =null;
  ResultSet rs=null;

try{
con = DBConnection.getConnection();
   sql="UPDATE dbo.week_plan "+
        "SET week_plan_context = '"+jTAText.getText()+"' "+
      "WHERE (term_id = '"+jCBTerm.getSelectedItem().toString()+"') AND (week_plan_weekno = "+String.valueOf(jCBWeek.getSelectedIndex()+1)+")";
Statement stmt=con.createStatement();
  rs=stmt.executeQuery(sql);
while(rs.next())
{
  System.out.print(rs.getString(1));
}
  }catch(Exception ee){

}finally{
  DbUtil.close(con);
}

  }

  void Reset_actionPerformed(ActionEvent e) {
    String sql = "DELETE FROM week_plan WHERE (term_id = ?) ";

        Connection con = null;
        try{
          con = DBConnection.getConnection();
          PreparedStatement ps = con.prepareStatement(sql);
          ps.setString(1, jCBTerm.getSelectedItem().toString() );
          System.out.print(sql) ;
          ps.executeUpdate();
          DbUtil.close(ps);
        }catch(Exception ee){
          ee.printStackTrace();
        }finally{
          DbUtil.close(con);
        }
jBiWeek.setEnabled(false);
  }

  void jCBWeek_actionPerformed(ActionEvent e) {
jTAText.setText(null);
    String sql = "SELECT * " +
                "FROM dbo.week_plan " +
               "WHERE (term_id = '"+jCBTerm.getSelectedItem().toString()+"') AND (week_plan_weekno = "+String.valueOf(jCBWeek.getSelectedIndex()+1)+")";
System.out.print(sql);
           Connection con = null;
        try{
          con = DBConnection.getConnection();
          PreparedStatement ps = con.prepareStatement(sql);
         // System.out.print(sql);
          // System.out.print(jCBTerm.getSelectedItem().toString());

          //ps.setString(1, jCBTerm.getSelectedItem().toString()  );
          ResultSet rs = ps.executeQuery();
          while(rs.next())
      {
        jTAText.setText(rs.getString("week_plan_context"));
      }

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


  }
}

class FWeekTable_this_windowAdapter extends java.awt.event.WindowAdapter {
  FWeekTable adaptee;

  FWeekTable_this_windowAdapter(FWeekTable adaptee) {
    this.adaptee = adaptee;
  }
  public void windowActivated(WindowEvent e) {
    adaptee.this_windowActivated(e);
  }
}

class FWeekTable_jBTermAdd_actionAdapter implements java.awt.event.ActionListener {
  FWeekTable adaptee;

  FWeekTable_jBTermAdd_actionAdapter(FWeekTable adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBTermAdd_actionPerformed(e);
  }
}

class FWeekTable_jCBTerm_actionAdapter implements java.awt.event.ActionListener {
  FWeekTable adaptee;

  FWeekTable_jCBTerm_actionAdapter(FWeekTable adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jCBTerm_actionPerformed(e);
  }
}

class FWeekTable_jBiWeek_actionAdapter implements java.awt.event.ActionListener {
  FWeekTable adaptee;

  FWeekTable_jBiWeek_actionAdapter(FWeekTable adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBiWeek_actionPerformed(e);
  }
}

class FWeekTable_Reset_actionAdapter implements java.awt.event.ActionListener {
  FWeekTable adaptee;

  FWeekTable_Reset_actionAdapter(FWeekTable adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.Reset_actionPerformed(e);
  }
}

class FWeekTable_jCBWeek_actionAdapter implements java.awt.event.ActionListener {
  FWeekTable adaptee;

  FWeekTable_jCBWeek_actionAdapter(FWeekTable adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jCBWeek_actionPerformed(e);
  }
}