selectc.*,ck.kind_name,ck.kind_remark
fromcoursekindck,coursec
whereck.kind_id=c.coursekind_idandck.kind_id=#{kind_id}
getbyKind方法在mybatis3.3.0返回一条记录在mybatis3.4.4返回多条记录求解
publicclassCourse{
privateStringcourseId;
privateStringcourseName;
privateStringcourseKindId;
privateStringcourseScore;
privateStringcourseHour;
privateStringcourseRemark;
privateCourseKindcourseKind;
publicCourse(){
super();
}
publicCourse(StringcourseId,StringcourseName,StringcourseKindId,StringcourseScore,StringcourseHour,
StringcourseRemark){
super();
this.courseId=courseId;
this.courseName=courseName;
this.courseKindId=courseKindId;
this.courseScore=courseScore;
this.courseHour=courseHour;
this.courseRemark=courseRemark;
}
publicStringgetCourseId(){
returncourseId;
}
publicvoidsetCourseId(StringcourseId){
this.courseId=courseId;
}
publicStringgetCourseName(){
returncourseName;
}
publicvoidsetCourseName(StringcourseName){
this.courseName=courseName;
}
publicStringgetCourseKindId(){
returncourseKindId;
}
publicvoidsetCourseKindId(StringcourseKindId){
this.courseKindId=courseKindId;
}
publicCourseKindgetCourseKind(){
returncourseKind;
}
publicvoidsetCourseKind(CourseKindcourseKind){
this.courseKind=courseKind;
}
publicStringgetCourseScore(){
returncourseScore;
}
publicvoidsetCourseScore(StringcourseScore){
this.courseScore=courseScore;
}
publicStringgetCourseHour(){
returncourseHour;
}
publicvoidsetCourseHour(StringcourseHour){
this.courseHour=courseHour;
}
@Override
publicStringtoString(){
return"Course[courseId="+courseId+",courseName="+courseName+",courseKindId="+courseKindId
+",courseScore="+courseScore+",courseHour="+courseHour+",courseRemark="+courseRemark
+"]";
}
publicStringgetCourseRemark(){
returncourseRemark;
}
publicvoidsetCourseRemark(StringcourseRemark){
this.courseRemark=courseRemark;
}
}
publicclassCourseKind{
privateStringkindId;
privateStringkindName;
privateStringkindRemark;
privateListcourseList;
publicStringgetKindId(){
returnkindId;
}
publicvoidsetKindId(StringkindId){
this.kindId=kindId;
}
publicStringgetKindName(){
returnkindName;
}
publicvoidsetKindName(StringkindName){
this.kindName=kindName;
}
publicStringgetKindRemark(){
returnkindRemark;
}
publicvoidsetKindRemark(StringkindRemark){
this.kindRemark=kindRemark;
}
publicListgetCourseList(){
returncourseList;
}
publicvoidsetCourseList(ListcourseList){
this.courseList=courseList;
}
}
DROPTABLEIFEXISTS`course`;
CREATETABLE`course`(
`course_id`varchar(11)NOTNULLCOMMENT'课程编号',
`course_name`varchar(255)DEFAULTNULLCOMMENT'课程名',
`coursekind_id`varchar(255)DEFAULTNULLCOMMENT'课程分类编号',
`course_score`varchar(255)DEFAULTNULLCOMMENT'学分',
`course_hour`varchar(255)DEFAULTNULLCOMMENT'学时',
`course_remark`varchar(255)DEFAULTNULLCOMMENT'附加说明',
PRIMARYKEY(`course_id`)
)ENGINE=InnoDBDEFAULTCHARSET=utf8;
--
--Dumpingdatafortable`course`
--
/*!40000ALTERTABLE`course`DISABLEKEYS*/;
INSERTINTO`course`(`course_id`,`course_name`,`coursekind_id`,`course_score`,`course_hour`,`course_remark`)VALUES
('1010','java1','10','5','90','课程介绍1'),
('1011','java2','10','3','60','课程介绍2'),
('1012','java3','11','5','90','课程介绍3'),
('1013','java4','12','5','40','课程介绍4'),
('1014','java5','10','5','70','课程介绍5'),
('1015','java6','10','5','90','课程介绍6'),
('1016','java7','10','5','90','课程介绍7'),
('1017','java8','11','5','90','课程介绍8'),
('1018','java9','12','5','90','课程介绍9'),
('1019','java10','10','5','90','课程介绍10'),
('1020','java11','12','5','90','课程介绍11');
/*!40000ALTERTABLE`course`ENABLEKEYS*/;
--
--Definitionoftable`coursekind`
--
DROPTABLEIFEXISTS`coursekind`;
CREATETABLE`coursekind`(
`kind_id`varchar(10)NOTNULLCOMMENT'分类编号',
`kind_name`varchar(255)DEFAULTNULLCOMMENT'分类名',
`kind_remark`varchar(255)DEFAULTNULLCOMMENT'附加说明',
PRIMARYKEY(`kind_id`)
)ENGINE=InnoDBDEFAULTCHARSET=utf8;
--
--Dumpingdatafortable`coursekind`
--
/*!40000ALTERTABLE`coursekind`DISABLEKEYS*/;
INSERTINTO`coursekind`(`kind_id`,`kind_name`,`kind_remark`)VALUES
('10','通识必修课','分类说明'),
('11','通识选修课','分类说明'),
('12','实践课','分类说明');
分 --> |
