은성이의 프로그램X파일

import java.util.HashMap;
import java.util.List;

import hr.dao.EmployeeDAO;
import hr.dto.DepartmentDTO;
import hr.dto.EmployeeDTO;

public class TestEmployee {

 public static void main(String[] args)throws Exception {
  DepartmentDTO deptDTO = new DepartmentDTO();
  deptDTO.setDepartmentId("D0001");
  EmployeeDTO empDTO = new EmployeeDTO("00013", "김건모", "abc@abc.com", "과장", 403000, deptDTO);
  EmployeeDAO dao = EmployeeDAO.getInstance();
  
 // dao.insertEmployee(empDTO);
  empDTO.setSalary(5405050);
  empDTO.setJobPosition("부장");
  int cnt = dao.updateEmployee(empDTO);
  System.out.println("변경된 row 수 : "+cnt);
  cnt = dao.deleteEmployeeById("00013");
  System.out.println("삭제된 row 수 : "+cnt);
  System.out.println("-----전체 직원 부서 조회하기------");
  List list = dao.selectAllEmployee();
  for(Object obj:list){
   EmployeeDTO dto = (EmployeeDTO)obj;
   System.out.println(dto.getEmployeeName()+" - "+dto.getDepartmentDTO().getDepartmentName());
   }
  System.out.println("-----부서 조회하기-------");
  list = dao.selectAllDepartment();
  for(Object obj:list){
   System.out.println(obj);
  }
  System.out.println("------봉급으로 조회-------");
  HashMap map = new HashMap();
  //map.put("start_salary", 2000000);
  map.put("end_salary", 10000000);
  
  List list1 = dao.selectEmployeeBySalaryRange(map);
  for(Object obj:list1){
   System.out.println(obj);
  }
  System.out.println("-----이름과 부서이름으로 조회--------");
  EmployeeDTO edto1 = new EmployeeDTO();
//  edto1.setEmployeeName("장");
  edto1.setJobPosition("부");
  List list2 = dao.selectEmployeeByNameOrPosition(edto1);
  for(Object obj:list2){
   System.out.println(obj);
  }
  
  System.out.println("-----iterate사용해서 여러명의 이름 중 있는 것만 조회하기------");
  HashMap names =  new HashMap();
  String[] ns = {"한석규","길무성","김건모"};
  names.put("names", ns);
     list = dao.selectEmployeeByNames(names);
  System.out.println(list.size()+"명 조회");
  for(Object obj:list){
   System.out.println(obj);
  }
 }
}

 <?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 namespace="dept">
 <select id="selectAllDepartment" resultClass="hr.dto.DepartmentDTO">
  select department_id as departmentId,
     department_name as departmentName,
     location
  from department
 </select>
</sqlMap>

<?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 namespace="hr">
 <typeAlias alias="empDTO" type="hr.dto.EmployeeDTO"/>
 <typeAlias alias="deptDTO" type="hr.dto.DepartmentDTO"/>
 <!-- insert -->
 <insert id="insertEmployee" parameterClass="empDTO">
 <!--
  <selectKey resultClass="int" keyProperty="employeeId">
  select aaaa from dual
 </selectKey>
 -->
  insert into employee
  (employee_id,employee_name, email, job_position, salary, department_id)
  values(#employeeId#,#employeeName#,#email#,#jobPosition#,#salary#,#departmentDTO.departmentId#)
 </insert>
 <update id="updateEmployee" parameterClass="empDTO">
  update employee
  set   employee_name=#employeeName#,
      email=#email#,
      job_position=#jobPosition#,
      salary=#salary#,
      department_id=#departmentDTO.departmentId#
  where  employee_id=#employeeId#
 </update>
 <delete id="deleteEmployeeById">
  delete from employee
  where employee_id=#id#
 </delete>
 <resultMap class="empDTO" id="employeeResultMap">
  <result property="employeeId" columnIndex="1"/><!--<result property="employeeId" column="employee_id"/>이렇게 줘도 되고  -->
  <result property="employeeName" columnIndex="2"/>
  <result property="email" columnIndex="3"/>
  <result property="jobPosition" columnIndex="4"/>
  <result property="salary" columnIndex="5"/>
  <result property="departmentDTO.departmentId" columnIndex="6"/>
  <result property="departmentDTO.departmentName" columnIndex="7"/>
  <result property="departmentDTO.location" columnIndex="8"/>
 </resultMap>
 <select id="selectAllEmployee" resultMap="employeeResultMap">
  select emp.employee_id ,
     emp.employee_name,
     emp.email,
     emp.job_position,
     emp.salary,
     dept.department_id,
     dept.department_name,
     dept.location
  from   employee emp, department dept
  where emp.department_id = dept.department_id
 </select>
 <select id="selectEmployeeBySalaryRange" resultMap="employeeResultMap" parameterClass="hashmap">
    select emp.employee_id ,
     emp.employee_name,
     emp.email,
     emp.job_position,
     emp.salary,
     dept.department_id,
     dept.department_name,
     dept.location
  from   employee emp, department dept
  where emp.department_id = dept.department_id
  <!--
  and    emp.salary &gt; #start_salary#
  and    emp.salary &lt; #end_salary#
   -->
  
   <isNotEmpty property="start_salary" prepend="and">
    emp.salary &gt; #start_salary#
   </isNotEmpty>
   <isNotEmpty property="end_salary" prepend="and">
    emp.salary &lt; #end_salary#
   </isNotEmpty>
  
 </select>
 <select id="selectEmployeeByNameAndJobPosition" resultMap="employeeResultMap" parameterClass="empDTO">
  select emp.employee_id ,
     emp.employee_name,
     emp.email,
     emp.job_position,
     emp.salary,
     dept.department_id,
     dept.department_name,
     dept.location
  from   employee emp, department dept
  where emp.department_id = dept.department_id
  <isNotEmpty property="employeeName" prepend="and">
   emp.employee_name Like '%$employeeName$%'
  </isNotEmpty>
  <isNotEmpty property="jobPosition" prepend="and">
   emp.job_position Like '%'||#jobPosition#||'%'<!-- '%'||#jobPosition#||'%' -->
  </isNotEmpty>
 </select>
 <select id="selectEmployeeByNames" resultMap="employeeResultMap" parameterClass="hashmap">
 select emp.employee_id ,
     emp.employee_name,
     emp.email,
     emp.job_position,
     emp.salary,
     dept.department_id,
     dept.department_name,
     dept.location
  from   employee emp, department dept
  where emp.department_id = dept.department_id
 <iterate property="names" conjunction="OR" open="(" close=")" prepend="and" >
  employee_name = #names[]#
 </iterate>
 <!-- and(name='홍길동' OR name='이순신') -->
 </select>
</sqlMap>

<?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>

  <!-- Configure a built-in transaction manager.  If you're using an
       app server, you probably want to use its transaction manager
       and a managed datasource -->
  <settings useStatementNamespaces="true"/><!-- namespace를 사용하겠다. true -->
  <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:@127.0.0.1:1521:XE"/>
      <property name="JDBC.Username" value="scott"/>
      <property name="JDBC.Password" value="tiger"/>
    </dataSource>
  </transactionManager>

  <!-- List the SQL Map XML files. They can be loaded from the
       classpath, as they are here (com.domain.data...) -->
 <!-- <sqlMap resource="config/member.xml"/> -->
<sqlMap resource="hr/config/hr.xml"/>
<sqlMap resource="hr/config/dept.xml"/>
</sqlMapConfig>

package hr.dao;

import hr.dto.EmployeeDTO;

import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.List;

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

public class EmployeeDAO {
 private SqlMapClient sqlMap;
 private static EmployeeDAO instance = new EmployeeDAO();
 private EmployeeDAO(){
  //SqlMapClient객체 생성
  try {
   Reader reader = Resources.getResourceAsReader("hr/config/SqlMapConfig.xml");
   sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
  } catch (IOException e) {
   e.printStackTrace();
  }
 }
 public static EmployeeDAO getInstance(){
  return instance;
 }
 //insert처리 메소드
 public void insertEmployee(EmployeeDTO empDTO) throws SQLException{
  sqlMap.insert("hr.insertEmployee",empDTO);
 }
 //update처리 메소드
 public int updateEmployee(EmployeeDTO empDTO) throws SQLException {
  return sqlMap.update("hr.updateEmployee", empDTO);
 }
 //delete처리 메소드
 public int deleteEmployeeById(String employeeId)throws SQLException{
  return sqlMap.delete("hr.deleteEmployeeById", employeeId);
 }
 //select처리 메소드
 public List selectAllEmployee() throws SQLException{
  return sqlMap.queryForList("hr.selectAllEmployee");//namespace를 사용했기 때문에 hr이 붙는다.
 }
 public List selectAllDepartment() throws SQLException{
  return sqlMap.queryForList("dept.selectAllDepartment");//namespace를 쓸 경우에는 반드시 namespace를 써 넣어야 한다.
 }
 public List selectEmployeeBySalaryRange(HashMap map) throws SQLException{
  return sqlMap.queryForList("hr.selectEmployeeBySalaryRange", map);
 }
 public List selectEmployeeByNameOrPosition(EmployeeDTO edto)throws SQLException{
  return sqlMap.queryForList("hr.selectEmployeeByNameAndJobPosition", edto);
 }
 public List selectEmployeeByNames(HashMap names)throws SQLException{
  return sqlMap.queryForList("hr.selectEmployeeByNames", names);
 }
}

package hr.dto;

public class DepartmentDTO {

 private String departmentId;
 private String departmentName;
 private String location;
 
 public DepartmentDTO() {}

 public DepartmentDTO(String departmentId, String departmentName,
   String location) {
  this.departmentId = departmentId;
  this.departmentName = departmentName;
  this.location = location;
 }

 public String getDepartmentId() {
  return departmentId;
 }

 public void setDepartmentId(String departmentId) {
  this.departmentId = departmentId;
 }

 public String getDepartmentName() {
  return departmentName;
 }

 public void setDepartmentName(String departmentName) {
  this.departmentName = departmentName;
 }

 public String getLocation() {
  return location;
 }

 public void setLocation(String location) {
  this.location = location;
 }

 @Override
 public String toString() {
  return "DepartmentDTO [departmentId=" + departmentId
    + ", departmentName=" + departmentName + ", location="
    + location + "]";
 }
 
 
}

package hr.dto;

public class EmployeeDTO {
 private String employeeId;
 private String employeeName;
 private String email;
 private String jobPosition;
 private int salary;
 private DepartmentDTO departmentDTO;
 public EmployeeDTO() {}
 public EmployeeDTO(String employeeId, String employeeName, String email,
   String jobPosition, int salary, DepartmentDTO departmentDTO) {
  this.employeeId = employeeId;
  this.employeeName = employeeName;
  this.email = email;
  this.jobPosition = jobPosition;
  this.salary = salary;
  this.departmentDTO = departmentDTO;
 }
 public String getEmployeeId() {
  return employeeId;
 }
 public void setEmployeeId(String employeeId) {
  this.employeeId = employeeId;
 }
 public String getEmployeeName() {
  return employeeName;
 }
 public void setEmployeeName(String employeeName) {
  this.employeeName = employeeName;
 }
 public String getEmail() {
  return email;
 }
 public void setEmail(String email) {
  this.email = email;
 }
 public String getJobPosition() {
  return jobPosition;
 }
 public void setJobPosition(String jobPosition) {
  this.jobPosition = jobPosition;
 }
 public int getSalary() {
  return salary;
 }
 public void setSalary(int salary) {
  this.salary = salary;
 }
 public DepartmentDTO getDepartmentDTO() {
  return departmentDTO;
 }
 public void setDepartmentDTO(DepartmentDTO departmentDTO) {
  this.departmentDTO = departmentDTO;
 }
 @Override
 public String toString() {
  return "EmployeeDTO [employeeId=" + employeeId + ", employeeName="
    + employeeName + ", email=" + email + ", jobPosition="
    + jobPosition + ", salary=" + salary + ", departmentDTO="
    + departmentDTO + "]";
 }
 
 
}

<?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>

</sqlMap>

<?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>

  <!-- Configure a built-in transaction manager.  If you're using an
       app server, you probably want to use its transaction manager
       and a managed datasource -->
  <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:@127.0.0.1:1521:XE"/>
      <property name="JDBC.Username" value="scott"/>
      <property name="JDBC.Password" value="tiger"/>
    </dataSource>
  </transactionManager>

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

import java.util.List;

import hr.dao.EmployeeDAO;
import hr.dto.DepartmentDTO;
import hr.dto.EmployeeDTO;

public class TestEmployee {

 public static void main(String[] args)throws Exception {
  DepartmentDTO deptDTO = new DepartmentDTO();
  deptDTO.setDepartmentId("D0001");
  EmployeeDTO empDTO = new EmployeeDTO("00013", "김건모", "abc@abc.com", "과장", 403000, deptDTO);
  EmployeeDAO dao = EmployeeDAO.getInstance();
  
 // dao.insertEmployee(empDTO);
  empDTO.setSalary(5405050);
  empDTO.setJobPosition("부장");
  int cnt = dao.updateEmployee(empDTO);
  System.out.println("변경된 row 수 : "+cnt);
  cnt = dao.deleteEmployeeById("00013");
  System.out.println("삭제된 row 수 : "+cnt);
  System.out.println("-----전체 직원 부서 조회하기------");
  List list = dao.selectAllEmployee();
  for(Object obj:list){
   EmployeeDTO dto = (EmployeeDTO)obj;
   System.out.println(dto.getEmployeeName()+" - "+dto.getDepartmentDTO().getDepartmentName());
   }
  System.out.println("-----부서 조회하기-------");
  list = dao.selectAllDepartment();
  for(Object obj:list){
   System.out.println(obj);
  }
  }
}


 

<?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 namespace="dept">
 <select id="selectAllDepartment" resultClass="hr.dto.DepartmentDTO">
  select department_id as departmentId,
     department_name as departmentName,
     location
  from department
 </select>
</sqlMap>

<!DOCTYPE sqlMap     
    PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"     
    "http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="hr">
 <typeAlias alias="empDTO" type="hr.dto.EmployeeDTO"/>
 <typeAlias alias="deptDTO" type="hr.dto.DepartmentDTO"/>
 <!-- insert -->
 <insert id="insertEmployee" parameterClass="empDTO">
 <!--
  <selectKey resultClass="int" keyProperty="employeeId">
  select aaaa from dual
 </selectKey>
 -->
  insert into employee
  (employee_id,employee_name, email, job_position, salary, department_id)
  values(#employeeId#,#employeeName#,#email#,#jobPosition#,#salary#,#departmentDTO.departmentId#)
 </insert>
 <update id="updateEmployee" parameterClass="empDTO">
  update employee
  set   employee_name=#employeeName#,
      email=#email#,
      job_position=#jobPosition#,
      salary=#salary#,
      department_id=#departmentDTO.departmentId#
  where  employee_id=#employeeId#
 </update>
 <delete id="deleteEmployeeById">
  delete from employee
  where employee_id=#id#
 </delete>
 <resultMap class="empDTO" id="employeeResultMap">
  <result property="employeeId" columnIndex="1"/><!--<result property="employeeId" column="employee_id"/>이렇게 줘도 되고  -->
  <result property="employeeName" columnIndex="2"/>
  <result property="email" columnIndex="3"/>
  <result property="jobPosition" columnIndex="4"/>
  <result property="salary" columnIndex="5"/>
  <result property="departmentDTO.departmentId" columnIndex="6"/>
  <result property="departmentDTO.departmentName" columnIndex="7"/>
  <result property="departmentDTO.location" columnIndex="8"/>
 </resultMap>
 <select id="selectAllEmployee" resultMap="employeeResultMap">
  select emp.employee_id ,
     emp.employee_name,
     emp.email,
     emp.job_position,
     emp.salary,
     dept.department_id,
     dept.department_name,
     dept.location
  from   employee emp, department dept
  where emp.department_id = dept.department_id
 </select>
 
</sqlMap>

<?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>

  <!-- Configure a built-in transaction manager.  If you're using an
       app server, you probably want to use its transaction manager
       and a managed datasource -->
  <settings useStatementNamespaces="true"/><!-- namespace를 사용하겠다. true -->
  <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:@127.0.0.1:1521:XE"/>
      <property name="JDBC.Username" value="scott"/>
      <property name="JDBC.Password" value="tiger"/>
    </dataSource>
  </transactionManager>

  <!-- List the SQL Map XML files. They can be loaded from the
       classpath, as they are here (com.domain.data...) -->
 <!-- <sqlMap resource="config/member.xml"/> -->
<sqlMap resource="hr/config/hr.xml"/>
<sqlMap resource="hr/config/dept.xml"/>
</sqlMapConfig>

package hr.dao;

import hr.dto.EmployeeDTO;

import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;
import java.util.List;

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

public class EmployeeDAO {
 private SqlMapClient sqlMap;
 private static EmployeeDAO instance = new EmployeeDAO();
 private EmployeeDAO(){
  //SqlMapClient객체 생성
  try {
   Reader reader = Resources.getResourceAsReader("hr/config/SqlMapConfig.xml");
   sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
  } catch (IOException e) {
   e.printStackTrace();
  }
 }
 public static EmployeeDAO getInstance(){
  return instance;
 }
 //insert처리 메소드
 public void insertEmployee(EmployeeDTO empDTO) throws SQLException{
  sqlMap.insert("hr.insertEmployee",empDTO);
 }
 //update처리 메소드
 public int updateEmployee(EmployeeDTO empDTO) throws SQLException {
  return sqlMap.update("hr.updateEmployee", empDTO);
 }
 //delete처리 메소드
 public int deleteEmployeeById(String employeeId)throws SQLException{
  return sqlMap.delete("hr.deleteEmployeeById", employeeId);
 }
 //select처리 메소드
 public List selectAllEmployee() throws SQLException{
  return sqlMap.queryForList("hr.selectAllEmployee");//namespace를 사용했기 때문에 hr이 붙는다.
 }
 public List selectAllDepartment() throws SQLException{
  return sqlMap.queryForList("dept.selectAllDepartment");//namespace를 쓸 경우에는 반드시 namespace를 써 넣어야 한다.
 }
}

package hr.dto;

public class DepartmentDTO {

 private String departmentId;
 private String departmentName;
 private String location;
 
 public DepartmentDTO() {}

 public DepartmentDTO(String departmentId, String departmentName,
   String location) {
  this.departmentId = departmentId;
  this.departmentName = departmentName;
  this.location = location;
 }

 public String getDepartmentId() {
  return departmentId;
 }

 public void setDepartmentId(String departmentId) {
  this.departmentId = departmentId;
 }

 public String getDepartmentName() {
  return departmentName;
 }

 public void setDepartmentName(String departmentName) {
  this.departmentName = departmentName;
 }

 public String getLocation() {
  return location;
 }

 public void setLocation(String location) {
  this.location = location;
 }

 @Override
 public String toString() {
  return "DepartmentDTO [departmentId=" + departmentId
    + ", departmentName=" + departmentName + ", location="
    + location + "]";
 }
 
 
}

package hr.dto;

public class EmployeeDTO {
 private String employeeId;
 private String employeeName;
 private String email;
 private String jobPosition;
 private int salary;
 private DepartmentDTO departmentDTO;
 public EmployeeDTO() {}
 public EmployeeDTO(String employeeId, String employeeName, String email,
   String jobPosition, int salary, DepartmentDTO departmentDTO) {
  this.employeeId = employeeId;
  this.employeeName = employeeName;
  this.email = email;
  this.jobPosition = jobPosition;
  this.salary = salary;
  this.departmentDTO = departmentDTO;
 }
 public String getEmployeeId() {
  return employeeId;
 }
 public void setEmployeeId(String employeeId) {
  this.employeeId = employeeId;
 }
 public String getEmployeeName() {
  return employeeName;
 }
 public void setEmployeeName(String employeeName) {
  this.employeeName = employeeName;
 }
 public String getEmail() {
  return email;
 }
 public void setEmail(String email) {
  this.email = email;
 }
 public String getJobPosition() {
  return jobPosition;
 }
 public void setJobPosition(String jobPosition) {
  this.jobPosition = jobPosition;
 }
 public int getSalary() {
  return salary;
 }
 public void setSalary(int salary) {
  this.salary = salary;
 }
 public DepartmentDTO getDepartmentDTO() {
  return departmentDTO;
 }
 public void setDepartmentDTO(DepartmentDTO departmentDTO) {
  this.departmentDTO = departmentDTO;
 }
 @Override
 public String toString() {
  return "EmployeeDTO [employeeId=" + employeeId + ", employeeName="
    + employeeName + ", email=" + email + ", jobPosition="
    + jobPosition + ", salary=" + salary + ", departmentDTO="
    + departmentDTO + "]";
 }
 
 
}

<?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="mdto" type="ibatis.dto.MemberDTO"/>
 <sql id="select">
 select id,
            password,
         name,
         register_number1 as registerNumber1,
         register_number2 as registerNumber2,
         mileage
   from  member
 </sql>
 <!-- insert태그 작성 -->
 <insert id="insertMember" parameterClass="ibatis.dto.MemberDTO">
  insert into member(id, password, name, register_number1, register_number2, mileage) values(#id#,#password#,#name#,#registerNumber1#,#registerNumber2#,#mileage#)
 </insert>
 <!-- select태그 작성 -->
 <select id="selectMemberById" parameterClass="java.lang.String" resultClass="mdto" >
  select id,
           password,
        name,
        register_number1 as registerNumber1,
        register_number2 as registerNumber2,
        mileage
  from  member
  where id=#id#
 </select>
 <!-- 주민번호로 조회 -->
 <select id="selectMemberByRegisterNumber" parameterClass="java.util.HashMap"  resultClass="mdto">
 <include refid="select"/>
  where  register_number1 = #registerNumber1# and register_number2 = #registerNumber2#
 </select>
 <select id="selectAllMember" resultClass="mdto">
  <include refid="select"/>
 </select>
 <select id="selectMemberByMileageRange" parameterClass="hashmap" resultClass="mdto">
  <include refid="select"/>
 <!-- where mileage &gt;= #firstMileage# and mileage &lt;= #endMileage# --><!-- where mileage between #firstMileage# and #endMileage# -->
  <!-- CDATA는 <>를 테크로 읽히지 않게 해준다. -->
  <![CDATA[
  where mileage >= #firstMileage#
  and mileage <= #endMileage#
  ]]>
 </select>

</sqlMap>

<!-- xxxx.insert("insertMember", mdto);  -->
<!-- Object obj = xxx.queryForObject("selectMemberById","abcde"); 추후 MemberDTO로 캐스팅해서 사용 -->

<?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="mdto" type="ibatis.dto.MemberDTO"/>
 <sql id="select">
 select id,
            password,
         name,
         register_number1,
         register_number2 as registerNumber2,
         mileage
   from  member
 </sql>
 <!-- resultMap 설정 -->
 <resultMap id="memberResultMap" class="mdto">
  <result property="id" column="id" />
  <result property="password" columnIndex="2" />
  <result property="name" columnIndex="3" />
  <result property="registerNumber1" column="register_number1" />
  <result property="registerNumber2" column="registerNumber2" />
  <result property="mileage" columnIndex="6" nullValue="0"/>
 </resultMap>
 <!-- insert태그 작성 -->
 <insert id="insertMember" parameterClass="ibatis.dto.MemberDTO">
  insert into member(id, password, name, register_number1, register_number2, mileage) values(#id#,#password#,#name#,#registerNumber1#,#registerNumber2#,#mileage#)
 </insert>
 <!-- select태그 작성 -->
 <select id="selectMemberById" parameterClass="java.lang.String" resultMap="memberResultMap">
  select id,
           password,
        name,
        register_number1,
        register_number2 as registerNumber2,
        mileage
  from  member
  where id=#id#
 </select>
 <!-- 주민번호로 조회 -->
 <select id="selectMemberByRegisterNumber" parameterClass="java.util.HashMap" resultMap="memberResultMap">
 <include refid="select"/>
  where  register_number1 = #registerNumber1# and register_number2 = #registerNumber2#
 </select>
 <select id="selectAllMember" resultMap="memberResultMap">
  <include refid="select"/>
 </select>
 <select id="selectMemberByMileageRange" parameterClass="hashmap" resultMap="memberResultMap">
  <include refid="select"/>
 <!-- where mileage &gt;= #firstMileage# and mileage &lt;= #endMileage# --><!-- where mileage between #firstMileage# and #endMileage# -->
  <!-- CDATA는 <>를 테크로 읽히지 않게 해준다. -->
  <![CDATA[
  where mileage >= #firstMileage#
  and mileage <= #endMileage#
  ]]>
 </select>
 <!-- update -->
 <update id="updateMemberId" parameterClass="mdto">
  update member
  set    password=#password#,
      name=#name#,
         register_number1=#registerNumber1#,
         register_number2=#registerNumber2#,
         mileage=#mileage#
  where id=#id#
 </update>
 <delete id="deleteMemberById" parameterClass="string">
  delete from member
  where id=#id#
 </delete>
</sqlMap>

<!-- xxxx.insert("insertMember", mdto);  -->
<!-- Object obj = xxx.queryForObject("selectMemberById","abcde"); 추후 MemberDTO로 캐스팅해서 사용 -->

<?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>

  <!-- Configure a built-in transaction manager.  If you're using an
       app server, you probably want to use its transaction manager
       and a managed datasource -->
  <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:@127.0.0.1:1521:XE"/>
      <property name="JDBC.Username" value="scott"/>
      <property name="JDBC.Password" value="tiger"/>
    </dataSource>
  </transactionManager>

  <!-- List the SQL Map XML files. They can be loaded from the
       classpath, as they are here (com.domain.data...) -->
 <!-- <sqlMap resource="config/member.xml"/> -->
<sqlMap resource="config/member2.xml"/>
</sqlMapConfig>

package ibatis.dao;

import ibatis.dto.MemberDTO;

import java.io.Reader;
import java.sql.SQLException;
 
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

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

public class MemberDAO {
 //싱글턴 패턴
 private static MemberDAO instance = new MemberDAO();
 private SqlMapClient sqlMap;//sql문 실행 메소드를 가진 객체
 private MemberDAO(){
  try {
   Reader reader = Resources.getResourceAsReader("config/SqlMapConfig.xml");//SqlMapConfig.xml과 연결되어있는 reader를 하나 읽어옴
   sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
   
  } catch (Exception e) {
   e.printStackTrace();
  }
 }
 public static MemberDAO getInstance(){
  return instance;
 }
 //회원데이터 insert메소드
 public void insertMember(MemberDTO mdto) throws SQLException{
  sqlMap.insert("insertMember", mdto);
 }
 //id로 회원 정보 조회
 public MemberDTO selectMemberById(String id) throws SQLException{
  return (MemberDTO)sqlMap.queryForObject("selectMemberById", id);
 }
 //주민번호로 조회
 public MemberDTO selectMemberByRegisterNumber(String rN1, String rN2) throws SQLException{

  HashMap<String, String> map = new HashMap<String, String>();
  map.put("registerNumber1", rN1);
  map.put("registerNumber2", rN2);
  return (MemberDTO)sqlMap.queryForObject("selectMemberByRegisterNumber",map);
 }
 //전체 회원 정보 조회
 public ArrayList<MemberDTO> selectAllMember() throws SQLException{
  return (ArrayList<MemberDTO>)sqlMap.queryForList("selectAllMember");
 }
 public Map selectAllMemberMap() throws SQLException{
  return sqlMap.queryForMap("selectAllMember", null, "id");//selectAllMember는 DB조회 id, null은 파라미터, id(property)가 키 값
 }
 public Map selectAllMemberMap2() throws SQLException{
  return sqlMap.queryForMap("selectAllMember", null, "id","name");//selectAllMember는 DB조회 id, null은 파라미터, id(property)가 키 값 , name(property)가 value
 }
 public List selectMemberByMileageRange(int firstMileage,int endMileage) throws SQLException{
  HashMap<String, Integer> map = new HashMap<String, Integer>();
  map.put("firstMileage", firstMileage);
  map.put("endMileage", endMileage);
  
  return sqlMap.queryForList("selectMemberByMileageRange", map);
 }
 public Map selectMemberByMileageRange2(int firstMileage, int endMileage) throws SQLException {
  HashMap<String, Integer> map = new HashMap<String, Integer>();
  map.put("firstMileage", firstMileage);
  map.put("endMileage", endMileage);
  
  return sqlMap.queryForMap("selectMemberByMileageRange", map,"id","name");
 
 }
 //update 메소드
 public int updateMemberId(MemberDTO mto) throws SQLException {
  return sqlMap.update("updateMemberId",mto);
 }
 //delete메소드
 public int deleteMemberById(String id)throws SQLException{
  return sqlMap.delete("deleteMemberById", id);
 }
}

package ibatis.dto;

public class MemberDTO {
 private String id;
 private String password;
 private String  name;
 private String registerNumber1; //db: register_number1
 private String registerNumber2; //register_number2
 private int mileage;
 //생성자
 public MemberDTO() {
  super();
 }
 public MemberDTO(String id, String password, String name,
   String registerNumber1, String registerNumber2, int mileage) {
  super();
  this.id = id;
  this.password = password;
  this.name = name;
  this.registerNumber1 = registerNumber1;
  this.registerNumber2 = registerNumber2;
  this.mileage = mileage;
 }
 public String getId() {
  return id;
 }
 public void setId(String id) {
  this.id = id;
 }
 public String getPassword() {
  return password;
 }
 public void setPassword(String password) {
  this.password = password;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public String getRegisterNumber1() {
  return registerNumber1;
 }
 public void setRegisterNumber1(String registerNumber1) {
  this.registerNumber1 = registerNumber1;
 }
 public String getRegisterNumber2() {
  return registerNumber2;
 }
 public void setRegisterNumber2(String registerNumber2) {
  this.registerNumber2 = registerNumber2;
 }
 public int getMileage() {
  return mileage;
 }
 public void setMileage(int mileage) {
  this.mileage = mileage;
 }
 @Override
 public String toString() {
  return "MemberDTO [id=" + id + ", password=" + password + ", name="
    + name + ", registerNumber1=" + registerNumber1
    + ", registerNumber2=" + registerNumber2 + ", mileage="
    + mileage + "]";
 }
 @Override
 public int hashCode() {
  final int prime = 31;
  int result = 1;
  result = prime * result + ((id == null) ? 0 : id.hashCode());
  result = prime * result + mileage;
  result = prime * result + ((name == null) ? 0 : name.hashCode());
  result = prime * result
    + ((password == null) ? 0 : password.hashCode());
  result = prime * result
    + ((registerNumber1 == null) ? 0 : registerNumber1.hashCode());
  result = prime * result
    + ((registerNumber2 == null) ? 0 : registerNumber2.hashCode());
  return result;
 }
 @Override
 public boolean equals(Object obj) {
  if (this == obj)
   return true;
  if (obj == null)
   return false;
  if (getClass() != obj.getClass())
   return false;
  MemberDTO other = (MemberDTO) obj;
  if (id == null) {
   if (other.id != null)
    return false;
  } else if (!id.equals(other.id))
   return false;
  if (mileage != other.mileage)
   return false;
  if (name == null) {
   if (other.name != null)
    return false;
  } else if (!name.equals(other.name))
   return false;
  if (password == null) {
   if (other.password != null)
    return false;
  } else if (!password.equals(other.password))
   return false;
  if (registerNumber1 == null) {
   if (other.registerNumber1 != null)
    return false;
  } else if (!registerNumber1.equals(other.registerNumber1))
   return false;
  if (registerNumber2 == null) {
   if (other.registerNumber2 != null)
    return false;
  } else if (!registerNumber2.equals(other.registerNumber2))
   return false;
  return true;
 }
 
}

package ibatis.main;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Set;

import ibatis.dao.MemberDAO;
import ibatis.dto.MemberDTO;

public class TestMember {
 public static void main(String[] args) throws SQLException {
  MemberDTO mdto1 = new MemberDTO("id-66", "1111", "이상운", "111111", "1111111", 10000);
  MemberDTO mdto2 = new MemberDTO("id-55", "2222", "장동건", "222222", "2222222", 20000);
  MemberDTO mdto3 = new MemberDTO("id-77", "3333", "원빈", "333333", "3333333", 30000);
  
  MemberDAO dao = MemberDAO.getInstance();
  
 // dao.insertMember(mdto1);
 // dao.insertMember(mdto2);
 // dao.insertMember(mdto3);
  
 // MemberDTO mdto4 = dao.selectMemberById("id-22");
 // System.out.println(mdto4);
  
  MemberDTO mdto5 = dao.selectMemberByRegisterNumber("545454", "5454545");
  System.out.println("주민번호로 조회 결과 : "+mdto5);
  ArrayList<MemberDTO> mdto6 = dao.selectAllMember();
  System.out.println("--------------전체 회원 목록 조회------------------");
  for(int i=0;i<mdto6.size();i++){
   System.out.println(mdto6.get(i));
  }
//  System.out.println("---------------전체회원목록조회- map----------");
//  Map map = dao.selectAllMemberMap();
//  System.out.println(map);
//  System.out.println("---------------전체회원목록조회- map(id가 id-77인 회원 찾기)----------");
//  Object obj1 = map.get("id-77");
//  System.out.println(obj1);
//  Set set = map.keySet();
//  Iterator itr = set.iterator();
//  if(itr.next()){
//   
//  }
//  System.out.println("---------------전체회원목록조회2- map----------");
//  Map map2 = dao.selectAllMemberMap2();
//  System.out.println(map2);
//  System.out.println("---------------전체회원목록조회2- map(id가 id-77인 회원 이름찾기)----------");
//  Object obj2 = map2.get("id-77");
//  System.out.println(obj2);
  System.out.println("---------------마일리지로 범위로 조회하기(List)----------");
  List list = dao.selectMemberByMileageRange(0, 1000);
  for(Object obj : list){
   System.out.println(obj);
  }
  
  System.out.println("---------------마일리지로 범위로 조회하기(Map)----------");
  Map map4 = dao.selectMemberByMileageRange2(0, 1000);
  Set entryset = map4.entrySet();
  //set을 이용한 key-value 뽑기
  for(Object obj:entryset){
   System.out.println(obj);
  }
  System.out.println("-----------ID로 회원 정보 수정하기(update)------------");
  mdto3.setMileage(40000);
  int cnt = dao.updateMemberId(mdto3);
  System.out.println(cnt+"개의 행이 수정되었습니다.");
  System.out.println(dao.selectMemberById("id-77"));
  System.out.println("-----------ID로 회원 정보 삭제하기(delete)------------");
  cnt = dao.deleteMemberById("id-66");
  System.out.println(cnt+"개의 행이 삭제되었습니다.");
  System.out.println(dao.selectMemberById("id-66"));
  list = dao.selectAllMember();
  for(Object obj:list){
   System.out.println(obj);
  }
  
 }
}

주민번호로 조회 결과 : MemberDTO [id=5454, password=5454, name=5454, registerNumber1=545454, registerNumber2=5454545, mileage=1000]
--------------전체 회원 목록 조회------------------
MemberDTO [id=2244, password=2244, name=홍, registerNumber1=224444, registerNumber2=4444444, mileage=0]
MemberDTO [id=1111, password=1111, name=1111, registerNumber1=111111, registerNumber2=1111111, mileage=1000]
MemberDTO [id=2233, password=2233, name=홍, registerNumber1=2233, registerNumber2=2233, mileage=1000]
MemberDTO [id=1717, password=1717, name=171717, registerNumber1=171717, registerNumber2=1717171, mileage=1000]
MemberDTO [id=5757, password=5757, name=5757, registerNumber1=575757, registerNumber2=5757575, mileage=1000]
MemberDTO [id=6868, password=6868, name=6868, registerNumber1=686868, registerNumber2=6868686, mileage=1000]
MemberDTO [id=7979, password=7979, name=7979, registerNumber1=797979, registerNumber2=7979797, mileage=1000]
MemberDTO [id=3333, password=3333, name=정형돈, registerNumber1=282882, registerNumber2=8327893, mileage=1000]
MemberDTO [id=5436, password=5436, name=5436, registerNumber1=543454, registerNumber2=3453534, mileage=1000]
MemberDTO [id=5454, password=5454, name=5454, registerNumber1=545454, registerNumber2=5454545, mileage=1000]
MemberDTO [id=6565, password=6565, name=홍길동, registerNumber1=111111, registerNumber2=1111122, mileage=1000]
MemberDTO [id=id-33, password=3333, name=원빈, registerNumber1=333333, registerNumber2=3333333, mileage=1000]
MemberDTO [id=2222, password=1111, name=홍길동, registerNumber1=111111, registerNumber2=2222222, mileage=1000]
MemberDTO [id=id-11, password=1111, name=이상운, registerNumber1=111111, registerNumber2=1111111, mileage=1000]
MemberDTO [id=id-22, password=2222, name=장동건, registerNumber1=222222, registerNumber2=2222222, mileage=1000]
MemberDTO [id=id-44, password=1111, name=이상운, registerNumber1=111111, registerNumber2=1111111, mileage=1000]
MemberDTO [id=id-77, password=3333, name=원빈, registerNumber1=333333, registerNumber2=3333333, mileage=40000]
---------------마일리지로 범위로 조회하기(List)----------
MemberDTO [id=1111, password=1111, name=1111, registerNumber1=111111, registerNumber2=1111111, mileage=1000]
MemberDTO [id=2233, password=2233, name=홍, registerNumber1=2233, registerNumber2=2233, mileage=1000]
MemberDTO [id=1717, password=1717, name=171717, registerNumber1=171717, registerNumber2=1717171, mileage=1000]
MemberDTO [id=5757, password=5757, name=5757, registerNumber1=575757, registerNumber2=5757575, mileage=1000]
MemberDTO [id=6868, password=6868, name=6868, registerNumber1=686868, registerNumber2=6868686, mileage=1000]
MemberDTO [id=7979, password=7979, name=7979, registerNumber1=797979, registerNumber2=7979797, mileage=1000]
MemberDTO [id=3333, password=3333, name=정형돈, registerNumber1=282882, registerNumber2=8327893, mileage=1000]
MemberDTO [id=5436, password=5436, name=5436, registerNumber1=543454, registerNumber2=3453534, mileage=1000]
MemberDTO [id=5454, password=5454, name=5454, registerNumber1=545454, registerNumber2=5454545, mileage=1000]
MemberDTO [id=6565, password=6565, name=홍길동, registerNumber1=111111, registerNumber2=1111122, mileage=1000]
MemberDTO [id=id-33, password=3333, name=원빈, registerNumber1=333333, registerNumber2=3333333, mileage=1000]
MemberDTO [id=2222, password=1111, name=홍길동, registerNumber1=111111, registerNumber2=2222222, mileage=1000]
MemberDTO [id=id-11, password=1111, name=이상운, registerNumber1=111111, registerNumber2=1111111, mileage=1000]
MemberDTO [id=id-22, password=2222, name=장동건, registerNumber1=222222, registerNumber2=2222222, mileage=1000]
MemberDTO [id=id-44, password=1111, name=이상운, registerNumber1=111111, registerNumber2=1111111, mileage=1000]
---------------마일리지로 범위로 조회하기(Map)----------
5436=5436
5757=5757
id-44=이상운
1111=1111
id-33=원빈
id-22=장동건
7979=7979
3333=정형돈
id-11=이상운
2233=홍
1717=171717
2222=홍길동
6868=6868
6565=홍길동
5454=5454
-----------ID로 회원 정보 수정하기(update)------------
1개의 행이 수정되었습니다.
MemberDTO [id=id-77, password=3333, name=원빈, registerNumber1=333333, registerNumber2=3333333, mileage=40000]
-----------ID로 회원 정보 삭제하기(delete)------------
0개의 행이 삭제되었습니다.
null
MemberDTO [id=2244, password=2244, name=홍, registerNumber1=224444, registerNumber2=4444444, mileage=0]
MemberDTO [id=1111, password=1111, name=1111, registerNumber1=111111, registerNumber2=1111111, mileage=1000]
MemberDTO [id=2233, password=2233, name=홍, registerNumber1=2233, registerNumber2=2233, mileage=1000]
MemberDTO [id=1717, password=1717, name=171717, registerNumber1=171717, registerNumber2=1717171, mileage=1000]
MemberDTO [id=5757, password=5757, name=5757, registerNumber1=575757, registerNumber2=5757575, mileage=1000]
MemberDTO [id=6868, password=6868, name=6868, registerNumber1=686868, registerNumber2=6868686, mileage=1000]
MemberDTO [id=7979, password=7979, name=7979, registerNumber1=797979, registerNumber2=7979797, mileage=1000]
MemberDTO [id=3333, password=3333, name=정형돈, registerNumber1=282882, registerNumber2=8327893, mileage=1000]
MemberDTO [id=5436, password=5436, name=5436, registerNumber1=543454, registerNumber2=3453534, mileage=1000]
MemberDTO [id=5454, password=5454, name=5454, registerNumber1=545454, registerNumber2=5454545, mileage=1000]
MemberDTO [id=6565, password=6565, name=홍길동, registerNumber1=111111, registerNumber2=1111122, mileage=1000]
MemberDTO [id=id-33, password=3333, name=원빈, registerNumber1=333333, registerNumber2=3333333, mileage=1000]
MemberDTO [id=2222, password=1111, name=홍길동, registerNumber1=111111, registerNumber2=2222222, mileage=1000]
MemberDTO [id=id-11, password=1111, name=이상운, registerNumber1=111111, registerNumber2=1111111, mileage=1000]
MemberDTO [id=id-22, password=2222, name=장동건, registerNumber1=222222, registerNumber2=2222222, mileage=1000]
MemberDTO [id=id-44, password=1111, name=이상운, registerNumber1=111111, registerNumber2=1111111, mileage=1000]
MemberDTO [id=id-77, password=3333, name=원빈, registerNumber1=333333, registerNumber2=3333333, mileage=40000]

<?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="mdto" type="ibatis.dto.MemberDTO"/>
 <sql id="select">
 select id,
            password,
         name,
         register_number1 as registerNumber1,
         register_number2 as registerNumber2,
         mileage
   from  member
 </sql>
 <!-- insert태그 작성 -->
 <insert id="insertMember" parameterClass="ibatis.dto.MemberDTO">
  insert into member(id, password, name, register_number1, register_number2, mileage) values(#id#,#password#,#name#,#registerNumber1#,#registerNumber2#,#mileage#)
 </insert>
 <!-- select태그 작성 -->
 <select id="selectMemberById" parameterClass="java.lang.String" resultClass="mdto" >
  select id,
           password,
        name,
        register_number1 as registerNumber1,
        register_number2 as registerNumber2,
        mileage
  from  member
  where id=#id#
 </select>
 <!-- 주민번호로 조회 -->
 <select id="selectMemberByRegisterNumber" parameterClass="java.util.HashMap"  resultClass="mdto">
 <include refid="select"/>
  where  register_number1 = #registerNumber1# and register_number2 = #registerNumber2#
 </select>
 <select id="selectAllMember" resultClass="mdto">
  <include refid="select"/>
 </select>
 <select id="selectMemberByMileageRange" parameterClass="hashmap" resultClass="mdto">
  <include refid="select"/>
 <!-- where mileage &gt;= #firstMileage# and mileage &lt;= #endMileage# --><!-- where mileage between #firstMileage# and #endMileage# -->
  <!-- CDATA는 <>를 테크로 읽히지 않게 해준다. -->
  <![CDATA[
  where mileage >= #firstMileage#
  and mileage <= #endMileage#
  ]]>
 </select>
</sqlMap>

<!-- xxxx.insert("insertMember", mdto);  -->
<!-- Object obj = xxx.queryForObject("selectMemberById","abcde"); 추후 MemberDTO로 캐스팅해서 사용 -->

<?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="mdto" type="ibatis.dto.MemberDTO"/>
 <sql id="select">
 select id,
            password,
         name,
         register_number1,
         register_number2 as registerNumber2,
         mileage
   from  member
 </sql>
 <!-- resultMap 설정 -->
 <resultMap id="memberResultMap" class="mdto">
  <result property="id" column="id" />
  <result property="password" columnIndex="2" />
  <result property="name" columnIndex="3" />
  <result property="registerNumber1" column="register_number1" />
  <result property="registerNumber2" column="registerNumber2" />
  <result property="mileage" columnIndex="6" nullValue="0"/>
 </resultMap>
 <!-- insert태그 작성 -->
 <insert id="insertMember" parameterClass="ibatis.dto.MemberDTO">
  insert into member(id, password, name, register_number1, register_number2, mileage) values(#id#,#password#,#name#,#registerNumber1#,#registerNumber2#,#mileage#)
 </insert>
 <!-- select태그 작성 -->
 <select id="selectMemberById" parameterClass="java.lang.String" resultMap="memberResultMap">
  select id,
           password,
        name,
        register_number1 as registerNumber1,
        register_number2 as registerNumber2,
        mileage
  from  member
  where id=#id#
 </select>
 <!-- 주민번호로 조회 -->
 <select id="selectMemberByRegisterNumber" parameterClass="java.util.HashMap" resultMap="memberResultMap">
 <include refid="select"/>
  where  register_number1 = #registerNumber1# and register_number2 = #registerNumber2#
 </select>
 <select id="selectAllMember" resultMap="memberResultMap">
  <include refid="select"/>
 </select>
 <select id="selectMemberByMileageRange" parameterClass="hashmap" resultMap="memberResultMap">
  <include refid="select"/>
 <!-- where mileage &gt;= #firstMileage# and mileage &lt;= #endMileage# --><!-- where mileage between #firstMileage# and #endMileage# -->
  <!-- CDATA는 <>를 테크로 읽히지 않게 해준다. -->
  <![CDATA[
  where mileage >= #firstMileage#
  and mileage <= #endMileage#
  ]]>
 </select>
</sqlMap>

<!-- xxxx.insert("insertMember", mdto);  -->
<!-- Object obj = xxx.queryForObject("selectMemberById","abcde"); 추후 MemberDTO로 캐스팅해서 사용 -->

<?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>

  <!-- Configure a built-in transaction manager.  If you're using an
       app server, you probably want to use its transaction manager
       and a managed datasource -->
  <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:@127.0.0.1:1521:XE"/>
      <property name="JDBC.Username" value="scott"/>
      <property name="JDBC.Password" value="tiger"/>
    </dataSource>
  </transactionManager>

  <!-- List the SQL Map XML files. They can be loaded from the
       classpath, as they are here (com.domain.data...) -->
 <!-- <sqlMap resource="config/member.xml"/> -->
<sqlMap resource="config/member2.xml"/>
</sqlMapConfig>

package ibatis.dao;

import ibatis.dto.MemberDTO;

import java.io.Reader;
import java.sql.SQLException;
 
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

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

public class MemberDAO {
 //싱글턴 패턴
 private static MemberDAO instance = new MemberDAO();
 private SqlMapClient sqlMap;//sql문 실행 메소드를 가진 객체
 private MemberDAO(){
  try {
   Reader reader = Resources.getResourceAsReader("config/SqlMapConfig.xml");//SqlMapConfig.xml과 연결되어있는 reader를 하나 읽어옴
   sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
   
  } catch (Exception e) {
   e.printStackTrace();
  }
 }
 public static MemberDAO getInstance(){
  return instance;
 }
 //회원데이터 insert메소드
 public void insertMember(MemberDTO mdto) throws SQLException{
  sqlMap.insert("insertMember", mdto);
 }
 //id로 회원 정보 조회
 public MemberDTO selectMemberById(String id) throws SQLException{
  return (MemberDTO)sqlMap.queryForObject("selectMemberById", id);
 }
 //주민번호로 조회
 public MemberDTO selectMemberByRegisterNumber(String rN1, String rN2) throws SQLException{

  HashMap<String, String> map = new HashMap<String, String>();
  map.put("registerNumber1", rN1);
  map.put("registerNumber2", rN2);
  return (MemberDTO)sqlMap.queryForObject("selectMemberByRegisterNumber",map);
 }
 //전체 회원 정보 조회
 public ArrayList<MemberDTO> selectAllMember() throws SQLException{
  return (ArrayList<MemberDTO>)sqlMap.queryForList("selectAllMember");
 }
 public Map selectAllMemberMap() throws SQLException{
  return sqlMap.queryForMap("selectAllMember", null, "id");//selectAllMember는 DB조회 id, null은 파라미터, id(property)가 키 값
 }
 public Map selectAllMemberMap2() throws SQLException{
  return sqlMap.queryForMap("selectAllMember", null, "id","name");//selectAllMember는 DB조회 id, null은 파라미터, id(property)가 키 값 , name(property)가 value
 }
 public List selectMemberByMileageRange(int firstMileage,int endMileage) throws SQLException{
  HashMap<String, Integer> map = new HashMap<String, Integer>();
  map.put("firstMileage", firstMileage);
  map.put("endMileage", endMileage);
  
  return sqlMap.queryForList("selectMemberByMileageRange", map);
 }
 public Map selectMemberByMileageRange2(int firstMileage, int endMileage) throws SQLException {
  HashMap<String, Integer> map = new HashMap<String, Integer>();
  map.put("firstMileage", firstMileage);
  map.put("endMileage", endMileage);
  
  return sqlMap.queryForMap("selectMemberByMileageRange", map,"id","name");
 
 }
 
}

package ibatis.dto;

public class MemberDTO {
 private String id;
 private String password;
 private String  name;
 private String registerNumber1; //db: register_number1
 private String registerNumber2; //register_number2
 private int mileage;
 //생성자
 public MemberDTO() {
  super();
 }
 public MemberDTO(String id, String password, String name,
   String registerNumber1, String registerNumber2, int mileage) {
  super();
  this.id = id;
  this.password = password;
  this.name = name;
  this.registerNumber1 = registerNumber1;
  this.registerNumber2 = registerNumber2;
  this.mileage = mileage;
 }
 public String getId() {
  return id;
 }
 public void setId(String id) {
  this.id = id;
 }
 public String getPassword() {
  return password;
 }
 public void setPassword(String password) {
  this.password = password;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public String getRegisterNumber1() {
  return registerNumber1;
 }
 public void setRegisterNumber1(String registerNumber1) {
  this.registerNumber1 = registerNumber1;
 }
 public String getRegisterNumber2() {
  return registerNumber2;
 }
 public void setRegisterNumber2(String registerNumber2) {
  this.registerNumber2 = registerNumber2;
 }
 public int getMileage() {
  return mileage;
 }
 public void setMileage(int mileage) {
  this.mileage = mileage;
 }
 @Override
 public String toString() {
  return "MemberDTO [id=" + id + ", password=" + password + ", name="
    + name + ", registerNumber1=" + registerNumber1
    + ", registerNumber2=" + registerNumber2 + ", mileage="
    + mileage + "]";
 }
 @Override
 public int hashCode() {
  final int prime = 31;
  int result = 1;
  result = prime * result + ((id == null) ? 0 : id.hashCode());
  result = prime * result + mileage;
  result = prime * result + ((name == null) ? 0 : name.hashCode());
  result = prime * result
    + ((password == null) ? 0 : password.hashCode());
  result = prime * result
    + ((registerNumber1 == null) ? 0 : registerNumber1.hashCode());
  result = prime * result
    + ((registerNumber2 == null) ? 0 : registerNumber2.hashCode());
  return result;
 }
 @Override
 public boolean equals(Object obj) {
  if (this == obj)
   return true;
  if (obj == null)
   return false;
  if (getClass() != obj.getClass())
   return false;
  MemberDTO other = (MemberDTO) obj;
  if (id == null) {
   if (other.id != null)
    return false;
  } else if (!id.equals(other.id))
   return false;
  if (mileage != other.mileage)
   return false;
  if (name == null) {
   if (other.name != null)
    return false;
  } else if (!name.equals(other.name))
   return false;
  if (password == null) {
   if (other.password != null)
    return false;
  } else if (!password.equals(other.password))
   return false;
  if (registerNumber1 == null) {
   if (other.registerNumber1 != null)
    return false;
  } else if (!registerNumber1.equals(other.registerNumber1))
   return false;
  if (registerNumber2 == null) {
   if (other.registerNumber2 != null)
    return false;
  } else if (!registerNumber2.equals(other.registerNumber2))
   return false;
  return true;
 }
 
}

package ibatis.main;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Set;

import ibatis.dao.MemberDAO;
import ibatis.dto.MemberDTO;

public class TestMember {
 public static void main(String[] args) throws SQLException {
  MemberDTO mdto1 = new MemberDTO("id-66", "1111", "이상운", "111111", "1111111", 10000);
  MemberDTO mdto2 = new MemberDTO("id-55", "2222", "장동건", "222222", "2222222", 20000);
  MemberDTO mdto3 = new MemberDTO("id-77", "3333", "원빈", "333333", "3333333", 30000);
  
  MemberDAO dao = MemberDAO.getInstance();
  
 // dao.insertMember(mdto1);
 // dao.insertMember(mdto2);
 // dao.insertMember(mdto3);
  
 // MemberDTO mdto4 = dao.selectMemberById("id-22");
 // System.out.println(mdto4);
  
  MemberDTO mdto5 = dao.selectMemberByRegisterNumber("545454", "5454545");
  System.out.println("주민번호로 조회 결과 : "+mdto5);
  ArrayList<MemberDTO> mdto6 = dao.selectAllMember();
  System.out.println("--------------전체 회원 목록 조회------------------");
  for(int i=0;i<mdto6.size();i++){
   System.out.println(mdto6.get(i));
  }
//  System.out.println("---------------전체회원목록조회- map----------");
//  Map map = dao.selectAllMemberMap();
//  System.out.println(map);
//  System.out.println("---------------전체회원목록조회- map(id가 id-77인 회원 찾기)----------");
//  Object obj = map.get("id-77");
//  System.out.println(obj);
//  Set set = map.keySet();
//  Iterator itr = set.iterator();
//  if(itr.next()){
//   
//  }
//  System.out.println("---------------전체회원목록조회2- map----------");
//  Map map2 = dao.selectAllMemberMap2();
//  System.out.println(map2);
//  System.out.println("---------------전체회원목록조회2- map(id가 id-77인 회원 이름찾기)----------");
//  Object obj2 = map2.get("id-77");
//  System.out.println(obj2);
  System.out.println("---------------마일리지로 범위로 조회하기(List)----------");
  List list = dao.selectMemberByMileageRange(0, 1000);
  for(Object obj1 : list){
   System.out.println(obj1);
  }
  
  System.out.println("---------------마일리지로 범위로 조회하기(Map)----------");
  Map map4 = dao.selectMemberByMileageRange2(0, 1000);
  Set entryset = map4.entrySet();
  //set을 이용한 key-value 뽑기
  for(Object obj3:entryset){
   System.out.println(obj3);
  }

 }
}

주민번호로 조회 결과 : MemberDTO [id=5454, password=5454, name=5454, registerNumber1=545454, registerNumber2=5454545, mileage=1000]
--------------전체 회원 목록 조회------------------
MemberDTO [id=2244, password=2244, name=홍, registerNumber1=224444, registerNumber2=4444444, mileage=0]
MemberDTO [id=1111, password=1111, name=1111, registerNumber1=111111, registerNumber2=1111111, mileage=1000]
MemberDTO [id=2233, password=2233, name=홍, registerNumber1=2233, registerNumber2=2233, mileage=1000]
MemberDTO [id=1717, password=1717, name=171717, registerNumber1=171717, registerNumber2=1717171, mileage=1000]
MemberDTO [id=5757, password=5757, name=5757, registerNumber1=575757, registerNumber2=5757575, mileage=1000]
MemberDTO [id=6868, password=6868, name=6868, registerNumber1=686868, registerNumber2=6868686, mileage=1000]
MemberDTO [id=7979, password=7979, name=7979, registerNumber1=797979, registerNumber2=7979797, mileage=1000]
MemberDTO [id=3333, password=3333, name=정형돈, registerNumber1=282882, registerNumber2=8327893, mileage=1000]
MemberDTO [id=5436, password=5436, name=5436, registerNumber1=543454, registerNumber2=3453534, mileage=1000]
MemberDTO [id=5454, password=5454, name=5454, registerNumber1=545454, registerNumber2=5454545, mileage=1000]
MemberDTO [id=6565, password=6565, name=홍길동, registerNumber1=111111, registerNumber2=1111122, mileage=1000]
MemberDTO [id=id-33, password=3333, name=원빈, registerNumber1=333333, registerNumber2=3333333, mileage=1000]
MemberDTO [id=2222, password=1111, name=홍길동, registerNumber1=111111, registerNumber2=2222222, mileage=1000]
MemberDTO [id=id-11, password=1111, name=이상운, registerNumber1=111111, registerNumber2=1111111, mileage=1000]
MemberDTO [id=id-22, password=2222, name=장동건, registerNumber1=222222, registerNumber2=2222222, mileage=1000]
MemberDTO [id=id-44, password=1111, name=이상운, registerNumber1=111111, registerNumber2=1111111, mileage=1000]
MemberDTO [id=id-66, password=1111, name=이상운, registerNumber1=111111, registerNumber2=1111111, mileage=1000]
MemberDTO [id=id-55, password=2222, name=장동건, registerNumber1=222222, registerNumber2=2222222, mileage=1000]
MemberDTO [id=id-77, password=3333, name=원빈, registerNumber1=333333, registerNumber2=3333333, mileage=1000]
---------------마일리지로 범위로 조회하기(List)----------
MemberDTO [id=1111, password=1111, name=1111, registerNumber1=111111, registerNumber2=1111111, mileage=1000]
MemberDTO [id=2233, password=2233, name=홍, registerNumber1=2233, registerNumber2=2233, mileage=1000]
MemberDTO [id=1717, password=1717, name=171717, registerNumber1=171717, registerNumber2=1717171, mileage=1000]
MemberDTO [id=5757, password=5757, name=5757, registerNumber1=575757, registerNumber2=5757575, mileage=1000]
MemberDTO [id=6868, password=6868, name=6868, registerNumber1=686868, registerNumber2=6868686, mileage=1000]
MemberDTO [id=7979, password=7979, name=7979, registerNumber1=797979, registerNumber2=7979797, mileage=1000]
MemberDTO [id=3333, password=3333, name=정형돈, registerNumber1=282882, registerNumber2=8327893, mileage=1000]
MemberDTO [id=5436, password=5436, name=5436, registerNumber1=543454, registerNumber2=3453534, mileage=1000]
MemberDTO [id=5454, password=5454, name=5454, registerNumber1=545454, registerNumber2=5454545, mileage=1000]
MemberDTO [id=6565, password=6565, name=홍길동, registerNumber1=111111, registerNumber2=1111122, mileage=1000]
MemberDTO [id=id-33, password=3333, name=원빈, registerNumber1=333333, registerNumber2=3333333, mileage=1000]
MemberDTO [id=2222, password=1111, name=홍길동, registerNumber1=111111, registerNumber2=2222222, mileage=1000]
MemberDTO [id=id-11, password=1111, name=이상운, registerNumber1=111111, registerNumber2=1111111, mileage=1000]
MemberDTO [id=id-22, password=2222, name=장동건, registerNumber1=222222, registerNumber2=2222222, mileage=1000]
MemberDTO [id=id-44, password=1111, name=이상운, registerNumber1=111111, registerNumber2=1111111, mileage=1000]
MemberDTO [id=id-66, password=1111, name=이상운, registerNumber1=111111, registerNumber2=1111111, mileage=1000]
MemberDTO [id=id-55, password=2222, name=장동건, registerNumber1=222222, registerNumber2=2222222, mileage=1000]
MemberDTO [id=id-77, password=3333, name=원빈, registerNumber1=333333, registerNumber2=3333333, mileage=1000]
---------------마일리지로 범위로 조회하기(Map)----------
5436=5436
id-77=원빈
id-66=이상운
5757=5757
id-55=장동건
id-44=이상운
1111=1111
id-33=원빈
id-22=장동건
7979=7979
3333=정형돈
id-11=이상운
2233=홍
1717=171717
2222=홍길동
6868=6868
6565=홍길동
5454=5454

<?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="mdto" type="ibatis.dto.MemberDTO"/>
 <sql id="select">
 select id,
            password,
         name,
         register_number1 as registerNumber1,
         register_number2 as registerNumber2,
         mileage
   from  member
 </sql>
 <!-- insert태그 작성 -->
 <insert id="insertMember" parameterClass="ibatis.dto.MemberDTO">
  insert into member(id, password, name, register_number1, register_number2, mileage) values(#id#,#password#,#name#,#registerNumber1#,#registerNumber2#,#mileage#)
 </insert>
 <!-- select태그 작성 -->
 <select id="selectMemberById" parameterClass="java.lang.String" resultClass="mdto" >
  select id,
           password,
        name,
        register_number1 as registerNumber1,
        register_number2 as registerNumber2,
        mileage
  from  member
  where id=#id#
 </select>
 <!-- 주민번호로 조회 -->
 <select id="selectMemberByRegisterNumber" parameterClass="java.util.HashMap"  resultClass="mdto">
 <include refid="select"/>
  where  register_number1 = #registerNumber1# and register_number2 = #registerNumber2#
 </select>
 <select id="selectAllMember" resultClass="mdto">
  <include refid="select"/>
 </select>
</sqlMap>

<!-- xxxx.insert("insertMember", mdto);  -->
<!-- Object obj = xxx.queryForObject("selectMemberById","abcde"); 추후 MemberDTO로 캐스팅해서 사용 -->

<?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>

  <!-- Configure a built-in transaction manager.  If you're using an
       app server, you probably want to use its transaction manager
       and a managed datasource -->
  <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:@127.0.0.1:1521:XE"/>
      <property name="JDBC.Username" value="scott"/>
      <property name="JDBC.Password" value="tiger"/>
    </dataSource>
  </transactionManager>

  <!-- List the SQL Map XML files. They can be loaded from the
       classpath, as they are here (com.domain.data...) -->
  <sqlMap resource="config/member.xml"/>

</sqlMapConfig>

package ibatis.dao;

import ibatis.dto.MemberDTO;

import java.io.Reader;
import java.sql.SQLException;
 
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Map;

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

public class MemberDAO {
 //싱글턴 패턴
 private static MemberDAO instance = new MemberDAO();
 private SqlMapClient sqlMap;//sql문 실행 메소드를 가진 객체
 private MemberDAO(){
  try {
   Reader reader = Resources.getResourceAsReader("config/SqlMapConfig.xml");//SqlMapConfig.xml과 연결되어있는 reader를 하나 읽어옴
   sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
   
  } catch (Exception e) {
   e.printStackTrace();
  }
 }
 public static MemberDAO getInstance(){
  return instance;
 }
 //회원데이터 insert메소드
 public void insertMember(MemberDTO mdto) throws SQLException{
  sqlMap.insert("insertMember", mdto);
 }
 //id로 회원 정보 조회
 public MemberDTO selectMemberById(String id) throws SQLException{
  return (MemberDTO)sqlMap.queryForObject("selectMemberById", id);
 }
 //주민번호로 조회
 public MemberDTO selectMemberByRegisterNumber(String rN1, String rN2) throws SQLException{

  HashMap<String, String> map = new HashMap<String, String>();
  map.put("registerNumber1", rN1);
  map.put("registerNumber2", rN2);
  return (MemberDTO)sqlMap.queryForObject("selectMemberByRegisterNumber",map);
 }
 //전체 회원 정보 조회
 public ArrayList<MemberDTO> selectAllMember() throws SQLException{
  return (ArrayList<MemberDTO>)sqlMap.queryForList("selectAllMember");
 }
 public Map selectAllMemberMap() throws SQLException{
  return sqlMap.queryForMap("selectAllMember", null, "id");//selectAllMember는 DB조회 id, null은 파라미터, id(property)가 키 값
 }
 public Map selectAllMemberMap2() throws SQLException{
  return sqlMap.queryForMap("selectAllMember", null, "id","name");//selectAllMember는 DB조회 id, null은 파라미터, id(property)가 키 값 , name(property)가 value
 }
}

package ibatis.dto;

public class MemberDTO {
 private String id;
 private String password;
 private String  name;
 private String registerNumber1; //db: register_number1
 private String registerNumber2; //register_number2
 private int mileage;
 //생성자
 public MemberDTO() {
  super();
 }
 public MemberDTO(String id, String password, String name,
   String registerNumber1, String registerNumber2, int mileage) {
  super();
  this.id = id;
  this.password = password;
  this.name = name;
  this.registerNumber1 = registerNumber1;
  this.registerNumber2 = registerNumber2;
  this.mileage = mileage;
 }
 public String getId() {
  return id;
 }
 public void setId(String id) {
  this.id = id;
 }
 public String getPassword() {
  return password;
 }
 public void setPassword(String password) {
  this.password = password;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public String getRegisterNumber1() {
  return registerNumber1;
 }
 public void setRegisterNumber1(String registerNumber1) {
  this.registerNumber1 = registerNumber1;
 }
 public String getRegisterNumber2() {
  return registerNumber2;
 }
 public void setRegisterNumber2(String registerNumber2) {
  this.registerNumber2 = registerNumber2;
 }
 public int getMileage() {
  return mileage;
 }
 public void setMileage(int mileage) {
  this.mileage = mileage;
 }
 @Override
 public String toString() {
  return "MemberDTO [id=" + id + ", password=" + password + ", name="
    + name + ", registerNumber1=" + registerNumber1
    + ", registerNumber2=" + registerNumber2 + ", mileage="
    + mileage + "]";
 }
 @Override
 public int hashCode() {
  final int prime = 31;
  int result = 1;
  result = prime * result + ((id == null) ? 0 : id.hashCode());
  result = prime * result + mileage;
  result = prime * result + ((name == null) ? 0 : name.hashCode());
  result = prime * result
    + ((password == null) ? 0 : password.hashCode());
  result = prime * result
    + ((registerNumber1 == null) ? 0 : registerNumber1.hashCode());
  result = prime * result
    + ((registerNumber2 == null) ? 0 : registerNumber2.hashCode());
  return result;
 }
 @Override
 public boolean equals(Object obj) {
  if (this == obj)
   return true;
  if (obj == null)
   return false;
  if (getClass() != obj.getClass())
   return false;
  MemberDTO other = (MemberDTO) obj;
  if (id == null) {
   if (other.id != null)
    return false;
  } else if (!id.equals(other.id))
   return false;
  if (mileage != other.mileage)
   return false;
  if (name == null) {
   if (other.name != null)
    return false;
  } else if (!name.equals(other.name))
   return false;
  if (password == null) {
   if (other.password != null)
    return false;
  } else if (!password.equals(other.password))
   return false;
  if (registerNumber1 == null) {
   if (other.registerNumber1 != null)
    return false;
  } else if (!registerNumber1.equals(other.registerNumber1))
   return false;
  if (registerNumber2 == null) {
   if (other.registerNumber2 != null)
    return false;
  } else if (!registerNumber2.equals(other.registerNumber2))
   return false;
  return true;
 }
 
}

package ibatis.main;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.Map;
import java.util.Set;

import ibatis.dao.MemberDAO;
import ibatis.dto.MemberDTO;

public class TestMember {
 public static void main(String[] args) throws SQLException {
  MemberDTO mdto1 = new MemberDTO("id-66", "1111", "이상운", "111111", "1111111", 10000);
  MemberDTO mdto2 = new MemberDTO("id-55", "2222", "장동건", "222222", "2222222", 20000);
  MemberDTO mdto3 = new MemberDTO("id-77", "3333", "원빈", "333333", "3333333", 30000);
  
  MemberDAO dao = MemberDAO.getInstance();
  
 // dao.insertMember(mdto1);
 // dao.insertMember(mdto2);
 // dao.insertMember(mdto3);
  
 // MemberDTO mdto4 = dao.selectMemberById("id-22");
 // System.out.println(mdto4);
  
  MemberDTO mdto5 = dao.selectMemberByRegisterNumber("545454", "5454545");
  System.out.println("주민번호로 조회 결과 : "+mdto5);
  ArrayList<MemberDTO> mdto6 = dao.selectAllMember();
  System.out.println("--------------전체 회원 목록 조회------------------");
  for(int i=0;i<mdto6.size();i++){
   System.out.println(mdto6.get(i));
  }
  System.out.println("---------------전체회원목록조회- map----------");
  Map map = dao.selectAllMemberMap();
  System.out.println(map);
  System.out.println("---------------전체회원목록조회- map(id가 id-77인 회원 찾기)----------");
  Object obj = map.get("id-77");
  System.out.println(obj);
//  Set set = map.keySet();
//  Iterator itr = set.iterator();
//  if(itr.next()){
//   
//  }
  System.out.println("---------------전체회원목록조회2- map----------");
  Map map2 = dao.selectAllMemberMap2();
  System.out.println(map2);
  System.out.println("---------------전체회원목록조회2- map(id가 id-77인 회원 이름찾기)----------");
  Object obj2 = map2.get("id-77");
  System.out.println(obj2);
 }
}

<?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>
 <!-- insert태그 작성 -->
 <insert id="insertMember" parameterClass="ibatis.dto.MemberDTO">
  insert into member(id, password, name, register_number1, register_number2, mileage) values(#id#,#password#,#name#,#registerNumber1#,#registerNumber2#,#mileage#)
 </insert>
 <!-- select태그 작성 -->
 <select id="selectMemberById" parameterClass="java.lang.String" resultClass="ibatis.dto.MemberDTO">
  select id,
           password,
        name,
        register_number1 as registerNumber1,
        register_number2 as registerNumber2,
        mileage
  from  member
  where id=#id#
 </select>
</sqlMap>

<!-- xxxx.insert("insertMember", mdto);  -->
<!-- Object obj = xxx.queryForObject("selectMemberById","abcde"); 추후 MemberDTO로 캐스팅해서 사용 -->

<?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>

  <!-- Configure a built-in transaction manager.  If you're using an
       app server, you probably want to use its transaction manager
       and a managed datasource -->
  <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:@127.0.0.1:1521:XE"/>
      <property name="JDBC.Username" value="scott"/>
      <property name="JDBC.Password" value="tiger"/>
    </dataSource>
  </transactionManager>

  <!-- List the SQL Map XML files. They can be loaded from the
       classpath, as they are here (com.domain.data...) -->
  <sqlMap resource="config/member.xml"/>

</sqlMapConfig>

package ibatis.dao;

import ibatis.dto.MemberDTO;

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 MemberDAO {
 //싱글턴 패턴
 private static MemberDAO instance = new MemberDAO();
 private SqlMapClient sqlMap;//sql문 실행 메소드를 가진 객체
 private MemberDAO(){
  try {
   Reader reader = Resources.getResourceAsReader("config/SqlMapConfig.xml");//SqlMapConfig.xml과 연결되어있는 reader를 하나 읽어옴
   sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
   
  } catch (Exception e) {
   e.printStackTrace();
  }
 }
 public static MemberDAO getInstance(){
  return instance;
 }
 //회원데이터 insert메소드
 public void insertMember(MemberDTO mdto) throws SQLException{
  sqlMap.insert("insertMember", mdto);
 }
 //id로 회원 정보 조회
 public MemberDTO selectMemberById(String id) throws SQLException{
  return (MemberDTO)sqlMap.queryForObject("selectMemberById", id);
 }
}

package ibatis.dto;

public class MemberDTO {
 private String id;
 private String password;
 private String  name;
 private String registerNumber1; //db: register_number1
 private String registerNumber2; //register_number2
 private int mileage;
 //생성자
 public MemberDTO() {
  super();
 }
 public MemberDTO(String id, String password, String name,
   String registerNumber1, String registerNumber2, int mileage) {
  super();
  this.id = id;
  this.password = password;
  this.name = name;
  this.registerNumber1 = registerNumber1;
  this.registerNumber2 = registerNumber2;
  this.mileage = mileage;
 }
 public String getId() {
  return id;
 }
 public void setId(String id) {
  this.id = id;
 }
 public String getPassword() {
  return password;
 }
 public void setPassword(String password) {
  this.password = password;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public String getRegisterNumber1() {
  return registerNumber1;
 }
 public void setRegisterNumber1(String registerNumber1) {
  this.registerNumber1 = registerNumber1;
 }
 public String getRegisterNumber2() {
  return registerNumber2;
 }
 public void setRegisterNumber2(String registerNumber2) {
  this.registerNumber2 = registerNumber2;
 }
 public int getMileage() {
  return mileage;
 }
 public void setMileage(int mileage) {
  this.mileage = mileage;
 }
 @Override
 public String toString() {
  return "MemberDTO [id=" + id + ", password=" + password + ", name="
    + name + ", registerNumber1=" + registerNumber1
    + ", registerNumber2=" + registerNumber2 + ", mileage="
    + mileage + "]";
 }
 @Override
 public int hashCode() {
  final int prime = 31;
  int result = 1;
  result = prime * result + ((id == null) ? 0 : id.hashCode());
  result = prime * result + mileage;
  result = prime * result + ((name == null) ? 0 : name.hashCode());
  result = prime * result
    + ((password == null) ? 0 : password.hashCode());
  result = prime * result
    + ((registerNumber1 == null) ? 0 : registerNumber1.hashCode());
  result = prime * result
    + ((registerNumber2 == null) ? 0 : registerNumber2.hashCode());
  return result;
 }
 @Override
 public boolean equals(Object obj) {
  if (this == obj)
   return true;
  if (obj == null)
   return false;
  if (getClass() != obj.getClass())
   return false;
  MemberDTO other = (MemberDTO) obj;
  if (id == null) {
   if (other.id != null)
    return false;
  } else if (!id.equals(other.id))
   return false;
  if (mileage != other.mileage)
   return false;
  if (name == null) {
   if (other.name != null)
    return false;
  } else if (!name.equals(other.name))
   return false;
  if (password == null) {
   if (other.password != null)
    return false;
  } else if (!password.equals(other.password))
   return false;
  if (registerNumber1 == null) {
   if (other.registerNumber1 != null)
    return false;
  } else if (!registerNumber1.equals(other.registerNumber1))
   return false;
  if (registerNumber2 == null) {
   if (other.registerNumber2 != null)
    return false;
  } else if (!registerNumber2.equals(other.registerNumber2))
   return false;
  return true;
 }
 
}

package ibatis.main;

import java.sql.SQLException;

import ibatis.dao.MemberDAO;
import ibatis.dto.MemberDTO;

public class TestMember {
 public static void main(String[] args) throws SQLException {
  MemberDTO mdto1 = new MemberDTO("id-66", "1111", "이상운", "111111", "1111111", 10000);
  MemberDTO mdto2 = new MemberDTO("id-55", "2222", "장동건", "222222", "2222222", 20000);
  MemberDTO mdto3 = new MemberDTO("id-77", "3333", "원빈", "333333", "3333333", 30000);
  
  MemberDAO dao = MemberDAO.getInstance();
  
  dao.insertMember(mdto1);
  dao.insertMember(mdto2);
  dao.insertMember(mdto3);
  
  MemberDTO mdto4 = dao.selectMemberById("id-22");
  System.out.println(mdto4);
 
  
  
 }
}