RowHandler

public class XmlRowHandler implements RowHandler {
	
	StringBuffer xmlresult = new StringBuffer("<UserList>");
	
	public void handleRow(Object valueObject) {
		User user = (User)valueObject;
		xmlresult.append("<User>");
		
		xmlresult.append("<id>");
		xmlresult.append(user.getId());
		xmlresult.append("</id>");
		
		xmlresult.append("<name>");
		xmlresult.append(user.getName());
		xmlresult.append("</name>");
		
		xmlresult.append("<password>");
		xmlresult.append(user.getPassword());
		xmlresult.append("</password>");
		
		xmlresult.append("</User>");
	}

	public String getXmlresult() {
		xmlresult.append("</UserList>");
		return xmlresult.toString();
	}

public void testRowHandler01(){
		Reader reader = null ;
		try {
			reader = Resources.getResourceAsReader("SqlMapConfig.xml");
			SqlMapClient sqlmap = SqlMapClientBuilder.buildSqlMapClient(reader);
			
			XmlRowHandler rh = new XmlRowHandler();
			
			sqlmap.queryWithRowHandler("queryUser03", 1, rh);
			
			System.out.println(rh.getXmlresult());
			
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

public class FilterHandler implements RowHandler {
	
	private List<User> list = new ArrayList<User> ();
	
	public void handleRow(Object valueObject) {
		User user = (User)valueObject;
		
		if (user.getName().equals("xixi")) {
			list.add(user);
		}
	}

	public List<User> getList() {
		return list;
	}
}

public void testRowHandler02(){
		Reader reader = null ;
		try {
			reader = Resources.getResourceAsReader("SqlMapConfig.xml");
			SqlMapClient sqlmap = SqlMapClientBuilder.buildSqlMapClient(reader);
			
			FilterHandler rh = new FilterHandler();
			
			sqlmap.queryWithRowHandler("queryUser", null, rh);
			
			System.out.println(rh.getList().get(0).getName());
			
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}