mybatis-plus日常学习

1.1mybatis-plus使用in来查询list中的数据（mapper中）

@Select("<script>"
		+"select * from CertificateStudent where CertificateNum in"
        + "<foreach item='sss' index='index' collection='certificateNums'  open='(' separator=',' close=')'>"
        + "#{sss}"
        + "</foreach>"
        + "</script>")
List<CertificateStudent> selectCStudent(@Param("certificateNums")List<String> certificateNums);

1.2mybatis-plus使用in来查询list中的数据（imple中）

@Override
public List<CertificateStudent> selectCStudent(List<String> certificateNums) {
	// TODO Auto-generated method stub
	QueryWrapper<CertificateStudent> qw= new QueryWrapper<CertificateStudent>();
	qw.in("CertificateNum", certificateNums);
	return list(qw);
}

1.3mybatis-plus使用QueryWrapper<> 的方法

imple

@Override
public IPage<Msg> page(Page<Msg> p, Integer deptId, String keyword) {
	QueryWrapper<Msg> qw = new QueryWrapper<>();
	qw.eq(deptId != null, "m.deptId", deptId)//
	 .and(keyword != null, q -> q.like("m.title", keyword).or().like("m.content", keyword));
	qw.orderByDesc("m.id");
	return baseMapper.page(p, qw);
}

mapper

@Select("select m.*, d.`name` deptName, t.`xm` createUserName "
		+ "from msg m  left JOIN dept d on m.deptId = d.id left JOIN teacher t on m.createUser = t.id "
		+ "${ew.customSqlSegment}")
Page<Msg> page(Page<Msg> p,@Param("ew")Wrapper<Msg> ew);