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#
    @}