package bean;   
import java.sql.*;
import sun.jdbc.odbc.JdbcOdbcDriver;
  
public class Total{   
      Connection  Con=null;
      Statement   Stmt=null;  
      public Total(){   
          try{
		       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			   Con =DriverManager.getConnection("jdbc:odbc:pass","","");
			   Stmt=Con.createStatement();   
          }   
          catch(Exception e){   
               System.out.println("Error"+e.getMessage());   
          }
      }
	        
      public ResultSet getTotal(String by){
	      int i=0;
		  String in="pass.num";
		  if(by.equals("1"))in="pass.num";
		  else if(by.equals("2"))in="pass.name";
		  else if(by.equals("3"))in="score.Escore";
		  else if(by.equals("4"))in="score.Mscore";
		  else if(by.equals("5"))in="score.Cscore";
		  else if(by.equals("6"))in="score.Total";
		  String sqlCmd="SELECT pass.num,pass.name,score.Escore,score.Mscore,score.Cscore,score.Total FROM pass INNER JOIN score ON pass.num=score.num ORDER BY "+in;
          try{
		       ResultSet result=Stmt.executeQuery(sqlCmd);
			   return result;      
           }   
           catch(Exception e){}  
           return null;         
      }
}