setsequence.java

自己写的一个JAVA实现的学生成绩管理系统

import java.sql.*;
import java.util.Iterator;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.SQLException;
import java.sql.DriverManager;
import java.util.Vector;
import java.lang.*;//这一句不应该要，但原文如此
import java.util.Enumeration;
import java.io.*;
import java.util.Date;

class SetSequence extends Vector 
{
   public static void setQ(int u) 
   {
      Vector e = new Vector(4, 1);
      Vector c = new Vector(4, 1);
      Vector m = new Vector(4, 1);
      Vector n = new Vector(4, 1);
      try 
      {
         DBClass a = new DBClass();
         a.executeSQL("select * from score", "studentdatabase");
         while(a.rs.next()) 
         {
            String name = a.rs.getString("name");
            String english = a.rs.getString("english");
            String chinese = a.rs.getString("chinese");
            String math = a.rs.getString("math");
            n.add(name);
            e.add(english);
            c.add(chinese);
            m.add(math);
         }
         int l = e.size();
         String[][] receive = new String[l][4];
         for(int y = 0; y < l; y ++ ) 
         {
            receive[y][0] = (String)n.get(y);
            receive[y][1] = (String)e.get(y);
            receive[y][2] = (String)c.get(y);
            receive[y][3] = (String)m.get(y);
         }
         for(int mm = 0; mm < 100; mm ++ ) 
            for(int i = 0; i < receive.length; i ++ ) 
               for(int j = i; j < receive.length - 1; j ++ ) 
                  if(Integer.parseInt(receive[j][u]) < Integer.parseInt(receive[j + 1][u])) 
                  {for(int p=0;p<4;p++)
                     {String temp = receive[j + 1][p];
                     receive[j + 1][p] = receive[j][p];
                     receive[j][p] = temp;}
                  }
         for(int i = 0; i < receive.length; i ++ ) 
         {
            FirstPane.ta.append(receive[i][0] + receive[i][1] + receive[i][2] + receive[i][3] + "\n");
         //System.out.println(receive[i][j]);
         }
      }
      catch(Exception e10) 
      {
         e10.printStackTrace();
      }
   }
//   public static void main(String[] args)
//   {
//  SetSequence.setQ();
//  }
}