package Panel.StudentSroce;

import javax.swing.*;
import java.util.*;
import Sys.dao.*;
import Sys.vo.*;

public class QuerySrocePanel extends javax.swing.JPanel {
	private static final long serialVersionUID = 1L;
	public QuerySrocePanel() {
		initComponents();
	}
	private void initComponents() {
		java.awt.GridBagConstraints gridBagConstraints;

		jLabel1 = new javax.swing.JLabel();
		jLabel2 = new javax.swing.JLabel();
		jTextField1 = new javax.swing.JTextField();
		jButton1 = new javax.swing.JButton();
		jLabel3 = new javax.swing.JLabel();
		jPanel1 = new javax.swing.JPanel();

		setLayout(new java.awt.GridBagLayout());

		jLabel1.setFont(new java.awt.Font("宋體", 1, 24));
		jLabel1.setText("\u67e5\u8be2\u5b66\u751f\u6210\u7ee9");
		gridBagConstraints = new java.awt.GridBagConstraints();
		gridBagConstraints.gridwidth = java.awt.GridBagConstraints.REMAINDER;
		gridBagConstraints.weightx = 5.0;
		gridBagConstraints.weighty = 2.0;
		add(jLabel1, gridBagConstraints);

		jLabel2.setFont(new java.awt.Font("宋體", 0, 14));
		jLabel2.setText("\u8bf7\u8f93\u5165\u5b66\u751f\u5b66\u53f7");
		gridBagConstraints = new java.awt.GridBagConstraints();
		gridBagConstraints.weightx = 5.0;
		gridBagConstraints.weighty = 2.0;
		add(jLabel2, gridBagConstraints);

		jTextField1.setColumns(20);
		gridBagConstraints = new java.awt.GridBagConstraints();
		gridBagConstraints.weightx = 5.0;
		gridBagConstraints.weighty = 2.0;
		add(jTextField1, gridBagConstraints);

		jButton1.setText("\u67e5\u8be2");
		jButton1.addActionListener(new java.awt.event.ActionListener() {
			public void actionPerformed(java.awt.event.ActionEvent evt) {
				jButton1ActionPerformed(evt);
			}
		});
		gridBagConstraints = new java.awt.GridBagConstraints();
		gridBagConstraints.gridwidth = java.awt.GridBagConstraints.REMAINDER;
		gridBagConstraints.weightx = 5.0;
		gridBagConstraints.weighty = 2.0;
		add(jButton1, gridBagConstraints);

		jLabel3.setFont(new java.awt.Font("宋體", 0, 14));
		jLabel3.setText("\u8be5\u751f\u6210\u7ee9\u5982\u4e0b");
		gridBagConstraints = new java.awt.GridBagConstraints();
		gridBagConstraints.weightx = 5.0;
		gridBagConstraints.weighty = 2.0;
		gridBagConstraints.insets = new java.awt.Insets(-10, 0, 0, 0);
		add(jLabel3, gridBagConstraints);

		jPanel1.setBorder(javax.swing.BorderFactory
				.createLineBorder(new java.awt.Color(0, 0, 0)));
		jPanel1.setLayout(new java.awt.GridBagLayout());
		gridBagConstraints = new java.awt.GridBagConstraints();
		gridBagConstraints.gridx = 0;
		gridBagConstraints.gridy = 3;
		gridBagConstraints.gridwidth = java.awt.GridBagConstraints.REMAINDER;
		gridBagConstraints.fill = java.awt.GridBagConstraints.BOTH;
		gridBagConstraints.weightx = 5.0;
		gridBagConstraints.weighty = 15.0;
		gridBagConstraints.insets = new java.awt.Insets(10, 40, 10, 40);
		add(jPanel1, gridBagConstraints);
	}

	private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
		jPanel1.removeAll();
		StudentInfoDao studentinfodao=new StudentInfoDao();
		StudentInfo studentinfo=studentinfodao.getStudentInfo(jTextField1.getText().trim());
		StudentSroceDao studentsrocedao=new StudentSroceDao();
		List<StudentSroce> list=studentsrocedao.getStudentSroce(jTextField1.getText().trim());
		if(studentinfo!=null){
			java.awt.GridBagConstraints gridBagConstraints;
			javax.swing.JLabel jLabel4=new JLabel();
			jLabel4.setFont(new java.awt.Font("宋體", 0, 14));
			jLabel4.setText("\u59d3\u540d");
			gridBagConstraints = new java.awt.GridBagConstraints();
			gridBagConstraints.weightx = 5.0;
			gridBagConstraints.weighty = 10.0;
			jPanel1.add(jLabel4, gridBagConstraints);
			
			javax.swing.JLabel jLabel5=new JLabel();
			jLabel5.setFont(new java.awt.Font("宋體", 0, 14));
			jLabel5.setText("\u5b66\u53f7");
			gridBagConstraints = new java.awt.GridBagConstraints();
			gridBagConstraints.gridx = 0;
			gridBagConstraints.gridy = 1;
			gridBagConstraints.weightx = 5.0;
			gridBagConstraints.weighty = 10.0;
			jPanel1.add(jLabel5, gridBagConstraints);
			
			javax.swing.JTextField jTextField2=new JTextField();
			jTextField2.setColumns(20);
			jTextField2.setText(studentinfo.getStudentName());
			jTextField2.setEditable(false);
			jTextField2.setFont(new java.awt.Font("宋體", 0, 18));
			gridBagConstraints = new java.awt.GridBagConstraints();
			gridBagConstraints.gridwidth = java.awt.GridBagConstraints.REMAINDER;
			gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
			gridBagConstraints.weightx = 5.0;
			gridBagConstraints.weighty = 10.0;
			jPanel1.add(jTextField2, gridBagConstraints);
			
			javax.swing.JTextField jTextField3=new JTextField();
			jTextField3.setColumns(20);
			jTextField3.setText(studentinfo.getStudentID());
			jTextField3.setEditable(false);
			gridBagConstraints = new java.awt.GridBagConstraints();
			gridBagConstraints.gridx = 1;
			gridBagConstraints.gridy = 1;
			gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
			gridBagConstraints.weightx = 5.0;
			gridBagConstraints.weighty = 10.0;
			jPanel1.add(jTextField3, gridBagConstraints);

			javax.swing.JLabel jLabel6=new JLabel();
			jLabel6.setFont(new java.awt.Font("宋體", 0, 14));
			jLabel6.setText("\u73ed\u7ea7");
			gridBagConstraints = new java.awt.GridBagConstraints();
			gridBagConstraints.gridx = 2;
			gridBagConstraints.gridy = 1;
			gridBagConstraints.anchor = java.awt.GridBagConstraints.CENTER;
			gridBagConstraints.weightx = 5.0;
			gridBagConstraints.weighty = 10.0;
			jPanel1.add(jLabel6, gridBagConstraints);

			javax.swing.JTextField jTextField4=new JTextField();
			jTextField4.setColumns(20);
			jTextField4.setText(studentinfo.getClassID());
			jTextField4.setEditable(false);
			gridBagConstraints = new java.awt.GridBagConstraints();
			gridBagConstraints.gridx = 3;
			gridBagConstraints.gridy = 1;
			gridBagConstraints.gridwidth = java.awt.GridBagConstraints.REMAINDER;
			gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
			gridBagConstraints.weightx = 5.0;
			gridBagConstraints.weighty = 10.0;
			jPanel1.add(jTextField4, gridBagConstraints);
			
			JLabel label1=null;
			JTextField jTextField=null;
			int i=1;
			double total=0;
			Iterator<StudentSroce> iter=list.iterator();
			while(iter.hasNext()){
				StudentSroce studentsroce=(StudentSroce)iter.next();
				label1=new JLabel();
				label1.setFont(new java.awt.Font("宋體", 0, 14));
				label1.setText(studentsroce.getCourseName());
				gridBagConstraints = new java.awt.GridBagConstraints();
				
				gridBagConstraints.weightx = 5.0;
				gridBagConstraints.weighty = 10.0;
				jPanel1.add(label1, gridBagConstraints);
				
				jTextField=new JTextField();
				jTextField.setColumns(20);
				jTextField.setText(Double.toString(studentsroce.getSroce()));
				jTextField.setEditable(false);
				gridBagConstraints = new java.awt.GridBagConstraints();
				if(i%2==0){
					gridBagConstraints.gridwidth = java.awt.GridBagConstraints.REMAINDER;
				}
				i++;
				total+=studentsroce.getSroce();
				gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
				gridBagConstraints.weightx = 5.0;
				gridBagConstraints.weighty = 10.0;
				jPanel1.add(jTextField, gridBagConstraints);
			}
			JLabel jLabel12=new JLabel();
			jLabel12.setFont(new java.awt.Font("宋體", 0, 14));
			jLabel12.setText("\u5e73\u5747\u5206");
			gridBagConstraints = new java.awt.GridBagConstraints();
			gridBagConstraints.gridx = 0;
			gridBagConstraints.gridy = 5;
			gridBagConstraints.weightx = 5.0;
			gridBagConstraints.weighty = 10.0;
			jPanel1.add(jLabel12, gridBagConstraints);
			
			JTextField jTextField10=new JTextField();
			jTextField10.setColumns(20);
			jTextField10.setText(Double.toString(total/(i-1)));
			jTextField10.setEditable(false);
			gridBagConstraints = new java.awt.GridBagConstraints();
			gridBagConstraints.gridx = 1;
			gridBagConstraints.gridy = 5;
			gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
			gridBagConstraints.weightx = 5.0;
			gridBagConstraints.weighty = 10.0;
			jPanel1.add(jTextField10, gridBagConstraints);

			JLabel jLabel13=new JLabel();
			jLabel13.setFont(new java.awt.Font("宋體", 0, 14));
			jLabel13.setText("\u603b\u5206");
			gridBagConstraints = new java.awt.GridBagConstraints();
			gridBagConstraints.gridx = 2;
			gridBagConstraints.gridy = 5;
			gridBagConstraints.anchor = java.awt.GridBagConstraints.CENTER;
			gridBagConstraints.weightx = 5.0;
			gridBagConstraints.weighty = 10.0;
			jPanel1.add(jLabel13, gridBagConstraints);

			JTextField jTextField11=new JTextField();
			jTextField11.setColumns(20);
			jTextField11.setText(Double.toString(total));
			jTextField11.setEditable(false);
			gridBagConstraints = new java.awt.GridBagConstraints();
			gridBagConstraints.gridx = 3;
			gridBagConstraints.gridy = 5;
			gridBagConstraints.gridwidth = java.awt.GridBagConstraints.REMAINDER;
			gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
			gridBagConstraints.weightx = 5.0;
			gridBagConstraints.weighty = 10.0;
			jPanel1.add(jTextField11, gridBagConstraints);
			jPanel1.validate();
		}else
			JOptionPane.showMessageDialog(null, "對不起沒有該學生");
	}

	private javax.swing.JButton jButton1;
	private javax.swing.JLabel jLabel1;
	private javax.swing.JLabel jLabel2;
	private javax.swing.JLabel jLabel3;
	private javax.swing.JPanel jPanel1;
	private javax.swing.JTextField jTextField1;
}