动态拼接update sql语句

@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);
    }