SQL查询

@Select("<script>" +
"SELECT " +
"w.warehouse_name, " +
"w.country_name, " +
"w.province_name, " +
"w.consignee, " +
"w.consignee_cellphone, " +
"w.full_address, " +
"w.warehouse_status, " +
"w.create_user_name, " +
"w.warehouse_name, " +
"w.create_time, " +
"wt.default_warehouse " +
"FROM warehouse AS w " +
"LEFT JOIN warehouse_transport AS wt on w.id=wt.warehouse_id) " +
"WHERE " +
"<IF test=\"warehouseName != null and warehouseName != ''\" >" +
" and w.warehouseName = #{warehouseName} " +
"</if>" +
"<IF test=\"countryName != null and countryName != ''\" >" +
" and w.country_name = #{countryName} " +
"</if>" +
"<IF test=\"provinceName != null and provinceName != ''\" >" +
" and w.province_name = #{provinceName} " +
"</if>" +
"<IF test=\"createUserName != null and createUserName != ''\" >" +
" and w.create_user_name = #{createUserName} " +
"</if>" +
"</script>")
List<WarehouseInfoListDTO> getWarehouseList(GetWarehouseListForm form);

1.用到<if></if>标签时需要在外面套一个<script></script>才能识别，多个if并列，表示该参数存在则加入查询条件。一般用于搜索时的多个查询条件

2.注意每行后面空格和逗号

3.form入参里面的参数可以多写（可以复用），入参需要写到#{  }里面才可以被识别

4.通过AS 起别名，on 后面的w.id=wt.warehouse_id 是表关联的条件