【Java开源代码栏目提醒】：网学会员为需要Java开源代码的朋友们搜集整理了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));
        }
    }