Mybatis 系列(2)——SSM(spring mvc+spring+Mybatis)框架整合

待我称王封你为后i 2022-08-22 13:28 322阅读 0赞

最近用Idea开发,idea是一款综合的相对较新的Java IDE。Idea支持很多整合功能,我觉得挺好用的。Idea可以校正xml,支持jsp的调试。最让我喜欢的是,写spring配置文件的时候,写的一些路径都可以自己找到。classpath自己有代码的提示,超级的智能。

环境配置

在整合框架之前,先配置一下JER运行环境,配置maven仓库。
1.File——ProjectStructure——Project——New… 选择jdk的安装环境
选择sdk的安装路径

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包

  1. <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">
  2. <modelVersion>4.0.0</modelVersion>
  3. <groupId>com.tgb</groupId>
  4. <artifactId>Order</artifactId>
  5. <packaging>war</packaging>
  6. <version>1.0-SNAPSHOT</version>
  7. <name>Order Maven Webapp</name>
  8. <url>http://maven.apache.org</url>
  9. <properties>
  10. <!-- spring版本号 -->
  11. <spring.version>4.0.2.RELEASE</spring.version>
  12. <!-- mybatis版本号 -->
  13. <mybatis.version>3.2.6</mybatis.version>
  14. <!-- log4j日志文件管理包版本 -->
  15. <slf4j.version>1.7.7</slf4j.version>
  16. <log4j.version>1.2.17</log4j.version>
  17. <project.build.sourceEncoding>
  18. UTF-8
  19. </project.build.sourceEncoding>
  20. </properties>
  21. <dependencies>
  22. <dependency>
  23. <groupId>junit</groupId>
  24. <artifactId>junit</artifactId>
  25. <version>4.11</version>
  26. <!-- 表示开发的时候引入,发布的时候不会加载此包 -->
  27. <scope>test</scope>
  28. </dependency>
  29. <!-- spring核心包 -->
  30. <dependency>
  31. <groupId>org.springframework</groupId>
  32. <artifactId>spring-core</artifactId>
  33. <version>${spring.version}</version>
  34. </dependency>
  35. <dependency>
  36. <groupId>org.springframework</groupId>
  37. <artifactId>spring-web</artifactId>
  38. <version>${spring.version}</version>
  39. </dependency>
  40. <dependency>
  41. <groupId>org.springframework</groupId>
  42. <artifactId>spring-oxm</artifactId>
  43. <version>${spring.version}</version>
  44. </dependency>
  45. <dependency>
  46. <groupId>org.springframework</groupId>
  47. <artifactId>spring-tx</artifactId>
  48. <version>${spring.version}</version>
  49. </dependency>
  50. <dependency>
  51. <groupId>org.springframework</groupId>
  52. <artifactId>spring-jdbc</artifactId>
  53. <version>${spring.version}</version>
  54. </dependency>
  55. <dependency>
  56. <groupId>org.springframework</groupId>
  57. <artifactId>spring-webmvc</artifactId>
  58. <version>${spring.version}</version>
  59. </dependency>
  60. <dependency>
  61. <groupId>org.springframework</groupId>
  62. <artifactId>spring-aop</artifactId>
  63. <version>${spring.version}</version>
  64. </dependency>
  65. <dependency>
  66. <groupId>org.springframework</groupId>
  67. <artifactId>spring-context-support</artifactId>
  68. <version>${spring.version}</version>
  69. </dependency>
  70. <dependency>
  71. <groupId>org.springframework</groupId>
  72. <artifactId>spring-test</artifactId>
  73. <version>${spring.version}</version>
  74. </dependency>
  75. <!-- mybatis核心包 -->
  76. <dependency>
  77. <groupId>org.mybatis</groupId>
  78. <artifactId>mybatis</artifactId>
  79. <version>${mybatis.version}</version>
  80. </dependency>
  81. <!-- mybatis/spring包 -->
  82. <dependency>
  83. <groupId>org.mybatis</groupId>
  84. <artifactId>mybatis-spring</artifactId>
  85. <version>1.2.2</version>
  86. </dependency>
  87. <!-- 导入java ee jar 包 -->
  88. <dependency>
  89. <groupId>javax</groupId>
  90. <artifactId>javaee-api</artifactId>
  91. <version>7.0</version>
  92. </dependency>
  93. <!-- 导入Mysql数据库链接jar包 -->
  94. <dependency>
  95. <groupId>mysql</groupId>
  96. <artifactId>mysql-connector-java</artifactId>
  97. <version>5.1.30</version>
  98. </dependency>
  99. <!-- 导入dbcp的jar包,用来在applicationContext.xml中配置数据库 -->
  100. <dependency>
  101. <groupId>commons-dbcp</groupId>
  102. <artifactId>commons-dbcp</artifactId>
  103. <version>1.2.2</version>
  104. </dependency>
  105. <!-- JSTL标签类 -->
  106. <dependency>
  107. <groupId>jstl</groupId>
  108. <artifactId>jstl</artifactId>
  109. <version>1.2</version>
  110. </dependency>
  111. <!-- 日志文件管理包 -->
  112. <!-- log start -->
  113. <dependency>
  114. <groupId>log4j</groupId>
  115. <artifactId>log4j</artifactId>
  116. <version>${log4j.version}</version>
  117. </dependency>
  118. <!-- 格式化对象,方便输出日志 -->
  119. <dependency>
  120. <groupId>com.alibaba</groupId>
  121. <artifactId>fastjson</artifactId>
  122. <version>1.1.41</version>
  123. </dependency>
  124. <dependency>
  125. <groupId>org.slf4j</groupId>
  126. <artifactId>slf4j-api</artifactId>
  127. <version>${slf4j.version}</version>
  128. </dependency>
  129. <dependency>
  130. <groupId>org.slf4j</groupId>
  131. <artifactId>slf4j-log4j12</artifactId>
  132. <version>${slf4j.version}</version>
  133. </dependency>
  134. <!-- log end -->
  135. <!-- 映入JSON -->
  136. <dependency>
  137. <groupId>org.codehaus.jackson</groupId>
  138. <artifactId>jackson-mapper-asl</artifactId>
  139. <version>1.9.13</version>
  140. </dependency>
  141. <!-- 上传组件包 -->
  142. <dependency>
  143. <groupId>commons-fileupload</groupId>
  144. <artifactId>commons-fileupload</artifactId>
  145. <version>1.3.1</version>
  146. </dependency>
  147. <dependency>
  148. <groupId>commons-io</groupId>
  149. <artifactId>commons-io</artifactId>
  150. <version>2.4</version>
  151. </dependency>
  152. <dependency>
  153. <groupId>commons-codec</groupId>
  154. <artifactId>commons-codec</artifactId>
  155. <version>1.9</version>
  156. </dependency>
  157. </dependencies>
  158. <build>
  159. <finalName>Order</finalName>
  160. </build>
  161. </project>

2.建立jdbc.properties,配置数据库信息

  1. driver=com.mysql.jdbc.Driver
  2. url=jdbc:mysql:///ordersystem
  3. username=root
  4. password=123456
  5. #定义初始连接数
  6. initialSize=0
  7. #定义最大连接数
  8. maxActive=20
  9. #定义最大空闲
  10. maxIdle=20
  11. #定义最小空闲
  12. minIdle=1
  13. #定义最长等待时间
  14. maxWait=60000

3.log4j.properties配置文件

  1. #定义LOG输出级别
  2. log4j.rootLogger=INFO,Console,File
  3. #定义日志输出目的地为控制台
  4. log4j.appender.Console=org.apache.log4j.ConsoleAppender
  5. log4j.appender.Console.Target=System.out
  6. #可以灵活地指定日志输出格式,下面一行是指定具体的格式
  7. log4j.appender.Console.layout = org.apache.log4j.PatternLayout
  8. log4j.appender.Console.layout.ConversionPattern=[%c] - %m%n
  9. #文件大小到达指定尺寸的时候产生一个新的文件
  10. log4j.appender.File = org.apache.log4j.RollingFileAppender
  11. #指定输出目录
  12. log4j.appender.File.File = logs/ssm.log
  13. #定义文件最大大小
  14. log4j.appender.File.MaxFileSize = 10MB
  15. # 输出所以日志,如果换成DEBUG表示输出DEBUG以上级别日志
  16. log4j.appender.File.Threshold = ALL
  17. log4j.appender.File.layout = org.apache.log4j.PatternLayout
  18. log4j.appender.File.layout.ConversionPattern =[%p] [%d{yyyy-MM-dd HH\:mm\:ss}][%c]%m%n

4.建立spring-Mybatis.xml配置文件

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <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/beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.1.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
  3. <!-- 自动扫描 -->
  4. <context:component-scan base-package="com.cn.order" />
  5. <!-- 引入配置文件 -->
  6. <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
  7. <property name="location" value="classpath:jdbc.properties" />
  8. </bean>
  9. <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  10. <property name="driverClassName" value="${driver}" />
  11. <property name="url" value="${url}" />
  12. <property name="username" value="${username}" />
  13. <property name="password" value="${password}" />
  14. <!-- 初始化连接大小 -->
  15. <property name="initialSize" value="${initialSize}"></property>
  16. <!-- 连接池最大数量 -->
  17. <property name="maxActive" value="${maxActive}"></property>
  18. <!-- 连接池最大空闲 -->
  19. <property name="maxIdle" value="${maxIdle}"></property>
  20. <!-- 连接池最小空闲 -->
  21. <property name="minIdle" value="${minIdle}"></property>
  22. <!-- 获取连接最大等待时间 -->
  23. <property name="maxWait" value="${maxWait}"></property>
  24. </bean>
  25. <!-- spring和MyBatis完美整合,不需要mybatis的配置映射文件 -->
  26. <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  27. <property name="dataSource" ref="dataSource" />
  28. <!-- 自动扫描mapping.xml文件 -->
  29. <property name="mapperLocations" value="classpath:com/cn/order/mapping/*.xml"></property>
  30. </bean>
  31. <!-- DAO接口所在包名,Spring会自动查找其下的类 -->
  32. <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  33. <property name="basePackage" value="com.cn.order.dao" />
  34. <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
  35. </bean>
  36. <!-- (事务管理)transaction manager, use JtaTransactionManager for global tx -->
  37. <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  38. <property name="dataSource" ref="dataSource" />
  39. </bean>
  40. </beans>

5.服务层接口 service

  1. package com.cn.order.service;
  2. import com.cn.order.pojo.User;
  3. /** * Created by azz-pc on 2016/5/24. */
  4. public interface IUserService {
  5. User getUserById(int userId);
  6. }

6.服务层实现serviceImpl

  1. package com.cn.order.service.impl;
  2. import javax.annotation.Resource;
  3. import org.springframework.stereotype.Service;
  4. import com.cn.order.dao.IUserDao;
  5. import com.cn.order.pojo.User;
  6. import com.cn.order.service.IUserService;
  7. /** * Created by azz-pc on 2016/5/24. */
  8. @Service("userService")
  9. public class UserServiceImpl implements IUserService {
  10. @Resource
  11. private IUserDao userDao;
  12. public User getUserById(int userId) {
  13. return this.userDao.selectByPrimaryKey(userId);
  14. }
  15. }

7.Junit测试
测试类编写:

  1. package org.zsl.testmybatis;
  2. import javax.annotation.Resource;
  3. import com.cn.order.pojo.*;
  4. import com.cn.order.service.*;
  5. import org.apache.log4j.Logger;
  6. /*import org.apache.log4j.net.SyslogAppender;*/
  7. import org.junit.Test;
  8. import org.junit.runner.RunWith;
  9. import org.springframework.context.ApplicationContext;
  10. import org.springframework.test.context.ContextConfiguration;
  11. import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
  12. @RunWith(SpringJUnit4ClassRunner.class) //表示继承了SpringJUnit4ClassRunner类
  13. @ContextConfiguration(locations = {
  14. "classpath:spring-mybatis.xml"})
  15. public class TestMyBatis {
  16. private static Logger logger = Logger.getLogger(TestMyBatis.class);
  17. private ApplicationContext ac = null;
  18. @Resource
  19. //private IUserService userService = null;
  20. private ICardService cardService=null;
  21. private Card card=new Card();
  22. // @Before
  23. // public void before() {
  24. // ac = new ClassPathXmlApplicationContext("applicationContext.xml");
  25. // userService = (IUserService) ac.getBean("userService");
  26. // }
  27. @Test
  28. public void test1() {
  29. // User user = userService.getUserById(1);
  30. // System.out.println(user.getUsername());
  31. // System.out.println(user.getPassword());
  32. // System.out.println(user.getState());
  33. // logger.info("值:"+user.getUsername());
  34. // logger.info(JSON.toJSONString(user));
  35. card.setCardid("E000010");
  36. card.setPassword("33333");
  37. card.setOwnername("xiaozhou");
  38. card.setCash("10.0");
  39. card.setCardtypeid(1);
  40. card.setStatus("T");
  41. cardService.insert(card);
  42. System.out.println("insert success");
  43. }
  44. }

利用MyBatis Generator自动创建mapping,dao,pojo层,详情参见博客:http://blog.csdn.net/zhou2s_101216/article/details/51175818

这里写图片描述

输出insert success 证明 测试成功。

整合springMVC

1.配置spring-mvc.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <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/beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsd http://www.springframework.org/schema/context http://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">
  3. <!-- 自动扫描该包,使SpringMVC认为包下用了@controller注解的类是控制器 -->
  4. <context:component-scan base-package="com.cn.order.controller"/>
  5. <!--<mvc:default-servlet-handler/>-->
  6. <!--避免IE执行AJAX时,返回JSON出现下载文件 -->
  7. <bean id="mappingJacksonHttpMessageConverter" class="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter">
  8. <property name="supportedMediaTypes">
  9. <list>
  10. <value>text/html;charset=UTF-8</value>
  11. </list>
  12. </property>
  13. </bean>
  14. <!-- 启动SpringMVC的注解功能,完成请求和注解POJO的映射 -->
  15. <bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">
  16. <property name="messageConverters">
  17. <list>
  18. <ref bean="mappingJacksonHttpMessageConverter"/> <!-- JSON转换器 -->
  19. </list>
  20. </property>
  21. </bean>
  22. <!-- 定义跳转的文件的前后缀 ,视图模式配置-->
  23. <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  24. <!-- 这里的配置我的理解是自动给后面action的方法return的字符串加上前缀和后缀,变成一个 可用的url地址 -->
  25. <property name="prefix" value="/WEB-INF/jsp/"/>
  26. <property name="suffix" value=".jsp"/>
  27. </bean>
  28. <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
  29. <!-- 默认编码 -->
  30. <property name="defaultEncoding" value="utf-8"/>
  31. <!-- 文件大小最大值 -->
  32. <property name="maxUploadSize" value="10485760000"/>
  33. <!-- 内存中的最大值 -->
  34. <property name="maxInMemorySize" value="40960"/>
  35. </bean>
  36. <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
  37. <property name="location" value="classpath:jdbc.properties"/>
  38. </bean>
  39. </beans>

2.配置web.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <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">
  3. <display-name>Archetype Created Web Application</display-name>
  4. <!-- Spring和mybatis的配置文件 -->
  5. <context-param>
  6. <param-name>contextConfigLocation</param-name>
  7. <param-value>classpath:spring-mybatis.xml</param-value>
  8. </context-param>
  9. <!-- 编码过滤器 -->
  10. <filter>
  11. <filter-name>encodingFilter</filter-name>
  12. <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
  13. <async-supported>true</async-supported>
  14. <init-param>
  15. <param-name>encoding</param-name>
  16. <param-value>UTF-8</param-value>
  17. </init-param>
  18. </filter>
  19. <filter-mapping>
  20. <filter-name>encodingFilter</filter-name>
  21. <url-pattern>/*</url-pattern>
  22. </filter-mapping>
  23. <!-- Spring监听器 -->
  24. <listener>
  25. <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  26. </listener>
  27. <!-- 防止Spring内存溢出监听器 -->
  28. <listener>
  29. <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
  30. </listener>
  31. <!-- Spring MVC servlet -->
  32. <servlet>
  33. <servlet-name>SpringMVC</servlet-name>
  34. <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  35. <init-param>
  36. <param-name>contextConfigLocation</param-name>
  37. <param-value>classpath:spring-mvc.xml</param-value>
  38. </init-param>
  39. <load-on-startup>1</load-on-startup>
  40. <async-supported>true</async-supported>
  41. </servlet>
  42. <servlet-mapping>
  43. <servlet-name>SpringMVC</servlet-name>
  44. <!-- 此处可以可以配置成*.do,对应struts的后缀习惯 -->
  45. <url-pattern>/</url-pattern>
  46. </servlet-mapping>
  47. <servlet-mapping>
  48. <servlet-name>default</servlet-name>
  49. <url-pattern>*.css</url-pattern>
  50. </servlet-mapping>
  51. <servlet-mapping>
  52. <servlet-name>default</servlet-name>
  53. <url-pattern>*.js</url-pattern>
  54. </servlet-mapping>
  55. <welcome-file-list>
  56. <welcome-file>/index.jsp</welcome-file>
  57. </welcome-file-list>
  58. <!-- 配置SESSION超时,单位是分钟 -->
  59. <session-config>
  60. <session-timeout>15</session-timeout>
  61. </session-config>
  62. </web-app>

3.前台使用的是,spring mvc、bootstrap、angularjs
showUser.jsp

  1. <%@ page language="java" import="java.util.*" pageEncoding="utf-8" %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta name="viewport" content="width=decive-width,initial-scale=1.0"> <title>测试</title> <!--import js in bootstrap--> <script type="text/javascript" src="../lib/js/jquery/jquery.js"></script> <script type="text/javascript" src="../lib/js/bootstrap/bootstrap.min.js"></script> <!--import css in bootstrap--> <link rel="stylesheet" href="../lib/css/bootstrap.min.css"> <!--import angularjs--> <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">测试test</div> </div> <div class="panel-body"> <div class="row"> <div class="col-md-12">${user.username},springmvc OKOK</div> <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 old</p> </div> </div> </div> <div class="panel-footer">footer:made by zhouzhou</div> </div> </body> </html>

运行后结果:
这里写图片描述

到这里,我5天左右搭出来的框架就在这里了~~

中间遇到了springMVC静态文件被拦截的问题,显示nomaping,正常的view访问都显示了404错误。如何你的DispatcherServlet拦截 * .do这样的URL,就不存在访问不到静态资源的问题。如果你的DispatcherServlet拦截“/”,拦截了所有的请求,同时对 .js,.jpg的访问也就被拦截了。为了可以正常访问静态文件,不要找不到静态文件报404。需要在web.xml中配置:

  1. <servlet-mapping>
  2. <servlet-name>default</servlet-name>
  3. <url-pattern>*.css</url-pattern>
  4. </servlet-mapping>
  5. <servlet-mapping>
  6. <servlet-name>default</servlet-name>
  7. <url-pattern>*.js</url-pattern>
  8. </servlet-mapping>

总结

经过了几天的痛苦,最起码搭过了7,8遍才搭出来了。我开始都不知道要发布war包,后来才知道要在tomcat中发布war包,才可以运行出来界面。整个过程虽然有过想放弃但是,还是坚持到了最后。学到很多东西,乐在其中。

发表评论

表情:
评论列表 (有 0 条评论,322人围观)

还没有评论,来说两句吧...

相关阅读