allgradecount.java

Java大作业+学生成绩管理系统,采用access数据库连接。

//总的成绩统计
//package grade;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.util.Vector;

public class AllgradeCount {
	
	//主框架
	private JFrame frame = new JFrame("总成绩统计");
	//四个标签
	private JLabel JLgradeavg = new JLabel("总分平均分");
	private JLabel JLsignalavg = new JLabel("平均分");
	private JLabel JLgrade = new JLabel("成绩");
	private JLabel JLstu = new JLabel("60的学生");
	//	各科目
	private String course[] = {"网络工程","操作系统","编译原理","软件工程","专业英语"};
	private String cmp[] = {">=","<"};
	//两个下拉列表
	private JComboBox JCBsubject = new JComboBox(course);
	private JComboBox JCBsign = new JComboBox(cmp);
	//两个文本框
	private JTextField JTFgradeavg = new JTextField(10);
	private JTextField JTFsignalavg = new JTextField(10);
	//一个列表
	private JList list = new JList();
	//一个滚动面板,五个面板
	private Container con = frame.getContentPane();
	private JPanel panel1 =new JPanel();
	private JPanel panel2 = new JPanel();
	private JPanel panel3 = new JPanel();
	private JPanel panel4 = new JPanel();
	private JPanel panel5 = new JPanel();
	
//	定义数据库操作对象
	private DataManager manager = new DataManager();
	//定义列表项
	private Vector<String> listStu = new Vector();
	
	//构造框架
	public AllgradeCount(){
		
		//把组件加入面板
		panel1.setLayout(new FlowLayout());
		panel1.add(JLgradeavg);
		panel1.add(JTFgradeavg);
		
		panel2.setLayout(new FlowLayout());
		panel2.add(JCBsubject);
		panel2.add(JLsignalavg);
		panel2.add(JTFsignalavg);
		
		con.setLayout(new BorderLayout());
		con.add(panel1,BorderLayout.NORTH);
		con.add(panel2,BorderLayout.CENTER);
		
		panel4.setLayout(new FlowLayout());
		panel4.add(JLgrade);
		panel4.add(JCBsign);
		panel4.add(JLstu);
		
		
		panel5.add(list);
		
		panel3.setLayout(new BorderLayout());
		panel3.add(panel4,BorderLayout.NORTH);
		panel3.add(panel5,BorderLayout.CENTER);
		
		con.add(panel3,BorderLayout.SOUTH);
		
		frame.setLocation(200,200);
		frame.setSize(400,400);
//		frame.pack();
		frame.setVisible(true);
		frame.setDefaultCloseOperation(frame.DISPOSE_ON_CLOSE);
		
		//初始化
		String subject = (String)JCBsubject.getSelectedItem();
		JTFsignalavg.setText(manager.SubjectAvg(subject));
		listStu = manager.Find(subject, (String)JCBsign.getSelectedItem());
		list.setListData(listStu);
		
		JTFgradeavg.setText(manager.allAvg());
		
		//增加监听器
		JCBsubject.addActionListener(new ActionListener(){

			public void actionPerformed(ActionEvent arg0) {
				// TODO 自动生成方法存根
				String subject = (String)JCBsubject.getSelectedItem();
				JTFsignalavg.setText(manager.SubjectAvg(subject));
				listStu = manager.Find(subject, (String)JCBsign.getSelectedItem());
				list.setListData(listStu);
			}});
		
		JCBsign.addActionListener(new ActionListener(){

			public void actionPerformed(ActionEvent arg0) {
				// TODO 自动生成方法存根
				String symbol = (String)JCBsign.getSelectedItem();
				listStu = manager.Find((String)JCBsubject.getSelectedItem(), symbol);
				list.setListData(listStu);
			}});
	}
	
	
	public static void main(String[] args) {
		// TODO 自动生成方法存根
		
		AllgradeCount a = new AllgradeCount();
		
	}

}