iBatis - iBatis

EmployeeTest.java

package ex1;

import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
import ex1.vo.Employee;
import java.io.Reader;
import java.util.List;

public class EmployeeTest {
    public static Reader reader;
    public static SqlMapClient sqlMapper;
   
    static {
        try {
            reader = Resources.getResourceAsReader("ex1/sqlMapConfig.xml");
            sqlMapper = SqlMapClientBuilder.buildSqlMapClient(reader);
            reader.close();
        } catch (Exception e) {e.printStackTrace();}
    }
   
        public static List<Employee> getSearchJob(String n)throws Exception{
            return sqlMapper.queryForList("searchJob",n);
        }
        public static void main(String[] args) throws Exception{
            List<Employee> list = getSearchJob("ANALYST");
            for(Employee e : list)
                System.out.println(e.getEmpno());
        }

}

Employee.xml

<?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="emp" type="ex1.vo.Employee"/>
    <resultMap id="empRes" class="emp">
        <result property="empno" column="empno"/>
        <result property="ename" column="ename"/>
        <result property="job" column="job"/>
        <result property="sal" column="sal"/>

    </resultMap>
   
    <select id="searchJob" parameterClass="String" resultMap="empRes">
        SELECT * FROM emp WHERE job=#job#
    </select>
</sqlMap>

sqlMapConfig.xml

<?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:@localhost:1521:ORCL1"/>
            <property name="JDBC.Username" value="scott"/>
            <property name="JDBC.Password" value="tiger"/>
        </dataSource>
    </transactionManager>
    <sqlMap resource="ex1/Employee.xml"/>
</sqlMapConfig>

Employee.java

package ex1.vo;

public class Employee {
    int empno , sal;
    String ename, job;

    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 getJob() {
        return job;
    }

    public void setJob(String job) {
        this.job = job;
    }

    public int getSal() {
        return sal;
    }

    public void setSal(int sal) {
        this.sal = sal;
    }

}

결과