selectedcourse.java

这个是我二年级写的一个教务管理系统 大家可以下来

package caoyu;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
class SelectedCourse extends JFrame implements ActionListener {
   public JRadioButton cname = null;
   public JRadioButton cno = null;
   public JTextField jt = null;
   public JButton btn = null;
   public JButton help=new JButton("查看课程信息");
   public JButton search=new JButton("查询成绩");
   public JTable table = null;
   
   public SelectedCourse() 
   {
      this.initFrame();
      this.setTitle("选课信息系统（视图实现）");
      setSize(700,600);
      setVisible(true);
  }
  public void initFrame()
  {
     Container container = this.getContentPane();
      String[][] p = new String[100][4];
      String[] n = {"sno","sname ","cno  ","cname "};
      table = new JTable(p,n);
      JLayeredPane jlp=new JLayeredPane();
      jlp.setLayout(new GridLayout(1,6));//生成布局
      
      JScrollPane s = new JScrollPane(table);
      container.add(s, BorderLayout.CENTER);
    
      cname = new JRadioButton( "学生姓名" );
      cno = new JRadioButton( "学号");
      
      btn = new JButton( "查询" );
      jlp.add( cname );
      jlp.add( cno);
      ButtonGroup buttongroup=new ButtonGroup();
      buttongroup.add(cname);
      buttongroup.add(cno);
      jlp.add(help);
      jlp.add(search); 
      search.addActionListener(this);   
      help.addActionListener(this);
      jlp.add( btn );
      jt = new JTextField( 10 );
      jlp.add( jt );
      container.add(jlp, BorderLayout.NORTH);
      btn.addActionListener(this);
 }

   public void actionPerformed(ActionEvent e)
      	    {   
      	        try {
      	 	      DBOperatorCourse op = new DBOperatorCourse();
      	 	      
      	 	    
      	 	     if(e.getSource()==btn&&cno.isSelected()&&!jt.getText().trim().equals(""))  //按照学号查询
      	 	      {ResultSet rs=op.queryCourse1(jt.getText().trim());
      	 	      for(int i=0;rs.next();i++)
					{
						table.setValueAt(rs.getString(1),i,0);
						table.setValueAt(rs.getString(2),i,1);
						table.setValueAt(rs.getString(3),i,2);
						table.setValueAt(rs.getString(4),i,3);
					}}
					
      	 	     else if(e.getSource()==btn&&cname.isSelected()&&!jt.getText().trim().equals(""))//按照姓名查询
      	 	      {ResultSet rs=op.queryCourse2(jt.getText().trim());
      	          for(int i=0;rs.next();i++)
					{
						table.setValueAt(rs.getString(1),i,0);
						table.setValueAt(rs.getString(2),i,1);
						table.setValueAt(rs.getString(3),i,2);
						table.setValueAt(rs.getString(4),i,3);
					}
					}
					
					
					
					else if(e.getSource()==help)         ///可供选课的表格（视图）
					{  For_select_corse a=new For_select_corse();}
					else if(e.getSource()==search )             ///查询成绩
					{  Mark a=new Mark();}
					else JOptionPane.showMessageDialog(this,"请输入相关信息");
			   
			       
			   
			   
			   
               }
               
               catch(Exception ex) {
                  //System.out.println(ex.getMessage());
                  ex.printStackTrace();	
               }
            }
   public static void main(String args[])
  {
    SelectedCourse a=new  SelectedCourse();
  }	
  
  }