67,550
社区成员




/**
* 查询所有班级信息
*/
List<Map<String, Object>> findAllclass(@Param("begin")Integer begin,@Param("endss")Integer endss,@Param("name")String name);
<select id="findAllclass" resultType="map">
SELECT c.*,m.majors_name FROM classs c,majors m WHERE c.majors_id=m.id
<if test="name != null and name!= '' "> and class_name like CONCAT('%',#{name},'%')</if>
ORDER BY c.majors_id
LIMIT #{begin},#{endss}
</select>