Supply_chain_finance/web/target/classes/sql/jlw/ipAddress.md

queryByCondition

• 根据不为空的参数进行分页查询

  select @pageTag(){ t.* @} from ip_address t where 1=1
  @//数据权限，该sql语句功能点,如果不考虑数据权限，可以删除此行
  and #function("ipAddress.query")# @if(!isEmpty(id)){ and t.id =#id# @} @if(!isEmpty(ip)){ and t.ip =#ip# @} @if(!isEmpty(province)){ and t.province =#province# @} @if(!isEmpty(city)){ and t.city =#city# @} @if(!isEmpty(district)){ and t.district =#district# @} @if(!isEmpty(remark)){ and t.remark =#remark# @}

deleteIpAddressByIds

• 批量删除

  delete from ip_address where find_in_set(id,#ids#)

getIpAddressValues

• 根据不为空的参数进行查询

  select t.* from ip_address t where 1=1
  @if(!isEmpty(id)){ and t.id =#id# @} @if(!isEmpty(ip)){ and t.ip =#ip# @} @if(!isEmpty(province)){ and t.province =#province# @} @if(!isEmpty(city)){ and t.city =#city# @} @if(!isEmpty(district)){ and t.district =#district# @} @if(!isEmpty(remark)){ and t.remark =#remark# @}

getValuesByQuery

• 根据不为空的参数进行查询

  select t.* from ip_address t where 1=1
  @if(!isEmpty(id)){ and t.id =#id# @} @if(!isEmpty(ip)){ and t.ip =#ip# @} @if(!isEmpty(province)){ and t.province =#province# @} @if(!isEmpty(city)){ and t.city =#city# @} @if(!isEmpty(district)){ and t.district =#district# @} @if(!isEmpty(remark)){ and t.remark =#remark# @}