无名后生

1.<where>标签和where的区别： <where>标签是Mybatis动态语句，代码中若where标签里的if全不成立，则不走where语句。  <select id="queryOneCity" resultType="com.***.model.vo.CityMd"> select <include ref...

MyBatis 批量更新数据 1. 数据库语句 #使用SQL一次批量更新多条记录 UPDATE rba_house_status SET audit_status = ( CASE WHEN house_id = 100023 then 3 END ), audit_desc = ( CASE WHEN house_id = 100010 then '111' END ), last_...