...JAVA通过Map拼接SQL语句(InsertUpdate语句)

2023年8月3日发(作者：)

javamapinsertsql_JAVA通过Map拼接SQL语句（InsertUpdate语句）;;ls;classSQLUtils {/*** 通过Map拼接Insert SQL语句**@paramtableName*@paramdataMap*@return*/public static String genSqlInsert(String tableName, MapdataMap) {if(y(dataMap)) {return null;}//⽣成INSERT INTO table(field1,field2) 部分StringBuffer sbField = newStringBuffer();//⽣成VALUES('value1','value2') 部分StringBuffer sbValue = newStringBuffer();("INSERT INTO " + rCase() + "(");for(ntry : et()){String mapKey=();String mapValue=ue();if((mapKey, )) {continue;}("`" + mapKey + "`,");("'" + mapValue + "',");}sbField=LastChar(sbField);sbValue=LastChar(sbValue);return ng() + ") VALUES(" + ng() + ")";}/*** 通过Map拼接Update SQL语句**@paramtableName*@paramoperation*@paramdataMap*@return*/public static String genSqlUpdate(String tableName, MapdataMap) {if(y(dataMap)) {return null;}String idColumn=();String idValue=(idColumn);StringBuffer sb= newStringBuffer();("UPDATE "+ rCase() +" SET ");for(ntry : et()){String mapKey=();String mapValue=ue();if((mapKey, )) {continue;}if((rCase(), idColumn)) {continue;}("`" + mapKey + "`='" + mapValue + "',");}sb=LastChar(sb);return ("%s where %s='%s'", ng(), idColumn, idValue);}}

2023年8月3日发(作者：)

javamapinsertsql_JAVA通过Map拼接SQL语句（InsertUpdate语句）;;ls;classSQLUtils {/*** 通过Map拼接Insert SQL语句**@paramtableName*@paramdataMap*@return*/public static String genSqlInsert(String tableName, MapdataMap) {if(y(dataMap)) {return null;}//⽣成INSERT INTO table(field1,field2) 部分StringBuffer sbField = newStringBuffer();//⽣成VALUES('value1','value2') 部分StringBuffer sbValue = newStringBuffer();("INSERT INTO " + rCase() + "(");for(ntry : et()){String mapKey=();String mapValue=ue();if((mapKey, )) {continue;}("`" + mapKey + "`,");("'" + mapValue + "',");}sbField=LastChar(sbField);sbValue=LastChar(sbValue);return ng() + ") VALUES(" + ng() + ")";}/*** 通过Map拼接Update SQL语句**@paramtableName*@paramoperation*@paramdataMap*@return*/public static String genSqlUpdate(String tableName, MapdataMap) {if(y(dataMap)) {return null;}String idColumn=();String idValue=(idColumn);StringBuffer sb= newStringBuffer();("UPDATE "+ rCase() +" SET ");for(ntry : et()){String mapKey=();String mapValue=ue();if((mapKey, )) {continue;}if((rCase(), idColumn)) {continue;}("`" + mapKey + "`='" + mapValue + "',");}sb=LastChar(sb);return ("%s where %s='%s'", ng(), idColumn, idValue);}}