SpringMVC+Spring+Mybatis整合 druid连接池声明式事务 maven配置

17-01-06 来源：[db:作者]

收藏我要投稿

SpringMVC+Spring+Mybatis整合 druid连接池声明式事务 maven配置：一直对springmvc和mybatis挺怀念的，最近想自己再搭建下框架，然后写点什么。

暂时没有整合缓存，druid也没有做ip地址的过滤。Spring的AOP简单配置了下，也还没具体弄，不知道能不能用，log也不知道能不能用，有点不负责任。

2014-08-12 23:45补：

=================开始=================

1、增加quartz :http://www.cnblogs.com/acehalo/p/3902731.html

2、mybatis添加ehcache缓存：http://www.cnblogs.com/acehalo/p/3902883.html

3、spring的aop: http://www.cnblogs.com/acehalo/p/3905718.html

=================结束================

直接上代码：

使用的eclipse和eclipse自带的maven，参考了网上的资料，有些代码是拷贝的，不过都自己测试过了。嗯，可以跑起来...

先上项目结构：

新建maven项目，选择web，然后配置pom：


    4.0.0
    ACE
    Test
    war
    0.0.1-SNAPSHOT
    Test Maven Webapp
    http://maven.apache.org

    
        4.0.0.M2
        1.6.1
    

    
        
            junit
            junit
            3.8.1
            test
        

        
        
            javax.servlet
            servlet-api
            2.5
            provided
        
        
            javax.servlet.jsp
            jsp-api
            2.1
            provided
        
        
            javax.servlet
            jstl
            1.2
        

        
        
            mysql
            mysql-connector-java
            5.1.26
        


        

        
            org.springframework
            spring-aop
            ${org.springframework.version}
        
        
            org.springframework
            spring-aspects
            ${org.springframework.version}
        
        
            org.springframework
            spring-beans
            ${org.springframework.version}
        

        
            org.springframework
            spring-context
            ${org.springframework.version}
            
                
                    commons-logging
                    commons-logging
                
            
        
        
            org.springframework
            spring-context-support
            ${org.springframework.version}
        
        
            org.springframework
            spring-core
            ${org.springframework.version}
        
        
            org.springframework
            spring-expression
            ${org.springframework.version}
        
        
            org.springframework
            spring-instrument
            ${org.springframework.version}
        
        
            org.springframework
            spring-instrument-tomcat
            ${org.springframework.version}
        
        
            org.springframework
            spring-jdbc
            ${org.springframework.version}
        
        
            org.springframework
            spring-jms
            ${org.springframework.version}
        
        
            org.springframework
            spring-orm
            ${org.springframework.version}
        
        
            org.springframework
            spring-oxm
            ${org.springframework.version}
        
        
            org.springframework
            spring-test
            ${org.springframework.version}
        
        
            org.springframework
            spring-tx
            ${org.springframework.version}
        
        
            org.springframework
            spring-web
            ${org.springframework.version}
        

        
            org.springframework
            spring-webmvc
            ${org.springframework.version}
        
        
            org.springframework
            spring-webmvc-portlet
            ${org.springframework.version}
        
        
            org.springframework
            spring-websocket
            ${org.springframework.version}
        

        
        
            org.mybatis
            mybatis
            3.2.2
        
        
            org.mybatis
            mybatis-spring
            1.2.0
        
        
        
            org.slf4j
            slf4j-api
            ${org.slf4j.version}
        
        
            org.slf4j
            jcl-over-slf4j
            ${org.slf4j.version}
            runtime
        

        
            log4j
            log4j
            1.2.16
            runtime
        


    
      
        com.alibaba  
        druid  
        1.0.7  


    

    
    
        
        
            org.jboss.repository.release
            JBoss Maven Release Repository
            https://repository.jboss.org/nexus/content/repositories/releases
            
                false
            
        
        
            org.springsource.maven.snapshot
            SpringSource Maven Central-compatible Snapshot Repository
            http://maven.springframework.org/snapshot
            
                daily
            
        
        
            spring-milestone
            Spring Maven MILESTONE Repository
            http://maven.springframework.org/milestone
        
        
            standard repo
            http://repo1.maven.org/maven2
        
        
            mirror repo
            http://mirrors.ibiblio.org/pub/mirrors/maven2
        
        
            com.springsource.repository.bundles.release
            SpringSource Enterprise Bundle Repository - SpringSource Bundle Releases
            http://repository.springsource.com/maven/bundles/release
        
        
            com.springsource.repository.bundles.external
            SpringSource Enterprise Bundle Repository - External Bundle Releases
            http://repository.springsource.com/maven/bundles/external
        
        
            sqlfire-release
            http://dist.gemstone.com/maven/release
        
    


    
        Test

web.xml:







    
    
        characterEncodingFilter
        org.springframework.web.filter.CharacterEncodingFilter
        
            encoding
            UTF-8
        
        
            forceEncoding
            true
        
    
    
        characterEncodingFilter
        /*
    

    
    
        org.springframework.web.context.request.RequestContextListener
    

    
    
        Test
        org.springframework.web.servlet.DispatcherServlet
        
            contextConfigLocation
            classpath*:applicationContext.xml
        
        1
    
    
        Test
        *.do
    
    
        404
        /error/404.jsp
    

    
    
        DruidStatView
        com.alibaba.druid.support.http.StatViewServlet
    
    
        DruidStatView
        /druid/*

applicationContext.xml:




    
    
    
    
    
    
    
    



    
        
        
        
            
                classpath:log4j.xml

spring-mvc.xml:

spring-aop.xml:

spring-database.xml:






    
    
    
        
        
        
        


        
        
        
        
        
        
        
        


        SELECT 1 
        
        
        

        
        
        
        

        
        
        
        
        
        

        
        
        
    

    
    
    
    
        
            
                com.hi.test.service.*

mybatis-config.xml:

log4j.xml:

commons-logging.properties:

org.apache.commons.logging.Log=org.apache.commons.logging.impl.Log4JLogger

IndexController:

package com.hi.test.controller;

import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import com.hi.test.bean.User;
import com.hi.test.mapper.UserMapper;
import com.hi.test.service.TxTestService;


@Controller
public class IndexController {

    @Autowired
    UserMapper userMapper;
    
    @Autowired
    TxTestService txTestService;
    
    @RequestMapping(value = "/index")
    public String index(HttpServletRequest request,Map model) {
        //String name=request.getParameter("name");
        //model.put("name", name);
 
        User u=new User();  
        u.setUsername("admin");  
        u.setPassword("admin");  
        User user=userMapper.selectUser(u);    
        model.put("user", user);
        return "hi";
    }
    
    @RequestMapping(value = "/text")
    @ResponseBody
    public String text(HttpServletRequest request) {

 
        
        return "{\"what\":\"hi\"}";
    }
    
    @RequestMapping(value = "/indexList")
    public String indexList(HttpServletRequest request,Map model) {

 
        List userList=userMapper.selectUserLsit();
        model.put("userList", userList);
        
         return "hiList";
    }
    
    @RequestMapping(value = "/TxTest")
    @ResponseBody
    public String test(HttpServletRequest request) {

 
        txTestService.insert();
        
        return "";
    }
}

User:

package com.hi.test.bean;

public class User {
     private int id;  
        private String username;  
        private String password;  
        public User(){  
              
        }  
        public int getId() {  
            return id;  
        }  
        public void setId(int id) {  
            this.id = id;  
        }  
        public String getUsername() {  
            return username;  
        }  
        public void setUsername(String username) {  
            this.username = username;  
        }  
        public String getPassword() {  
            return password;  
        }  
        public void setPassword(String password) {  
            this.password = password;  
        }  
        public String toString(){  
             return "User [id = "+ id +" , username = "+ username +"]" + " , password = "+ password;  
        }  
}

UserMapper:

package com.hi.test.mapper;

import java.util.List;

import org.springframework.stereotype.Repository;

import com.hi.test.bean.User;

@Repository
public interface  UserMapper {
    public User selectUser(User user);  
    public void insertUser(User user);  
    public void updateUser(User user);  
    public void deleteUser(int userId);
    public List selectUserLsit();
}

UserMapper.xml:

  
  
  

  
          
          
          
      


  
  
   INSERT INTO user (id,username,password) VALUES (#{id},#{username},#{password})  
  
  
    UPDATE user SET password=#{password} WHERE id=#{id}  
  
  
    DELETE FROM user WHERE id=#{userId}

TxTestService:

package com.hi.test.service;

import java.util.UUID;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import com.hi.test.bean.User;
import com.hi.test.mapper.UserMapper;

@Transactional
@Service
public class TxTestService {

    @Autowired
    UserMapper userMapper;

    public void insert() {
        for (int i = 0; i < 100; i++) {
            User u = new User();
            u.setUsername(UUID.randomUUID().toString());
            u.setPassword(UUID.randomUUID().toString());
            userMapper.insertUser(u);
        }
        
        
        throw new RuntimeException();
    }
    
    
}

sql文件,navicat导出的:

/*
Navicat MySQL Data Transfer

Source Server         : MySQL
Source Server Version : 50704
Source Host           : localhost:3306
Source Database       : mydb

Target Server Type    : MYSQL
Target Server Version : 50704
File Encoding         : 65001

Date: 2014-08-09 23:52:32
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=902 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'admin', 'admin');

index.jsp：

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

hi.jsp:

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

this is springmvc,${user.username }

hiList.jsp:

<%@ page isELIgnored="false"%>  
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
 <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>

${user.username}----${user.password}

======================================================================================

OK，代码贴完了，项目上右键，debug on server应该就能跑起来了。

几个链接可以查看效果：druid的监控信息：http://localhost:8080/Test/druid/sql.html

http://localhost:8080/Test/

http://localhost:8080/Test/text.do

http://localhost:8080/Test/indexList.do

http://localhost:8080/Test/TxTest.do

现在简单讲讲，配置文件里面有注释就不说了：

一：在配置文件添加事务的时候遇到tx标签没用，在xsi:schemaLocation这里添加两行

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

就可以了。

二：还遇到EL表达式不能用，然后

web.xml修改:

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
version="2.5">

jsp增加:
<%@ page isELIgnored="false"%>

三：还有c:forEach这种标签不能用

在JSP上增加

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

就可以了

四：spring事务这里

数据库是mysql ，然后表引擎是InnoDB

用navicat在design table---option--engine可以看到

访问http://localhost:8080/Test/TxTest.do之后会出现异常，这个异常是手动抛出的，数据库也没有插入数据。

然后将表的引擎换成MyISAM，保存

之后再访问http://localhost:8080/Test/TxTest.do，发现数据库被插入数据了。

说明：Spring的这个声明事务能使用，MyISAM不支持事务。

五：Controller里的四个方法

第一个方法是一般的测试。

第二个方法是想测试返回json的，主要是@ResponseBody标签。

第三个方法测试LIST。

第四个是测试事务的。

点击复制链接与好友分享!回本站首页

SpringMVC+Spring+Mybatis整合 druid连接池 声明式事务 maven配置

SpringMVC+Spring+Mybatis整合 druid连接池声明式事务 maven配置