fcoursesetting.java

中小学校园的教师

package untitled2;

import javax.swing.*;
import java.awt.*;
import com.borland.jbcl.layout.*;
import com.borland.dbswing.*;
import javax.swing.border.*;
import java.awt.event.*;
import Digital_Campus_DataModule.*;
import javax.swing.*;
import java.awt.*;
import com.borland.jbcl.layout.*;
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 javax.swing.border.*;
import java.sql.Statement;
import java.util.Date;
import java.text.*;

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

public class FCourseSetting extends JFrame {
   String num[]=new String[]{"1","2","3","4","5","6","7","8"};
  XYLayout xYLayout1 = new XYLayout();
  JLabel jLTerm = new JLabel();
  JLabel jLGrade = new JLabel();
  JButton jBCourseAdd = new JButton();
  JPanel jPCouseSet = new JPanel();
  Border border1;
  TitledBorder titledBorder1;
  JComboBox jCBChooseCouse = new JComboBox();
  JLabel jLChooseCouse = new JLabel();
  JLabel jLClassNum = new JLabel();
  Border border2;
  TitledBorder titledBorder2;
  Border border3;
  TitledBorder titledBorder3;
  DB_DataModule dB_DataModule_CourseSet;
  JComboBox jCBTerm = new JComboBox();
  JComboBox jCBGrade = new JComboBox();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JComboBox jComboBox3 = new JComboBox(num);
  JPanel jPCourseTime = new JPanel();
  TitledBorder titledBorder4;
  JPanel jPCourseTimeShow = new JPanel();
  TitledBorder titledBorder5;
  XYLayout xYLayout2 = new XYLayout();
  TableScrollPane tSPCourse = new TableScrollPane();
  JdbTable jdbTCouse = new JdbTable();
  JTextField jTFClassNumber = new JTextField();
  JButton jBTime = new JButton();
  JButton jButton2 = new JButton();
  JFormattedTextField jFormattedTextField1 = new JFormattedTextField();
  JTextField jTextField1 = new JTextField();
  DB_DataModule dB_DataModule_Course;
  JTextField jTextField2 = new JTextField();
  JButton jButton1 = new JButton();
  Object columnnames[]={"课程名","学期"};
    Object rowdata[][]=new Object[25][2];
  JPanel jPShow = new JPanel();
  Border border4;
  JScrollPane jScrollPane1 = new JScrollPane();
  JTable jTable1 = new JTable(rowdata,columnnames);
  JButton jButton3 = new JButton();

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

  void jbInit() throws Exception {
    border1 = BorderFactory.createEmptyBorder();
    titledBorder1 = new TitledBorder(BorderFactory.createEtchedBorder(Color.white,new Color(148, 145, 140)),"课程设置");
    border2 = BorderFactory.createLineBorder(SystemColor.controlText,1);
    titledBorder2 = new TitledBorder(BorderFactory.createEtchedBorder(Color.white,new Color(148, 145, 140)),"课程设置预览");
    border3 = BorderFactory.createEtchedBorder(Color.white,new Color(148, 145, 140));
    titledBorder3 = new TitledBorder(border3,"上课时间设置");
    dB_DataModule_CourseSet = Digital_Campus_DataModule.DB_DataModule.getDataModule();
    titledBorder4 = new TitledBorder(BorderFactory.createEtchedBorder(Color.white,new Color(148, 145, 140)),"上课时间");
    titledBorder5 = new TitledBorder(BorderFactory.createEtchedBorder(Color.white,new Color(148, 145, 140)),"课程时间");
    dB_DataModule_Course = Digital_Campus_DataModule.DB_DataModule.getDataModule();
    border4 = new TitledBorder(BorderFactory.createEtchedBorder(Color.white,new Color(148, 145, 140)),"课程信息");
    this.getContentPane().setLayout(xYLayout1);
    this.setDefaultCloseOperation(HIDE_ON_CLOSE);
    this.setLocale(new java.util.Locale("zh", "CN", ""));
    this.setResizable(false);
    this.setSize(new Dimension(800, 600));
    this.setTitle("课程设置");
    this.addWindowListener(new FCourseSetting_this_windowAdapter(this));
    jLTerm.setFont(new java.awt.Font("Dialog", 0, 12));
    jLTerm.setText("学期：");
    jLTerm.setBounds(new Rectangle(16, 26, 45, 20));
    jLGrade.setFont(new java.awt.Font("Dialog", 0, 12));
    jLGrade.setText("年级：");
    jLGrade.setBounds(new Rectangle(172, 27, 60, 18));
    jBCourseAdd.setBounds(new Rectangle(648, 26, 61, 21));
    jBCourseAdd.setFont(new java.awt.Font("Dialog", 0, 12));
    jBCourseAdd.setText("添加");
    jBCourseAdd.addActionListener(new FCourseSetting_jBCourseAdd_actionAdapter(this));
    jPCouseSet.setLayout(null);
    jPCouseSet.setFont(new java.awt.Font("Dialog", 0, 13));
    jPCouseSet.setBorder(titledBorder1);
    jPCouseSet.setDebugGraphicsOptions(0);
    jCBChooseCouse.setBounds(new Rectangle(566, 23, 63, 22));
    jLChooseCouse.setFont(new java.awt.Font("Dialog", 0, 12));
    jLChooseCouse.setText("所学科目：");
    jLChooseCouse.setBounds(new Rectangle(496, 26, 76, 20));
    jLClassNum.setFont(new java.awt.Font("Dialog", 0, 12));
    jLClassNum.setText("班级数：");
    jLClassNum.setBounds(new Rectangle(394, 26, 57, 20));
    jCBTerm.setBounds(new Rectangle(59, 26, 103, 21));
    jCBTerm.addItemListener(new FCourseSetting_jCBTerm_itemAdapter(this));
    jCBTerm.addActionListener(new FCourseSetting_jCBTerm_actionAdapter(this));
    jCBGrade.setBounds(new Rectangle(220, 25, 82, 22));
    jCBGrade.addActionListener(new FCourseSetting_jCBGrade_actionAdapter(this));
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel2.setToolTipText("");
    jLabel2.setText("开始时间：");
    jLabel2.setBounds(new Rectangle(171, 29, 65, 20));
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel1.setLocale(java.util.Locale.getDefault());
    jLabel1.setDebugGraphicsOptions(0);
    jLabel1.setText("节数：");
    jLabel1.setBounds(new Rectangle(22, 30, 44, 18));
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel3.setText("结束时间：");
    jLabel3.setBounds(new Rectangle(360, 30, 79, 19));
    jComboBox3.setBounds(new Rectangle(79, 30, 56, 19));
    jPCourseTime.setBorder(titledBorder3);
    jPCourseTime.setLayout(null);

    jPCourseTimeShow.setFont(new java.awt.Font("Dialog", 0, 13));
    jPCourseTimeShow.setLocale(java.util.Locale.getDefault());
    jPCourseTimeShow.setBorder(titledBorder5);
    jPCourseTimeShow.setLayout(xYLayout2);
    jdbTCouse.setDataSet(dB_DataModule_CourseSet.getQDSCourseSet());
    jTFClassNumber.setEditable(false);
    jTFClassNumber.setText("");
    jTFClassNumber.setBounds(new Rectangle(454, 26, 28, 20));
    jBTime.setBounds(new Rectangle(575, 28, 63, 22));
    jBTime.setText("确定");
    jBTime.addActionListener(new FCourseSetting_jBTime_actionAdapter(this));
    jButton2.setBounds(new Rectangle(682, 28, 65, 23));
    jButton2.setText("重置");
    jButton2.addActionListener(new FCourseSetting_jButton2_actionAdapter(this));
   // jFTFStar.setBounds(new Rectangle(270, 31, 84, 20));
    jTextField1.setText("");
    jTextField1.setBounds(new Rectangle(451, 30, 89, 19));
    jTextField2.setText("");
    jTextField2.setBounds(new Rectangle(254, 30, 81, 19));
    jButton1.setBounds(new Rectangle(717, 25, 59, 22));
    jButton1.setFont(new java.awt.Font("Dialog", 0, 12));
    jButton1.setText("重置");
    jButton1.addActionListener(new FCourseSetting_jButton1_actionAdapter(this));
    jPShow.setBorder(border4);
    jPShow.setDebugGraphicsOptions(0);
    jPShow.setLayout(null);
    jScrollPane1.setBounds(new Rectangle(23, 26, 371, 345));
    jButton3.setBounds(new Rectangle(319, 26, 60, 23));
    jButton3.setFont(new java.awt.Font("Dialog", 0, 12));
    jButton3.setText("查询");
    jButton3.addActionListener(new FCourseSetting_jButton3_actionAdapter(this));
    jPCouseSet.add(jLTerm, null);
    jPCouseSet.add(jCBTerm, null);
    jPCouseSet.add(jButton1, null);
    jPCouseSet.add(jBCourseAdd, null);
    jPCouseSet.add(jLChooseCouse, null);
    jPCouseSet.add(jLClassNum, null);
    jPCouseSet.add(jTFClassNumber, null);
    jPCouseSet.add(jLGrade, null);
    jPCouseSet.add(jCBGrade, null);
    jPCouseSet.add(jButton3, null);
    jPCouseSet.add(jCBChooseCouse, null);
    this.getContentPane().add(jPCourseTime,    new XYConstraints(8, 83, 779, 69));
    jPCourseTime.add(jButton2, null);
    //jPCourseTime.add(jFTFStar, null);
    jPCourseTime.add(jLabel1, null);
    jPCourseTime.add(jComboBox3, null);
    jPCourseTime.add(jLabel2, null);
    jPCourseTime.add(jTextField2, null);
    jPCourseTime.add(jLabel3, null);
    jPCourseTime.add(jTextField1, null);
    jPCourseTime.add(jBTime, null);

    this.getContentPane().add(jPCouseSet,    new XYConstraints(5, 8, 783, 65));
    this.getContentPane().add(jPCourseTimeShow,    new XYConstraints(432, 163, 355, 416));
    jPCourseTimeShow.add(tSPCourse,   new XYConstraints(12, 3, 318, 368));
    this.getContentPane().add(jPShow,   new XYConstraints(13, 163, 414, 416));
    jPShow.add(jScrollPane1, null);
    jScrollPane1.getViewport().add(jTable1, null);
    tSPCourse.getViewport().add(jdbTCouse, null);

  }

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

  void jBCourseAdd_actionPerformed(ActionEvent e) {
   String sql=null;

    Connection con = null;
       PreparedStatement ps =null;
       ResultSet rs=null;
       try{
         con = DBConnection.getConnection();
         if(Integer.parseInt(jTFClassNumber.getText())==0)
         {
           JOptionPane.showMessageDialog(null," 该年级尚未设置班级");

         }

         for(int i=0;i<Integer.parseInt(jTFClassNumber.getText());i++){


         if(i==0){
           sql =" SELECT *  "+
                "FROM dbo.course  "+
                "WHERE (course_name = '"+jCBGrade.getSelectedItem().toString()+String.valueOf(i+1)+"班"+jCBChooseCouse.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.course "+
                     "(course_term, course_name) "+
                     "VALUES ('"+jCBTerm.getSelectedItem().toString()+"', '"+jCBGrade.getSelectedItem().toString()+String.valueOf(i+1)+"班"+jCBChooseCouse.getSelectedItem().toString()+"') ";



           ps = con.prepareStatement(sql);
            //System.out.print(jCBGrade.getSelectedItem().toString()+String.valueOf(i+1)+jCBChooseCouse.getSelectedItem().toString()+ );

          //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);
       }
 DB_DataModule.getDataModule().getQDSCourse() .refresh();

  }

  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"));
      }
      sql = "SELECT * FROM grade";
      ps = con.prepareStatement(sql);
      rs = ps.executeQuery();