Mybatis 系列（2）——SSM（spring mvc+spring+Mybatis）框架整合
最近用Idea开发，idea是一款综合的相对较新的Java IDE。Idea支持很多整合功能，我觉得挺好用的。Idea可以校正xml，支持jsp的调试。最让我喜欢的是，写spring配置文件的时候，写的一些路径都可以自己找到。classpath自己有代码的提示，超级的智能。
环境配置
在整合框架之前，先配置一下JER运行环境，配置maven仓库。
1.File——ProjectStructure——Project——New… 选择jdk的安装环境
2.File——Settings——Maven——Maven home directory选择自己maven的安装目录。下面是maven管理jar包的地方。
概念
1.spring
Spring目的：就是让对象与对象（模块与模块）之间的关系没有通过代码来关联，都是通过配置类说明管理的，简单的说，不用在代码里写死new某个对象，而是全部在配置文件中进行了配置。Spring是一个容器，凡是在容器里的对象才会有Spring所提供的这些服务和功能。
2.Spring MVC
Spring MVC属于SpringFrameWork的后续产品，已经融合在Spring Web Flow里面。Spring MVC 分离了控制器、模型对象、分派器以及处理程序对象的角色，这种分离让它们更容易进行定制。
3.Mybatis
MyBatis 是支持普通 SQL查询，存储过程和高级映射的优秀持久层框架。MyBatis 消除了几乎所有的JDBC代码和参数的手工设置以及结果集的检索。MyBatis 使用简单的 XML或注解用于配置和原始映射，将接口和 Java 的POJOs（Plain Old Java Objects，普通的 Java对象）映射成数据库中的记录。
spring Mybatis整合
用的框架的版本分别是：
spring版本号 4.0.2.RELEASE
mybatis版本号 3.2.6
Spring MVC版本号 4.0.2 RELEASE
log4j日志文件管理包版本号 {slf4j |1.7.7} { log4j |1.2.17}
项目目录如下：
1.编写pom.xml，引入jar包
<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.0modelVersion><groupId>com.tgbgroupId><artifactId>OrderartifactId><packaging>warpackaging><version>1.0-SNAPSHOTversion><name>Order Maven Webappname><url>http://maven.apache.orgurl><properties><spring.version>4.0.2.RELEASEspring.version><mybatis.version>3.2.6mybatis.version><slf4j.version>1.7.7slf4j.version><log4j.version>1.2.17log4j.version><project.build.sourceEncoding>UTF-8project.build.sourceEncoding>properties><dependencies><dependency><groupId>junitgroupId><artifactId>junitartifactId><version>4.11version><scope>testscope>dependency><dependency><groupId>org.springframeworkgroupId><artifactId>spring-coreartifactId><version>${spring.version}version>dependency><dependency><groupId>org.springframeworkgroupId><artifactId>spring-webartifactId><version>${spring.version}version>dependency><dependency><groupId>org.springframeworkgroupId><artifactId>spring-oxmartifactId><version>${spring.version}version>dependency><dependency><groupId>org.springframeworkgroupId><artifactId>spring-txartifactId><version>${spring.version}version>dependency><dependency><groupId>org.springframeworkgroupId><artifactId>spring-jdbcartifactId><version>${spring.version}version>dependency><dependency><groupId>org.springframeworkgroupId><artifactId>spring-webmvcartifactId><version>${spring.version}version>dependency><dependency><groupId>org.springframeworkgroupId><artifactId>spring-aopartifactId><version>${spring.version}version>dependency><dependency><groupId>org.springframeworkgroupId><artifactId>spring-context-supportartifactId><version>${spring.version}version>dependency><dependency><groupId>org.springframeworkgroupId><artifactId>spring-testartifactId><version>${spring.version}version>dependency><dependency><groupId>org.mybatisgroupId><artifactId>mybatisartifactId><version>${mybatis.version}version>dependency><dependency><groupId>org.mybatisgroupId><artifactId>mybatis-springartifactId><version>1.2.2version>dependency><dependency><groupId>javaxgroupId><artifactId>javaee-apiartifactId><version>7.0version>dependency><dependency><groupId>mysqlgroupId><artifactId>mysql-connector-javaartifactId><version>5.1.30version>dependency><dependency><groupId>commons-dbcpgroupId><artifactId>commons-dbcpartifactId><version>1.2.2version>dependency><dependency><groupId>jstlgroupId><artifactId>jstlartifactId><version>1.2version>dependency><dependency><groupId>log4jgroupId><artifactId>log4jartifactId><version>${log4j.version}version>dependency><dependency><groupId>com.alibabagroupId><artifactId>fastjsonartifactId><version>1.1.41version>dependency><dependency><groupId>org.slf4jgroupId><artifactId>slf4j-apiartifactId><version>${slf4j.version}version>dependency><dependency><groupId>org.slf4jgroupId><artifactId>slf4j-log4j12artifactId><version>${slf4j.version}version>dependency><dependency><groupId>org.codehaus.jacksongroupId><artifactId>jackson-mapper-aslartifactId><version>1.9.13version>dependency><dependency><groupId>commons-fileuploadgroupId><artifactId>commons-fileuploadartifactId><version>1.3.1version>dependency><dependency><groupId>commons-iogroupId><artifactId>commons-ioartifactId><version>2.4version>dependency><dependency><groupId>commons-codecgroupId><artifactId>commons-codecartifactId><version>1.9version>dependency>dependencies><build><finalName>OrderfinalName>build>
project>
2.建立jdbc.properties，配置数据库信息
driver=com.mysql.jdbc.Driver
url=jdbc:mysql:///ordersystem
username=root
password=123456
#定义初始连接数
initialSize=0
#定义最大连接数
maxActive=20
#定义最大空闲
maxIdle=20
#定义最小空闲
minIdle=1
#定义最长等待时间
maxWait=600003.log4j.properties配置文件
#定义LOG输出级别
log4j.rootLogger=INFO,Console,File
#定义日志输出目的地为控制台
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.Target=System.out
#可以灵活地指定日志输出格式，下面一行是指定具体的格式
log4j.appender.Console.layout = org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=[%c] - %m%n#文件大小到达指定尺寸的时候产生一个新的文件
log4j.appender.File = org.apache.log4j.RollingFileAppender
#指定输出目录
log4j.appender.File.File = logs/ssm.log
#定义文件最大大小
log4j.appender.File.MaxFileSize = 10MB
# 输出所以日志，如果换成DEBUG表示输出DEBUG以上级别日志
log4j.appender.File.Threshold = ALL
log4j.appender.File.layout = org.apache.log4j.PatternLayout
log4j.appender.File.layout.ConversionPattern =[%p] [%d{yyyy-MM-dd HH\:mm\:ss}][%c]%m%n4.建立spring-Mybatis.xml配置文件
<beans xmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"xmlns:context="http://www.springframework.org/schema/context"xmlns:mvc="http://www.springframework.org/schema/mvc"xsi:schemaLocation="http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans-3.1.xsdhttp://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context-3.1.xsdhttp://www.springframework.org/schema/mvchttp://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd"><context:component-scan base-package="com.cn.order" /><bean id="propertyConfigurer"class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"><property name="location" value="classpath:jdbc.properties" />bean><bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"destroy-method="close"><property name="driverClassName" value="${driver}" /><property name="url" value="${url}" /><property name="username" value="${username}" /><property name="password" value="${password}" /><property name="initialSize" value="${initialSize}">property><property name="maxActive" value="${maxActive}">property><property name="maxIdle" value="${maxIdle}">property><property name="minIdle" value="${minIdle}">property><property name="maxWait" value="${maxWait}">property>bean><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSource" /><property name="mapperLocations" value="classpath:com/cn/order/mapping/*.xml">property>bean><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="basePackage" value="com.cn.order.dao" /><property name="sqlSessionFactoryBeanName" value="sqlSessionFactory">property>bean><bean id="transactionManager"class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSource" />bean>beans>5.服务层接口 service
package com.cn.order.service;import com.cn.order.pojo.User;
/*** Created by azz-pc on 2016/5/24.*/
public interface IUserService {User getUserById(int userId);
}
6.服务层实现serviceImpl
package com.cn.order.service.impl;import javax.annotation.Resource;import org.springframework.stereotype.Service;import com.cn.order.dao.IUserDao;
import com.cn.order.pojo.User;
import com.cn.order.service.IUserService;/*** Created by azz-pc on 2016/5/24.*/
@Service("userService")
public class UserServiceImpl implements IUserService {@Resource private IUserDao userDao;public User getUserById(int userId) {return this.userDao.selectByPrimaryKey(userId);}}
7.Junit测试
测试类编写：
package org.zsl.testmybatis;import javax.annotation.Resource;import com.cn.order.pojo.*;
import com.cn.order.service.*;
import org.apache.log4j.Logger;
/*import org.apache.log4j.net.SyslogAppender;*/
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.context.ApplicationContext;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;@RunWith(SpringJUnit4ClassRunner.class) //表示继承了SpringJUnit4ClassRunner类
@ContextConfiguration(locations = {"classpath:spring-mybatis.xml"})
public class TestMyBatis {private static Logger logger = Logger.getLogger(TestMyBatis.class);private ApplicationContext ac = null;@Resource//private IUserService userService = null;private ICardService cardService=null;private Card card=new Card();
// @Before
// public void before() {
// ac = new ClassPathXmlApplicationContext("applicationContext.xml");
// userService = (IUserService) ac.getBean("userService");
// }@Testpublic void test1() {
// User user = userService.getUserById(1);
// System.out.println(user.getUsername());
// System.out.println(user.getPassword());
// System.out.println(user.getState());
// logger.info("值："+user.getUsername());
// logger.info(JSON.toJSONString(user));card.setCardid("E000010");card.setPassword("33333");card.setOwnername("xiaozhou");card.setCash("10.0");card.setCardtypeid(1);card.setStatus("T");cardService.insert(card);System.out.println("insert success");}
}
利用MyBatis Generator自动创建mapping，dao，pojo层，详情参见博客：http://blog.csdn.net/zhou2s_101216/article/details/51175818
输出insert success 证明 测试成功。
整合springMVC
1.配置spring-mvc.xml
<beans xmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:context="http://www.springframework.org/schema/context"xmlns:mvc="http://www.springframework.org/schema/mvc"xsi:schemaLocation="http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans-3.1.xsdhttp://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context-3.1.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd"><context:component-scan base-package="com.cn.order.controller"/><bean id="mappingJacksonHttpMessageConverter"class="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter"><property name="supportedMediaTypes"><list><value>text/html;charset=UTF-8value>list>property>bean><bean
class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter"><property name="messageConverters"><list><ref bean="mappingJacksonHttpMessageConverter"/> list>property>bean><bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"><property name="prefix" value="/WEB-INF/jsp/"/><property name="suffix" value=".jsp"/>bean><bean id="multipartResolver"class="org.springframework.web.multipart.commons.CommonsMultipartResolver"><property name="defaultEncoding" value="utf-8"/><property name="maxUploadSize" value="10485760000"/><property name="maxInMemorySize" value="40960"/>bean><bean id="propertyConfigurer"class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"><property name="location" value="classpath:jdbc.properties"/>bean>beans>2.配置web.xml
<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"><display-name>Archetype Created Web Applicationdisplay-name><context-param><param-name>contextConfigLocationparam-name><param-value>classpath:spring-mybatis.xmlparam-value>context-param><filter><filter-name>encodingFilterfilter-name><filter-class>org.springframework.web.filter.CharacterEncodingFilterfilter-class><async-supported>trueasync-supported><init-param><param-name>encodingparam-name><param-value>UTF-8param-value>init-param>filter><filter-mapping><filter-name>encodingFilterfilter-name><url-pattern>/*url-pattern>filter-mapping><listener><listener-class>org.springframework.web.context.ContextLoaderListenerlistener-class>listener><listener><listener-class>org.springframework.web.util.IntrospectorCleanupListenerlistener-class>listener><servlet><servlet-name>SpringMVCservlet-name><servlet-class>org.springframework.web.servlet.DispatcherServletservlet-class><init-param><param-name>contextConfigLocationparam-name><param-value>classpath:spring-mvc.xmlparam-value>init-param><load-on-startup>1load-on-startup><async-supported>trueasync-supported>servlet><servlet-mapping><servlet-name>SpringMVCservlet-name><url-pattern>/url-pattern>servlet-mapping><servlet-mapping><servlet-name>defaultservlet-name><url-pattern>*.cssurl-pattern>servlet-mapping><servlet-mapping><servlet-name>defaultservlet-name><url-pattern>*.jsurl-pattern>servlet-mapping><welcome-file-list><welcome-file>/index.jspwelcome-file>welcome-file-list><session-config><session-timeout>15session-timeout>session-config>web-app>
3.前台使用的是，spring mvc、bootstrap、angularjs
showUser.jsp
<%@ page language="java" import="java.util.*" pageEncoding="utf-8" %>
<html>
<head><meta name="viewport" content="width=decive-width,initial-scale=1.0"><title>测试title><script type="text/javascript" src="../lib/js/jquery/jquery.js">script><script type="text/javascript" src="../lib/js/bootstrap/bootstrap.min.js">script><link rel="stylesheet" href="../lib/css/bootstrap.min.css"><script type="text/javascript" src="../lib/js/angular/angular.js">script>
head><body><div class="panel panel-primary"><div class="panel-heading"><div class="panel-title">测试testdiv>div><div class="panel-body"><div class="row"><div class="col-md-12">${user.username}，springmvc OKOKdiv><div ng-app="" ng-init="old='22'"><p>Input how old are you：<input type="text" ng-model="old">p><p>You wrote: you are {{old}} years oldp>div>div>div><div class="panel-footer">footer:made by zhouzhoudiv>
div>body>
html>
运行后结果：
到这里，我5天左右搭出来的框架就在这里了~~
中间遇到了springMVC静态文件被拦截的问题，显示nomaping，正常的view访问都显示了404错误。如何你的DispatcherServlet拦截 * .do这样的URL，就不存在访问不到静态资源的问题。如果你的DispatcherServlet拦截“/”，拦截了所有的请求，同时对 .js,.jpg的访问也就被拦截了。为了可以正常访问静态文件，不要找不到静态文件报404。需要在web.xml中配置：
<servlet-mapping><servlet-name>defaultservlet-name><url-pattern>*.cssurl-pattern>servlet-mapping><servlet-mapping><servlet-name>defaultservlet-name><url-pattern>*.jsurl-pattern>servlet-mapping>总结
经过了几天的痛苦，最起码搭过了7，8遍才搭出来了。我开始都不知道要发布war包，后来才知道要在tomcat中发布war包，才可以运行出来界面。整个过程虽然有过想放弃但是，还是坚持到了最后。学到很多东西，乐在其中。
本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！