Vic,
You could write a row handler to take the returned maps and a string
builder to create xml.
One class would handle all of your requirements.
Something like this is close - testing is an exercise left to the reader. ;-)
===
public class MapToXmlRowHandler
implements RowHandler
{
private String wrapper;
private String item;
private StringBuilder builder;
public MapToXmlRowHandler(String wrapper, String item) {
this.wrapper = wrapper;
this.item = item;
builder = new StringBuilder();
}
public void handleRow(Object object) {
Map<String, Object> m = (Map<String, Object>) object;
builder.append("<").append(item).append(">");
for(String key : m.keySet()){
// todo: make sure these values are xml friendly
builder.append("<").append(key).append(">")
.append(m.get(key))
.append("</").append(key).append(">");
}
builder.append("</").append(item).append(">");
}
public String getResultsAsXml(){
StringBuilder result = new StringBuilder("<" + wrapper + ">")
.append(builder)
.append("</").append(wrapper).append(">");
return result.toString();
}
}
===
Larry
On 3/15/07, netsql <[EMAIL PROTECTED]> wrote:
In the past I allways returned arraylist of hashmap and that works EXCLENT.
I now want to return xml. I saw some notes on xstream and it works but not
so well, I do not like the xml it makes.
Is there snipets or more ideas to help me?
tia,
.V
