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