은성이의 프로그램X파일

<?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="ddto" type="dept.dto.DepartmentDTO"/>
<parameterMap class="ddto" id="insertPM">
 <parameter property="departmentId"/>
 <parameter property="departmentName"/>
 <parameter property="location"/>
</parameterMap>
<sql id="select">
 select department_id as departmentId,
    department_name as departmentName,
    location
 from department
</sql>
<insert id="insertDepartment" parameterMap="insertPM">
 insert into department (department_id, department_name, location) values(?,?,?)
</insert>
<update id="updateDepartment" parameterClass="ddto">
 update department set department_name=#departmentName#, location=#location# where department_id=#departmentId#
</update>
<delete id="deleteDepartment" parameterClass="string">
 delete from department
 where department_id=#departmentId#
</delete>
<select id="selectDepartmentById" parameterClass="string" resultClass="ddto">
<include refid="select"/>
 where department_id=#departmentId#
</select>
<select id="selectAllDepartment"  resultClass="ddto">
 <include refid="select"/>
 order by department_id asc
</select>
</sqlMap>

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">
 <!-- BasicDataSource 생성 -->
 <bean name="datasource" class="org.apache.tomcat.dbcp.dbcp.BasicDataSource">
  <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
  <property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:XE"/>
  <property name="username" value="scott"/>
  <property name="password" value="tiger"/>
 </bean>
 <!-- SqlMapClient 생성 -->
 <bean name="sqlMapclient" class="org.springframework.orm.ibatis.SqlMapClientTemplate">
  <property name="sqlMapClient" ref="sqlMapClientFactoryBean"/>
 </bean>
 <!-- SqlMapClientTemplate 생성 -->
 <bean name="sqlMapClientFactoryBean" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
  <property name="configLocation" value="dept/config/SqlMapConfig.xml"/>
  <property name="dataSource" ref="datasource"/>
 </bean>
 <!-- DepartmentDAO 생성 -->
  <bean name="departmentDAO" class="dept.dao.DepartmentDAO">
   <constructor-arg ref="sqlMapclient"/>
  </bean>
 
</beans>

<?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>
 <!-- SqlMap파일 등록 -->

 <sqlMap resource="dept/config/department.xml"/>
</sqlMapConfig>

package dept.dao;

import java.util.List;

import org.springframework.orm.ibatis.SqlMapClientTemplate;

import dept.dto.DepartmentDTO;

public class DepartmentDAO {
 private SqlMapClientTemplate sqlMap;
 public DepartmentDAO(SqlMapClientTemplate sqlMap){
  this.sqlMap = sqlMap;
 }
 public void insertDepartment(DepartmentDTO dto){
  sqlMap.insert("insertDepartment", dto);
  System.out.println("1개의 부서가 삽입되었습니다."+dto);
 }
 public int updateDepartment(DepartmentDTO dto){
  int cnt = sqlMap.update("updateDepartment", dto);
  return cnt;
 }
 public int deleteDepartmentById(String departmentId){
  int cnt = sqlMap.delete("deleteDepartment", departmentId);
  return cnt;
  
 }
 public DepartmentDTO selectDepartmentById(String departmentId){
  DepartmentDTO ddt = (DepartmentDTO) sqlMap.queryForObject("selectDepartmentById", departmentId);
  return ddt;
  
 }
 public List selectAllDepartment(){
  return sqlMap.queryForList("selectAllDepartment");
 }
}

package dept.dto;

/*
 * Table : Department(department_id(pk), department_name, location)
 */
public class DepartmentDTO {
 private String departmentId;
 private String departmentName;
 private String location;
 
 public DepartmentDTO() {
  super();
 }

 public DepartmentDTO(String departmentId, String departmentName,
   String location) {
  super();
  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 + "]";
 }

 @Override
 public int hashCode() {
  final int prime = 31;
  int result = 1;
  result = prime * result
    + ((departmentId == null) ? 0 : departmentId.hashCode());
  result = prime * result
    + ((departmentName == null) ? 0 : departmentName.hashCode());
  result = prime * result
    + ((location == null) ? 0 : location.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;
  DepartmentDTO other = (DepartmentDTO) obj;
  if (departmentId == null) {
   if (other.departmentId != null)
    return false;
  } else if (!departmentId.equals(other.departmentId))
   return false;
  if (departmentName == null) {
   if (other.departmentName != null)
    return false;
  } else if (!departmentName.equals(other.departmentName))
   return false;
  if (location == null) {
   if (other.location != null)
    return false;
  } else if (!location.equals(other.location))
   return false;
  return true;
 }
 
}

package dept.main;

import java.util.List;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import dept.dao.DepartmentDAO;
import dept.dto.DepartmentDTO;

public class TestDepartment {
 public static void main(String[] args) {
  
  ApplicationContext ctx = new ClassPathXmlApplicationContext("dept/config/spring.xml");
  DepartmentDAO dao = (DepartmentDAO)ctx.getBean("departmentDAO");
  DepartmentDTO ddto = new DepartmentDTO("D0007","개발부","울산지점");
  
  System.out.println("-------부서 삽입하기-------");
  dao.insertDepartment(ddto);
  System.out.println("-------부서 수정하기-----------");
  ddto = new DepartmentDTO("D0004", "수정부", "수정지점");
  int cnt = dao.updateDepartment(ddto);
  System.out.println(cnt+"개의 행이 수정되었습니다."+ddto);
  System.out.println("---------부서 삭제하기---------");
  String departmentId = "D0005";
  int cnt1 = dao.deleteDepartmentById(departmentId);
  System.out.println(cnt1+"개의 행이 삭제되었습니다."+departmentId);
  System.out.println("--------------ID로 조회하기(select)-----------");
  String selectDepartmentId = "D0007";
  ddto = dao.selectDepartmentById(selectDepartmentId);
  System.out.println(ddto);
  System.out.println("--------전체 조회하기------------");
  List 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>

</sqlMap>

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">
 <!-- BasicDataSource 생성 -->
 <bean name="datasource" class="org.apache.tomcat.dbcp.dbcp.BasicDataSource">
  <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
  <property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:XE"/>
  <property name="username" value="scott"/>
  <property name="password" value="tiger"/>
 </bean>
 <!-- SqlMapClient 생성 -->
 <bean name="sqlMapclient" class="org.springframework.orm.ibatis.SqlMapClientTemplate">
  <property name="sqlMapClient" ref="sqlMapClientFactoryBean"/>
 </bean>
 <!-- SqlMapClientTemplate 생성 -->
 <bean name="sqlMapClientFactoryBean" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
  <property name="configLocation" value="dept/config/SqlMapConfig.xml"/>
  <property name="dataSource" ref="datasource"/>
 </bean>
 <!-- DepartmentDAO 생성 -->
  <bean name="departmentDAO" class="dept.dao.DepartmentDAO">
   <constructor-arg ref="sqlMapclient"/>
  </bean>
 
</beans>

<?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>
 <!-- SqlMap파일 등록 -->

 <sqlMap resource="dept/config/department.xml"/>
</sqlMapConfig>

package dept.dao;

import java.util.List;

import org.springframework.orm.ibatis.SqlMapClientTemplate;

import dept.dto.DepartmentDTO;

public class DepartmentDAO {
 private SqlMapClientTemplate sqlMap;
 public DepartmentDAO(SqlMapClientTemplate sqlMap){
  this.sqlMap = sqlMap;
 }
 public void insertDepartment(DepartmentDTO dto){
  System.out.println(sqlMap);
 }
 public int updateDepartment(DepartmentDTO dto){
  return 0;
  
 }
 public int deleteDepartmentById(String departmentId){
  return 0;
  
 }
 public DepartmentDTO selectDepartmentById(String departmentId){
  return null;
  
 }
 public List selectAllDepartment(){
  return null;
  
 }
}

package dept.dto;

/*
 * Table : Department(department_id(pk), department_name, location)
 */
public class DepartmentDTO {
 private String departmentId;
 private String departmentName;
 private String location;
 
 public DepartmentDTO() {
  super();
 }

 public DepartmentDTO(String departmentId, String departmentName,
   String location) {
  super();
  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 + "]";
 }

 @Override
 public int hashCode() {
  final int prime = 31;
  int result = 1;
  result = prime * result
    + ((departmentId == null) ? 0 : departmentId.hashCode());
  result = prime * result
    + ((departmentName == null) ? 0 : departmentName.hashCode());
  result = prime * result
    + ((location == null) ? 0 : location.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;
  DepartmentDTO other = (DepartmentDTO) obj;
  if (departmentId == null) {
   if (other.departmentId != null)
    return false;
  } else if (!departmentId.equals(other.departmentId))
   return false;
  if (departmentName == null) {
   if (other.departmentName != null)
    return false;
  } else if (!departmentName.equals(other.departmentName))
   return false;
  if (location == null) {
   if (other.location != null)
    return false;
  } else if (!location.equals(other.location))
   return false;
  return true;
 }
 
}

package dept.main;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import dept.dao.DepartmentDAO;
import dept.dto.DepartmentDTO;

public class TestDepartment {
 public static void main(String[] args) {
  
  ApplicationContext ctx = new ClassPathXmlApplicationContext("dept/config/spring.xml");
  DepartmentDAO dao = (DepartmentDAO)ctx.getBean("departmentDAO");
  DepartmentDTO ddto = new DepartmentDTO();
  dao.insertDepartment(ddto);
 }

}

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">

 <bean id="testDTO" class="di.dto.TestDTO" />
 <bean id="testDTO2" class="di.dto.TestDTO"/>
</beans>

package di.dto;

public class TestDTO {
 
}

package di.main;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import di.dto.TestDTO;

public class TestScope {
 public static void main(String[] args) {
  ApplicationContext ctx = new ClassPathXmlApplicationContext("di/config/test.xml");
  TestDTO dto1 = (TestDTO) ctx.getBean("testDTO");
  TestDTO dto2 = (TestDTO) ctx.getBean("testDTO");
  TestDTO dto3 = (TestDTO) ctx.getBean("testDTO2");
  System.out.println("dto1 : "+dto1);
  System.out.println("dto2 : "+dto2);
  System.out.println("testDTO2 : "+dto3);
  System.out.println("dto1==dto2 : "+(dto1==dto2));
  System.out.println("dto1==dto3 : "+(dto1==dto3));
 }

}

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">

 <bean id="testDTO" class="di.dto.TestDTO" scope="prototype"/>
 <bean id="testDTO2" class="di.dto.TestDTO"/>
</beans>

package di.dto;

public class TestDTO {
 
}

package di.main;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import di.dto.TestDTO;

public class TestScope {
 public static void main(String[] args) {
  ApplicationContext ctx = new ClassPathXmlApplicationContext("di/config/test.xml");
  TestDTO dto1 = (TestDTO) ctx.getBean("testDTO");
  TestDTO dto2 = (TestDTO) ctx.getBean("testDTO");
  TestDTO dto3 = (TestDTO) ctx.getBean("testDTO2");
  System.out.println("dto1 : "+dto1);
  System.out.println("dto2 : "+dto2);
  System.out.println("testDTO2 : "+dto3);
  System.out.println("dto1==dto2 : "+(dto1==dto2));
  System.out.println("dto1==dto3 : "+(dto1==dto3));
 }

}

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">
 <bean name="director" class="di.dto.DirectorDTO">
  <constructor-arg value="d-0001"/>
  <constructor-arg value="박찬욱"/>
  <constructor-arg value="30"/>
 </bean>
 <bean name="collection1" class="di.dto.CollectionDTO">
  <property name="myList">
   <!-- <list value-type="java.lang.Integer"> -->
   <list>
   <!--  <value type="java.lang.Integer">10</value> -->
    <value>10</value>
    <value>20</value>
    <value>30</value>
    <value>40</value>
    <value>50</value>
    <value>adv</value>
    <ref bean="director"/>
   </list>
  </property>
  <property name="names">
   <list>
    <value>유재석</value>
    <value>정준하</value>
    <value>정형돈</value>
    <value>길</value>
    <value>노홍철</value>
   </list>
  </property>
  
 </bean>
 <bean name="collection2" class="di.dto.CollectionDTO">
  <property name="mySet">
   <set>
    <value>10</value>
    <value>20</value>
    <value>30</value>
    <!-- set이라 중복된 값인 30은 두번 들어 가지 않는다. -->
    <value>30</value>
    <value>abcde</value>
    <ref bean="director"/>
   </set>
   
  </property>
  <property name="myMap">
   <map>
    <entry>
     <key>
      <value>감독</value>
     </key>
     <ref bean="director"/>
    </entry>
    <entry>
     <key>
      <value>aaa</value>
     </key>
     <value>100000</value>
    </entry>
    <entry key="bbb" value="20000000"/>
    <entry key="감독2" value-ref="director"/>
   </map>
  </property>
  <property name="myProps">
   <props>
    <prop key="aaaa">홍길동</prop>
    <prop key="bbbb">이순신</prop>
    <prop key="cccc">강감찬</prop>
    <prop key="dddd">을지문덕</prop>
    
   </props>
  </property>
 </bean>
 
</beans>

package di.dto;

import java.util.List;
import java.util.Map;
import java.util.Properties;
import java.util.Set;

public class CollectionDTO {
 private List myList;
 private String[] names;
 private Set mySet;
 private Map myMap;
 private Properties myProps;
 public List getMyList() {
  return myList;
 }

 public void setMyList(List myList) {
  this.myList = myList;
 }

 public String[] getNames() {
  return names;
 }

 public void setNames(String[] names) {
  this.names = names;
 }
 
 

 public Set getMySet() {
  return mySet;
 }

 public void setMySet(Set mySet) {
  this.mySet = mySet;
 }
 

 public Map getMyMap() {
  return myMap;
 }

 public void setMyMap(Map myMap) {
  this.myMap = myMap;
 }
 

 public Properties getMyProps() {
  return myProps;
 }

 public void setMyProps(Properties myProps) {
  this.myProps = myProps;
 }
 
 
}

package di.dto;

public class DirectorDTO {
 private String directorId;
 private String name;
 private int age;
 public DirectorDTO() {
  super();
 }
 public DirectorDTO(String directorId, String name, int age) {
  super();
  this.directorId = directorId;
  this.name = name;
  this.age = age;
 }
 
 public String getDirectorId() {
  return directorId;
 }
 public void setDirectorId(String directorId) {
  this.directorId = directorId;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public int getAge() {
  return age;
 }
 public void setAge(int age) {
  this.age = age;
 }
 @Override
 public String toString() {
  return "DirectorDTO [directorId=" + directorId + ", name=" + name
    + ", age=" + age + "]";
 }
 
}

package di.main;

import java.util.Enumeration;
import java.util.List;
import java.util.Map;
import java.util.Properties;
import java.util.Set;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import di.dto.CollectionDTO;

public class TestCollection {

 public static void main(String[] args) {
  ApplicationContext ctx = new ClassPathXmlApplicationContext("di/config/collection.xml");
  CollectionDTO dto = (CollectionDTO) ctx.getBean("collection1");
  List list = dto.getMyList();
  for(Object obj: list){
   System.out.println(obj.getClass().getName()+" - "+obj);
  }
  
  System.out.println("-------------names[]조회-------------");
  String [] names = dto.getNames();
  for(String name : names){
   System.out.println(name);
  }
  
  System.out.println("-------mySet조회-------------");
  dto = (CollectionDTO) ctx.getBean("collection2");
  Set set = dto.getMySet();
  for(Object obj:set){
   System.out.println(obj);
  }
  System.out.println("------myMap조회------------");
  Map map = dto.getMyMap();
  
  Set keys = map.keySet();
  for(Object key:keys){
   Object value = map.get(key);
   System.out.println(key+" - "+value);
  }
  
  System.out.println(map.get("aaa"));
  System.out.println(map.get("bbb"));
  
  System.out.println("----------properties조회---------");
  Properties props = dto.getMyProps();
  Enumeration enu = props.propertyNames();//Enumeration : iterater의 옛버전(collection 조회해 주는 것)
  
  while(enu.hasMoreElements()){
   String key = (String) enu.nextElement();
   String value = props.getProperty(key);
   System.out.println(key+" - "+value);
  }

 }
}