cn.patterncat.helper.sql.util.SqlUtils Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of sql-helper Show documentation

sql-helper

There is a newer version: 0.0.7

package cn.patterncat.helper.sql.util;

import cn.patterncat.helper.sql.builder.SQL;

import java.util.Map;

/**
 * Created by patterncat on 2017-11-21.
 */
public class SqlUtils {

    public static String buildInsertNamedSql(String table,Map valueMap,boolean selective){
        SQL sql = new SQL();
        sql.INSERT_INTO(table);
        for(Map.Entry entry:valueMap.entrySet()){
            String key = entry.getKey();
            Object value = entry.getValue();
            String column = ValueUtils.camelhumpToUnderline(key);
            if(selective){
                if(value != null){
                    sql.VALUES(column, ":" + key);
                }
            }else{
                sql.VALUES(column, ":" + key);
            }
        }
        return sql.toString();

    }

    public static String buildUpdateNamedSql(String table,Map valueMap,boolean selective){
        SQL sql = new SQL();
        sql.UPDATE(table);

        for(Map.Entry entry:valueMap.entrySet()){
            String key = entry.getKey();
            String column = ValueUtils.camelhumpToUnderline(key);
            if("id".equals(key)){
                continue;
            }
            Object value = entry.getValue();
            if(selective){
                if(value != null){
                    sql.SET(column + " = :" + key);
                }
            }else{
                sql.SET(column + " = :" + key);
            }
        }
        return sql.toString();
    }
}