组件值程序源个别coursedaoimp.pdfVIP

@Component(value=courseDao)

publicclassCourseDaoImplimplementsICourseDao{

@Resource(name=sqlSessionFactoryBean)

SqlSessionFactorysqlSessionFactory;

publicvoidsetSqlSessionFactory(SqlSessionFactorysqlSessionFactory){

this.sqlSessionFactory=sqlSessionFactory;

}

@Override

publicCoursequeryCourseById(StringcourseId){

SqlSessionsqlSession=sqlSessionFactory.openSession();

Coursecourse=(Course)

sqlSession.selectOne(COURSE.queryById,courseId);

//将中文转化为枚举中的英文

//课程类型

for(CourseTypeEnumtypeEnum:CourseTypeEnum.values()){

if(typeEnum.getCourseName().equals(course.getcType())){

course.setcType(typeEnum.toString());

break;

}

}

//是否必修

for(CourseRequireEnumtypeEnum:CourseRequireEnum.values()){

if

(typeEnum.getCourseRequireNameString().equals(course.getcRequire())){

course.setcRequire(typeEnum.toString());

break;

}

}

returncourse;

}

@Override

publicListCoursequeryCourseByName(StringcourseName){

SqlSessionsqlSession=sqlSessionFactory.openSession();

returnsqlSession.selectList(COURSE.queryByName,courseName);

}

@Override

publicListCoursegetList(StringtId){

SqlSessionsqlSession=sqlSessionFactory.openSession();

returnsqlSession.selectList(COURSE.getList,tId);

}

@Override

publicListCoursegetCourseList(@Param(value=sId)StringsId){

SqlSessionsqlSession=sqlSessionFactory.openSession();

returnsqlSession.selectList(COURSE.getCourseList,sId);

}

@Override

publicintinsertCourse(Coursecourse){

SqlSessionsqlSession=sqlSessionFactory.openSession();