2014년 1월 7일 화요일

IBatis Spring을 이용한 미니 방명록 작성하기[재직자무료교육/프로그래머교육/구로디지털IT교육,오라클/자바/닷넷/C#/iOS/안드로이드/아이폰교육]

IBatis Spring을 이용한 미니 방명록 작성하기[재직자무료교육/프로그래머교육/구로디지털IT교육,오라클/자바/닷넷/C#/iOS/안드로이드/아이폰교육]


구로디지털단지 실무중심 개발교육
www.onjprogramming.co.kr
 
 
IBatis + Spring을 이용한 미니 방명록 작성하기
:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /> 
------------------------------------------------------------------------
1. Eclipse에서 ibatistest 라는 톰캣 프로젝트 생성
-------------------------------------------------------------------------
 
------------------------------------------------------------------------
2. iBatis 설치
------------------------------------------------------------------------
 
------------------------------------------------------------------------
3. 기타 jar 파일들 (log4j, commons 관련, spring framework 관련)은 아래와 같다. 적절히 추가하자.
------------------------------------------------------------------------
 
commons-collections-3.2.jar
commons-dbcp-1.2.1.jar
commons-dbcp-1.2.1.jar
commons-logging.jar
commons-pool-1.3.jar
jstl.jar
log4j-1.2.9.jar
ojdbc14.jar
spring.jar
spring-webmvc.jar
 
------------------------------------------------------------------------
4. WEB-INF/web.xml
------------------------------------------------------------------------
 
 <?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="2.4"
       xmlns="http://java.sun.com/xml/ns/j2ee"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
 
       <listener>
             <listener-class>
                    org.springframework.web.context.ContextLoaderListener
             </listener-class>
       </listener>
      
       <servlet>
             <servlet-name>guestbook</servlet-name>
             <servlet-class>
                    org.springframework.web.servlet.DispatcherServlet
             </servlet-class>
             <load-on-startup>1</load-on-startup>
       </servlet>
      
       <servlet-mapping>
             <servlet-name>guestbook</servlet-name>
             <url-pattern>*.guest</url-pattern>
       </servlet-mapping>
      
</web-app>
 
 
------------------------------------------------------------------------
5.  /WEB-INF/guestbook-servlet.xml
------------------------------------------------------------------------
 
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
 
<bean name="questbookController"  class="guestbook.controller.GuestbookController">
    <property name="guestbookManager" ref="guestbookManager" />
</bean>
<bean id="urlMapping" class="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping">
        <property name="mappings">
            <props>
                <prop key="/list.guest">questbookController</prop>
            </props>
        </property>
</bean>
</beans>
 
 
 
------------------------------------------------------------------------
6. applicationContext.xml
------------------------------------------------------------------------
 
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<bean id="sqlMapClient"        class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">       
  <property name="dataSource" ref="dataSource"/>       
  <property name="configLocation" value="/WEB-INF/SqlMapConfig.xml"/>
</bean>
<bean id="guestbookDao" class="guestbook.dao.GuestbookDaoImpl">   
  <property name="sqlMapClient" ref="sqlMapClient" />
</bean>   
<bean name="guestbookManager"      class="guestbook.service.GuestbookManagerImpl">   
  <property name="guestbookDao" ref="guestbookDao" />
</bean>
<bean id="dataSource"
       class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
       <property name="driverClassName">
           <value>oracle.jdbc.driver.OracleDriver</value>
       </property>
       <property name="url">
           <value>jdbc:oracle:thin:@192.168.1.131:1521:ORCL</value>
       </property>
       <property name="username">
           <value>scott</value>
       </property>
       <property name="password">
           <value>tiger</value>
       </property>      
    </bean>
 
</beans>
 
 
 
------------------------------------------------------------------------
7. log4j.xml
------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
    <appender name="CONSOLE" class="org.apache.log4j.ConsoleAppender">
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" value="%p - %m%n"/>
        </layout>
    </appender>
</log4j:configuration>
 
 
 
------------------------------------------------------------------------
8. 실습용 테이블 작성
------------------------------------------------------------------------
 
Oracle에서 scott/tiger로 로그인 후
 
    SQL>  create table guestbook (
           no number constraints pk_guestbook_no primary key,
password varchar2(10),
name varchar2(20),
subject varchar2(100),
content varchar2(500),
write_date varchar2(20)
);
 
테이블 생성할 때 PK이름 위에서 처럼 주세요… 나중에 SEELCT에서 그 이름으로 힌트 사용합니다.
 
실습을 위해 데이터 한 건 입력하시구요…
 
SQL> insert into guestbook values (1,'1111','이종철','연습','연습입니다.',to_char(sysdate,'yyyymmdd'));
 
SQL> Commit;
 
------------------------------------------------------------------------
9. WEB-INF/src/SqlMapConfig.xml
------------------------------------------------------------------------
 
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig  PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"   "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
       <typeAlias alias="GuestbookVo" type="guestbook.vo.GuestbookVo" />
       <sqlMap resource="guestbook.xml" />
</sqlMapConfig>
 
 
------------------------------------------------------------------------
10. /WEB-INF/src/guestbook/vo/GuestbookVo.java
------------------------------------------------------------------------
 
package guestbook.vo;
 
public class GuestbookVo {
       private int no;
       private String password;
       private String name;
       private String subject;
       private String content;
       private String write_date;
 
       public String getContent() {
             return content;
       }
       public void setContent(String content) {
             this.content = content;
       }
       public String getName() {
             return name;
       }
       public void setName(String name) {
             this.name = name;
       }
       public int getNo() {
             return no;
       }
       public void setNo(int no) {
             this.no = no;
       }
       public String getPassword() {
             return password;
       }
       public void setPassword(String password) {
             this.password = password;
       }
       public String getSubject() {
             return subject;
       }
       public void setSubject(String subject) {
             this.subject = subject;
       }
       public String getWrite_date() {
             return write_date;
       }
       public void setWrite_date(String write_date) {
             this.write_date = write_date;
       }
}
 
 
------------------------------------------------------------------------
11. /WEB-INF/src/guestbook/dao/GuestbookDao.java
------------------------------------------------------------------------
 
package guestbook.dao;
 
 
import java.util.List;
 
public interface GuestbookDao {
   public List  getContents();
}
 
 
------------------------------------------------------------------------
12. /WEB-INF/src/guestbook/dao/GuestbookDaoImpl.java
------------------------------------------------------------------------
 
package guestbook.dao;
 
import guestbook.vo.GuestbookVo;
import java.util.List;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
 
public class GuestbookDaoImpl extends SqlMapClientDaoSupport implements GuestbookDao {
 

  • JAVA
  • ORACLE
  • iPhone/Android
  • .NET
  • 표준웹/HTML5
  • 채용/취업무료교육
  • 초보자(재학생)코스

    •
    [기업100%환급]Spring ,MyBatis,Hibernate실무과정 총 5일 40시간  01-13
    [기업100%환급]자바기초에서 JDBC, Servlet/JSP까지 총 5일 40시간  01-20
    자바기초에서JSP,Ajax,jQuery,Spring3.2,MyBatis까지 총 24일 72시간  01-24
    Spring3.X, MyBatis, Hibernate실무과정 총 12일 36시간  02-03
    Spring3.X, MyBatis, Hibernate실무과정 총 5일 35시간  01-11
    JAVA&WEB프레임워크실무과정 총 14일 98시간  01-11
    작성자: 시간:

    댓글 없음:

    댓글 쓰기

    피드 구독하기: 댓글 (Atom)