inputt_c.java

Student management system

package scoremis;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import java.util.Vector;    //
import javax.swing.table.DefaultTableModel;//
public class  InputT_C extends JFrame
{
   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("宋体",Font.PLAIN,24));//设置各个组件的位置，字体等属性
        jLabel1.setBounds(new Rectangle(56,9,359,42));
        jLabel2.setBounds(new Rectangle(56,69,85,32));
        tea.setBounds(new Rectangle(131,69,147,31));
        tea.addItem("请选择教师");
        jLabel3.setBounds(new Rectangle(56,120,84,38));
        course.setBounds(new Rectangle(131,123,147,29));
        course.addItem("请选择课程");
        jLabel4.setBounds(new Rectangle(56,170,82,40));
        greade.setBounds(new Rectangle(132,173,146,29));
        jLabel5.setBounds(new Rectangle(56,219,94,38));
        term.setBounds(new Rectangle(132,222,146,29));
        sure.setBounds(new Rectangle(303,69,75,31));
        edit.setBounds(new Rectangle(303,123,75,29));
        browse.setBounds(new Rectangle(303,173,75,29));
        del.setBounds(new Rectangle(303,222,75,29));
        jScrollPanel.setBounds(new Rectangle(29,268,373,144));
        this.getContentPane().add(jLabel1);  //在窗体中添加各个组件
        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(greade);
        this.getContentPane().add(browse);
        this.getContentPane().add(jLabel5);
        this.getContentPane().add(term);
        this.getContentPane().add(del);
        this.getContentPane().add(jScrollPane);
        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()//为表格dbtable添加监视器
        {
           public void mouseClicked(MouseEvent e)//处理鼠标单击
           {
             int j=dbtable.getSelectedRow(); //利用整型变量j存放表格中的行数
             a1=(String)model.getValueAt(j,0);//分别利用字符串变量a1,a2,a3,a4存放表格中第j行的第0,1,2,3列的值
             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();
     }
    JLabel jLabel1=new JLabel("教师任课登记");//设各个组件的初始值
    JLabel jLabel2=new JLabel("教师姓名");
    JComboBox tea=new JComboBox();
    JLabel jLabel3=new JLabel("课程名称");
    JComboBox course=new JComboBox();
    JLable 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 jScrollPanel=new JScrollPane(dbtable);  //在表格中添加滚动条
    String sql="";
    String a1;
    String a2;
    String a3;
    String a4;

  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.ddd(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();
             Stirng 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);//执行sql语句，并根据执行结果弹出相应的信息提示框
                  if(i>0)
                     JOptionPane.showMessageDialog(null,"操作成功");
                  else
                     JOptionPane.showMessageDialog(null,"操作失败");    
                  }              
               }
             catch(exception er)
               {
                 System.out.println(er.toString());
               }
 
            }
        }
     }
}