[SpringFramework] Spring+Mybatis 프로젝트 구성

pom.xml

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">

<modelVersion>4.0.0</modelVersion>

<groupId>com.granya</groupId>

<artifactId>nh</artifactId>

<name>NeedHelp</name>

<packaging>war</packaging>

<version>1.0.0-BUILD-SNAPSHOT</version>

<properties>

<java-version>1.7</java-version>

<org.springframework-version>4.0.6.RELEASE</org.springframework-version>

<org.aspectj-version>1.8.1</org.aspectj-version>

<org.slf4j-version>1.7.7</org.slf4j-version>

</properties>

<dependencies>

<!-- Spring -->

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-context</artifactId>

<version>${org.springframework-version}</version>

<exclusions>

<!-- Exclude Commons Logging in favor of SLF4j -->

<exclusion>

<groupId>commons-logging</groupId>

<artifactId>commons-logging</artifactId>

</exclusion>

</exclusions>

</dependency>

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-webmvc</artifactId>

<version>${org.springframework-version}</version>

</dependency>

<!-- AspectJ -->

<dependency>

<groupId>org.aspectj</groupId>

<artifactId>aspectjrt</artifactId>

<version>${org.aspectj-version}</version>

</dependency>

<!-- Logging -->

<dependency>

<groupId>org.slf4j</groupId>

<artifactId>slf4j-api</artifactId>

<version>${org.slf4j-version}</version>

</dependency>

<dependency>

<groupId>org.slf4j</groupId>

<artifactId>jcl-over-slf4j</artifactId>

<version>${org.slf4j-version}</version>

<scope>runtime</scope>

</dependency>

<dependency>

<groupId>org.slf4j</groupId>

<artifactId>slf4j-log4j12</artifactId>

<version>${org.slf4j-version}</version>

<scope>runtime</scope>

</dependency>

<dependency>

<groupId>log4j</groupId>

<artifactId>log4j</artifactId>

<version>1.2.17</version>

<exclusions>

<exclusion>

<groupId>javax.mail</groupId>

<artifactId>mail</artifactId>

</exclusion>

<exclusion>

<groupId>javax.jms</groupId>

<artifactId>jms</artifactId>

</exclusion>

<exclusion>

<groupId>com.sun.jdmk</groupId>

<artifactId>jmxtools</artifactId>

</exclusion>

<exclusion>

<groupId>com.sun.jmx</groupId>

<artifactId>jmxri</artifactId>

</exclusion>

</exclusions>

<scope>runtime</scope>

</dependency>

<!-- @Inject -->

<dependency>

<groupId>javax.inject</groupId>

<artifactId>javax.inject</artifactId>

<version>1</version>

</dependency>

<!-- Servlet -->

<dependency>

<groupId>javax.servlet</groupId>

<artifactId>javax.servlet-api</artifactId>

<version>3.0.1</version>

<scope>provided</scope>

</dependency>

<dependency>

<groupId>javax.servlet.jsp</groupId>

<artifactId>jsp-api</artifactId>

<version>2.2</version>

<scope>provided</scope>

</dependency>

<dependency>

<groupId>javax.servlet</groupId>

<artifactId>jstl</artifactId>

<version>1.2</version>

</dependency>

<!-- Test -->

<dependency>

<groupId>junit</groupId>

<artifactId>junit</artifactId>

<version>4.11</version>

<scope>test</scope>

</dependency>

<!-- Mysql -->

<dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

<version>5.1.31</version>

</dependency>

<!-- jdbc -->

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-jdbc</artifactId>

<version>${org.springframework-version}</version>

</dependency>

<!-- MyBatis -->

<dependency>

<groupId>org.mybatis</groupId>

<artifactId>mybatis</artifactId>

<version>3.2.7</version>

</dependency>

<dependency>

<groupId>org.mybatis</groupId>

<artifactId>mybatis-spring</artifactId>

<version>1.2.2</version>

</dependency>

<!-- Json -->

<dependency>

<groupId>com.googlecode.json-simple</groupId>

<artifactId>json-simple</artifactId>

<version>1.1</version>

</dependency>

</dependencies>

<build>

<plugins>

<plugin>

<artifactId>maven-eclipse-plugin</artifactId>

<version>3.2.2</version>

<configuration>

<additionalProjectnatures>

<projectnature>org.springframework.ide.eclipse.core.springnature</projectnature>

</additionalProjectnatures>

<additionalBuildcommands>

<buildcommand>org.springframework.ide.eclipse.core.springbuilder</buildcommand>

</additionalBuildcommands>

<downloadSources>true</downloadSources>

<downloadJavadocs>true</downloadJavadocs>

</configuration>

</plugin>

<plugin>

<groupId>org.apache.maven.plugins</groupId>

<artifactId>maven-compiler-plugin</artifactId>

<version>3.1</version>

<configuration>

<source>1.6</source>

<target>1.6</target>

<compilerArgument>-Xlint:all</compilerArgument>

<showWarnings>true</showWarnings>

<showDeprecation>true</showDeprecation>

</configuration>

</plugin>

<plugin>

<groupId>org.codehaus.mojo</groupId>

<artifactId>exec-maven-plugin</artifactId>

<version>1.3.1</version>

<configuration>

<mainClass>org.test.int1.Main</mainClass>

</configuration>

</plugin>

</plugins>

</build>

</project>

web.xml

<?xml version="1.0" encoding="UTF-8"?>

<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns="http://java.sun.com/xml/ns/javaee"

xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"

version="3.0">

<context-param>

<param-name>contextConfigLocation</param-name>

<param-value>/WEB-INF/spring/root-context.xml</param-value>

</context-param>

<listener>

<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>

</listener>

<filter>

<filter-name>characterEncodingFilter</filter-name>

<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>

<init-param>

<param-name>encoding</param-name>

<param-value>UTF-8</param-value>

</init-param>

</filter>

<filter-mapping>

<filter-name>characterEncodingFilter</filter-name>

<url-pattern>/*</url-pattern>

</filter-mapping>

<servlet>

<servlet-name>appServlet</servlet-name>

<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

<init-param>

<param-name>contextConfigLocation</param-name>

<param-value>/WEB-INF/spring/appServlet/servlet-context.xml</param-value>

</init-param>

<load-on-startup>1</load-on-startup>

</servlet>

<servlet-mapping>

<servlet-name>appServlet</servlet-name>

<url-pattern>/</url-pattern>

</servlet-mapping>

<jsp-config>

<jsp-property-group>

<url-pattern>*.jsp</url-pattern>

<include-prelude>/WEB-INF/prelude.jspf</include-prelude>

</jsp-property-group>

</jsp-config>

</web-app>

root-context.xml

<?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.xsd">

<!-- Root Context: defines shared resources visible to all other web components -->

<import resource="mybatis-context.xml"/>

</beans>

mybatis-context.xml

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tx="http://www.springframework.org/schema/tx"

xmlns:context="http://www.springframework.org/schema/context"

xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd

http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd

http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd">

<context:component-scan base-package="com.granya.nh" />

<context:property-placeholder location="classpath:db.properties" />

<bean id="dataSource"

class="org.springframework.jdbc.datasource.DriverManagerDataSource">

<property name="driverClassName" value="${jdbc.driver}" />

<property name="url" value="${jdbc.url}" />

<property name="username" value="${jdbc.user}" />

<property name="password" value="${jdbc.pwd}" />

</bean>

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

<property name="dataSource" ref="dataSource" />

<property name="typeAliasesPackage" value="com.granya.nh.domain" />

<property name="configLocation" value="/WEB-INF/spring/mybatis-config.xml" />

<property name="mapperLocations" value="classpath:com/granya/nh/mapper/*.xml" />

</bean>

<bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">

<constructor-arg ref="sqlSessionFactory" />

</bean>

<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">

<constructor-arg index="0" ref="sqlSessionFactory" />

</bean>

<!-- 트랜잭션 사용 -->

<bean id="transactionManager"

class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

<property name="dataSource" ref="dataSource"></property>

</bean>

<tx:annotation-driven transaction-manager="transactionManager" />

</beans>

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE configuration

PUBLIC "-//mybatis.org//DTD config 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>

<settings>

<setting name="cacheEnabled" value="false" />

<setting name="useGeneratedKeys" value="true" />

<setting name="defaultExecutorType" value="REUSE" />

</settings>

<mappers>

</mappers>

</configuration>

db.properties

jdbc.driver=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://host:3306/dbname

jdbc.user=username

jdbc.pwd=password

Product.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mapper

    PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

    "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.granya.nh.dao.ProductDao">

<select id="getProductList" resultType="Product">

SELECT * FROM product

</select>

<insert id="insertProduct">

INSERT INTO product (name, price)

VALUES(#{name}, #{price})

</insert>

<delete id="deleteProduct">

DELETE FROM product WHERE name = #{name}

</delete>

</mapper>

Product.java

package com.granya.nh.domain;

public class Product {

private String name;

private String price;

public Product(String name, String price) {

super();

this.name = name;

this.price = price;

}

public Product() {

super();

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public String getPrice() {

return price;

}

public void setPrice(String price) {

this.price = price;

}

@Override

public String toString() {

return "Product [name=" + name + ", price=" + price + "]";

}

}

ProductDao.java

package com.granya.nh.dao;

import java.util.List;

import com.granya.nh.domain.Product;

public interface ProductDao {

List getProductList();

void insertProduct(Product product);

void deleteProduct(Product product);

}

ProductDaoImpl.java

package com.granya.nh.dao;

import java.util.List;

import org.apache.ibatis.session.SqlSession;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Component;

import com.granya.nh.domain.Product;

@Component

public class ProductDaoImpl implements ProductDao {

@Autowired

private SqlSession sqlSession;

@Override

public List getProductList() {

// TODO Auto-generated method stub

return sqlSession.selectList("com.granya.nh.dao.ProductDao.getProductList");

}

@Override

public void insertProduct(Product product) {

// TODO Auto-generated method stub

sqlSession.insert("com.granya.nh.dao.ProductDao.insertProduct", product);

}

@Override

public void deleteProduct(Product product) {

// TODO Auto-generated method stub

sqlSession.delete("com.granya.nh.dao.ProductDao.deleteProduct", product);

}

}

ProductService.java

package com.granya.nh.service;

import java.util.List;

import com.granya.nh.domain.Product;

public interface ProductService {

List getProductList();

void insertProduct(Product product);

void deleteProduct(Product product);

}

ProductServiceImpl.java

package com.granya.nh.service;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Component;

import com.granya.nh.dao.ProductDao;

import com.granya.nh.domain.Product;

@Component

public class ProductServiceImpl implements ProductService {

@Autowired

private ProductDao productDao;

@Override

public List<Product> getProductList() {

// TODO Auto-generated method stub

return productDao.getProductList();

}

@Override

public void insertProduct(Product product) {

// TODO Auto-generated method stub

productDao.insertProduct(product);

}

@Override

public void deleteProduct(Product product) {

// TODO Auto-generated method stub

productDao.deleteProduct(product);

}

}

ProductController.java

package com.granya.nh.controller;

import java.util.Locale;

import javax.servlet.ServletRequest;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Controller;

import org.springframework.ui.Model;

import org.springframework.web.bind.annotation.ModelAttribute;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RequestMethod;

import com.granya.nh.domain.Product;

import com.granya.nh.service.ProductService;

/**

 * Handles requests for the application home page.

 */

@Controller

public class ProductController {

private static final Logger logger = LoggerFactory

.getLogger(ProductController.class);

/**

* Simply selects the home view to render by returning its name.

*/

@Autowired

private ProductService productService;

@RequestMapping(value = "/product", method = RequestMethod.GET)

public String product(Locale locale, Model model) {

model.addAttribute("productList", productService.getProductList());

System.out.println(model);

return "product";

}

@RequestMapping(value = "/product", method = RequestMethod.POST)

public String insertProduct(Locale locale, Model model,

@ModelAttribute("command") Product product) {

if (!(product.getName().equals("") || product.getPrice().equals(""))) {

productService.insertProduct(product);

}

model.addAttribute("productList", productService.getProductList());

return "product";

}

@RequestMapping(value = "/deleteProduct", method = RequestMethod.POST)

public String deleteProduct(Locale locale, Model model,

@ModelAttribute("command") Product product) {

productService.deleteProduct(product);

model.addAttribute("productList", productService.getProductList());

return "product";

}

}

prelude.jspf

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>

product.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<!DOCTYPE html>

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

<!-- <meta name="viewport" content="width=device-width, initial-scale=1"> -->

<title>Insert title here</title>

<!-- <link rel="stylesheet" href="http://code.jquery.com/mobile/1.4.2/jquery.mobile-1.4.2.min.css">  -->

<script

src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>

<!-- <script src="http://code.jquery.com/mobile/1.4.2/jquery.mobile-1.4.2.min.js"></script> -->

<script>

function deleteProduct(name) {

var answer = confirm(name + '을 삭제 하시겠습니까?');

if (answer) {

$.post("deleteProduct", {

name : name

}, function() {

$(location).attr('href', 'product');

});

} else {

return false;

}

}

</script>

</head>

<body>

<form action="product" method="post">

name : <input type="text" name="name"><br>

price : <input type="text" name="price"><br>

<input type="submit" value="입력">

</form>

<div>

<c:forEach items="${productList}" var="product">

<div>

<a href="javascript:deleteProduct('${product.name}')">

Product Name : ${product.name}</a><br>

Product Price : ${product.price}

</div>

</c:forEach>

</div>

</body>

</html>