You've got to find what you love.

package daoEx.vo;

public class Emp {
    private int empno, deptno, sal;
    private String ename, job, hiredate;

    public int getDeptno() {
        return deptno;
    }
    public void setDeptno(int deptno) {
        this.deptno = deptno;
    }
    public int getEmpno() {
        return empno;
    }
    public void setEmpno(int empno) {
        this.empno = empno;
    }
    public String getEname() {
        return ename;
    }
    public void setEname(String ename) {
        this.ename = ename;
    }
    public String getHiredate() {
        return hiredate;
    }
    public void setHiredate(String hiredate) {
        this.hiredate = hiredate;
    }
    public String getJob() {
        return job;
    }
    public void setJob(String job) {
        this.job = job;
    }
    public int getSal() {
        return sal;
    }
    public void setSal(int sal) {
        this.sal = sal;
    }
}

package daoEx.inter;

import java.util.List;
import daoEx.vo.Emp;

public interface EmpInter
{
    public List<Emp> getAllEmp();
}

package daoEx.inter;

import com.ibatis.dao.client.DaoManager;
import com.ibatis.dao.client.template.SqlMapDaoTemplate;
import daoEx.vo.Emp;
import java.util.List;
/*
 * 1. DAO 환경에서 구현객체는 반드시 SqlMapDaoTemplate으로부터
 *     상속을 받아야 한다. 그리고
 * 2. DaoManager 객체를 인자로 받는 생성자 또한 정의 해야한다.
*/
public class EmpInterImpl extends SqlMapDaoTemplate implements EmpInter
{
// 생성자를 만들어준다. DaoManager 객체는 ibatis.dao가 가지고있는 클래스
    public EmpInterImpl(DaoManager daoManager)
    {
        super(daoManager);
    }
    public List<Emp> getAllEmp()
    {
        // config 디렉토리에 Emp.xml에 선언된 selectAllEmp 쿼리문을 리턴해준다.
        return queryForList("selectAllEmp");
    }
}

package daoEx.client;

import daoEx.inter.EmpInter;
import daoEx.vo.Emp;
import service.DaoService;

public class EmpClient
{
    public static void main(String[] arr)
    {
        // DaoService에 있는 getDao를 통하여 원하는 Dao(인터페이스)를 얻어낸다.
        EmpInter obj = (EmpInter) DaoService.getDao(EmpInter.class);
        for(Emp e : obj.getAllEmp())
        {
            System.out.println(e.getEmpno()+", "+e.getEname());
        }
    }
}

package service;

import com.ibatis.common.resources.Resources;
import com.ibatis.dao.client.Dao;
import com.ibatis.dao.client.DaoManager;
import com.ibatis.dao.client.DaoManagerBuilder;
import java.io.Reader;

public class DaoService
{
    // 싱글턴 static 객체를 생성한다.
    private static DaoManager dm;

    public static Dao getDao(Class n)
    {
        try
        {
            if(dm == null)
            {// 최초 호출시 수행하는 부분. dm이 null값일경우 로드한다.
             // sqlMapConfig.xml 을 로딩하던 기존과 다르다.
                Reader reader = Resources.getResourceAsReader("config/dao.xml");
                dm = DaoManagerBuilder.buildDaoManager(reader);
             // implement된 객체들을 dm 객체에 담아둔다.
                reader.close();
            }
        } catch (Exception e)
        {
            System.out.println(e.getMessage());
        }
        // DaoManager 클래스 안에 getDao() 메서드를 리턴해준다.
        return dm.getDao(n);
    }
}

<?xml version="1.0" encoding="euc-kr"?>

<!DOCTYPE sqlMapConfig PUBLIC '-//ibatis.apache.org//DTD SQL Map Config 2.0//EN' 'http://ibatis.apache.org/dtd/sql-map-config-2.dtd'>
<sqlMapConfig>
    <transactionManager type="JDBC" commitRequired="false">
<!-- WEB 환경으로 할때는 대부분 JNDI 로 설정-->
        <dataSource type="SIMPLE">
            <property name="JDBC.Driver" value="oracle.jdbc.driver.OracleDriver"/>
            <property name="JDBC.ConnectionURL" value="jdbc:oracle:thin:@203.236.209.201:1521:orcl"/>
            <property name="JDBC.Username" value="scott"/>
            <property name="JDBC.Password" value="tiger"/>
        </dataSource>
    </transactionManager>

    <sqlMap resource="config/Emp.xml"/>
</sqlMapConfig>

<?xml version="1.0" encoding="euc-kr"?>

<!DOCTYPE sqlMap PUBLIC '-//ibatis.apache.org//DTD SQL Map 2.0//EN' 'http://ibatis.apache.org/dtd/sql-map-2.dtd'>
<sqlMap>
    <typeAlias alias="empVo" type="daoEx.vo.Emp"/>

    <select id="selectAllEmp" resultClass="empVo">
        SELECT * FROM emp
    </select>
</sqlMap>

<?xml version="1.0" encoding="euc-kr"?>

<!DOCTYPE daoConfig PUBLIC '-//ibatis.apache.org//DTD DAO Configuration 2//EN' 'http://ibatis.apache.org/dtd/dao-2.dtd'>
<daoConfig>
    <context id="sqlMap">
        <!-- type="SQLMAP"은 지정된 타입 type="JDBC" 를 입력할경우 <datasource 를 사용할수 있다 -->
        <transactionManager type="SQLMAP">
        <!-- name="SqlMapConfigResource" 키값이므로 정확히 -->
            <property name="SqlMapConfigResource" value="config/sqlMapConfig.xml"/>
        </transactionManager>
        <dao interface="daoEx.inter.EmpInter" implementation="daoEx.inter.EmpInterImpl"/>
    </context>
</daoConfig>

CREATE SEQUENCE memo_T_seq
increment by 1
start with 1
nomaxvalue
nocycle
cache 10;

CREATE SEQUENCE comment_T_seq
increment by 1
start with 1
nomaxvalue
nocycle
cache 10;

CREATE TABLE memo_T(
 idx NUMBER,
 subject VARCHAR2(50),
 name VARCHAR2(20),
 email VARCHAR2(50),
 w_day date,
 memo VARCHAR2(4000),
 CONSTRAINT memo_T PRIMARY KEY(idx)
);

CREATE TABLE comment_T(
 idx NUMBER,
 memo_idx NUMBER CONSTRAINT comment_fk REFERENCES memo_T (idx),
 name VARCHAR2(20),
 email VARCHAR2(50),
 w_day date,
 comm VARCHAR2(4000)
);

INSERT INTO memo_T VALUES(memo_T_seq.NEXTVAL,'test1','마루치','aaa@hanbiteni.co.kr','2008-11-18','테스트입니다.');
INSERT INTO memo_T VALUES(memo_T_seq.NEXTVAL,'내가 누구게~~?','아라치','bbb@hanbiteni.co.kr','2008-11-19','마루치 못 봤어요?.');
INSERT INTO memo_T VALUES(memo_T_seq.NEXTVAL,'세번째 테스트','파토나슈','papa@hanbiteni.co.kr','2008-11-19','파토나슈~~.');

INSERT INTO comment_T VALUES(comment_T_seq.NEXTVAL,2,'마루치','aaa@hanbiteni.co.kr','2008-11-18','몰라~! 알 수가 없어!!');
INSERT INTO comment_T VALUES(comment_T_seq.NEXTVAL,2,'파토나슈','papa@hanbiteni.co.kr','2008-11-19','파토! 깽판!');
INSERT INTO comment_T VALUES(comment_T_seq.NEXTVAL,1,'파토나슈','papa@hanbiteni.co.kr','2008-11-19','시워~ 시워^^');

package memo.vo;

import java.util.List;

public class Memo {
    private int idx;
    private String subject, name, email, w_day, memo;
    private List<Comment> comments;
   
    public List<Comment> getComments() {
        return comments;
    }
    public void setComments(List<Comment> comments) {
        this.comments = comments;
    }
    public String getEmail() {
        return email;
    }
    public void setEmail(String email) {
        this.email = email;
    }
    public int getIdx() {
        return idx;
    }
    public void setIdx(int idx) {
        this.idx = idx;
    }
    public String getMemo() {
        return memo;
    }
    public void setMemo(String memo) {
        this.memo = memo;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getSubject() {
        return subject;
    }
    public void setSubject(String subject) {
        this.subject = subject;
    }
    public String getW_day() {
        return w_day;
    }
    public void setW_day(String w_day) {
        this.w_day = w_day;
    }
}

package memo.vo;

public class Comment {
    private int idx, memo_idx;
    private String c_name, c_email, c_w_day, comm;

    public String getC_email() {
        return c_email;
    }
    public void setC_email(String c_email) {
        this.c_email = c_email;
    }
    public String getC_name() {
        return c_name;
    }
    public void setC_name(String c_name) {
        this.c_name = c_name;
    }
    public String getC_w_day() {
        return c_w_day;
    }
    public void setC_w_day(String c_w_day) {
        this.c_w_day = c_w_day;
    }
    public String getComm() {
        return comm;
    }
    public void setComm(String comm) {
        this.comm = comm;
    }
    public int getIdx() {
        return idx;
    }
    public void setIdx(int idx) {
        this.idx = idx;
    }
    public int getMemo_idx() {
        return memo_idx;
    }
    public void setMemo_idx(int memo_idx) {
        this.memo_idx = memo_idx;
    }
}

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE sqlMapConfig PUBLIC '-//ibatis.apache.org//DTD SQL Map Config 2.0//EN' 'http://ibatis.apache.org/dtd/sql-map-config-2.dtd'>
<sqlMapConfig>
    <transactionManager type="JDBC" commitRequired="false">
        <dataSource type="SIMPLE">
            <property name="JDBC.Driver" value="oracle.jdbc.driver.OracleDriver"/>
            <property name="JDBC.ConnectionURL" value="jdbc:oracle:thin:@203.236.209.201:1521:orcl"/>
            <property name="JDBC.Username" value="scott"/>
            <property name="JDBC.Password" value="tiger"/>
        </dataSource>
    </transactionManager>
    <sqlMap resource="config/Memo.xml"/>
</sqlMapConfig>

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE sqlMap PUBLIC '-//ibatis.apache.org//DTD SQL Map 2.0//EN' 'http://ibatis.apache.org/dtd/sql-map-2.dtd'>
<sqlMap>
    <typeAlias alias="memo" type="memo.vo.Memo"/>
    <typeAlias alias="comment" type="memo.vo.Comment"/>

    <resultMap id="getComm" class="comment">
        <result property="idx" column="idx"/>
        <result property="memo_idx" column="memo_idx"/>
        <result property="c_name" column="name"/>
        <result property="c_email" column="email"/>
        <result property="c_w_day" column="w_day"/>
        <result property="comm" column="comm"/>
    </resultMap>
<!--
memo 클래스의 resultMap 를 만든다.
getMemo_comm 을 하지 않고
Comment.java 에는 getMemo에서 다 선언하지 않은 List 타입의 comments 컬럼이 있다.
-->
    <resultMap id="getMemo" class="memo">
        <result property="idx" column="idx"/>
        <result property="subject" column="subject"/>
        <result property="name" column="name"/>
        <result property="email" column="email"/>
        <result property="w_day" column="w_day"/>
        <result property="memo" column="memo"/>
    </resultMap>
<!--
getMemo_comm의 이름을 가진 resultMap 에서는 위의 getMemo 를 상속받는다.
자바에서와 같이 상속을 받아서 getMemo의 result로 선언한 컬럼을 모두 포함한다.
아래 getMemo_comm에서는 List 타입의 comments를 오버라이딩 하였다.
-->
    <resultMap id="getMemo_comm" class="memo" extends="getMemo">
        <result property="comments" select="getCommList" column="{memo_idx=idx}"/>
    </resultMap>

<!-- Comment -->
    <select id="getCommList" resultMap="getComm" parameterClass="comment">
        SELECT * FROM comment_T
        WHERE memo_idx = #memo_idx#
        ORDER BY memo_idx DESC
    </select>
<!-- Memo -->
    <select id="getMemoList" resultMap="getMemo_comm">
        SELECT * FROM memo_T
        ORDER BY idx DESC
    </select>
    </sqlMap>

package memo.client;

import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;
import java.util.List;
import memo.vo.Comment;
import memo.vo.Memo;

public class MemoClient {
    public static void main(String[] arr)throws IOException, SQLException{
        Reader reader = Resources.getResourceAsReader("sqlMapConfig.xml");

        SqlMapClient map = SqlMapClientBuilder.buildSqlMapClient(reader);
        reader.close();

        List<Memo> list = map.queryForList("getMemoList");

        // Memo 타입의  m
        for(Memo m : list)
        {
            // 메인 글의 번호, 제목, 코멘트 개수가 출력되고
            System.out.println(m.getIdx()+" - "+m.getSubject()+"("+m.getComments().size()+")");
            for(Comment c : m.getComments())
            {   // 코멘트의 내용, 글쓴이 이름 이 출력된다.
                System.out.println(" -->"+c.getComm()+"("+c.getC_name()+")");
            }
        }
    }
}