구디아카데미

Spring

참조 자료 링크

• STS
• mybatis
• maven
• maven repository
• tomcat
• mariadb
• w3schools

Spring MVC - GuideLine

Spring MVC Project Create

• pom.xml

  
    Spring  - spring-webmvc, spring-jdbc, spring-test
    Test    - junit
    JDBC    - mariadb-java-client
    Mybatis - mybatis, mybatis-spring
    JSON    - json-lib-ext-spring
  

JNDI - Tomcat 설정 방법 (MariaDB)

server.xml

1. JDBC 연결

  
    Resource 
    auth="Container" 
    defaultAutoCommit="true" 
    factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" 
    type="javax.sql.DataSource" 
    initialSize="1" 
    maxActive="1" 
    maxWait="10000" 
    minIdle="1" 
    name="jdbc/name" 
    driverClassName="org.mariadb.jdbc.Driver" 
    url="jdbc:mysql://host:3306/database-name"  
    username=""
    password="" 
    validationQuery="SELECT 1"
  

context.xml

2. 프로젝트에서 사용 가능하도록 전역 변수 생성

  
   ResourceLink 
   global="jdbc/name" 
   name="jdbc/name" 
   type="javax.sql.DataSource"
  

Spring Configuration

root-context.xml

1. JNDI 연결1 방법

  
   jee:jndi-lookup 
   jndi-name="jdbc/name" 
   id="dataSource" 
   expected-type="javax.sql.DataSource"
  

1. JNDI 연결2 방법

  
   bean 
   id="dataSource" 
   class="org.springframework.jndi.JndiObjectFactoryBean" 
   p:jndiName="java:/comp/env/jdbc/name" 
   p:resourceRef="true"
  

2. Mybatis 설정

  
   bean 
   id="sqlSessionFactory" 
   class="org.mybatis.spring.SqlSessionFactoryBean" 
   p:dataSource-ref="dataSource" 
   p:mapperLocations="classpath:/sql/*.xml" 
   p:typeAliasesPackage="com.java.web.bean"
  

3. Session 생성 (openSession)

  
   bean 
   id="sqlSession" 
   class="org.mybatis.spring.SqlSessionTemplate" 
   c:sqlSessionFactory-ref="sqlSessionFactory"