scoreinfoframe.java

学生成绩管理系统

import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.*;
import java.sql.*;
public class ScoreInfoFrame extends JFrame {
  
	public ScoreInfoFrame(Connection connect,String user){

		setTitle("Score Infromation Query Frame");
          Container c=getContentPane();
          c.setLayout(new GridLayout(7,2));
		jl_term=new JLabel("Please select a term");
		//jco_term=new JComboBox();
		
		
		con=connect;
		this.user=user;
		Vector vc=getTerm();
		jco_term=new JComboBox(vc);
		//for(int i=0;i<vc.size();i++)
		//jco_term.addItem(vc.get(i));
		
		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);
		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);
		
		///////////为JComboBox添加事件响应
		jco_term.addActionListener(new TermListener());
		
		
		
		
	}
	
	////获得学期内容
	Vector getTerm(){
		
		Vector vc=new Vector();
		try{
			
			Statement st=con.createStatement();
			String sql="select * from score where sno='"+user+"'";
			rs=st.executeQuery(sql);
			while(rs.next()){
				vc.addElement(rs.getInt(6)+"");
			}
			
		}catch(SQLException e1){
			JOptionPane.showMessageDialog(null, e1.getMessage());
		}
		return vc;
	}
	
	////////////////////Cmobox事件响应
	
	class TermListener implements ActionListener{

		public void actionPerformed(ActionEvent e) {
			
			String s=jco_term.getSelectedItem().toString();
			try{
			String sql=" select * from score where sno=? and term=?";
			PreparedStatement st=con.prepareStatement(sql);
			st.setString(1, user);
			st.setInt(2, Integer.parseInt(s));
			rs=st.executeQuery();
			rs.next();
			jtf_sno.setText(rs.getString(1));
			jtf_eng.setText(rs.getFloat(2)+"");
			jtf_math.setText(rs.getFloat(3)+"");
			jtf_db.setText(rs.getFloat(4)+"");
			jtf_java.setText(rs.getFloat(5)+"");
			
			rs.close();
			st.close();
			}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;
	String user;
	
	
	
}
/*JLabel jl_jold;
JLabel jl_jnew;
JLabel jl_again;
JTextField jtf_old,jtf_new,jtf_again;*/