idea 2017 SpringMVC-Spring-MyBa

作者: Coang | 来源:发表于2017-08-14 21:19 被阅读0次

idea 2017 SpringMVC-Spring-MyBa
intelij and webstorm 账号
java基于maven环境搭建
Intellij Idea破解
Intelij idea 安装和破解
IntelliJ IDEA 2017破解版安装(Mac版本)
Java web技术实践路线
Mac IntelliJ IDEA 导入 MyEclipse
IntelliJ Idea 2017 免费激活方法
idea使用过程中遇到问题解决

前言:

本文为小白爬坑指南,主要作用是防止自己失忆 (逃

零：创建Web工程

1.File -> new project -> maven 选择 mavne-webapp 模板 idea会生成一个基础的web工程目录结构
2.在pom文件中增加相应的依赖包

壹：集成SpringMVC

在web.xml 中引入 SpringMVC

<!--Spring MVC 配置-->
<servlet>
  <servlet-name>springMVC</servlet-name>
  <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  <init-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>
      classpath:applicationContext-mvc.xml
    </param-value>
  </init-param>
  <load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
  <servlet-name>springMVC</servlet-name>
  <url-pattern>/</url-pattern>
</servlet-mapping>

SpringMVC 配置如下:
1.开启扫描，指定扫描目录
指定目录到Controller包的目的是预防SpringMVC和Spring扫描冲突
2.开启静态资源访问

  <!-- 扫描所有的controller 但是不扫描service-->
  <context:component-scan base-package="com.coang.controller"/>

  <!-- <mvc:resources mapping="/pages/**" location="/WEB-INF/pages/" />-->
  <mvc:default-servlet-handler />

  <!-- 自动扫描该包，使SpringMVC认为包下用了@controller注解的类是控制器 -->
  <mvc:annotation-driven />

  <!-- configure the InternalResourceViewResolver -->
  <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"
        id="internalResourceViewResolver">
      <!-- 前缀 -->
      <property name="prefix" value="/WEB-INF/jsp/" />
      <!-- 后缀 -->
      <property name="suffix" value=".jsp" />
  </bean>

3.配置好之后创建Controller以及jsp文件

@Controller
public class TestController {

    @RequestMapping("index")
    public String index(){
        return "index";
    }
}

4.配置好tomcat运行环境
5.启动工程
6.SpringMVC集成完毕

貳：集成Spring MyBatis

1.Dao匹配/Bean封装
2.注解事务处理

applicationContext-database.xml 数据源配置/mapping文件和dao映射

    <!-- 引入配置文件 -->
    <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="location">
            <value>classpath:/config/jdbc-mysql.properties</value>
        </property>
    </bean>

    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="${jdbc.driver}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
        <property name="initialSize" value="${initialSize}"/>
        <property name="maxActive" value="${maxActive}"/>
        <property name="maxIdle" value="${maxildle}"/>
        <property name="minIdle" value="${minldle}"/>
        <property name="maxWait" value="${maxWait}"/>
    </bean>
    <!--spring和MyBatis整合 自动扫描mapping.xml文件-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="mapperLocations" value="classpath:mapper/*.xml"/>
    </bean>
    <!--Dao接口所在包名 Spring自动查找类-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.coang.dao"/>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    </bean>

applicationContext-service.xml 事务管理

  <!-- 扫描所有的Service -->
  <context:component-scan base-package="com.coang"/>
  <!-- 事务管理 -->
  <bean id="transactionManager"
      class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dataSource"/>
  </bean>
  <!--
        基于注解的声明时事物 ：
        1、开发团队达成一致约定，明确标注事物的方法
        2、保证事物方法的执行时间尽可能短
        3、不是所有的方法都需要事物，如只有一条修改记录操作
    -->
  <tx:annotation-driven transaction-manager="transactionManager"/>

坑1 -- 如果SpringMVC的扫描路径包含Service扫描路径,由于加载顺序,Service会在SpringMVC加载时在Spring中生成无事务的bean 在事务扫描时由于bean已存在则不再重新创建,导致事务不生效

坑2 -- idea中的Spring框架context配置应如下,否则框架无法正常加载

image.png

TestDEMO:

单元测试

    @RunWith(SpringJUnit4ClassRunner.class)
    @ContextConfiguration(locations = {"classpath*:application-service.xml"})
    public class TestUser {
    
        @Autowired
        UserService userService;
    
        @Test
        @Ignore
        public void testAddUser() {
            UserModel user = new UserModel();
            user.setName("aaa");
            user.setPassword("bbb");
            Integer id = userService.addUser(user);
            Assert.assertNotNull(id);
    
        }
    
    }

Dao mapper文件

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
    <mapper namespace="com.coang.dao.UserDao" >
        <select id="findUserById" resultType="com.coang.modal.UserModel" parameterType="java.lang.Integer">
            select * from user where id = #{id}
        </select>
        <insert id="insertUser" parameterType="com.coang.modal.UserModel">
            insert into user(name,password) values(#{name},#{password})
            <selectKey resultType="int" keyProperty="id" >
                SELECT LAST_INSERT_ID();
            </selectKey>
        </insert>
    </mapper>

注:成功整合 mapper文件相当于Dao层接口的实现类在Service层调用时可进行注解注入

附录:附配置文件

1.maven: pom.xml

<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.coang</groupId>
<artifactId>java</artifactId>
<packaging>war</packaging>
<version>1.0-SNAPSHOT</version>
<name>ssm Maven Webapp</name>
<url>http://maven.apache.org</url>
<properties>
  <java-version>1.8</java-version>
  <!-- spring版本号 -->
  <spring.version>4.3.10.RELEASE</spring.version>
  <!-- mybatis版本号 -->
  <mybatis.version>3.3.0</mybatis.version>
  <!-- log4j日志文件管理包版本 -->
  <slf4j.version>1.7.7</slf4j.version>
  <log4j.version>1.2.17</log4j.version>
</properties>

<dependencies>
  <!-- Spring -->
  <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-beans</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-jdbc</artifactId>
    <version>${spring.version}</version>
  </dependency>

  <dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-webmvc</artifactId>
    <version>${spring.version}</version>
  </dependency>
  <!-- springframe end -->
  <!-- mybatis/spring包 -->
  <dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis-spring</artifactId>
    <version>1.2.3</version>
  </dependency>
  <!-- mybatis核心包 -->
  <dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>${mybatis.version}</version>
  </dependency>
  <!-- mysql驱动包 -->
  <dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.29</version>
  </dependency>
  <!--数据库连接池-->
  <dependency>
    <groupId>commons-dbcp</groupId>
    <artifactId>commons-dbcp</artifactId>
    <version>1.4</version>
  </dependency>
  <!-- https://mvnrepository.com/artifact/com.microsoft.sqlserver/mssql-jdbc -->
  <dependency>
    <groupId>com.microsoft.sqlserver</groupId>
    <artifactId>mssql-jdbc</artifactId>
    <version>6.1.0.jre8</version>
    <scope>test</scope>
  </dependency>
  <!-- https://mvnrepository.com/artifact/javax.servlet/servlet-api -->
  <dependency>
    <groupId>javax.servlet</groupId>
    <artifactId>servlet-api</artifactId>
    <version>2.5</version>
    <scope>provided</scope>
  </dependency>
  <!-- 引入oracle数据库jdbc驱动包 -->
  <!--<dependency>
      <groupId>com.oracle</groupId>
      <artifactId>ojdbc6</artifactId>
      <version></version>
  </dependency>-->
  <!--jedis 驱动-->
  <dependency>
    <groupId>redis.clients</groupId>
    <artifactId>jedis</artifactId>
    <version>2.9.0</version>
    <type>jar</type>
    <scope>compile</scope>
  </dependency>

  <!--spring data redis-->
  <dependency>
    <groupId>org.springframework.data</groupId>
    <artifactId>spring-data-redis</artifactId>
    <version>1.8.6.RELEASE</version>
  </dependency>


  <!-- Test -->
  <dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-test</artifactId>
    <version>${spring.version}</version>
    <scope>test</scope>
  </dependency>
  <dependency>
    <groupId>junit</groupId>
    <artifactId>junit</artifactId>
    <version>4.12</version>
    <scope>test</scope>
  </dependency>
  <!-- json数据 -->
  <dependency>
    <groupId>org.codehaus.jackson</groupId>
    <artifactId>jackson-mapper-asl</artifactId>
    <version>1.9.13</version>
  </dependency>
  <!-- https://mvnrepository.com/artifact/com.alibaba/fastjson -->
  <dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>fastjson</artifactId>
    <version>1.2.35</version>
  </dependency>
  <!-- JSTL -->
  <dependency>
    <groupId>javax.servlet</groupId>
    <artifactId>jstl</artifactId>
    <version>1.2</version>
  </dependency>
  <!-- 日志文件管理包 -->
  <!-- log start -->
  <dependency>
    <groupId>log4j</groupId>
    <artifactId>log4j</artifactId>
    <version>${log4j.version}</version>
  </dependency>
  <dependency>
    <groupId>org.slf4j</groupId>
    <artifactId>slf4j-api</artifactId>
    <version>${slf4j.version}</version>
  </dependency>
  <dependency>
    <groupId>org.slf4j</groupId>
    <artifactId>slf4j-log4j12</artifactId>
    <version>${slf4j.version}</version>
  </dependency>
  <!-- log end -->


</dependencies>

<build>
  <finalName>WebFramwork-ssm</finalName>
</build>
</project>

2.web: web.xml

<!DOCTYPE web-app PUBLIC
"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd" >
<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">
<display-name>WebFramwork-ssm</display-name>

<context-param>
  <param-name>contextConfigLocation</param-name>
  <param-value>
    classpath:applicationContext-database.xml,
    classpath:applicationContext-service.xml
  </param-value>
</context-param>

<context-param>
  <param-name>log4jConfigLocation</param-name>
  <param-value>classpath:config/log4j.properties</param-value>
</context-param>

<filter>
  <filter-name>encodingFilter</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>
  <init-param>
    <param-name>forceEncoding</param-name>
    <param-value>true</param-value>
  </init-param>
</filter>
<filter-mapping>
  <filter-name>encodingFilter</filter-name>
  <url-pattern>/*</url-pattern>
</filter-mapping>

<!--Spring 监听器-->
<listener>
  <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>

<!--防止Spring内存溢出监听器-->
<listener>
  <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
</listener>
<!--Spring MVC 配置-->
<servlet>
  <servlet-name>springMVC</servlet-name>
  <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  <init-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>
      classpath:applicationContext-mvc.xml
    </param-value>
  </init-param>
  <load-on-startup>1</load-on-startup>
</servlet>

<servlet-mapping>
  <servlet-name>springMVC</servlet-name>
  <url-pattern>/</url-pattern>
</servlet-mapping>

<welcome-file-list>
  <welcome-file>/jsp/index.jsp</welcome-file>
</welcome-file-list>

<!-- session配置 -->
<session-config>
  <session-timeout>15</session-timeout>
</session-config>
</web-app>

3.Spring mvc:applicationContext-mvc.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/mvc
       http://www.springframework.org/schema/mvc/spring-mvc.xsd
       http://www.springframework.org/schema/context
       http://www.springframework.org/schema/context/spring-context.xsd">

  <!-- 扫描所有的controller 但是不扫描service-->
  <context:component-scan base-package="com.coang.controller"/>

  <!-- <mvc:resources mapping="/pages/**" location="/WEB-INF/pages/" />-->
  <mvc:default-servlet-handler />

  <!-- 自动扫描该包，使SpringMVC认为包下用了@controller注解的类是控制器 -->
  <mvc:annotation-driven />

  <!-- configure the InternalResourceViewResolver -->
  <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"
        id="internalResourceViewResolver">
      <!-- 前缀 -->
      <property name="prefix" value="/WEB-INF/jsp/" />
      <!-- 后缀 -->
      <property name="suffix" value=".jsp" />
  </bean>
</beans>

4.Spring:applicationContext-service.xml/applicationContext-database.xml

applicationContext-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:mvc="http://www.springframework.org/schema/mvc"
  xmlns:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop"
  xmlns:context="http://www.springframework.org/schema/context"
  xmlns:util="http://www.springframework.org/schema/util" xmlns:p="http://www.springframework.org/schema/p"
  xmlns:cache="http://www.springframework.org/schema/cache" xmlns:jdbc="http://www.springframework.org/schema/jdbc"
  xsi:schemaLocation="http://www.springframework.org/schema/beans 
            http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
            http://www.springframework.org/schema/mvc
            http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd
            http://www.springframework.org/schema/tx
            http://www.springframework.org/schema/tx/spring-tx-3.2.xsd
            http://www.springframework.org/schema/context
            http://www.springframework.org/schema/context/spring-context-3.2.xsd
            http://www.springframework.org/schema/util 
            http://www.springframework.org/schema/util/spring-util-3.2.xsd
            http://www.springframework.org/schema/cache 
            http://www.springframework.org/schema/cache/spring-cache.xsd
            http://www.springframework.org/schema/task 
            http://www.springframework.org/schema/task/spring-task-3.2.xsd
            http://www.springframework.org/schema/jdbc
            http://www.springframework.org/schema/jdbc/spring-jdbc-3.2.xsd"
  default-lazy-init="true">


  <!-- 扫描所有的Service -->
  <context:component-scan base-package="com.coang"/>

  <!-- 事务管理 -->
  <bean id="transactionManager"
      class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dataSource"/>
  </bean>

  <!--
        基于注解的声明时事物 ：
        1、开发团队达成一致约定，明确标注事物的方法
        2、保证事物方法的执行时间尽可能短
        3、不是所有的方法都需要事物，如只有一条修改记录操作
    -->
  <tx:annotation-driven transaction-manager="transactionManager"/>
</beans>

applicationContext-database.xml - 管理数据库连接/dao层映射

<?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:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:util="http://www.springframework.org/schema/util"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans.xsd">

    <!--<context:component-scan base-package="com.coang.web"/>-->

    <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="location">
            <!--<value>classpath:../../config/jdbc-mysql.properties</value>-->
            <value>classpath:/config/jdbc-mysql.properties</value>
        </property>
    </bean>

    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="${jdbc.driver}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
        <property name="initialSize" value="${initialSize}"/>
        <property name="maxActive" value="${maxActive}"/>
        <property name="maxIdle" value="${maxildle}"/>
        <property name="minIdle" value="${minldle}"/>
        <property name="maxWait" value="${maxWait}"/>
    </bean>
    <!--spring和MyBatis整合 自动扫描mapping.xml文件-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="mapperLocations" value="classpath:mapper/*.xml"/>
    </bean>
    <!--Dao接口所在包名 Spring自动查找类-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.coang.dao"/>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    </bean>

</beans>

ps_0 Spring配置文件是可以用单个xml配置,只是个人喜好将配置分开方便理解
ps_1 目录结构

    WebFramwork-ssm/
    │  pom.xml
    │  tree.txt
    │  WebFramwork-ssm.iml
    │      
    └─src
       └─main
          ├─java
          │  └─com
          │      └─coang
          │          ├─common
          │          ├─controller
          │          │      TestController.java
          │          │      
          │          ├─dao
          │          │      UserDao.java
          │          │      
          │          ├─modal
          │          │      UserModel.java
          │          │      
          │          └─service
          │              │  UserService.java
          │              │  
          │              └─impl
          │                      UserServiceImpl.java
          │                      
          ├─resources
          │  │  applicationContext-database.xml
          │  │  applicationContext-mvc.xml
          │  │  applicationContext-service.xml
          │  │  
          │  ├─config
          │  │      jdbc-mysql.properties
          │  │      jdbc-sqlserver.properties
          │  │      log4j.properties
          │  │      
          │  └─mapper
          │          UserMapper.xml
          │          
          └─webapp
              │  index.jsp
              │  
              └─WEB-INF
                  │  web.xml
                  │  
                  └─jsp
                          index.jsp

idea 2017 SpringMVC-Spring-MyBa
前言: 本文为小白爬坑指南,主要作用是防止自己失忆 (逃零：创建Web工程 1.File -> new proj...
intelij and webstorm 账号
IDEA破解 2017 IDEA license server 激活（可用） WebStorm 2017 最新版激...
java基于maven环境搭建
部署前期准备：下载intellij idea 2017 IDE开发工具激活intellij idea 2017...
Intellij Idea破解
IntelliJ Idea 2017 免费激活方法 IntelliJ IDEA 注册码 IntelliJ IDEA...
Intelij idea 安装和破解
IntelliJ IDEA（2017）安装和破解 IDEA 全称 IntelliJ IDEA，是Java语言开发的...
IntelliJ IDEA 2017破解版安装(Mac版本)
IntelliJ IDEA 2017破解版安装(Mac版本) 1.下载IntelliJ IDEA 2017和破解文...
Java web技术实践路线
Java Web知识总图环境搭建开发 IntelliJ IDEA2017 [IntelliJ-IDEA-Tuto...
Mac IntelliJ IDEA 导入 MyEclipse
[1] 安装 IntelliJ IDEA 下载IntelliJ IDEA 2017-10-31-1.png 安装过...
IntelliJ Idea 2017 免费激活方法
IntelliJ Idea 2017 免费激活方法到网站：http://idea.lanyus.com/ 获取注...
idea使用过程中遇到问题解决
[TOC] 1. IntelliJ Idea 2017 免费激活方法到网站 http://idea.lanyus...