基于全注解的Spring3.1 mvc、myBatis3.1、Mysql的輕量級項目
對于現在主流的j2ee企業級開發而言，ssh（struts+hibernate+spring）依然是一個事實的標準。由struts充當的mvc調度控制；hibernate的orm持久化映射；spring的ioc和aop的容器環境近乎于完美的框架組合。 但是，在實際的開發工作中，由于程序猿對于技術、以及更加快速的解決方案的追求，我們會越來越發現ssh框架所存在的諸多問題和困擾。
基于REST風格的Spring3 MVC資源映射編程模型，編寫的Code真的很優雅。那是相當的驚喜，編程之美。
MyEclipse項目清單
SVN淘寶蝌蚪：
http://code.taobao.org/p/mySpring3myBatis3/src/
http://code.taobao.org/p/mySpring3myBatis3/src/
清單1. web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5"
xmlns=";
xmlns:xsi=";
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
;
<display-name>mySpring3 and myBatis3 Project</display-name>
<!-- 配置文件位置，默認為/WEB-INF/applicationContext.xml -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>
<!-- 字符集過濾器 -->
<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>
<!-- 上下文Spring監聽器 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- servlet控制跳轉 -->
<servlet>
<servlet-name>spring3</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<!-- 配置文件 -->
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:context-dispatcher.xml</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>spring3</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<!-- 激活靜態資源的默認配置,解決Rest風格兼容 -->
<servlet-mapping>
<servlet-name>default</servlet-name>
<url-pattern>.css</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>default</servlet-name>
<url-pattern>.js</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>default</servlet-name>
<url-pattern>.gif</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>default</servlet-name>
<url-pattern>*.jpg</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
</web-app></pre>
清單2. applicationContext.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
http://www.springframework.org/schema/context
<!-- (事務管理)transaction manager, use JtaTransactionManager for global tx -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
<!-- 創建SqlSessionFactory，同時指定數據源 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="configLocation" value="classpath:mybatis.cfg.xml"></property>
<property name="dataSource" ref="dataSource" />
</bean>
<!-- 可通過注解控制事務 -->
<tx:annotation-driven transaction-manager="transactionManager"/>
<!-- 配置事務的傳播特性 -->
<!--
<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="create*" propagation="REQUIRED" />
<tx:method name="modify*" propagation="REQUIRED" />
<tx:method name="delete*" propagation="REQUIRED" />
<tx:method name="*" read-only="true" />
</tx:attributes>
</tx:advice>
-->
<!-- 配置事務的切入點 -->
<!--
<aop:config>
<aop:pointcut id="targetMethod" expression="execution(* com.matol.service.*.*(..))" />
<aop:advisor advice-ref="txAdvice" pointcut-ref="targetMethod" />
</aop:config>
-->
<!-- Mapper接口所在包名，Spring會自動查找其下的Mapper -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.matol.mapper" />
</bean>
<!-- 負責注冊JSR-250 的注釋生效 @Resource MapperScannerConfigurer配置會自動啟用mapper注解,可省略當前配置
<bean class="org.springframework.context.annotation.CommonAnnotationBeanPostProcessor"/>
-->
</beans></pre>
清單3. context-dispatcher.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans default-lazy-init="true"
xmlns="
<!-- 探測注解的包，包括子集， 在JUnit測試的時候需要 --> <!-- 自動掃描bean，把作了注解的類轉換為bean -->
<context:component-scan base-package="com.matol" />
<!-- 加載組裝所以配置文件 context:component-scan注冊后可以省略當前配置
<context:annotation-config/>
-->
<!-- 視圖解析器 -->
<bean id="viewResolver"
class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<!-- 使用JSP頁面進行輸出 -->
<property name="viewClass" value="org.springframework.web.servlet.view.JstlView" />
<!-- 指定了表示層的前綴 --> <!-- 這個配置是配置JSP頁面的位置，按照你自己的配置來配 -->
<property name="prefix" value="/" />
<!-- 指定了表示層的后綴 -->
<property name="suffix" value=".jsp"></property>
</bean>
<!-- 處理文件上傳處理 -->
<bean id="multipartResolver"
class="org.springframework.web.multipart.commons.CommonsMultipartResolver" p:defaultEncoding="UTF-8" />
</beans></pre>
清單4. jdbc.properties
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/matolDB
username=root
password=root
清單5. mybatis.cfg.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>
<typeAliases>
<typeAlias alias="Student" type="com.matol.entity.User" />
</typeAliases>
<mappers>
<mapper resource="com/matol/mapper/UserMapper.xml" />
</mappers>
</configuration>
清單6. matolDB.sql
/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50141
Source Host : localhost:3306
Source Database : matoldb
Target Server Type : MYSQL
Target Server Version : 50141
File Encoding : 65001
Date: 2013-01-23 16:47:52
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS sys_user;
CREATE TABLE sys_user (
id int(11) unsigned zerofill NOT NULL AUTO_INCREMENT,
name varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
pass varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
age int(11) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;</pre>
清單7. User.java
package com.matol.entity;
import java.io.Serializable;
import org.springframework.stereotype.Repository;
/*
@author matol
@date 2013-01-23 16:38
*/
@Repository(value = "user")
public class User implements Serializable {
private Integer id;
private String name;
private String pass;
private Integer age;
public User(){}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPass() {
return pass;
}
public void setPass(String pass) {
this.pass = pass;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
}</pre>
清單7. UserMapper.java
package com.matol.mapper;
import java.util.List;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;
import com.matol.entity.User;
/*
@author matol
@date 2013-01-23 16:38
*/
@Repository(value = "userMapper")
@Transactional
public interface UserMapper {
Integer create(User user);
Integer delete(Integer id);
Integer modify(User user);
User findById(Integer id);
User findByUser(User user);
List<User> findAll();
List<User> findAll(User user);
Integer count();
}</pre>
清單8. UserMapper .xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" ";
<mapper namespace="com.matol.mapper.UserMapper">
<!-- 定義數據庫字段與實體對象的映射關系 -->
<resultMap type="com.matol.entity.User" id="resultUser">
<id property="id" column="id"/>
<result property="name" column="name"/>
<result property="pass" column="pass"/>
<result property="age" column="age"/>
</resultMap>
<!-- 定義參數模型 -->
<parameterMap type="com.matol.entity.User" id="paramUser">
<parameter property="id"/>
<parameter property="name"/>
<parameter property="pass"/>
<parameter property="age"/>
</parameterMap>
<!-- 定義要操縱的SQL語句 -->
<insert id="create" parameterType="com.matol.entity.User" >
INSERT INTO sys_user(name,pass,age)
VALUES(#{name},#{pass},#{age})
</insert>
<delete id="delete" parameterType="Integer" >
DELETE FROM sys_user
WHERE id=#{value}
</delete>
<update id="modify" parameterType="com.matol.entity.User" >
UPDATE sys_user
<set>
<if test="name != null">name=#{name},</if>
<if test="pass != null">pass=#{pass},</if>
<if test="age != null">age=#{age},</if>
</set>
WHERE id=#{id}
</update>
<select id="findById" parameterType="Integer" resultMap="resultUser">
SELECT FROM sys_user
WHERE id=#{value}
</select>
<select id="findAll" resultType="list" resultMap="resultUser">
SELECT FROM sys_user
</select>
<select id="count" resultType="Integer">
SELECT count(*) FROM sys_user
</select>
</mapper></pre>
清單9. UserService.java
package com.matol.service;
import java.util.List;
import org.springframework.stereotype.Repository;
import com.matol.entity.User;
/*
@author matol
@date 2013-01-23 16:38
*/
@Repository(value = "userService")
public interface UserService {
Integer create(User user);
Integer delete(Integer id);
Integer modify(User user);
User findById(Integer id);
User findByUser(User user);
List<User> findAll();
List<User> findAll(User user);
Integer count();
}</pre>
清單10. UserServiceImpl.java
package com.matol.service.impl;
import java.util.List;
import javax.annotation.Resource;
import org.springframework.stereotype.Repository;
import com.matol.entity.User;
import com.matol.mapper.UserMapper;
import com.matol.service.UserService;
/*
@author matol
@date 2013-01-23 16:38
*/
@Repository(value = "userServiceImpl")
public class UserServiceImpl implements UserService{
@Resource(name = "userMapper")
private UserMapper userMapper;
public Integer count() {
return userMapper.count();
}
public Integer create(User user) {
return userMapper.create(user);
}
public Integer delete(Integer id) {
return userMapper.delete(id);
}
public List<User> findAll() {
return userMapper.findAll();
}
public List<User> findAll(User user) {
return userMapper.findAll(user);
}
public User findById(Integer id) {
return userMapper.findById(id);
}
public User findByUser(User user) {
return userMapper.findByUser(user);
}
public Integer modify(User user) {
return userMapper.modify(user);
}
}</pre>
清單11. UserController.java
package com.matol.controller;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;
import com.matol.entity.User;
import com.matol.service.UserService;
/*
@author matol
@date 2013-01-23 16:38
*/
@Controller
@RequestMapping(value = "/user")
public class UserController {
@Resource(name = "userServiceImpl")
private UserService userService;
/**
@author matol
@date 2013-01-23 16:38
@return
/
@RequestMapping(value = "/list")
public ModelAndView getAllUser(HttpServletRequest request,HttpServletResponse response) throws Exception {
Map<String, Object> map = new HashMap<String, Object>();
List<User> result = new ArrayList<User>();
result = userService.findAll();
map.put("result", result);
return new ModelAndView("/user/list", map);
}
/
@author matol
@date 2013-01-23 16:38
@return
/
@RequestMapping(value = "**/list/{id}")
public ModelAndView getTheUser(@PathVariable("id") int id){
Map<String, Object> map = new HashMap<String, Object>();
List<User> result = new ArrayList<User>();
result.add(userService.findById(id));
map.put("result", result);
return new ModelAndView("/user/list", map);
}
/
@author matol
@date 2013-01-23 16:38
@return
/
@RequestMapping(value = "/toAdd")
public ModelAndView toAddUser(){
return new ModelAndView("/user/adds");
}
/
@author matol
@date 2013-01-23 16:38
@return
/
@RequestMapping(value = "/doAdd")
public String addUser(User user){
userService.create(user);
Map<String, Object> map = new HashMap<String, Object>();
List<User> result = new ArrayList<User>();
result = userService.findAll();
map.put("result", result);
return "redirect:list";
}
/
@author matol
@date 2013-01-23 16:38
@return
/
@RequestMapping(value = "/delete/{id}")
public String deleteTheUser(@PathVariable("id") int id){
Map<String, Object> map = new HashMap<String, Object>();
userService.delete(id);
List<User> result = new ArrayList<User>();
result = userService.findAll();
map.put("result", result);
return "redirect:/user/list";
}
}</pre>
清單12. index.jsp
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'index.jsp' starting page</title>
</head>
<body>
<h3>Spring3.1、MyBatis3.1、MySQL 整合.</h3>
<a href="user/list">查詢所有</a><br/>
<a href="user/toAdd">添加記錄</a><br/>
</body>
</html></pre>
清單13. list.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri=";
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" ";
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Insert title here</title>
</head>
<body>
<c:forEach items="${result}" var="item">
<a href="list/${item.id }">${item.name }</a> pass: ${item.pass } --- age: ${item.age } <a href="delete/${item.id }">delete</a><hr/>
</c:forEach>
<a href="toAdd">添加記錄</a><br/>
</body>
</html></pre>
清單14. adds.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri=";
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" ";
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Insert title here</title>
</head>
<body>
<br/>
<form action="doAdd" method="post">
name:<input type="text" name="name">
pass:<input type="text" name="pass">
age:<input type="text" name="age">
<input type="submit" value="submit">
</form>
<br/>
<a href="list">查詢所有</a><br/>
</body>
</html></pre>
lib的jar清單
由于只是一個相對簡單的使用范例，所以沒有非常標準的注入DAO，以及DAO接口，只是通過Mapper代替過程。不過，道理都是一樣，無非就是新添加一層注入而已。