inputt_c.java

java语言写的

package scoremis;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import java.util.Vector;
import javax.swing.table.DefaultTableModel;
import java.io.*;

public class InputT_C extends JFrame{
  JLabel jLabel1=new JLabel("教师任课登记");
  JLabel jLabel2=new JLabel("教师姓名：");
  JComboBox tea=new JComboBox();
  JLabel jLabel3=new JLabel("课程名称：");
  JComboBox course=new JComboBox();
  JLabel jLabel4=new JLabel("任课班级：");
  JTextField greade=new JTextField();
  JButton sure=new JButton("添加");
  JButton edit=new JButton("修改");
  JButton browse=new JButton("浏览");
  JButton del=new JButton("删除");
  ResultSet rs=null;
  JLabel jLabel5=new JLabel("任课学期：");
  JTextField term=new JTextField();
  Vector tempvector=new Vector(1,1);
  DefaultTableModel model=new DefaultTableModel();
  JTable dbtable=new JTable(model);
  JScrollPane jScrollPane1=new  JScrollPane(dbtable);
  String sql="",a1,a2,a3,a4;

  public InputT_C() {
    try{
      jbInit();
    }catch(Exception exception){
      exception.printStackTrace() ;
    }
  }
  private void jbInit() throws Exception{
    setTitle("任课登录");
    this.getContentPane().setLayout(null);
    jLabel1.setFont(new java.awt.Font("Dialog", 1, 22)) ;
    jLabel1.setBounds(new Rectangle(146, 24, 157, 42)) ;//设置各组件的位置
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel2.setBounds(new Rectangle(63, 83, 59, 32));
    tea.setFont(new java.awt.Font("Dialog", 0, 12));
    tea.setBounds(new Rectangle(138, 85, 147, 26));
    tea.addItem("请选择教师") ;
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel3.setBounds(new Rectangle(63, 134, 84, 38));
    course.setFont(new java.awt.Font("Dialog", 0, 12));
    course.setBounds(new Rectangle(138, 137, 147, 29));
    course.addItem("请选择课程") ;
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel4.setBounds(new Rectangle(63, 184, 57, 40));
    greade.setFont(new java.awt.Font("Dialog", 0, 12));
    greade.setBounds(new Rectangle(139, 187, 146, 29));
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel5.setBounds(new Rectangle(63, 233, 64, 38));
    term.setFont(new java.awt.Font("Dialog", 0, 12));
    term.setBounds(new Rectangle(139, 236, 146, 29));
    sure.setBounds(new Rectangle(310, 83, 75, 31));
    sure.setFont(new java.awt.Font("Dialog", 0, 12));
    edit.setBounds(new Rectangle(310, 137, 75, 29));
    edit.setFont(new java.awt.Font("Dialog", 0, 12));
    browse.setBounds(new Rectangle(310, 187, 75, 29));
    browse.setFont(new java.awt.Font("Dialog", 0, 12));
    del.setBounds(new Rectangle(310, 236, 75, 29));
    del.setFont(new java.awt.Font("Dialog", 0, 12));
    jScrollPane1.setFont(new java.awt.Font("Dialog", 0, 12));
    jScrollPane1.setBounds(new Rectangle(36, 282, 373, 144));
//添加各组件
    this.getContentPane().add(greade);
    this.getContentPane().add(jLabel2);
    this.getContentPane().add(tea);
    this.getContentPane().add(sure);
    this.getContentPane().add(jLabel3);
    this.getContentPane().add(course);
    this.getContentPane().add(edit);
    this.getContentPane().add(jLabel4);
    this.getContentPane().add(browse);
    this.getContentPane().add(jLabel5);
    this.getContentPane().add(term);
    this.getContentPane().add(del);
    this.getContentPane().add(jScrollPane1);
    this.getContentPane().add(jLabel1);

    model.addColumn("任课教师") ;//为表格添加各列
    model.addColumn("课程名称") ;
    model.addColumn("任课班级") ;
    model.addColumn("任课学期") ;

    sure.addActionListener(new EventHandel()) ;//为各按钮添加监视器
    edit.addActionListener(new EventHandel()) ;
    browse.addActionListener(new EventHandel()) ;
    del.addActionListener(new EventHandel()) ;
    del.setEnabled(false) ;//“删除”与“修改”按钮设置为不可编辑
    edit.setEnabled(false) ;
    dbtable.addMouseListener(new MouseAdapter(){ //为表格添加监视器
        public void mouseClicked(MouseEvent e){
          int j=dbtable.getSelectedRow();
          a1=(String)model.getValueAt(j,0) ;
          a2=(String)model.getValueAt(j,1) ;
          a3=(String)model.getValueAt(j,2) ;
          a4=(String)model.getValueAt(j,3) ;
          tea.setSelectedItem(a1) ;
          course.setSelectedItem(a2) ;
          greade.setText(a3) ;
          term.setText(a4) ;
        }
    });
   dbconn db=new dbconn();
   rs=db.Query("select cname from course") ;
   while(rs.next())
     course.addItem(rs.getString(1)) ;//添加课程项
   rs=db.Query("select name from teacher") ;
   while(rs.next())
     tea.addItem(rs.getString(1)) ;//添加教师项
   db.close() ;
  }
  class EventHandel implements ActionListener{//事件处理类
    public void actionPerformed(ActionEvent e){
      dbconn db=new dbconn();
      if(e.getSource()==browse){//处理查询事件
        sql="select teacher.name,T_C.cname,T_C.Cgreade,T_C.Term from teacher,T_C where T_C.tID=teacher.ID";
        rs=db.Query(sql) ;
        int j=model.getRowCount() ;//删除原dbtable中的说有数据
        if(j>0){
          for(int i=0;i<j;i++)
            model.removeRow(0) ;
        }
        try{
          while(rs.next()){
            tempvector=new Vector(1,1);
            tempvector.add(rs.getString(1)) ;
            tempvector.add(rs.getString(2)) ;
            tempvector.add(rs.getString(3)) ;
            tempvector.add(rs.getString(4)) ;
            model.addRow(tempvector) ;
          }
        }catch(Exception e2){System.out.println(e2.toString()) ;}
        del.setEnabled(true) ;
        edit.setEnabled(true) ;
      }
      else{
        String js=(String)tea.getSelectedItem() ;
        String bj=greade.getText() ;
        String kc=(String)course.getSelectedItem() ;
        String xq=term.getText() ;
        String tid="";
        try{
          sql="select ID from teacher where name='"+js+"'";
          rs=db.Query(sql) ;
          if(rs.next()){
            tid=rs.getString(1) ;
            if(e.getSource()==edit){//建立修改SQL语句
              sql="update T_C set cname='"+kc+"',tID='"+tid+"',Cgreade='"+bj
                  +"',Term='"+xq+"' where cname='"+a2+"' and tID='"+tid+"'and Cgreade='"+a3
                  +"'and Term='"+a4+"'";
            }
            else if(e.getSource()==del){//建立删除SQL语句
              sql="delete * from T_C where cname='"+a2+"'and tID='"+tid+"'and Cgreade='"+a3
                  +"'and Term='"+a4+"'";
            }
            else{//建立插入SQL语句
              sql="insert into T_C values('"+kc+"','"+tid+"','"+bj+"','"+xq+"')";
            }
            int i=db.Update(sql) ;
            if(i>0)
              JOptionPane.showMessageDialog(null,"操作成功！") ;
            else
              JOptionPane.showMessageDialog(null,"操作失败！") ;
          }
        }catch(Exception er){System.out.println(er.toString()) ;}
      }
    }
  }

}