ibatis simple select

준비파일

ibatis-2.3.4.726.jar

작성파일

test.ibatis.xml

sqlmapConfig.xml

IbatisTest.java

--------------------------------------------------

☞ test.ibatis.xml

<?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="TestMap">
    <select id="selectTest" parameterClass="int" resultClass="string">
    SELECT
    name
    FROM
    test_table
    WHERE
    id=#value#
    </select>
</sqlMap>

--------------------------------------------------

☞ sqlmapConfig.xml

<?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/db명" />
            <property name="JDBC.Username" value="db아이디" />
            <property name="JDBC.Password" value="db패스워드" />
        </dataSource>
    </transactionManager>

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

--------------------------------------------------

☞ IbatisTest.java

import java.io.Reader;

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);
       
        String name = null;
        name = (String)sqlMap.queryForObject("selectTest", 2);
        System.out.println("test :: " + name);
    }

}