mybatis_plus常见用法-不用xml实现自定义查询

发表于 更新于 分类于 ， 本文字数： 163 阅读时长 ≈ 1 分钟
围绕mybatis_plus常见用法-不用xml实现自定义查询整理相关实践、经验与思考。

找到两种方法：
1、采用mybatis注解的方式
参见：MyBatis Plus 自定义查询语句
DAO层：

1
2
3
4
5
6
7
8
9
10
11
@Select("select b.bomName, " +
		"b.bomProductType, b.bomMaterial, " +
		"o.customerID AS bomID, " +
		"o.ordersDataNo AS qrCode, " +
		"s.deliveryDate AS barCode, " +
		"s.mainType AS workshop " +
		"FROM mes_order_bom b " +
		"LEFT JOIN mes_order_ordersdata o ON b.ordersID = o.id " +
		"LEFT JOIN mes_order_soncontract s ON o.sonContractID = s.id " +
		"WHERE o.ordersDataNo IN (#{orderNoList})")
List<MesOrderBom> getBomAndOrderCodeNumber(@Param("orderNoList")List<String> orderNoList);

Service层：

1
List<MesOrderBom> getBomAndOrderCodeNumber(List<String> orderNoList);

Service实现类:

1
2
3
4
@Override
public List<MesOrderBom> getBomAndOrderCodeNumber(List<String> orderNoList) {
	return this.baseMapper.getBomAndOrderCodeNumber(orderNoList);
}

2、自定义实现
结合mybatis-plus 实现无XML多表联查询
项目地址：multipleselect
java 结合mybatis-plus 实现非手写sql多表查询

参考资料