public ResponseResult bind(DriverCarBindingRelationship driverCarBindingRelationship){
public ResponseResult bind(DriverCarBindingRelationship driverCarBindingRelationship){ QueryWrapper queryWrapper = new QueryWrapper<>(); //查询包装器 //多种条件情况下进行查询,以下三种情况必须满足 queryWrapper.eq("driver_id",driverCarBindingRelationship.getDriverId()); queryWrapper.eq("car_id",driverCarBindingRelationship.getCarId()); queryWrapper.eq("bind_state",DriverCarConstants.DRIVER_CAR_BIND); Integer integer = driverCarBindingRelationshipMapper.selectCount(queryWrapper); if(integer.intValue()>0){ return ResponseResult.fail(CommonStatusEnum.DRIVER_CAR_BIND_EXIST.getCode(),CommonStatusEnum.DRIVER_CAR_BIND_EXIST.getValue()); }}
底层运行结果:
Creating a new sqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@66061384] was not reGIStered for synchronization because synchronization is not active
JDBC Connection [HikariProxyConnection@704441103 wrapping com.Mysql.cj.jdbc.ConnectionImpl@4e911e70] will not be managed by spring
> Preparing: SELECT COUNT( * ) FROM driver_car_binding_relationship WHERE (driver_id = ? AND car_id = ? AND bind_state = ?)
> Parameters: 53(Long), 6(Long), 1(Integer)
< Columns: COUNT( * )
< Row: 0
<== Total: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@66061384]
来源地址:https://blog.csdn.net/weixin_59479961/article/details/128019960
--结束END--
本文标题: QueryWrapper中eq的用法案例
本文链接: https://www.lsjlt.com/news/499443.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0