XML Result
The following example shows using XML result class.
It provides a way of serializing results to an XML string.
The attribute xmlResultName="STUDENT"
allows us to specify the ROOT XML Tag name.
01<?xml version="1.0" encoding="UTF-8"?>
02<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
05<sqlMap namespace="Student">
07 <select id="getXMLById" parameterClass="int" resultClass="xml" xmlResultName="STUDENT">
10 STUDENT_ID as studentId,
11 FIRST_NAME as firstName,
12 LAST_NAME as lastName,
16 FROM STUDENT where STUDENT_ID = #value#
package com.bethecoder.tutorials.ibatis.tests.basic; import java.io.IOException; import java.io.Reader; import java.sql.SQLException; import com.ibatis.common.resources.Resources; import com.ibatis.sqlmap.client.SqlMapClient; import com.ibatis.sqlmap.client.SqlMapClientBuilder; public class XMLResultName { /** * @param args * @throws IOException * @throws SQLException */ public static void main ( String [] args ) throws IOException, SQLException { Reader reader = Resources.getResourceAsReader ( "SqlMapConfig.xml" ) ; SqlMapClient sqlMapClent = SqlMapClientBuilder.buildSqlMapClient ( reader ) ; String studentXML = ( String ) sqlMapClent.queryForObject ( "Student.getXMLById" , 1 ) ; System.out.println ( studentXML ) ; } }
It gives the following output,
1<?xml version="1.0" encoding="UTF-8" standalone="no"?>
3 <STUDENTID>1</STUDENTID>
4 <FIRSTNAME>Jim</FIRSTNAME>
5 <LASTNAME>Attic</LASTNAME>
7 <PHONE>+919999999999</PHONE>
8 <HOBBY>Painting</HOBBY>
