inquirescorebo.java

来自「网上报名系统,是一个功能很完善的系统,推存给大家,很好用的」· Java 代码 · 共 37 行

package bo;

import myjdbc.DatabaseOperation;
import struts.actionform.InquireScoreForm;
import java.util.List;
import java.util.*;
import vo.WbApplicantCourses;

public class InquireScoreBo {
    private static DatabaseOperation db = null;
    private static InquireScoreBo bo = null;
    private InquireScoreBo() {
      db = DatabaseOperation.getInstance();
    }
    public static InquireScoreBo getInstance() {
       if (bo == null)
           bo = new InquireScoreBo();
       return bo;
   }
   public void getScoreInfo(InquireScoreForm form)
   {
      List scoreInfoCol = new ArrayList();
      String idCard = form.getIdCard();
      String sql = "select c.course_name , rel.course_score from Wb_Applicant_Courses rel , Wb_Courses c where c.course_id = rel.course_id and rel.id_card = '"+idCard+"' ";
      System.out.println("sql = " + sql);
      List result = db.executeSQL(sql);
      for (Iterator iter = result.iterator(); iter.hasNext(); ) {
          Object[] item = (Object[]) iter.next();
          WbApplicantCourses rel = new WbApplicantCourses();
          rel.setCourseName((String)item[0]);
          rel.setCourseScore((Double)item[1]);
          scoreInfoCol.add(rel);
      }
      form.setScoreInfoCol(scoreInfoCol);
   }
}