sql对应字段属性生成java属性和驼峰转换

最新推荐文章于 2024-07-29 03:15:38 发布

可口可乐的配方

最新推荐文章于 2024-07-29 03:15:38 发布

阅读量228

点赞数

文章标签： java sql 数据库 idea

本文链接：https://blog.csdn.net/weixin_41217938/article/details/130345231

版权

该代码片段展示了如何使用Java处理字符串。它将一个包含字段名的长字符串按逗号分割，然后对每个字段的类型进行转换，如将datetime转换为Date，text和varchar转换为String，decimal转换为BigDecimal。同时，还有一个方法将下划线分隔的字符串转为驼峰式命名。

摘要由CSDN通过智能技术生成

public static void main(String[] args) {
    String name = "BILLID,BILLNO,DO_LINEID,ITEMID,ITEMCODE,ITEMNAME,ITEMBARCODE,PARENTID,CAPACITY,FMODEL,ORIGN,STOCKUNIT,PACKCODE,PACKSIZE,PCS,ODD,QTY,GIFT_QTY,SDPLANQTY,PCSUNQTY,ODDUNQTY,PRICE,NETPRICE,LOTID,LOTNO,BATCHNO,YIELDDATE,EXPDATE,LINESTATUS,REFBILLID,REFBILLNO,REFBILLLINEID,STOCKSTATUS,STOREROOMCODE,AREACODE,LOADBILLNO,LOCID,LOCCODE,BATCHREQUEST,INVTURMODE,KEEPTYPE,ISHANGUP,ISCANCEL,CONSIGNOR,CONSIGNORNAME,BRANCHID,ENTERPRISEID,LASTMODIFYBY,LASTMODIFYDATE,REMARK,ATTR_STR1,ATTR_STR2,ATTR_STR3,ATTR_STR4,ATTR_STR5,ATTR_STR6,ATTR_STR7,ATTR_STR8,ATTR_STR9,ATTR_STR10,ATTR_NUM1,ATTR_NUM2,ATTR_NUM3,ATTR_NUM4,ATTR_NUM5,ATTR_NUM6,ATTR_NUM7,ATTR_NUM8,ATTR_NUM9,ATTR_NUM10,ATTR_DTE1,ATTR_DTE2,ATTR_DTE3,ATTR_DTE4,ATTR_DTE5,ATTR_DTE6,ATTR_DTE7,ATTR_DTE8,ATTR_DTE9,ATTR_DTE10,WAVENO,WAVE_FLG,WAVEDATE,PRDLINE,PRDLOC,ONLINEDATE,DSTLOC,ONLINETIME,RULE_ID,REFUNITNAME,REFUNITQTY,SEQNO,ISRUNFLAG,LOTLIMIT,SHIPBILLNO,SHIPBILLID";
    String atr1 = "varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,decimal,decimal,decimal,decimal,decimal,decimal,decimal,decimal,decimal,decimal,varchar,varchar,varchar,datetime,datetime,decimal,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,decimal,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,datetime,text,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,decimal,decimal,decimal,decimal,decimal,decimal,decimal,decimal,decimal,decimal,datetime,datetime,datetime,datetime,datetime,datetime,datetime,datetime,datetime,datetime,varchar,decimal,datetime,varchar,varchar,datetime,varchar,varchar,varchar,varchar,decimal,varchar,varchar,varchar,varchar,varchar";
    String[] split = name.split(",");
    String[] atr = atr1.split(",");
    for (int i = 0; i < split.length; i++) {
        String s = split[i];
        String a = atr[i];
        String s1 = underlineToHump(s);
        a = transfoatt(a);
        System.out.println(a + "," + s1);
    }
}

private static String transfoatt(String a) {
    if ("datetime".equals(a)) {
        a = "Date";
    }
    if ("text".equals(a)) {
        a = "String";
    }
    if ("varchar".equals(a)) {
        a = "String";
    }
    if ("decimal".equals(a)) {
        a = "BigDecimal";
    }
    if ("char".equals(a)) {
        a = "String";
    }


    return a;
}

public static String underlineToHump(String str) {
    str = str.toLowerCase();
    String regex = "_(.)";
    Matcher matcher = Pattern.compile(regex).matcher(str);
    while (matcher.find()) {
        String target = matcher.group(1);
        str = str.replaceAll("_" + target, target.toUpperCase());
    }
    return str;
}