ibatis simple select java bean class와 연동하기

DTO(Data Transfer Object)

자바빈즈

Sample.java

package test.ibatis;

public class Sample {
    private Long id;
    private String description;
   
    /**
     * @return the id
     */
    public Long getId() {
        return id;
    }
    /**
     * @param id the id to set
     */
    public void setId(Long id) {
        this.id = id;
    }
    /**
     * @return the description
     */
    public String getDescription() {
        return description;
    }
    /**
     * @param description the description to set
     */
    public void setDescription(String description) {
        this.description = description;
    }
   
   
}

Sample.xml (SqlMap파일)

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd">

<sqlMap namespace="Sample">
    <select id="getSample" resultClass="test.ibatis.Sample">
        SELECT
            ID as id,
            `DESC` as description
        FROM SAMPLE
        WHERE ID = #value#
    </select>
</sqlMap>

sqlMapConfig.xml (SqlMapConfig파일)

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN" "http://www.ibatis.com/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
 
    <transactionManager type="JDBC">
        <dataSource type="SIMPLE">
            <property name="JDBC.Driver" value="org.gjt.mm.mysql.Driver" />
            <property name="JDBC.ConnectionURL" value="jdbc:mysql://localhost/foods" />
            <property name="JDBC.Username" value="midori" />
            <property name="JDBC.Password" value="midori" />
        </dataSource>
    </transactionManager>

    <sqlMap resource="test/ibatis/test.ibatis.xml" />
    <sqlMap resource="test/ibatis/Sample.xml" />
</sqlMapConfig>

IBatisTest.java(테스트파일)

import java.io.Reader;

import test.ibatis.Sample;

import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;


public class IbatisTest {

    /**
     * @param args
     */
    public static void main(String[] args) throws Exception {
        Reader reader = Resources.getResourceAsReader("sqlMapConfig.xml");
        SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
       

       
        Sample sample = (Sample)sqlMap.queryForObject("getSample", new Long(1L));
        System.out.println(sample.getId());
        System.out.println(sample.getDescription());
    }

}