收货地址过滤

输入:湖南省 岳阳市 岳阳楼区 三眼桥街道南湖游路 11
输出:SalesOrderAddress(province=湖南省, city=岳阳市, district=岳阳楼区, detailAddress=岳阳楼区11)
输入:上海 上海市 宝山区 大场镇上海市宝山区锦秋路
输出:SalesOrderAddress(province=上海, city=上海市, district=宝山区, detailAddress=宝山区大场镇上海市宝山区锦秋路)
输入:广西壮族自治区 钦州市 钦北区 子材街道江滨豪园
输出:SalesOrderAddress(province=广西壮族自治区, city=钦州市, district=钦北区, detailAddress=钦北区子材街道江滨豪园)

@Data
public class SalesOrderAddress implements Serializable {

    //省
    private String province;

    //市
    private String city;

    //区
    private String district;

    //详细地址
    private String detailAddress;

}

public class StringUtils {
    /**
     * 收货地址过滤
     * @param address
     * @return salesOrderAddress
     */
    public static SalesOrderAddress addressFilter(String address){
        salesOrderAddress = new SalesOrderAddress();
        //收货地址用空格分割
        String[] s = address.split(" ");
        for (int i = 0; i < s.length; i++) {
            if (i == 0){
                salesOrderAddress.setProvince(s[i]);
            }else if (i == 1){
                salesOrderAddress.setCity(s[i]);
            }else if (i == 2){
                salesOrderAddress.setDistrict(s[i]);
            }else {
                //如果详细地址有多段,将剩余段都追加到detailAddress中
                salesOrderAddress.setDetailAddress(salesOrderAddress.getDistrict()+s[i]);
            }
        }
        return salesOrderAddress;
    }

    @Test
    public void stringTest(){
        SalesOrderAddress salesOrderAddress1 = addressFilter("湖南省 岳阳市 岳阳楼区 三眼桥街道南湖游路 11");
        System.out.println(salesOrderAddress1);
        SalesOrderAddress salesOrderAddress2 = addressFilter("上海 上海市 宝山区 大场镇上海市宝山区锦秋路");
        System.out.println(salesOrderAddress2);
        SalesOrderAddress salesOrderAddress3 = addressFilter("广西壮族自治区 钦州市 钦北区 子材街道江滨豪园");
        System.out.println(salesOrderAddress3);
    }

}
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
可以使用以下SQL语句实现: ``` SELECT * FROM product_table WHERE NOT ( (shipping_value_1 = 0 OR shipping_value_1 IS NULL) AND (shipping_value_2 = 0 OR shipping_value_2 IS NULL) AND (shipping_value_3 = 0 OR shipping_value_3 IS NULL) AND (shipping_value_4 = 0 OR shipping_value_4 IS NULL) AND (shipping_value_5 = 0 OR shipping_value_5 IS NULL) AND (shipping_value_6 = 0 OR shipping_value_6 IS NULL) AND (shipping_value_7 = 0 OR shipping_value_7 IS NULL) AND (shipping_value_8 = 0 OR shipping_value_8 IS NULL) AND (shipping_value_9 = 0 OR shipping_value_9 IS NULL) AND (shipping_value_10 = 0 OR shipping_value_10 IS NULL) AND (shipping_value_11 = 0 OR shipping_value_11 IS NULL) AND (shipping_value_12 = 0 OR shipping_value_12 IS NULL) AND (receiving_value_1 = 0 OR receiving_value_1 IS NULL) AND (receiving_value_2 = 0 OR receiving_value_2 IS NULL) AND (receiving_value_3 = 0 OR receiving_value_3 IS NULL) AND (receiving_value_4 = 0 OR receiving_value_4 IS NULL) AND (receiving_value_5 = 0 OR receiving_value_5 IS NULL) AND (receiving_value_6 = 0 OR receiving_value_6 IS NULL) AND (receiving_value_7 = 0 OR receiving_value_7 IS NULL) AND (receiving_value_8 = 0 OR receiving_value_8 IS NULL) AND (receiving_value_9 = 0 OR receiving_value_9 IS NULL) AND (receiving_value_10 = 0 OR receiving_value_10 IS NULL) AND (receiving_value_11 = 0 OR receiving_value_11 IS NULL) AND (receiving_value_12 = 0 OR receiving_value_12 IS NULL) ) ``` 其中,`product_table`是产品表的表名,`shipping_value_1`到`shipping_value_12`是连续12个月的发货值字段,`receiving_value_1`到`receiving_value_12`是连续12个月的收货值字段。该SQL语句使用了NOT运算符和AND运算符来判断连续12个月的发货值和收货值是否为空或为0,如果都为空或为0,则过滤该产品。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值