cloud-manage-new/src/main/java/cn/com/taiji/manage/util/SqlUtil.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package cn.com.taiji.manage.util;

import com.google.common.base.CaseFormat;
import org.apache.commons.lang.StringUtils;

import java.util.List;

public class SqlUtil {

    public static String camelToUnderScore(String name) {
        String to = CaseFormat.LOWER_CAMEL.to(CaseFormat.LOWER_UNDERSCORE, name);
        return to;
    }

    public static String getTableName(String prefix, String platNum, String name){
        return prefix + "_" + platNum + "_" + name;
    }

    /**
     * 生成预加载sql
     *
     * @param keys
     * @param tableName
     * @return
     */
    public static String createSql(List<String> keys, String tableName) {

        StringBuilder sb = new StringBuilder("insert into ").append(tableName).append(" (");
        StringBuilder valueSql = new StringBuilder();
        for (String key : keys) {
            sb.append("`").append(key).append("`,");
            valueSql.append("?,");
        }
        StringBuilder insertSql = sb.replace(sb.length() - 1, sb.length(), ") values (");
        valueSql = valueSql.replace(valueSql.length() - 1, valueSql.length(), ")");
        return insertSql.append(valueSql).toString();
    }

    public static String createSqlNew(List<String> keys, String tableName){
        StringBuilder sb = new StringBuilder("insert into ").append(tableName).append(" (");
        for (String key : keys) {
            sb.append("`").append(key).append("`,");
        }
        sb.append(")");
        return sb.toString().replace(",)", ")");
    }

    public static String createAppendSql(int size){
        StringBuffer buffer = new StringBuffer("(");
        for (int i = 0; i < size; i++) {
            buffer.append("?,");
        }
        buffer.append(")");
        return buffer.toString().replace(",)", ")");
    }

    /**
     * 生成查询最新版本的sql
     * @return
     */