grade_countinformation.java

用java实现的学生管理系统

package xscjgl;
import java.sql.ResultSet;
import javax.swing.JOptionPane;
public class Grade_CountInformation{
    /*
     //CountSum:求总分
     //CountAvg：平均分
     //subjectOrder:单科排名
     //SubjectCount:科目统计
     //CountStudent:单科学生数目

     */
    public String sumString,avgString;
    public int SubjectCount,CountStudent,SubjectOrder,SumOrder;
    public float CountSum,CountAvg;

    public Grade_CountInformation(){
       this.CountAvg=0;
       this.CountStudent=0;
       this.CountSum=0;
       this.SubjectCount=0;
       this.SubjectOrder=0;
       this.SumOrder=0;
       this.sumString="";
       this.avgString="";

    }


    //根据学号求统计信息
    public void setCountInformation(String Snumber){
        try {
            Jdbcconn Count = new Jdbcconn();
            Count.OpenConn("tqti", "tqti", "111111");
            String subjectSQL = "select * from SC where Sno='"+Snumber+"'";
            //*******统计学生科目*************
            ResultSet crs = Count.getResults(subjectSQL);
            crs.last();
            this.SubjectCount=crs.getRow();
            //*******统计学生科目*************

             //******统计总分*************
            String sumSQL = "select sum(Cgrade)as countSum from sc where sno='"+Snumber+"'";
            ResultSet srs = Count.getResults(sumSQL);
            srs.first();
            this.CountSum=srs.getFloat(1);
            //JOptionPane.showMessageDialog(null,"统计总分："+srs.getFloat(1));
            //******统计总分*************
             //******求平均分*************
            this.CountAvg=CountSum/SubjectCount;
             //JOptionPane.showMessageDialog(null,"平均分："+CountAvg);
            //******求平均分*************
             Count.closeStmt();
             Count.closeConn();
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        }
    }

    //根据课程号得到排名，由当前CNO得到排名
    public void setSubjectOrder(String CNO,String Sno) {
        try {
              Jdbcconn Order = new Jdbcconn();
              Order.OpenConn("tqti", "tqti", "111111");
              String OrderSQL="select * from SC where Cno='"+CNO+"'order by Cgrade desc";
              ResultSet ors=Order.getResults(OrderSQL);
              ors.last();
              this.CountStudent=ors.getRow();//单科学生数目
              ors.beforeFirst();

              //****************单科排名****************
              while (ors.next()) {
                  String Snumber = ors.getString("Sno");
                  int OrderNumber = ors.getRow();
                  if (Snumber.equals(Sno)) {
                      //将当前的行号（即名次）赋给subjectOrder
                      this.SubjectOrder = OrderNumber;

                     // JOptionPane.showMessageDialog(null,"排名in:"+SubjectOrder);
                       break;
                  } else {
                      this.SubjectOrder =0;
                  }//end if else
              }//end while
              //****************单科排名****************

               Order.closeStmt();
               Order.closeConn();
          } catch (Exception ex) {
              System.out.println(ex.getMessage());
          }
    }







    //CountSum:求总分
    public float getCountSum(){
        return CountSum;
    }


    //CountAvg：平均分
    public float getCountAvg() {
        return CountAvg;
    }

    //subjectOrder:单科排名
    public int getsubjectOrder() {
        return SubjectOrder;
    }

    //SubjectCount:科目统计
    public int getSubjectCount() {
        return SubjectCount;
    }

    //CountStudent:单科学生数目
    public int getCountStudent() {
        return CountStudent;
    }


    //SumOrder:单科排名
    public int getSumOrder() {
        return SumOrder;
    }





}//end class