image.png

1.添加依赖包，可以通过properties统一框架版本

  1. <properties>
  2.     <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  3.     <maven.compiler.source>11.0</maven.compiler.source>
  4.     <maven.compiler.target>11.0</maven.compiler.target>
  5.     <springversion>5.0.8.RELEASE</springversion>
  6.   </properties>
  9.   <dependencies>
  10.     <!-- 加入ServletAPI -->
  11.     <dependency>
  12.       <groupId>javax.servlet</groupId>
  13.       <artifactId>javax.servlet-api</artifactId>
  14.       <version>3.1.0</version>
  15.       <scope>provided</scope>
  16.     </dependency>
  17.     <!-- MySQL依赖 start -->
  18.     <dependency>
  19.       <groupId>mysql</groupId>
  20.       <artifactId>mysql-connector-java</artifactId>
  21.       <version>5.1.38</version>
  22.     </dependency>
  23.     <!-- 加入MyBatis 依赖 start -->
  24.     <dependency>
  25.       <groupId>org.mybatis</groupId>
  26.       <artifactId>mybatis</artifactId>
  27.       <version>3.2.8</version>
  28.     </dependency>
  29.     <!-- 引入Spring(包含SpringMVC) 依赖 start -->
  30.     <dependency>
  31.       <groupId>org.springframework</groupId>
  32.       <artifactId>spring-core</artifactId>
  33.       <version>${springversion}</version>
  34.     </dependency>
  35.     <dependency>
  36.       <groupId>org.springframework</groupId>
  37.       <artifactId>spring-web</artifactId>
  38.       <version>${springversion}</version>
  39.     </dependency>
  40.     <dependency>
  41.       <groupId>org.springframework</groupId>
  42.       <artifactId>spring-oxm</artifactId>
  43.       <version>${springversion}</version>
  44.     </dependency>
  45.     <dependency>
  46.       <groupId>org.springframework</groupId>
  47.       <artifactId>spring-tx</artifactId>
  48.       <version>${springversion}</version>
  49.     </dependency>
  50.     <dependency>
  51.       <groupId>org.springframework</groupId>
  52.       <artifactId>spring-jdbc</artifactId>
  53.       <version>${springversion}</version>
  54.     </dependency>
  55.     <dependency>
  56.       <groupId>org.springframework</groupId>
  57.       <artifactId>spring-webmvc</artifactId>
  58.       <version>${springversion}</version>
  59.     </dependency>
  60.     <dependency>
  61.       <groupId>org.springframework</groupId>
  62.       <artifactId>spring-aop</artifactId>
  63.       <version>${springversion}</version>
  64.     </dependency>
  65.     <dependency>
  66.       <groupId>org.springframework</groupId>
  67.       <artifactId>spring-context-support</artifactId>
  68.       <version>${springversion}</version>
  69.     </dependency>
  70.     <dependency>
  71.       <groupId>org.springframework</groupId>
  72.       <artifactId>spring-test</artifactId>
  73.       <version>${springversion}</version>
  74.     </dependency>
  75.     <!-- 引用插件依赖：MyBatis整合Spring,如果mybatis版本在3.4及以上版本
  76.     mybatis-spring的版本要在1.3以上 -->
  77.     <dependency>
  78.       <groupId>org.mybatis</groupId>
  79.       <artifactId>mybatis-spring</artifactId>
  80.       <version>1.2.2</version>
  81.     </dependency>
  82.     <!-- JSTL -->
  83.     <dependency>
  84.       <groupId>jstl</groupId>
  85.       <artifactId>jstl</artifactId>
  86.       <version>1.2</version>
  87.     </dependency>
  88.     <!-- 德鲁伊数据连接池 -->
  89.     <dependency>
  90.       <groupId>com.alibaba</groupId>
  91.       <artifactId>druid</artifactId>
  92.       <version>1.0.9</version>
  93.     </dependency>
  94.     <!-- pagehelper -->
  95.     <dependency>
  96.       <groupId>com.github.pagehelper</groupId>
  97.       <artifactId>pagehelper</artifactId>
  98.       <version>4.1.6</version>
  99.     </dependency>
  100.     <!--处理json-->
  101.     <dependency>
  102.       <groupId>com.fasterxml.jackson.core</groupId>
  103.       <artifactId>jackson-databind</artifactId>
  104.       <version>2.9.5</version>
  105.     </dependency>
  106.     <!--javaee-->
  107.     <dependency>
  108.       <groupId>javax</groupId>
  109.       <artifactId>javaee-api</artifactId>
  110.       <version>7.0</version>
  111.       <scope>provided</scope>
  112.     </dependency>
  113.     <!--文件上传下载-->
  114.     <dependency>
  115.       <groupId>commons-fileupload</groupId>
  116.       <artifactId>commons-fileupload</artifactId>
  117.       <version>1.3.1</version>
  118.     </dependency>
  119.     <dependency>
  120.       <groupId>commons-io</groupId>
  121.       <artifactId>commons-io</artifactId>
  122.       <version>2.4</version>
  123.     </dependency>
  124.   <!--  如果遇到声明式事务报错，需要添加下面的依赖包-->
  125.     <dependency>
  126.       <groupId>org.aspectj</groupId>
  127.       <artifactId>aspectjweaver</artifactId>
  128.       <version>1.9.1</version>
  129.     </dependency>
  130.     <dependency>
  131.       <groupId>org.mybatis.generator</groupId>
  132.       <artifactId>mybatis-generator-core</artifactId>
  133.       <version>1.3.5</version>
  134.     </dependency>
  135.     <!-- https://mvnrepository.com/artifact/javax.annotation/javax.annotation-api -->
  136.     <dependency>
  137.       <groupId>javax.annotation</groupId>
  138.       <artifactId>javax.annotation-api</artifactId>
  139.       <version>1.2</version>
  140.     </dependency>
  141.   </dependencies>

2.添加spring配置文件，ssm中可以省略mybatis.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:p="http://www.springframework.org/schema/p"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:tx="http://www.springframework.org/schema/tx"
       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
                           http://www.springframework.org/schema/tx
                           http://www.springframework.org/schema/tx/spring-tx.xsd
">
    <!-- 1.配置数据源-->
    <bean id="db" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/mvc?useUnicode=true&amp;characterEncoding=utf-8"/>
        <property name="username" value="root"/>
<!--        <property name="password" value="123456"></property>-->
    </bean>
    <!--2.创建sqlSessionFactory-->
    <bean id="fac" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="db"/>
        <property name="configLocation" value="classpath:mybatis.xml"/> <!--指定mybatis的配置文件路径-->
        <property name="mapperLocations" value="classpath:mapper/*.xml"/><!--指定mybatis的mapper文件路径-->
    </bean>
    <!--3.创建MapperScannerConfigurer,用于省略dao的实现类-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="sqlSessionFactoryBeanName" value="fac"/>
        <property name="basePackage" value="com.zh.dao"/><!--接口所在包的路径-->
    </bean>
    <!--4.配置事务-->
    <bean id="mytx" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="db"/>
    </bean>
    <tx:annotation-driven transaction-manager="mytx"/>
    <!--5.启用springmvc注解-->
    <mvc:annotation-driven></mvc:annotation-driven>
    <!--6.配置视图解析器-->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/"/>
        <property name="suffix" value=".jsp"/>
    </bean>
    <!--7.扫描注解包-->
    <context:component-scan base-package="com.zh"/>
    <!--8.配置静态资源访问-->
    <mvc:default-servlet-handler/>
</beans>

Mybatis.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 type="com.yhp.bean.Student" alias="stu"></typeAlias>-->
        <package name="com.zh.bean"/>
    </typeAliases>

    <plugins>
        <!-- PageHelper4.1.6 -->
        <plugin interceptor="com.github.pagehelper.PageHelper">
            <property name="dialect" value="mysql"/>
        </plugin>
    </plugins>


</configuration>

3.配置web.xml文件，同时加载spring配置文件

<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_2_5.xsd" version="2.5">
    <display-name>Archetype Created Web Application</display-name>

    <!--1.配置前端控制器-->
    <servlet>
        <servlet-name>mvc</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:spring.xml</param-value>
        </init-param>
    </servlet>
    <servlet-mapping>
        <servlet-name>mvc</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>

    <!--2.处理post乱码-->
    <filter>
        <filter-name>aa</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>aa</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>

</web-app>

4.创建数据表,添加项目包结构，包括实体类等

给dao,service,web包下使用注解创建对象，给service,web中的属性注入对象,这一步也可以使用上一节的自动生成，然后再加注解，自动生成见后面。

5.配置文件代码

这个是spring.xml的内容模板，这种是从properties文件中读取数据源

<!--1.创建数据源,使用spring连接数据库 -->
<context:property-placeholder location="db.properties" system-properties-mode="FALLBACK"/>
<bean id="db" destroy-method="close" class="com.alibaba.druid.pool.DruidDataSource">
<property name="url" value="${url}"></property>
<property name="username" value="${username}"></property>
<property name="password" value="${password}"></property>
<property name="driverClassName" value="${driver}"></property>
<property name="maxActive" value="10"/>
<property name="minIdle" value="5"/>
</bean>
<!--2.扫描注解包-->
<context:component-scan base-package="com"></context:component-scan>
<!--3.创建视图解析器-->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/"/>
<property name="suffix" value=".jsp"/>
</bean>
<!--4.加载注解驱动-->
<mvc:annotation-driven></mvc:annotation-driven>
<!--5.创建sqlsession工厂-->
<bean id="fac" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="db" ></property>
<property name="mapperLocations" value="classpath:/mapper/*.xml"></property>
<property name="configLocation" value="classpath:mybatis.xml"></property>
</bean>
<!--6.使用dao层实现类的时候，需要得到sqlSessionTemplate对象
<bean id="temp" class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg index="0" ref="fac"></constructor-arg>
</bean>-->
<!--7.配置事务-->
<bean id="tx" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="db"></property>
</bean>
<tx:annotation-driven transaction-manager="mytx"></tx:annotation-driven>
<!--8.配置静态资源-->
<mvc:resources mapping="/css/**" location="/css/"></mvc:resources>
<mvc:resources mapping="/dtree/**" location="/dtree/"></mvc:resources>
<mvc:resources mapping="/Images/**" location="/Images/"></mvc:resources>
<mvc:resources mapping="/img/**" location="/img/"></mvc:resources>
<mvc:resources mapping="/Script/**" location="/Script/"></mvc:resources>
<mvc:resources mapping="/Style/**" location="/Style/"></mvc:resources>
或者:
<mvc:default-servlet-handler></mvc:default-servlet-handler>

6.配置controller文件

使用的注解：@Controller,@RequestMapping,@AutoWired,@Resource，@Qualifier(“empBiz”)

7.添加service,dao层

使用的注解：@Service ，@AutoWired，@Resource
(1) dao层省略了实现类
(2) dao 层只定义接口,由spring创建dao层对象以及扫描mapper文件
注:当添加了spring-jdbc的jar包后，会自动提交事务
补充:
分页插件:

<plugins>
<!-- PageHelper4.1.6 -->
<plugin interceptor="com.github.pagehelper.PageHelper">
<property name="dialect" value="mysql"/>
</plugin>
</plugins>

(1) 省略dao层实现类(使用MapperScannerConfigurer替代SqlSessionTemplate):

<!--省略实现类-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.dao"></property>
<property name="sqlSessionFactoryBeanName" value="fac"></property>
</bean>

注意:此时也可以测试使用属性文件的方式来加载数据源(支持属性文件链接数据源)
(2) maven类型的web项目加载mybatis-generator插件，自动生成bean，mapper，dao
先添加依赖：

<dependency>
    <groupId>org.mybatis.generator</groupId>
    <artifactId>mybatis-generator-core</artifactId>
    <version>1.3.5</version>
</dependency>

添加插件：

        <plugin>
        <groupId>org.mybatis.generator</groupId>
        <artifactId>mybatis-generator-maven-plugin</artifactId>
        <version>1.3.5</version>
        <configuration>
          <!--配置文件的路径-->
          <configurationFile>src/main/resources/generatorConfig.xml</configurationFile>
          <overwrite>true</overwrite>
        </configuration>
        <dependencies>
          <dependency>
            <groupId>org.mybatis.generator</groupId>
            <artifactId>mybatis-generator-core</artifactId>
            <version>1.3.5</version>
          </dependency>
        </dependencies>
      </plugin>

添加配置文件：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>
    <!--数据库驱动jar -->
    <classPathEntry
            location="E:\Maven\maven_repository\mysql\mysql-connector-java\5.1.46\mysql-connector-java-5.1.46.jar" />

    <context id="MyBatis" targetRuntime="MyBatis3">

        <!--去除注释 -->
        <commentGenerator>
            <property name="suppressAllComments" value="true" />
        </commentGenerator>

        <!--数据库连接 -->
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                        connectionURL="jdbc:mysql://localhost:3306/mvc?useUnicode=true&amp;characterEncoding=utf-8"
                        userId="root">
<!--                        password="123456">-->
        </jdbcConnection>

        <!--生成实体类 指定包名 以及生成的地址 （可以自定义地址，但是路径不存在不会自动创建
        使用Maven生成在target目录下，会自动创建） -->
        <javaModelGenerator targetPackage="com.zh.bean"
                            targetProject="F:\IdeaProjects\SSMProject\src\main\java">
            <property name="trimStrings" value="true" />
        </javaModelGenerator>


        <!--生成SQLmapper文件 -->
        <sqlMapGenerator targetPackage="mapper"
                         targetProject="F:\IdeaProjects\SSMProject\src\main\resources">
        </sqlMapGenerator>
        <!--生成Dao文件,生成接口 -->
        <javaClientGenerator type="XMLMAPPER"
                             targetPackage="com.zh.dao"
                             targetProject="F:\IdeaProjects\SSMProject\src\main\java">
        </javaClientGenerator>


        <table tableName="student" enableCountByExample="false"
               enableUpdateByExample="false" enableDeleteByExample="false"
               enableSelectByExample="false" selectByExampleQueryId="false">
        </table>
        <table tableName="admins" enableCountByExample="false"
               enableUpdateByExample="false" enableDeleteByExample="false"
               enableSelectByExample="false" selectByExampleQueryId="false">
        </table>
    </context>
</generatorConfiguration>

web类型的Maven项目，maven Project选项卡->plugins->找到mybatis-generator-core是找不到的
image.png
需要配置：
点击Edit这个
image.png
然后添加Maven，注意这里需要先配置好Tomcat，否则没有Name选项
然后Name：mybatis
Command line：mybatis-generator:generate -e
image.png
配置完之后，就有：
image.png
然后点击运行即可。
注意:反向生成后，最好把该指令删除，否则不小心点了之后，又会生成一遍代码，尤其是mapper.xml文件中sql语句又会生成一遍，运行时会报错。