majorclassterm.java.bak

辽宁交通专科学校０３级大三的一个课程设计学生成绩管理信息系统．赵磊

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.util.*;
import java.sql.*;
import javax.swing.table.*;
class MajorClassTerm extends JFrame implements ActionListener
{ 
  JFrame f=new JFrame(" 专业，班级和学期设置");
  JLabel lbmajor=new JLabel("请输入查询的专业"),
         lbclass=new JLabel("  班级"),
         lbterm=new JLabel("  学期");
                                  
  JTextField tfmajor=new JTextField(12),       
             tfclass=new JTextField(12),
             tfterm=new JTextField(12);
            
   JPanel p1=new JPanel(),
          p2=new JPanel(),
          p3=new JPanel(),
          p4=new JPanel(),
          p5=new JPanel();
  JScrollPane sp=new JScrollPane();
  JButton btnserch=new JButton("查询 "), 
          btnclear=new JButton("清空 "),
          btnadd=new JButton("添加 "),
          btndelete=new JButton("删除 "),
          btnexit=new JButton("退出 ");
  Vector tempvector1;
  DefaultTableModel model=new DefaultTableModel();
  JTable TableResult=new JTable(model);        
          
          
  public MajorClassTerm()
  {
    Container cp=f.getContentPane();
    cp.setLayout(new BorderLayout());
    p5.setLayout(new GridLayout(4,1));
    p1.add(lbmajor);p1.add(tfmajor);p1.add(btnserch);
    p2.add(lbclass);p2.add(tfclass);
    p3.add(lbterm);p3.add(tfterm);
    p4.add(btnclear);p4.add(btnadd);p4.add(btndelete);p4.add(btnexit);
    p5.add(p1);p5.add(p2);p5.add(p3);p5.add(p4);
    cp.add("North",p5);cp.add("Center",sp);
    
    
  
    model.addColumn("专业") ;
    model.addColumn("班级") ;
    model.addColumn("学期") ;
    
    sp.getViewport().add(TableResult,null);
    
    btnserch.addActionListener(this);
    btnclear.addActionListener(this);
    btnadd.addActionListener(this);
    btndelete.addActionListener(this);
    btnexit.addActionListener(this);
  
    f.setSize(400,400);
    f.setVisible(true);
    }
    
    public void actionPerformed(ActionEvent e)
    {          
    	
     if(e.getSource()==btnserch)
       {  
     	
     	    if(tfmajor.getText().trim().equals(""))
     	     {
               JOptionPane.showMessageDialog(this,"抱歉，您还没有输入查询的内容，请输入查询的内容后再查询 ");
               tfmajor.setText(null);
             }
          else{
      	        for(int i=model.getRowCount()-1;i>=0;i--)
                 { model.removeRow(i); }
	  	      	
     	       try{
	          Connection con=DriverManager.getConnection("jdbc:odbc:Xsstudent");
                  Statement s=con.createStatement();
                  String strSQL="select * from mcterm where major='"+tfmajor.getText().trim()+"'";
                  ResultSet rs=s.executeQuery(strSQL);
                       
                          if(!rs.next())
                            { JOptionPane.showMessageDialog(this,"抱歉,还没有您要查询的记录，或者您的输入不符合查询的条件，请确认后重新输入 ");
                              tfmajor.setText(null);
                            }
                          else{
                            
		             do  {
		                
			 	tempvector1=new Vector(1,1);
		         	tempvector1.add(rs.getString("major"));
			 	tempvector1.add(rs.getString("class"));
           	         	tempvector1.add(rs.getString("term"));
                                model.addRow(tempvector1);
     	                         }while(rs.next());
     	                       }
     	          s.close();
     	          con.close();       
     	         }       
     	      catch(Exception ee)
     	      {System.out.println("信息查询出错: "+ee.getMessage()); }
          }
      }

            if (e.getSource()==btnclear) 
            {
                     
                    tfmajor.setText(null); 
                    tfclass.setText(null);
                    tfterm.setText(null);
                    for(int i=model.getRowCount()-1;i>=0;i--)
                      { model.removeRow(i); }
                  } 
                  
           if (e.getSource()==btnadd) 
            { 
            	     try{  
                        
                        if((tfmajor.getText().equals(""))||(tfclass.getText().equals("")) ||(tfterm.getText().equals("")) )
            	         
            	          {JOptionPane.showMessageDialog(null,"抱歉！您还有相关的信息没有输入。请输入相应的信息再点击添加按钮！"); }
            	       else
            	         {String strSQL="insert into mcterm(major,class,term) values('"+tfmajor.getText()+"','"+tfclass.getText()+"','"+tfterm.getText()+"')";
            	          String strall="select * from mcterm";
            	          Connection con=DriverManager.getConnection("jdbc:odbc:Xsstudent"); 
                          Statement s=con.createStatement(); 
            	    	  s.executeUpdate(strSQL);
            	    	  JOptionPane.showMessageDialog(null,"恭喜你，添加成功！ ");
            	    	  tfmajor.setText(null); 
                 	  tfclass.setText(null);
                 	  tfterm.setText(null);	
            	    	 
            	    	 ResultSet rs=s.executeQuery(strall);
            	    	 for(int i=model.getRowCount()-1;i>=0;i--)
                           { model.removeRow(i); }
            	    	 while(rs.next())
            	    	 {      tempvector1=new Vector(1,1);
		         	tempvector1.add(rs.getString("major"));
			 	tempvector1.add(rs.getString("class"));
           	         	tempvector1.add(rs.getString("term"));
                                model.addRow(tempvector1);
            	    	 	}
            	    	 
            	    	
            	    	 
                    	 
            	         } 
                    }         
                   catch(Exception ee)
                   {System.out.println("添加信息出错:"+ee.getMessage()); } 
                  

            }/*
         if (e.getSource()==btndelete)
          {   
           if(tfmajor.getText().trim().equals(""))
       	       { JOptionPane.showMessageDialog(this,"抱歉，专业不可以为空，无法删除");}
           else{
        	
                 try{ 
       	            Connection con=DriverManager.getConnection("jdbc:odbc:Xsstudent");
                    Statement s=con.createStatement();  
       	            String id = tfsid.getText();
                    String strSQL = "delete * from mcterm where major= '"+tfmajor.getText().trim()+"' ";
         	    s.executeUpdate(strSQL);
                  }
                catch(Exception exx)
                {JOptionPane.showMessageDialog(null,"抱歉，出错了");}
                
           	
            	    JOptionPane.showMessageDialog(null,"删除成功！");
             	   
             	    tfmajor.setText(null);
             	    tfphone.setText(null);
             	    tfjiguan.setText(null);
             	   
       	     }
       	}*/
      if (e.getSource()==btnexit) { f.setVisible(false);}
    	
     
     }
    
    public static void main(String args[])
    {       
    	String JDriver="sun.jdbc.odbc.JdbcOdbcDriver";
	      String conURL="jdbc:odbc:Xsstudent";
	      try{
	      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	      }
	      catch(Exception e)
	      { 
	      	System.out.println("加载驱动失败");}
    	
    	new MajorClassTerm();
    	
    	}
 
 }