Idea SpringMVC+Spring+MyBatis+Maven整合

创建项目
File-New Project

选中左侧的Maven,选中右侧上方的Create from archetype,然后选中下方列表中的webapp,然后点击Next
1.jpg
在GroupId和ArtifactId中填入指定内容,点击Next
2.jpg
直接点Next
3.jpg
输入项目名称,Finish
4.jpg
Idea会自动开始下载所依赖的包,等待其完成。
项目结构
项目刚建好的时候是没有这些文件的,所以自己手动创建缺少的文件夹(包)
创建完后的项目框架:
5.jpg

修改pom.xml导入依赖包插件

依赖包需要如下:
spring framework
aspectj事务
c3p0数据源
servlet/jsp api
junit4
mybatis
mybatis spring整合
MySQL driver
jstl

<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>  
    <groupId>com.unpor</groupId>  
    <artifactId>ssm</artifactId>  
    <packaging>war</packaging>  
    <version>1.0-SNAPSHOT</version>  
    <name>ssm Maven Webapp</name>  
    <url>http://maven.apache.org</url>  
    <build>  
        <finalName>ssm</finalName>  
        <plugins>  
            <!--mybatis 逆向工程插件-->  
            <plugin>  
                <groupId>org.mybatis.generator</groupId>  
                <artifactId>mybatis-generator-maven-plugin</artifactId>  
                <version>1.3.2</version>  
                <configuration>  
                    <verbose>true</verbose>  
                    <overwrite>true</overwrite>  
                </configuration>  
            </plugin>  
        </plugins>  
    </build>  
    <properties>  
        <spring.version>4.1.1.RELEASE</spring.version>  
    </properties>  
    <dependencies>  
        <!-- springframe start -->  
        <dependency>  
            <groupId>org.springframework</groupId>  
            <artifactId>spring-core</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-oxm</artifactId>  
            <version>${spring.version}</version>  
        </dependency>  
  
        <dependency>  
            <groupId>org.springframework</groupId>  
            <artifactId>spring-tx</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-aop</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-test</artifactId>  
            <version>${spring.version}</version>  
        </dependency>  
        <!-- springframe end -->  
  
        <!--aspectj start-->  
        <dependency>  
            <groupId>org.aspectj</groupId>  
            <artifactId>aspectjweaver</artifactId>  
            <version>1.8.6</version>  
        </dependency>  
  
        <dependency>  
            <groupId>org.aspectj</groupId>  
            <artifactId>aspectjrt</artifactId>  
            <version>1.8.6</version>  
        </dependency>  
        <!--aspectj end-->  
  
        <!--c3p0-->  
        <dependency>  
            <groupId>com.mchange</groupId>  
            <artifactId>c3p0</artifactId>  
            <version>0.9.5.1</version>  
        </dependency>  
  
        <!--servlet/jsp api start-->  
        <dependency>  
            <groupId>javax.servlet</groupId>  
            <artifactId>servlet-api</artifactId>  
            <version>2.5</version>  
        </dependency>  
  
        <dependency>  
            <groupId>javax.servlet.jsp</groupId>  
            <artifactId>jsp-api</artifactId>  
            <version>2.1</version>  
            <scope>provided</scope>  
        </dependency>  
        <!--servlet/jsp api end-->  
  
        <!--junit4-->  
        <dependency>  
            <groupId>junit</groupId>  
            <artifactId>junit</artifactId>  
            <version>4.11</version>  
            <scope>test</scope>  
        </dependency>  
  
        <!--mybatis-->  
        <dependency>  
            <groupId>org.mybatis</groupId>  
            <artifactId>mybatis</artifactId>  
            <version>3.3.0</version>  
        </dependency>  
        <!--mybatis spring整合-->  
        <dependency>  
            <groupId>org.mybatis</groupId>  
            <artifactId>mybatis-spring</artifactId>  
            <version>1.2.3</version>  
        </dependency>  
  
        <!--mysql driver-->  
        <dependency>  
            <groupId>mysql</groupId>  
            <artifactId>mysql-connector-java</artifactId>  
            <version>5.1.6</version>  
        </dependency>  
  
        <!--jstl-->  
        <dependency>  
            <groupId>jstl</groupId>  
            <artifactId>jstl</artifactId>  
            <version>1.2</version>  
        </dependency>  
  
    </dependencies>  
</project>

插件需要用到mybatis的逆向工程
完整的pom.xml代码清单:

使用mybatis逆向工程创建mapper接口和xml文件

先创建表(MySql)
user表结构

DROP TABLE IF EXISTS `user`;  
/*!40101 SET @saved_cs_client     = @@character_set_client */;  
/*!40101 SET character_set_client = utf8 */;  
CREATE TABLE `user` (  
  `id` int(11) NOT NULL AUTO_INCREMENT,  
  `username` varchar(32) NOT NULL COMMENT '用户名称',  
  `birthday` date DEFAULT NULL COMMENT '生日',  
  `sex` char(1) DEFAULT NULL COMMENT '性别',  
  `address` varchar(256) DEFAULT NULL COMMENT '地址',  
  PRIMARY KEY (`id`)  
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;

在main/resources中创建generatorConfig.xml文件
generatorConfig.xml代码清单
下载 mysql-connector-java-5.1.7-bin.jar 放到本项目的 src -> main -> webapp -> WEB-INF -> lib
配置jar文件包依赖库
6.jpg

<?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="E:\JavaClass\idea\UnporSSM\src\main\webapp\WEB-INF\lib\mysql-connector-java-5.1.7-bin.jar"/>  
    <context id="testTables" targetRuntime="MyBatis3" >  
        <commentGenerator>  
            <!-- 是否去除自动生成的注释 true:是 : false:否 -->  
            <property name="suppressAllComments" value="true" />  
        </commentGenerator>  
        <!--数据库连接的信息:驱动类、连接地址、用户名、密码 -->  
        <!--<jdbcConnection driverClass="${jdbc.driver}"-->  
                        <!--connectionURL="${jdbc.url}"-->  
                        <!--userId="${jdbc.username}"-->  
                        <!--password="${jdbc.password}">-->  
        <!--</jdbcConnection>-->  
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"  
            connectionURL="jdbc:mysql://127.0.0.1:3306/mybatis?characterEncoding=UTF-8"  
            userId="root"  
            password="">  
        </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.unpor.pojo"  
                            targetProject="src\main\java">  
            <!-- enableSubPackages:是否让schema作为包的后缀 -->  
            <property name="enableSubPackages" value="false" />  
            <!-- 从数据库返回的值被清理前后的空格 -->  
            <property name="trimStrings" value="true" />  
        </javaModelGenerator>  
        <!-- targetProject:mapper映射文件生成的位置 -->  
        <sqlMapGenerator targetPackage="com.unpor.mapper"  
                         targetProject="src\main\resources">  
            <!-- enableSubPackages:是否让schema作为包的后缀 -->  
            <property name="enableSubPackages" value="false" />  
        </sqlMapGenerator>  
        <!-- targetPackage:mapper接口生成的位置 -->  
        <javaClientGenerator type="XMLMAPPER"  
                             targetPackage="com.unpor.mapper"  
                             targetProject="src\main\java">  
            <!-- enableSubPackages:是否让schema作为包的后缀 -->  
            <property name="enableSubPackages" value="false" />  
        </javaClientGenerator>  
        <!-- 指定数据库表 -->  
        <table tableName="user"></table>  
  
        <!-- 有些表的字段需要指定java类型  
         <table schema="" tableName="">  
            <columnOverride column="" javaType="" />  
        </table> -->  
    </context>  
</generatorConfiguration>

在src -> main 下面新建一个 java 包,并设置成蓝色
点击idea右侧的maven选项卡,选择其中的mybatis-generator,点击顶部的绿色按钮运行
7.jpg
如果没有出错的话,应该会自动生成mapper接口文件、xml文件、pojo文件。
8.jpg

db.properties文件

在src/main/resources/config中创建db.properties,该文件用来描述mysql连接信息(同时创建下面的几个文件)
9.jpg

jdbc.driver = com.mysql.jdbc.Driver  
jdbc.url = jdbc:mysql://127.0.0.1:3306/mybatis?characterEncoding=UTF-8  
jdbc.username = root  
jdbc.password =  

SqlMapConfig文件

在resources/config/mybatis中创建SqlMapConfig.xml文件,该文件为Mybatis的配置文件,由于跟spring整合,所以一些基础配置文件都在spring中,在这里该文件中值需要写文件的框架

<?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>  
  
</configuration>  

SpringMVC配置文件

在resources/config/spring中创建springmvc.xml文件

<?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: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.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd">  
  
       <!--自动扫描控制器-->  
       <context:component-scan base-package="com.unpor.controller"/>  
       <!--视图渲染-->  
       <bean id="internalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">  
              <property name="prefix" value="/WEB-INF/views/"/>  
              <property name="suffix" value=".jsp"/>  
       </bean>  
       <!--控制器映射器和控制器适配器-->  
       <mvc:annotation-driven></mvc:annotation-driven>  
</beans>

Spring IOC注入和事件控制

在resources/config/spring中创建applicationContext-dao.xml、application-service.xml、applicationContext-transaction.xml文件

applicationContext-dao.xml

<?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:context="http://www.springframework.org/schema/context"  
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">  
  
  
       <!--获取数据库配置文件-->  
       <context:property-placeholder location="classpath:config/db.properties"/>  
  
  
       <!--设置数据源c3p0-->  
       <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">  
              <property name="driverClass" value="${jdbc.driver}"/>  
              <property name="jdbcUrl" value="${jdbc.url}"/>  
              <property name="user" value="${jdbc.username}"/>  
              <property name="password" value="${jdbc.password}"/>  
              <property name="maxPoolSize" value="50"/>  
              <property name="minPoolSize" value="2"/>  
              <property name="maxIdleTime" value="60"/>  
       </bean>  
  
       <!--sqlsessionFactory bean-->  
       <bean id="sqlSession" class="org.mybatis.spring.SqlSessionFactoryBean">  
              <property name="configLocation" value="classpath:config/mybatis/SqlMapConfig.xml"/>  
              <property name="dataSource" ref="dataSource"/>  
       </bean>  
  
       <!--自动扫描mapper接口,并注入sqlsession-->  
       <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">  
              <property name="basePackage" value="com.unpor.mapper"/>  
              <property name="sqlSessionFactoryBeanName" value="sqlSession"/>  
       </bean>  
  
</beans> 

application-service.xml

<?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:context="http://www.springframework.org/schema/context"  
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">  
         
       <!--扫描service-->  
       <context:component-scan base-package="com.unpor.service"/>  
</beans>  

applicationContext-transaction.xml

<?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:tx="http://www.springframework.org/schema/tx"  
       xmlns:aop="http://www.springframework.org/schema/aop"  
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">  
  
  
       <bean id="dataSourceTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">  
              <property name="dataSource" ref="dataSource"/>  
       </bean>  
  
       <tx:advice id="txAdvice" transaction-manager="dataSourceTransactionManager">  
              <tx:attributes>  
                     <tx:method name="find*" propagation="REQUIRED"/>  
                     <tx:method name="update*" propagation="REQUIRED"/>  
                     <tx:method name="delete*" propagation="REQUIRED"/>  
                     <tx:method name="add*" propagation="REQUIRED"/>  
              </tx:attributes>  
       </tx:advice>  
  
       <aop:config>  
              <aop:advisor advice-ref="txAdvice" pointcut="execution(* cn.elinzhou.ixxs.service.*.*(..))"/>  
       </aop:config>  
</beans>

web.xml文件

修改web.xml文件内容

<?xml version="1.0" encoding="UTF-8"?>  
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"  
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  
         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"  
         version="3.1">  
  
    <!--设置spring 配置文件的位置-->  
    <context-param>  
        <param-name>contextConfigLocation</param-name>  
        <param-value>classpath*:config/spring/applicationContext-*.xml</param-value>  
  
    </context-param>  
    <!--配置spring listener-->  
    <listener>  
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>  
    </listener>  
  
  
    <!--解决POST乱码问题-->  
    <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>  
  
    <!--springmvc前端控制器配置-->  
    <servlet>  
        <servlet-name>dispatcherServlet</servlet-name>  
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>  
        <init-param>  
            <param-name>contextConfigLocation</param-name>  
            <param-value>classpath*:config/spring/springmvc.xml</param-value>  
        </init-param>  
        <load-on-startup>1</load-on-startup>  
    </servlet>  
  
    <servlet-mapping>  
        <servlet-name>dispatcherServlet</servlet-name>  
        <url-pattern>/</url-pattern>  
    </servlet-mapping>  
  
</web-app> 

Service接口与实现

创建一个简单的service,只有一个查看所有用户列表的功能
UserService.Java

package com.unpor.service;  
  
import com.unpor.pojo.User;  
  
import java.util.List;  
  
public interface UserService {  
  
    /** 
     * 查找所有用户 
     * @return 
     * @throws Exception 
     */  
    List<User> findUser()throws Exception;  
}  

实现类UserServiceImpl.java

package com.unpor.service;  
  
import com.unpor.mapper.UserMapper;  
import com.unpor.pojo.User;  
import org.springframework.beans.factory.annotation.Autowired;  
import org.springframework.stereotype.Service;  
  
import java.util.List;  
 
@Service  
public class UserServiceImpl implements UserService {  
  
    //User接口  
    @Autowired  
    private UserMapper userMapper;  
  
    public List<User> findUser() throws Exception {  
        //调用mapper类中的selectByExample方法,如果传入类型为null,则表示无条件查找  
        List<User> users = userMapper.selectByExample(null);  
  
        return users;  
    }  
}  

Controller

package com.unpor.controller;  
  
import com.unpor.pojo.User;  
import com.unpor.service.UserService;  
import org.springframework.beans.factory.annotation.Autowired;  
import org.springframework.stereotype.Controller;  
import org.springframework.web.bind.annotation.RequestMapping;  
import org.springframework.web.servlet.ModelAndView;  
  
import java.util.List;  
   
@Controller  
@RequestMapping("/user")  
public class UserController {  
  
    //service类  
    @Autowired  
    private UserService userService;  
  
    /** 
     * 查找所用用户控制器方法 
     * @return 
     * @throws Exception 
     */  
    @RequestMapping("/findUser")  
    public ModelAndView findUser()throws Exception{  
        ModelAndView modelAndView = new ModelAndView();  
  
        //调用service方法得到用户列表  
        List<User> users = userService.findUser();  
        //将得到的用户列表内容添加到ModelAndView中  
        modelAndView.addObject("users",users);  
        //设置响应的jsp视图  
        modelAndView.setViewName("findUser");  
  
        return modelAndView;  
    }  
}  

视图

根据之前写的controller,返回的视图为findUser,所以在/WEB-INF/views中创建findUser.jsp文件,用来显示查询出来的结果

<%@ page contentType="text/html;charset=UTF-8" language="java" %>  
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>  
<html>  
<head>  
    <title></title>  
</head>  
<body>  
<h1>findUser</h1>  
<table>  
  <c:forEach items="${users}" var="u">  
    <tr>  
      <td>${u.id}</td>  
      <td>${u.username}</td>  
      <td>${u.birthday}</td>  
    </tr>  
  </c:forEach>  
  
</table>  
</body>  
</html> 

最后别忘了配置下tomcat

发表评论

发表评论