{"id":6459,"date":"2024-08-07T23:01:03","date_gmt":"2024-08-07T15:01:03","guid":{"rendered":""},"modified":"2024-08-07T23:01:03","modified_gmt":"2024-08-07T15:01:03","slug":"querywapper.eq_PowerQUERy\u5408\u5e76\u67e5\u8be2\u6a21\u7cca\u5339\u914d","status":"publish","type":"post","link":"https:\/\/mushiming.com\/6459.html","title":{"rendered":"querywapper.eq_PowerQUERy\u5408\u5e76\u67e5\u8be2\u6a21\u7cca\u5339\u914d"},"content":{"rendered":"<p><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"display: none;\"> \n <path stroke-linecap=\"round\" d=\"M5,0 0,2.5 5,5z\" id=\"raphael-marker-block\" style=\"-webkit-tap-highlight-color: rgba(0, 0, 0, 0);\"><\/path> \n<\/svg> <\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img-blog.csdnimg.cn\/8524333f5e774b1aa94433e6e1b3941b.png\" =\"\" =\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" alt=\"querywapper.eq_PowerQUERy\u5408\u5e76\u67e5\u8be2\u6a21\u7cca\u5339\u914d (https:\/\/mushiming.com\/)  \u7b2c1\u5f20\" title=\"querywapper.eq_PowerQUERy\u5408\u5e76\u67e5\u8be2\u6a21\u7cca\u5339\u914d  \u7b2c1\u5f20-\u7a46\u4e16\u660e\u535a\u5ba2\" ><\/p>\n<pre class=\"language-java prettyprint linenums\"><code>public ResponseResult bind(DriverCarBindingRelationship driverCarBindingRelationship){ \/* * \u5224\u65ad\uff1a\u5728\u7ed1\u5b9a\u53f8\u673a\u548c\u8f66\u8f86\u5173\u7cfb\u4e4b\u524d\uff0c\u5148\u5224\u65ad\u4e00\u4e0b\u4e8c\u8005\u4e4b\u95f4\u662f\u5426\u5df2\u7ecf\u7ed1\u5b9a\uff0c\u5982\u679c\u5df2\u7ecf\u7ed1\u5b9a\u8fc7\uff0c\u5219\u4e0d\u5bb9\u8bb8\u518d\u7ed1\u5b9a * *\/ QueryWrapper&lt;DriverCarBindingRelationship&gt; queryWrapper = new QueryWrapper&lt;&gt;(); \/\/\u67e5\u8be2\u5305\u88c5\u5668 \/\/\u591a\u79cd\u6761\u4ef6\u60c5\u51b5\u4e0b\u8fdb\u884c\u67e5\u8be2\uff0c\u4ee5\u4e0b\u4e09\u79cd\u60c5\u51b5\u5fc5\u987b\u6ee1\u8db3 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()&gt;0){ return ResponseResult.fail(CommonStatusEnum.DRIVER_CAR_BIND_EXIST.getCode(),CommonStatusEnum.DRIVER_CAR_BIND_EXIST.getValue()); } } <\/code><\/pre>\n<p>\u5e95\u5c42\u8fd0\u884c\u7ed3\u679c\uff1a<\/p>\n<blockquote>\n<p>Creating a new SqlSession<br \/> SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@] was not registered for synchronization because synchronization is not active<br \/> JDBC Connection [HikariProxyConnection@ wrapping com.mysql.cj.jdbc.ConnectionImpl@4e911e70] will not be managed by Spring<br \/> <mark>&gt; Preparing: SELECT COUNT( * ) FROM driver_car_binding_relationship WHERE (driver_id = ? AND car_id = ? AND bind_state = ?)<br \/> <mark>&gt; Parameters: 53(Long), 6(Long), 1(Integer)<br \/> &lt;<\/mark> Columns: COUNT( * )<br \/> &lt;<\/mark> Row: 0<br \/> &lt;== Total: 1<br \/> Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@]<\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"querywapper.eq_PowerQUERy\u5408\u5e76\u67e5\u8be2\u6a21\u7cca\u5339\u914dQueryWrapper\u4e2deq\u7684\u610f\u601d\u4ee5\u53ca\u7528\u6cd5\u6848\u4f8b_querywrapper.eq","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"_links":{"self":[{"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/posts\/6459"}],"collection":[{"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/comments?post=6459"}],"version-history":[{"count":0,"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/posts\/6459\/revisions"}],"wp:attachment":[{"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/media?parent=6459"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/categories?post=6459"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/tags?post=6459"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}