动态拼接update sql语句

最新推荐文章于 2024-07-18 04:00:11 发布

sinaihalo

最新推荐文章于 2024-07-18 04:00:11 发布

阅读量6.4k

点赞数 1

本文链接：https://blog.csdn.net/sinaihalo/article/details/80908399

版权

@WriteDataSource
    public void updateEquipmentAssets(String tableName,List<String> keyList,List<String> valueList){
        StringBuilder sb = new StringBuilder();
        sb.append("UPDATE "+tableName+" SET ");//equipmentassetstable 
        for(int i=0;i<keyList.size();i++){
            if(!"ID".equals(keyList.get(i))){
                sb.append(keyList.get(i));
                sb.append("=");
                sb.append("'"+valueList.get(i)+"'");
                if(i!=keyList.size()-1){
                    sb.append(",");
                }
            }

        }
        for(int i=0;i<keyList.size();i++){
            if("ID".equals(keyList.get(i))){
                sb.append(" WHERE ID = '"+valueList.get(i)+"'");
            }
        }
        //jt.execute(sb.toString());
        System.out.println(sb);
    }