package com.student;

import java.awt.BorderLayout;
import java.awt.Container;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.Vector;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;

import org.bson.Document;

import com.mongodb.BasicDBObject;
import com.mongodb.client.FindIterable;
import com.mongodb.client.MongoCollection;
import com.mongodb.client.MongoCursor;

public class GradeSort {

	public static void SortGrade(MongoCollection collection)
	{
		Vector columnNames = null;
	    Vector rowData = null;
	    
	    JFrame jf = new JFrame();
		Container c=jf.getContentPane();
		
	    JTable jtable;
	    DefaultTableModel tableModel;
	    
		JScrollPane jscrollpane = new JScrollPane();
		c.add(jscrollpane, BorderLayout.CENTER);
		
		columnNames = new Vector();
		columnNames.add("学号");
        columnNames.add("姓名");
        columnNames.add("性别");
        columnNames.add("年龄");
        columnNames.add("学院");
        columnNames.add("成绩");
        rowData = new Vector();
        
        FindIterable<Document> it = collection.find().sort(new BasicDBObject("grade", -1));//降序排序
		//获取游标对象
		MongoCursor<Document> cursor = it.iterator();
		while(cursor.hasNext())
		{
			//取出每一个文档对象(行)
			Document doc = cursor.next();
			
			Vector hang = new Vector();
			hang.add(doc.getInteger("no"));
			hang.add(doc.getString("name"));
			hang.add(doc.getString("gender"));
			hang.add(doc.getInteger("age"));
			hang.add(doc.getString("academy"));
			hang.add(doc.getInteger("grade"));
			rowData.add(hang);
			//String name = doc.getString("name");
			//int age = doc.getInteger("age");
			//System.out.println(name+","+age);
			
		}
		tableModel = new DefaultTableModel(rowData, columnNames);
		jtable = new JTable(tableModel);//利用表格模型创建表格对象
		jscrollpane.setViewportView(jtable);
		
		JPanel jp = new JPanel();
		c.add(jp,BorderLayout.SOUTH);
		JButton jb_Pai1 = new JButton("前十名");
		JButton jb_Pai2 = new JButton("十一到二十名");
		JButton jbback = new JButton("返回");
		jp.add(jb_Pai1);jp.add(jb_Pai2);jp.add(jbback);
		
		jbback.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				jf.dispose();
			}
		});
		jb_Pai1.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				new PaiMing().SortGrade(collection);
				//jf.dispose();
			}
		});
		jb_Pai2.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				new PaiMing().SortGrade1(collection);
				//jf.dispose();
			}
		});
		
		
		jf.setTitle("成绩排序");
		jf.setSize(650,500);
		jf.setLocation(100, 100);
		jf.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
		jf.setVisible(true);
	}
}