怎样实现单MyBatis单表查询

这是数据库关系表，就一张表，INDUS对应多个THEME,每个THEME对应多个LABEL,每个Label对应多个KPI，求帮忙了，谢谢，我只要大概的思路 项目的框架用的Springmvc +myBatis
java的Service层怎么给集合排序，MyBatis的xml怎么写sql呢，要求用一个集合返回所有数据

如果你是用的IDE是eclipse的话，可以安装mybatis generator自动生成sql文。

mybatis generator plugin下载地址
https://github.com/mybatis/generator

mybatis generator怎么使用和写sql下面文章可以参考。
http://blog.csdn.net/engchina/article/details/48780373
http://blog.csdn.net/engchina/article/details/49028155
http://blog.csdn.net/engchina/article/details/49028995

 <!-- 查询所有的记录 -->
 <select id="findAll" resultMap="studentResultMap">
  select * from student
 </select>

要想用一个集合返回所有数据.我的意见是:(1)创建一个与该表对应的model类;(2)编写sql.xml文件,将查询结果封装到model集合中.

镇楼

SELECT
USER.UserId, USER.UserName, ROLE.RoleName, USER.Status,
USER.AddTime, USER.Mobile,
USER.Email, ROLE.RoleId, USER.Password,
USER.UserCode,
POST.post_id,POST.post_name,DEMP.department_id,DEMP.department_name,POS.position_name,POS.position_id, USER.IsLock
FROM sys_user USER LEFT JOIN sys_role ROLE ON USER.RoleId =
ROLE.RoleId LEFT JOIN crm_post POST ON USER.PostId = POST.post_id
LEFT
JOIN crm_department DEMP ON POST.department_id = DEMP.department_id
LEFT JOIN crm_position POS ON POST.position_id = POS.position_id WHERE
1 = 1

AND USER.UserId = #{UserId}


AND ROLE.RoleId = #{RoleId}


AND ROLE.RoleName = #{RoleName}


AND ROLE.RoleName != '超级管理员'


AND USER.Password = #{Password}


AND USER.Tel = #{Tel}


AND USER.IsDelete = #{IsDelete}


AND USER.UserCode LIKE CONCAT('%',CONCAT(#{UserCode},'%'))


AND USER.Status = #{Status}


AND USER.UserCode = #{Mobile}


AND USER.PostId = #{post_id}


AND USER.IsLock = #{IsLock}

AND USER.IsDelete = 1 order by USER.AddTime desc limit #{start},#{end}

SELECT USER.UserId, USER.UserName, USER.RoleId, USER.UserCode
FROM sys_user USER WHERE 1 = 1

AND USER.UserCode = #{UserCode}

http://www.cnblogs.com/xdp-gacl/p/4264440.html这里有详解可以看看

举这样一个例子,有学生表 t_student,有课程表t_course,因为一个学生可能选择多门课程,一门课程可能对应多个学生,所以是m2m类型,也就是多对多,假如要查询学生并且要带出他所有的课程,所以需要关系表t_relation,那么如下:

select
from t_student s
left join t_relation r on s.id=r.sid
left join t_course c on c.id=r.cid

只是个简单例子,欢迎去我博客查询,有类似的例子,写的 比较详细

Dao层 List aaa(@Param("bbb") String bbb);

映射的方法模糊查询

select *from aaa where xxx LIKE CONCAT('%', #{bbb}, '%') order by xxx//排序的条件