MyBatis Plus 自定义查询语句

最新推荐文章于 2024-09-23 08:38:38 发布

好奇的我

最新推荐文章于 2024-09-23 08:38:38 发布

阅读量6.4k

点赞数

本文链接：https://blog.csdn.net/weixin_31058701/article/details/102834031

版权

MyBatis Plus 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

MyBatis Plus 自定义查询语句

1，Dao层

@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);

2，Service层

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

3，Service实现类

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

这样写不用再Mapper中写xml文件