inforsortjpanel.java

学生成绩管理系统

package myjava.javaSeries.java.compoent;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.text.*;
public class InforSortJpanel extends JPanel
{
	JTable table;
	private JLabel JLmessage=new JLabel("学生成绩表");
	private JPanel JPLabels=new JPanel();
	//private JPanel JPlistArea=new JPanel();
	public InforSortJpanel()
	{
      JPLabels.setLayout(new FlowLayout());
      JPLabels.add(JLmessage);
      String[] strTabelTitle={"学号","姓名","成绩"};
 	  String[][] strTabelData=null;
	  //从数据库中获得数据
	  try{
          InforModelDB mydata=new InforModelDB();
		 String sqlst="select count(*) from students";
		  ResultSet rs =mydata.executeSelect(sqlst);
		  int Num=0;
		  if(rs.next())
			 Num=rs.getInt(1);
		 rs=null;
		  //组织数据
         strTabelData=new String[Num][3];
		  //形成Select语句
		 sqlst="select  * from students order by score";
		  rs=mydata.executeSelect(sqlst);
		  int row=0;
		  while(rs.next())
		  {
             strTabelData[row][0]=rs.getString("num");
			 strTabelData[row][1]=rs.getString("name");
			 strTabelData[row][2]=rs.getString("score");
			 row++;
		  }
	  }catch(SQLException ex){
				ex.printStackTrace();
	  }catch(ClassNotFoundException ex){
				 ex.printStackTrace();
	  }
	  table=new JTable(strTabelData,strTabelTitle);
      this.setLayout(new BorderLayout());
	  this.add(JPLabels,BorderLayout.NORTH);
      this.add(new JScrollPane(table),BorderLayout.CENTER);
	}
}