signupbo.java

网上报名系统,是一个功能很完善的系统,推存给大家,很好用的

package bo;

import myjdbc.DatabaseOperation;
import struts.actionform.SignUpForm;
import vo.WbApplicantCourses;
import java.util.List;
import java.util.*;
import vo.WbCourses;
import vo.ClassCourseExtentVO;
import vo.WbClass;

public class SignUpBo {
    private static DatabaseOperation db = null;
    private static SignUpBo sbo = null;
    private SignUpBo() {
        db = DatabaseOperation.getInstance();
    }

    public static SignUpBo getInstance() {
        if (sbo == null)
            sbo = new SignUpBo();
        return sbo;
    }
    //保存用户的报名信息
    public String saveNewSignUp(SignUpForm form)
    {
        return storeOperation(form,"报名成功！");
    }
    //保存用户的修改后的报名信息
    public String saveModifySignUp(SignUpForm form)
    {
        return storeOperation(form,"修改报名信息成功！");
    }
    private String storeOperation(SignUpForm form,String returnString)
    {
        String idCard = form.getIdCard();
         String classId = form.getClassId();
         String sql = "update Wb_ApplicantInfo set class_id = '" + classId +
                      "' where id_card = '" + idCard + "' ";
         db.executeSQL(sql);
         return returnString;
    }
    //获得课程班和它所对应的课程
    public void getCoureseRespondingClass(SignUpForm form)
    {
        List result = new ArrayList();

        String sqlClass = "select class_id ,class_name from wb_class";
        String sqlCourse = null;
        String classId = null;
        String className = null;
        List courseResult = null;
        //获得数据库中所有的课程班
        List classResult = db.executeSQL(sqlClass);
        for (Iterator iter = classResult.iterator(); iter.hasNext(); ) {
            Object[] item = (Object[]) iter.next();
            classId = (String)item[0];
            className = (String)item[1];
            //获得某一课程班所对应的课程
            sqlCourse = "select c.course_id ,c.course_name from wb_courses c, wb_class_course cc where cc.course_id = c.course_id and cc.class_id = '"+classId+"' ";
            courseResult = db.executeSQL(sqlCourse);
            List temp = new  ArrayList();
            for (Iterator iter1 = courseResult.iterator(); iter1.hasNext(); ) {
                Object[] item1 = (Object[]) iter1.next();
                WbCourses wc = new WbCourses();
                wc.setCourseId((String)item1[0]);
                wc.setCourseName((String)item1[1]);
                temp.add(wc);
            }
            //生成一个自定义的扩展vo
            ClassCourseExtentVO vo = new ClassCourseExtentVO();
            vo.setClassId(classId);
            vo.setClassName(className);
            vo.setCoursesCol(temp);
            //加入result中
            result.add(vo);
        }

        form.setClassCourseExtentCol(result);
    }
    //由用户的身份证号获得他报名的课程班
    public String getSignUpClassIdByIdCard(String idCard) throws Exception
    {
        String sql = "select class_id from Wb_ApplicantInfo where id_card = '"+idCard+"' ";
        List temp = db.executeSQL(sql);
        if (temp.size() == 0 || temp.size() > 1)
            throw new Exception("在表Wb_ApplicantInfo中，由主键("+idCard+")查找所获得的结果集，它的size为0或者大于1");
       return (String)((Object[])temp.get(0))[0];
    }
    public void getClassInfoByClassId(SignUpForm form) throws Exception
    {
        String classId = form.getClassId();
        String sql = "select * from Wb_Class where class_id = '"+classId+"' ";
        List result = db.executeSQL(sql);
        if (result.size() == 0 || result.size() > 1)
            throw new Exception("在表Wb_Class中，由主键("+classId+")查找所获得的结果集，它的size为0或者大于1");
        form.setWbClass((WbClass)result.get(0));
    }
    public void getCourseInfoByCourseId(SignUpForm form) throws Exception
    {
         String courseId = form.getCourseId();
         String sql = "select * from Wb_Courses where course_id = '"+courseId+"' ";
         List result = db.executeSQL(sql);
         if (result.size() == 0 || result.size() > 1)
             throw new Exception("在表Wb_Courses中，由主键("+courseId+")查找所获得的结果集，它的size为0或者大于1");
         form.setWbCourses((WbCourses)result.get(0));
    }
}