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