markstatisticframe.java

学生信息管理系统

package com.sccp.StudentMS.baseFrame;


import java.awt.BorderLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.DefaultComboBoxModel;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JTextField;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.swing.JOptionPane;
import com.sccp.StudentMS.DBtools.DBtool;
import com.swtdesigner.SwingResourceManager;

public class MarkStatisticFrame extends JFrame {

	private JTextField max;
	private JTextField min;
	private JComboBox type;
	DBtool db=new DBtool();
	ResultSet rs,rs1;
	String sql;
	String sumType;
	
	/**
	 * Launch the application
	 * @param args
	 */
	public static void main(String args[]) {
		try {
			MarkStatisticFrame frame = new MarkStatisticFrame();
			frame.setVisible(true);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	/**
	 * Create the frame
	 */
	public MarkStatisticFrame() {
		super();
		setTitle("成绩统计");
		setBounds(100, 100, 500, 227);
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

		final JPanel panel = new JPanel();
		panel.setLayout(null);
		getContentPane().add(panel, BorderLayout.CENTER);

		final JLabel label = new JLabel();
		label.setText("选择统计选项：");
		label.setBounds(53, 35, 105, 15);
		panel.add(label);

		type = new JComboBox();
		type.setModel(new DefaultComboBoxModel(new String[] {"总分", "政治", "高数", "英语", "专业课"}));
		type.setBounds(53, 77, 87, 23);
		panel.add(type);

		final JLabel label_1 = new JLabel();
		label_1.setText("请输入统计范围：");
		label_1.setBounds(244, 35, 148, 15);
		panel.add(label_1);

		final JLabel label_2 = new JLabel();
		label_2.setText("从");
		label_2.setBounds(264, 81, 16, 15);
		panel.add(label_2);

		min = new JTextField();
		min.setBounds(286, 79, 63, 20);
		panel.add(min);

		final JLabel label_3 = new JLabel();
		label_3.setText("到");
		label_3.setBounds(355, 81, 19, 15);
		panel.add(label_3);

		max = new JTextField();
		max.setBounds(376, 79, 61, 20);
		panel.add(max);

		final JButton button = new JButton();
		button.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				sql="select * from grade ";
				 if(type.getSelectedIndex()==0)
					 sumType="Total";
				 else if(type.getSelectedIndex()==1)
					 sumType="philosophy";
				 else if(type.getSelectedIndex()==2)
					 sumType="math";
				 else if(type.getSelectedIndex()==3)
					 sumType="english";
				 else if(type.getSelectedIndex()==4)
					 sumType="specialty";
					 if(min.getText().equals("")&&max.getText().equals(""))
						 JOptionPane.showMessageDialog(null, "统计范围不能为空！");
					 else 
				{
						 if(min.getText().equals(""))
						  sql=sql+" where "+sumType+"<="+max.getText();
					 else if(max.getText().equals(""))
						  sql=sql+" where "+sumType+">="+min.getText();
					 else 
					 {
						  sql=sql+" where "+sumType+">="+min.getText();
						  sql=sql+" and "+sumType+"<="+max.getText();
					 }
					 rs=db.getResult(sql);	
					 rs1=db.getResult(sql);				      
					 try {
						if(rs.next())
						 {  
							 listShow();
							 MarkStatisticFrame.this.dispose();
						 }else
						 {
							 JOptionPane.showMessageDialog(null, "无满足条件的学生信息！");
						 }
					} catch (SQLException e1) {
						// TODO Auto-generated catch block
						e1.printStackTrace();
					}
			 }		 
			}
		});
		button.setText("确定");
		button.setBounds(73, 131, 72, 23);
		panel.add(button);

		final JButton button_1 = new JButton();
		button_1.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				 MarkStatisticFrame.this.dispose();
			}
		});
		button_1.setText("取消");
		button_1.setBounds(223, 131, 71, 23);
		panel.add(button_1);

		final JLabel label_5 = new JLabel();
		panel.add(label_5);
		label_5.setIcon(SwingResourceManager.getIcon(MarkStatisticFrame.class, "/images/cool8.gif"));
		label_5.setText(" ");
		label_5.setBounds(160, 35, 50, 50);

		final JLabel label_4 = new JLabel();
		label_4.setIcon(SwingResourceManager.getIcon(MarkStatisticFrame.class, "/images/发.JPG"));
		label_4.setText(" ");
		label_4.setBounds(0, 0, 492, 193);
		panel.add(label_4);
		//
	}
 public void listShow()
 {
	 MarkSortTableFrame mstf=new MarkSortTableFrame();
	 mstf.showTableMarkInfo(rs1);
	 mstf.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
	 mstf.setVisible(true);
 }
}