Shulou(Shulou.com)06/02 Report--

This article is about how test judges Boolean in MyBatis sql. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

There are three ways for test to judge Boolean in mybatis sql: select id and address Remark from address where 1 UPDATE epc_subject_center 1 and address = # {address} UPDATE epc_subject_center s SET s.have_new_comment=1 WHERE s.id=# {id} UPDATE epc_subject_center s SET s.have_new_comment=0 WHERE s.id=# {id} UPDATE epc_subject_center s SET s.have_new_comment=1 WHERE s.id=# {id} UPDATE epc_subject_center s The example method of SET s.have_new_comment=0 WHERE s.id=# {id} if tag to judge the boolean type

Directly judge AND order_status IN (1,2,3) AND order_status IN (4,5,6) when the input parameter flag is not empty.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.