整合Spring+SpringMVC+Mybatis+Maven+Mysql

来源：互联网发布：送礼物的淘宝店铺编辑：程序博客网时间：2024/05/19 21:16

Spring+SpringMVC+Mybatis+Maven+Mysql

一、创建Maven项目

详情见博客：IntelliJ IDEA 创建Maven 工程

创建完成此时的包结构目录：

这里写图片描述

此时在WEB-INF下已经有一个log4j.xml配置文件，查看此文件内容可以看到已经自动对log4j进行了一些基本配置。不过这里我们采用log4j.properties方式来配置log4j。log4j相关用法参考另一篇博客：log4j的知识点以及相关报错问题解决办法。

本项目的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>  <packaging>war</packaging>  <name>MistraRSSSMMM</name>  <groupId>com.sm</groupId>  <artifactId>MistraRSSSMMM</artifactId>  <version>1.0-SNAPSHOT</version>  <properties>    <file.encoding>UTF-8</file.encoding>    <spring.version>3.2.0.RELEASE</spring.version>    <mysql.version>5.1.29</mysql.version>    <servlet.version>3.0-alpha-1</servlet.version>    <aspectj.version>1.8.1</aspectj.version>    <commons-codec.version>1.9</commons-codec.version>    <commons-dbcp.version>1.4</commons-dbcp.version>    <jetty.version>8.1.8.v20121106</jetty.version>    <slf4j.version>1.7.5</slf4j.version>    <testng.version>6.8.7</testng.version>  </properties>  <build>    <plugins>      <plugin>        <groupId>org.apache.tomcat.maven</groupId>        <artifactId>tomcat6-maven-plugin</artifactId>        <version>2.1</version>        <configuration>          <url>http://localhost:8080/manager</url>          <server>Tomcat6</server>          <port>8080</port>          <path>/mistrasssmmm</path>        </configuration>      </plugin>      <plugin>        <groupId>org.apache.maven.plugins</groupId>        <artifactId>maven-surefire-plugin</artifactId>        <version>2.17</version>        <configuration>          <parallel>methods</parallel>          <threadCount>10</threadCount>        </configuration>      </plugin>      <!-- mybatisn逆向工程插件 -->      <plugin>        <groupId>org.mybatis.generator</groupId>        <artifactId>mybatis-generator-maven-plugin</artifactId>        <version>1.3.2</version>        <configuration>          <!--配置文件的位置-->          <configurationFile>src/main/resources/generatorConfig.xml</configurationFile>          <verbose>true</verbose>          <overwrite>true</overwrite>        </configuration>        <executions>          <execution>            <id>Generate MyBatis Artifacts</id>            <goals>              <goal>generate</goal>            </goals>          </execution>        </executions>        <dependencies>          <dependency>            <groupId>org.mybatis.generator</groupId>            <artifactId>mybatis-generator-core</artifactId>            <version>1.3.2</version>          </dependency>        </dependencies>      </plugin>    </plugins>  </build>  <dependencies>    <!-- 依赖的spring 类库-->    <dependency>      <groupId>org.springframework</groupId>      <artifactId>spring-beans</artifactId>      <version>${spring.version}</version>    </dependency>    <dependency>      <groupId>org.springframework</groupId>      <artifactId>spring-context</artifactId>      <version>${spring.version}</version>    </dependency>    <dependency>      <groupId>org.springframework</groupId>      <artifactId>spring-context-support</artifactId>      <version>${spring.version}</version>    </dependency>    <dependency>      <groupId>org.springframework</groupId>      <artifactId>spring-jdbc</artifactId>      <version>${spring.version}</version>    </dependency>    <dependency>      <groupId>org.springframework</groupId>      <artifactId>spring-webmvc</artifactId>      <version>${spring.version}</version>    </dependency>    <dependency>      <groupId>org.springframework</groupId>      <artifactId>spring-web</artifactId>      <version>${spring.version}</version>    </dependency>    <dependency>      <groupId>org.springframework</groupId>      <artifactId>spring-aop</artifactId>      <version>${spring.version}</version>    </dependency>    <dependency>      <groupId>org.springframework</groupId>      <artifactId>spring-test</artifactId>      <version>${spring.version}</version>      <scope>test</scope>    </dependency>    <!-- mybatis-spring -->    <dependency>      <groupId>org.mybatis</groupId>      <artifactId>mybatis-spring</artifactId>      <version>1.3.0</version>    </dependency>    <!-- mybatis核心 -->    <dependency>      <groupId>org.mybatis</groupId>      <artifactId>mybatis</artifactId>      <version>3.4.1</version>    </dependency>    <dependency>      <groupId>org.apache.ibatis</groupId>      <artifactId>ibatis-sqlmap</artifactId>      <version>2.3.0</version>    </dependency>    <dependency>      <groupId>org.apache.ibatis</groupId>      <artifactId>ibatis-core</artifactId>      <version>3.0</version>    </dependency>    <!--依赖的连接池类库-->    <dependency>      <groupId>commons-dbcp</groupId>      <artifactId>commons-dbcp</artifactId>      <version>1.4</version>    </dependency>    <!--依赖的数据库驱动类-->    <dependency>      <groupId>mysql</groupId>      <artifactId>mysql-connector-java</artifactId>      <version>${mysql.version}</version>    </dependency>    <!--log4j-->    <dependency>      <groupId>log4j</groupId>      <artifactId>log4j</artifactId>      <version>1.2.17</version>    </dependency>    <!--jstl-->    <dependency>      <groupId>jstl</groupId>      <artifactId>jstl</artifactId>      <version>1.2</version>    </dependency>    <dependency>      <groupId>org.aspectj</groupId>      <artifactId>aspectjweaver</artifactId>      <version>${aspectj.version}</version>    </dependency>    <dependency>      <groupId>org.codehaus.jackson</groupId>      <artifactId>jackson-mapper-asl</artifactId>      <version>1.9.11</version>    </dependency>    <!--依赖的测试类库-->    <dependency>      <groupId>org.testng</groupId>      <artifactId>testng</artifactId>      <version>${testng.version}</version>      <scope>test</scope>    </dependency>    <dependency>      <groupId>org.apache.maven.plugins</groupId>      <artifactId>maven-clean-plugin</artifactId>      <version>2.5</version>    </dependency>  </dependencies></project>

各个包的版本真的很重要，有时候一个包版本不匹配就会报些奇怪的错误，要是想使用不同版本的包就只能自己慢慢调了。

创建好相应的包结构：

这里写图片描述

创建数据库：创建一张有：用户名、密码字段的user表就好了。

二、整合

1、在src/main/resources下创建jdbc.properties和log4j.properties

jdbc.properties

db.driver=com.mysql.jdbc.Driverdb.url=jdbc:mysql://localhost:3306/ssmintroduction?useUnicode=true&characterEncoding=utf8db.username=rootdb.password=123456

log4j.properties

# Global logging configurationlog4j.rootLogger=DEBUG,out# Console output...log4j.appender.out=org.apache.log4j.ConsoleAppenderlog4j.appender.out.layout=org.apache.log4j.PatternLayoutlog4j.appender.out.layout.ConversionPattern=%d{HH:mm:ss} %-5p [%F\:%L] -- %m%nlog4j.logger.org.apache=INFO

2、在src/main/resources下创建generatorConfig.xml

在pom.xml里面已经加入了mybatis-generator-maven-plugin插件。运用Mybatis逆向工程生成映射类mapper.java、po、mapper.xml文件到对应的包。相关博客：Mybatis逆向工程Generator。这里踩了坑。在maven里面使用这个插件有个痛点就是每次启动Tomcat的时候这个插件都会执行一次，生成相应的文件。po类等文件都能覆盖掉，但是不会覆盖*.xml文件。相当于把里面的代码copy了一次追加在后面。

这里写图片描述

这时候启动就会报错：java.lang.IllegalArgumentException: Result Maps collection already contains value for com.sm.mapper.UserMapper.BaseResultMap
网上有相关博客和解决办法：
mybatis-generator重新生成代码时的SQL映射文件覆盖
Mybatis code generator1.3.4版本 XML 文件重新生成不会覆盖原文件
我这里是创建好依赖，写好配置文件generatorConfig.xml之后，在Maven-Projects里面手动执行了一次mybatis-generator:generate，生成相应文件之后我就把pom.xml里面的gengerator依赖注释掉了。相当于就用一次，这里写demo倒是无关紧要。推荐还是自己写个逆向工程的工具项目，这样有需要就跑一次，copy过来就好了。

generatorConfig.xml

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd"><generatorConfiguration>    <!-- 指定数据库连接驱动地址 -->    <classPathEntry location="D:\jarPackage\mysqlforjdbc\mysql-connector-java-5.1.7-bin.jar" />    <!-- 一个数据库一个 context -->    <context id="testTables" targetRuntime="MyBatis3">        <commentGenerator>            <!-- 将不会向任何生成的元素添加注释 -->            <property name="suppressAllComments" value="true"/>            <property name="suppressDate" value ="true"/>        </commentGenerator>        <!--数据库连接的信息：驱动类、连接地址、用户名、密码 -->        <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost/ssmintroduction" userId="root" password="123456">        </jdbcConnection>        <!-- 默认false，把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer，为 true时把JDBC DECIMAL 和            NUMERIC 类型解析为java.math.BigDecimal -->        <javaTypeResolver>            <property name="forceBigDecimals" value="false" />        </javaTypeResolver>        <!-- targetProject:生成PO类的位置 -->        <javaModelGenerator targetPackage="com.sm.po" targetProject="src/main/java">            <!-- enableSubPackages:是否让schema作为包的后缀 -->            <property name="enableSubPackages" value="false" />            <!-- 从数据库返回的值被清理前后的空格 -->            <property name="trimStrings" value="true" />        </javaModelGenerator>        <!-- targetProject:mapper.xml映射文件生成的位置 -->        <sqlMapGenerator targetPackage="com.sm.mapper" targetProject="src/main/resources">            <!-- enableSubPackages:是否让schema作为包的后缀 -->            <property name="enableSubPackages" value="false" />        </sqlMapGenerator>        <!-- targetPackage：mapper接口生成的位置 -->        <javaClientGenerator type="XMLMAPPER" targetPackage="com.sm.mapper" targetProject="src/main/java">            <!-- enableSubPackages:是否让schema作为包的后缀 -->            <property name="enableSubPackages" value="false" />        </javaClientGenerator>        <!-- 指定数据库表 -->        <table tableName="user" domainObjectName="User"></table>        <!-- 有些表的字段需要指定java类型         <table schema="" tableName="">            <columnOverride column="" javaType="" />        </table> -->    </context></generatorConfiguration>

这里有个坑爹的地方就是要自己指定本地的数据库连接驱动jar包，配置中的< classPathEntry / >标签。
上面配置的输出文件的位置很重要，mapper.xml一定要输出在resources下面，并且包结构要和UserMapper.java所在包结构一样。
双击：

这里写图片描述

就会发现指定包下已经生成了User.java等文件：

这里写图片描述

3、开发controller、service、serviceImpl

UserService.java

package com.sm.service;import com.sm.po.User;/** * Created by Mistra.WR on 2017/11/10/010. */public interface UserService {    int insertSelective(User user);}

UserServiceImpl.java

package com.sm.serviceimpl;import com.sm.mapper.UserMapper;import com.sm.po.User;import com.sm.service.UserService;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;/** * Created by Mistra.WR on 2017/11/10/010. */@Servicepublic class UserServiceImpl implements UserService{    @Autowired    private UserMapper userMapperDao;    public int insertSelective(User user) {        return userMapperDao.insertSelective(user);    }}

UserAddController.java

package com.sm.controller;import com.sm.po.User;import com.sm.service.UserService;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.ui.Model;import org.springframework.web.bind.annotation.RequestMapping;/** * Created by Mistra.WR on 2017/11/10/010. */@Controller@RequestMapping("/userAdd")public class UserAddController {    @Autowired    private UserService userService;    @RequestMapping("/index.do")    public String addPage(){        return "addUser";    }    @RequestMapping("/userAdd.do")    public String UserAdd(User user, Model model){        if(userService.insertSelective(user)>0){            model.addAttribute("successMsg", "注册成功！");            model.addAttribute("name", user.getUsername());            return "success";//返回的页面        }else{            model.addAttribute("failMsg", "注册失败！");            return "fail";        }    }}

4、在src/main/resources下创建mybatis的配置文件mybatis-config.xml

这个配置文件相当于用来给实体类定义别名。

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>    <typeAliases>        <typeAlias alias="user" type="com.sm.po.User"/>    </typeAliases></configuration>

5、在src/main/resources下创建spring-mybatis.xml

spring和mybatis整合的重要文件。

<?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:p="http://www.springframework.org/schema/p"       xmlns:c="http://www.springframework.org/schema/c"       xmlns:util="http://www.springframework.org/schema/util"       xmlns:aop="http://www.springframework.org/schema/aop"       xmlns:mvc="http://www.springframework.org/schema/mvc"       xmlns:tx="http://www.springframework.org/schema/tx"       xmlns:context="http://www.springframework.org/schema/context"       xmlns:ehcache="http://www.springmodules.org/schema/ehcache"       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsd        http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-3.1.xsd        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-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-3.1.xsd        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.1.xsd        http://www.springmodules.org/schema/ehcache http://www.springmodules.org/schema/cache/springmodules-ehcache.xsd">    <!--引入属性文件-->    <context:property-placeholder location="classpath:jdbc.properties" />    <!-- 配置数据源 -->    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">        <property name="driverClassName" value="${db.driver}" />        <property name="url" value="${db.url}" />        <property name="username" value="${db.username}" />        <property name="password" value="${db.password}" />    </bean>    <!-- myBatis文件 -->    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">        <property name="dataSource" ref="dataSource" />        <!-- 自动扫描entity目录, 省掉Configuration.xml里的手工配置 -->        <property name="configLocation" value="classpath:mybatis-config.xml" />        <property name="mapperLocations" value="classpath*:com/sm/mapper/*.xml" />    </bean>    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">        <property name="basePackage"  value="com.sm.mapper" />        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />    </bean>    <!-- 配置事务管理器 -->    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">        <property name="dataSource" ref="dataSource" />    </bean>    <!-- 配置事物的注解方式注入 -->    <tx:annotation-driven transaction-manager="transactionManager"/>    <bean id="sqlSession"     class="org.mybatis.spring.SqlSessionTemplate">        <constructor-arg index="0" ref="sqlSessionFactory" />        <constructor-arg index="1" value="BATCH" />    </bean></beans>

6、在src/main/resources下创建spring-mvc.xml

<?xml version="1.0" encoding="utf-8"?><beans xmlns="http://www.springframework.org/schema/beans"       xmlns:p="http://www.springframework.org/schema/p" 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" xmlns:util="http://www.springframework.org/schema/util"       xmlns:aop="http://www.springframework.org/schema/aop"       xsi:schemaLocation="    http://www.springframework.org/schema/beans    http://www.springframework.org/schema/beans/spring-beans-3.0.xsd    http://www.springframework.org/schema/context    http://www.springframework.org/schema/context/spring-context-3.0.xsd    http://www.springframework.org/schema/mvc    http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd    http://www.springframework.org/schema/util    http://www.springframework.org/schema/util/spring-util-3.0.xsd    http://www.springframework.org/schema/aop    http://www.springframework.org/schema/aop/spring-aop-3.0.xsd    ">    <!-- Enables the Spring MVC @Controller programming model -->    <mvc:annotation-driven />    <!-- 扫描serviceimpl -->    <context:component-scan base-package="com.sm.serviceimpl" />    <!-- 为controller加上自动代理 -->    <aop:aspectj-autoproxy proxy-target-class="true" />    <!-- controller包(自动注入) -->    <context:component-scan base-package="com.sm.controller" />    <!-- **********开启注解***********    spring3.1之前DefaultAnnotionHandlerMapping AnnotionMethodHandlerAdapter    spring3.1之后RequestMappingHandlerMapping RequestMappingHandlerAdapter -->    <!-- 启动Spring MVC 的注解功能,完成请求和注解POJO的映射 即启用@RequestMapping -->    <bean            class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">        <property name="messageConverters">            <list>                <ref bean="mappingJacksonHttpMessageConverter" />            </list>        </property>    </bean>    <bean id="mappingJacksonHttpMessageConverter"          class="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter">    </bean>    <!-- 视图解析器对模型视图名称的解析,即在模型视图名称添加前后缀 -->    <bean            class="org.springframework.web.servlet.view.InternalResourceViewResolver">        <property name="prefix" value="/WEB-INF/jsp/" />        <property name="suffix" value=".jsp" />        <property name="order" value="10"/>    </bean></beans>

5、配置web.xml

<?xml version="1.0" encoding="UTF-8"?><web-app version="2.4"         xmlns="http://java.sun.com/xml/ns/j2ee"         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"         xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">  <!-- Spring-mybatis的配置文件 -->  <context-param>    <param-name>contextConfigLocation</param-name>    <param-value>classpath:spring-mybatis.xml</param-value>  </context-param>  <!-- log4j的配置文件 -->  <context-param>    <param-name>log4jConfigLocation</param-name>    <param-value>classpath:log4j.properties</param-value>  </context-param>  <listener>    <description>spring监听器</description>    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>  </listener>  <listener>    <description>log4j监听器</description>    <listener-class>org.springframework.web.util.Log4jConfigListener</listener-class>  </listener>  <!-- 防止spring内存溢出监听器 -->  <listener>    <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>  </listener>  <!-- spring mvc servlet -->  <servlet>    <description>spring mvc servlet</description>    <servlet-name>springMvc</servlet-name>    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>    <init-param>      <description>spring mvc 配置文件</description>      <param-name>contextConfigLocation</param-name>      <param-value>classpath:spring-mvc.xml</param-value>    </init-param>    <load-on-startup>1</load-on-startup>  </servlet>  <servlet-mapping>    <servlet-name>springMvc</servlet-name>    <url-pattern>*.do</url-pattern>  </servlet-mapping>  <filter>    <description>字符集过滤器</description>    <filter-name>encodingFilter</filter-name>    <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>    <init-param>      <description>字符集编码</description>      <param-name>encoding</param-name>      <param-value>UTF-8</param-value>    </init-param>  </filter>  <filter-mapping>    <filter-name>encodingFilter</filter-name>    <url-pattern>/*</url-pattern>  </filter-mapping>  <!-- 配置session超时时间，单位分钟 -->  <session-config>    <session-timeout>60</session-timeout>  </session-config>  <!-- DEFAULT PAGE -->  <welcome-file-list>    <welcome-file>index.jsp</welcome-file>  </welcome-file-list></web-app>

6、jsp

addUser.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"    pageEncoding="UTF-8"%><%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %><html>    <head>        <title>添加用户</title>    </head>    <body>        <c:if test="${!empty error}">            <font color="red"><c:out value="${error}" /></font>        </c:if>        <form action="<c:url value="userAdd.do"/>" method="post">            用户名：            <input type="text" name="username">            <br>            密 码：            <input type="password" name="password">            <br>            <input type="submit" value="注册" />            <input type="reset" value="重置" />        </form>    </body></html>

success.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><!DOCTYPE html><html><head></head><body>    <h1>注册成功</h1></body></html>

代码完成时的包结构：

这里写图片描述

三、测试

跑起来！

这里写图片描述
输入请求地址：http://localhost:8080/mistrasssmmm/userAdd/index.do

这里写图片描述

返回success.jsp

这里写图片描述

数据插入完成

这里写图片描述

此实例
GitHub地址：MistraR/MistraRSSSMMM
CSDN：CSDN下载地址
欢迎一起交流学习！

阅读全文

0 0