scoreframe.java

学生成绩管理系统

import java.awt.*;
import java.awt.event.*;

import java.util.*;
import java.sql.*;

import javax.swing.*;


public class ScoreFrame extends JFrame {
  
	public ScoreFrame(Connection connect){

		setTitle("Score Manage Frame");
          Container c=getContentPane();
          c.setLayout(new GridLayout(12,2));
		jl_term=new JLabel("Please select a term");
		
		
		
		con=connect;
		
		Vector vc=getTerm();
		jco_term=new JComboBox(vc);
		jco_term.setEditable(true);
		jco_term.validate();
		
		jl_sno=new JLabel("number");jtf_sno=new JTextField("",10);
		jl_eng=new JLabel("english");jtf_eng=new JTextField("",10);
		jl_math=new JLabel("mathmatics");jtf_math=new JTextField("",10);
		jl_db=new JLabel("database");jtf_db=new JTextField("",10);
		jl_java=new JLabel("Java");jtf_java=new JTextField("",10);
		
		
		jb_find=new JButton("find");
   		jb_delete=new JButton("delete");
   		jb_update=new JButton("alter");
   		jb_ok=new JButton("insert");
   		
   		
		c.add(jl_term);
		c.add(jco_term);
		c.add(jl_sno);c.add(jtf_sno);
		c.add(jl_eng);c.add(jtf_eng);
		c.add(jl_math);c.add(jtf_math);
		c.add(jl_db);c.add(jtf_db);
		c.add(jl_java);c.add(jtf_java);
		c.add(jb_find);c.add(jb_delete);
		c.add(jb_update);c.add(jb_ok);
		
	
		
		
		jb_find.addActionListener(new FindListener());
   		jb_delete.addActionListener(new DeleteListener());
   		jb_update.addActionListener(new UpdateListener() );
   		jb_ok.addActionListener(new OKListener());
		
		
	}
	
	////获得学期内容
	Vector getTerm(){
		
		Vector vc=new Vector();
		try{
			
			Statement st=con.createStatement();
			String sql="select * from score ";
			rs=st.executeQuery(sql);
			while(rs.next()){
				vc.addElement(rs.getInt(6)+"");
			}
			
		}catch(SQLException e1){
			JOptionPane.showMessageDialog(null, e1.getMessage());
		}
		return vc;
	}
	
	
	 ////////////响应事件
    class FindListener implements ActionListener{

		public void actionPerformed(ActionEvent e) {
			try{
			
			String s=jtf_sno.getText();
			String sql="select * from score where sno =?";
			PreparedStatement pre=con.prepareStatement(sql);
			pre.setString(1, s);
			rs=pre.executeQuery();
			if(!rs.next()){
				JOptionPane.showMessageDialog(null, "Can not find");
				return;
			}
			jtf_eng.setText(rs.getFloat(2)+"");
			jtf_math.setText(rs.getFloat(3)+"");
			jtf_db.setText(rs.getFloat(4)+"");
			jtf_java.setText(rs.getFloat(5)+"");
			pre.close();
		   }catch(SQLException e1){
			   JOptionPane.showMessageDialog(null, e1.getMessage());
		   }
		}
  	  
    }
    class DeleteListener implements ActionListener{

		public void actionPerformed(ActionEvent e) {
			try{
				
				
				String s=jtf_sno.getText();
				String sql="delete from score where sno=?";
				PreparedStatement pre=con.prepareStatement(sql);
				pre.setString(1, s);
				if(pre.executeUpdate()!=0)
				JOptionPane.showMessageDialog(null, "delete successfully!");
				else
					JOptionPane.showMessageDialog(null, "delete error!");
				jtf_sno.setText("");
				jtf_eng.setText("");
				jtf_math.setText("");
				jtf_db.setText("");
				jtf_java.setText("");
				jco_term.removeItem(jco_term.getSelectedItem());
				
			}catch(SQLException e1){
			   JOptionPane.showMessageDialog(null, e1.getMessage());
		   }
			
		}
    	  
      }
    class UpdateListener implements ActionListener{

  		public void actionPerformed(ActionEvent e) {
  			
  			String s1=jtf_sno.getText();
  			if(s1.equals("")){
  				JOptionPane.showMessageDialog(null, "Can not Update!");
  				return;
  			}
  				
  			try{
    				String s=jtf_sno.getText();
    				
    				String sql="delete from score where sno=?";
    				PreparedStatement pre=con.prepareStatement(sql);
    				pre.setString(1, s);
    				pre.executeUpdate();
    				
    				
    			}catch(SQLException e1){
   			   JOptionPane.showMessageDialog(null, e1.getMessage());
   		   }
  			
  		}
      	  
        }
    class OKListener implements ActionListener{

    		public void actionPerformed(ActionEvent e) {
    			
    			
    			try{
    				if(jtf_sno.getText().equals("")){
      				JOptionPane.showMessageDialog(null, "Can not Update!");
      				return;
      			}
    				
    				
    				
    				
    				
    				String sql="insert into dept values(?,?,?,?,?,?)";
    				PreparedStatement pre=con.prepareStatement(sql);
    				pre.setString(1, jtf_sno.getText());
    				pre.setFloat(2, Float.parseFloat(jtf_eng.getText()));
    				pre.setFloat(3, Float.parseFloat(jtf_math.getText()));
    				pre.setFloat(4, Float.parseFloat(jtf_db.getText()));
    				pre.setFloat(5, Float.parseFloat(jtf_java.getText()));
    				pre.setInt(6, Integer.parseInt(jco_term.getSelectedItem().toString()));
    				
    				pre.executeUpdate();
    				JOptionPane.showMessageDialog(null, "update successfully!");
    				
    				
    			}catch(SQLException e1){
   			   JOptionPane.showMessageDialog(null, e1.getMessage());
   		   }
    			
    			
    		}
        	  
          }
	
	JLabel jl_term;
	JComboBox jco_term;
	JList jlist_info;
	
	JLabel jl_sno,jl_eng,jl_math,jl_db,jl_java;
	JTextField jtf_eng,jtf_math,jtf_db,jtf_java,jtf_sno;
	Connection con;
	ResultSet rs;
	
	
	
	JButton jb_find,jb_delete,jb_update,jb_ok;
	
	
	
}