ssm集成thylmeaf和mybatis-plus

最新推荐文章于 2022-10-29 11:00:00 发布

aaaaaaddddsssss

最新推荐文章于 2022-10-29 11:00:00 发布

阅读量156

点赞数

分类专栏：前端文章标签： mysql mybatis spring

本文链接：https://blog.csdn.net/aaaaaaddddsssss/article/details/115053837

版权

前端专栏收录该内容

21 篇文章 1 订阅

订阅专栏

SSM项目集成mybatis-plus
2019-12-06阅读 1660
1.导入mybatis-plus包

<dependency>
  <groupId>com.baomidou</groupId>
  <artifactId>mybatis-plus</artifactId>
  <version>2.1-gamma</version>
</dependency>
<dependency>
  <groupId>org.apache.velocity</groupId>
  <artifactId>velocity</artifactId>
  <version>1.7</version>
</dependency>
2.替换 spring.xml  配置文件中的 sqlSessionFactory

<!-- MyBatis SqlSessionFactoryBean 配置 -->
<bean id="sqlSessionFactory"
   class="com.baomidou.mybatisplus.spring.MybatisSqlSessionFactoryBean">
   <property name="dataSource" ref="dataSource" />
   <property name="configLocation" value="/WEB-INF/classes/mybaties/mybatis-config.xml" />
   <property name="typeAliasesPackage" value="com.entity" />
   <property name="mapperLocations" value="/WEB-INF/classes/mapper/xml/*.xml" />
   <property name="plugins">
      <array>
         <!-- 分页插件配置 -->
         <bean id="paginationInterceptor"
            class="com.baomidou.mybatisplus.plugins.PaginationInterceptor">
            <property name="dialectType" value="mysql" />
         </bean>
      </array>
   </property>
   <!-- MP 全局配置注入 -->
   <property name="globalConfig" ref="globalConfig"/>
</bean>

<!-- 定义 MP 全局策略 -->
<bean id="globalConfig" class="com.baomidou.mybatisplus.entity.GlobalConfiguration">
   <!-- 主键策略配置 -->
   <!-- 可选参数
           AUTO->`0`("数据库ID自增")
           INPUT->`1`(用户输入ID")
           ID_WORKER->`2`("全局唯一ID")
           UUID->`3`("全局唯一ID")
       -->
   <property name="idType" value="0"/>
   <!-- 数据库类型配置 -->
   <!-- 可选参数（默认mysql）
           MYSQL->`mysql`
           ORACLE->`oracle`
           DB2->`db2`
           H2->`h2`
           HSQL->`hsql`
           SQLITE->`sqlite`
           POSTGRE->`postgresql`
           SQLSERVER2005->`sqlserver2005`
           SQLSERVER->`sqlserver`
       -->
   <!--<property name="dbType" value="oracle"/>-->
   <!-- 全局表为下划线命名设置 true -->
   <property name="dbColumnUnderline" value="true"/>
</bean>
本文参与腾讯云自媒体分享计划，欢迎正在阅读的你也加入，一起分享。

ssm集成mp
在这里插入图片描述
https://cloud.tencent.com/developer/article/1550168

在这里插入图片描述

ssm集成thylmeaf
https://blog.csdn.net/malimingwq/article/details/78878758

SSM配置驼峰命名法
在这里插入图片描述
https://blog.csdn.net/qq_16696457/article/details/109230910

SSM文件
在这里插入图片描述
db.properties

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/markter?useUnicode=true&characterEncoding=utf8
jdbc.username=root
jdbc.password=123456

log4j.properties

# Global logging configuration
log4j.rootLogger=ERROR, stdout
# MyBatis logging configuration...
log4j.logger.com.itheima=DEBUG
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

applicationContext.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:aop="http://www.springframework.org/schema/aop"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
    http://www.springframework.org/schema/tx
    http://www.springframework.org/schema/tx/spring-tx-4.3.xsd
    http://www.springframework.org/schema/context
    http://www.springframework.org/schema/context/spring-context-4.3.xsd
    http://www.springframework.org/schema/aop
    http://www.springframework.org/schema/aop/spring-aop-4.3.xsd">
    <!-- 读取db.properties -->
    <context:property-placeholder location="classpath:db.properties"/>
    <!-- 配置数据源 -->
	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
		<property name="driverClass" value="${jdbc.driverClassName}" />
		<property name="jdbcUrl" value="${jdbc.url}" />
		<property name="user" value="${jdbc.username}" />
		<property name="password" value="${jdbc.password}" />
		<!-- 请求超时时间 -->
		<property name="checkoutTimeout" value="30000" />
		<!-- 每60秒检查所有连接池中的空闲连接。默认值: 0，不检查 -->
		<property name="idleConnectionTestPeriod" value="30" />
		<!-- 连接数据库连接池最大空闲时间 -->
		<property name="maxIdleTime" value="30" />
		<!-- 连接池初始化连接数 -->
		<property name="initialPoolSize" value="5" />
		<property name="minPoolSize" value="5" />
		<property name="maxPoolSize" value="20" />
		<!--当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。默认值: 3 -->
		<property name="acquireIncrement" value="5" />
	</bean>
     <!-- 事务管理器，依赖于数据源 -->
	<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource" />
	</bean>
    <!-- 开启事务注解 -->
	<tx:annotation-driven transaction-manager="transactionManager"/>
    <!-- 配置MyBatis工厂SqlSessionFactory -->
	<bean id="sqlSessionFactory"
		  class="com.baomidou.mybatisplus.spring.MybatisSqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource" />
         <!--指定核MyBatis心配置文件位置 -->
          <property name="configLocation" value="classpath:mybatis-config.xml" />
		
	</bean>

	<!-- 定义 MP 全局策略 -->
	<bean id="globalConfig" class="com.baomidou.mybatisplus.entity.GlobalConfiguration">
		<!-- 主键策略配置 -->
		<!-- 可选参数
                AUTO->`0`("数据库ID自增")
                INPUT->`1`(用户输入ID")
                ID_WORKER->`2`("全局唯一ID")
                UUID->`3`("全局唯一ID")
            -->
		<property name="idType" value="0"/>
		<!-- 数据库类型配置 -->
		<!-- 可选参数（默认mysql）
                MYSQL->`mysql`
                ORACLE->`oracle`
                DB2->`db2`
                H2->`h2`
                HSQL->`hsql`
                SQLITE->`sqlite`
                POSTGRE->`postgresql`
                SQLSERVER2005->`sqlserver2005`
                SQLSERVER->`sqlserver`
            -->
		<!--<property name="dbType" value="oracle"/>-->
		<!-- 全局表为下划线命名设置 true -->
		<property name="dbColumnUnderline" value="true"/>

	</bean>
	
    <!-- 配置mapper扫描器 -->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="com.example.mapper"/>
	</bean>
    <!-- 扫描Service -->
    <context:component-scan base-package="com.example" />
</beans>

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>
	<settings> 
		<!-- 打印查询语句 -->
        <setting name="logImpl" value="STDOUT_LOGGING" />
        <setting name="cacheEnabled" value="true" /><!-- 全局映射器启用缓存 -->   
        <setting name="useGeneratedKeys" value="true" /> 
        <setting name="defaultExecutorType" value="REUSE" />
        <setting name="mapUnderscoreToCamelCase" value="true"/>  <!-- 开启驼峰命名-->

    </settings>
	<!-- 别名定义 -->
	<typeAliases>
		<package name="com.example.entity" />
	</typeAliases>

</configuration>

springmvc-config.xml

<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:context="http://www.springframework.org/schema/context"
  xmlns:tx="http://www.springframework.org/schema/tx"
  xsi:schemaLocation="http://www.springframework.org/schema/beans 
  http://www.springframework.org/schema/beans/spring-beans-4.3.xsd 
  http://www.springframework.org/schema/mvc 
  http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd 
  http://www.springframework.org/schema/context 
  http://www.springframework.org/schema/context/spring-context-4.3.xsd">
	<!-- 配置包扫描器，扫描@Controller注解的类 -->
	<context:component-scan base-package="com.example.controller" />
	<!-- 加载注解驱动 -->
	<mvc:annotation-driven />

	<!--配置静态资源的访问映射，此配置中的文件，将不被前端控制器拦截 -->
	<mvc:resources location="/img/" mapping="/img/**"/>
	<mvc:resources location="/layer/" mapping="/layer/**"/>
	<mvc:resources location="/Scripts/" mapping="/Scripts/**"/>
	<mvc:resources location="/Styles/" mapping="/Styles/**"/>
	<mvc:resources location="/vendor/" mapping="/vendor/**"/>
	<mvc:resources location="/js/" mapping="/js/**"/>
	<mvc:resources location="/css/" mapping="/css/**"/>
<!--	<mvc:resources location="/fonts/" mapping="/fonts/**"/>-->
	<mvc:resources location="/images/" mapping="/images/**"/>
	<mvc:resources location="/lib/" mapping="/lib/**"/>
<!--	<mvc:resources location="/layui_exts/" mapping="/layui_exts/**"/>-->
	<mvc:resources location="/static/" mapping="/static/**"/>


<!--	<bean id="templateResolver" class="org.thymeleaf.spring4.templateresolver.SpringResourceTemplateResolver">-->
<!--		<property name="prefix" value="/WEB-INF/"/>-->
<!--		<property name="suffix" value=".html"/>-->
<!--		<property name="templateMode" value="HTML5"/>-->
<!--		<property name="cacheable" value="false"/>&lt;!&ndash; 缓存&ndash;&gt;-->
<!--		<property name="characterEncoding" value="UTF-8"/>&lt;!&ndash;解决中文乱码&ndash;&gt;-->
<!--	</bean>-->
<!--	<bean id="templateEngine"-->
<!--		  class="org.thymeleaf.spring4.SpringTemplateEngine">-->
<!--		<property name="templateResolver" ref="templateResolver"/>-->
<!--	</bean>-->
<!--	<bean class="org.thymeleaf.spring4.view.ThymeleafViewResolver">-->
<!--		<property name="templateEngine" ref="templateEngine"/>-->
<!--		<property name="order" value="2"/>-->
<!--		<property name="viewNames" value="*_th"/>-->
<!--		<property name="characterEncoding" value="UTF-8"/>&lt;!&ndash;解决中文乱码&ndash;&gt;-->
<!--	</bean>-->


	<!--静态资源-->
	<!-- 对静态资源文件的访问 支持访问WEB-INF目录 -->
	<mvc:resources mapping="/static/**" location="/static/" />

	 <!-- 为404界面，500界面做准备-->
<!--	 <mvc:resources mapping="/errorpage/*" location="/errorpage/" />-->
	<!-- 使用thymeleaf解析 -->
	 <bean id="templateResolver" class="org.thymeleaf.spring4.templateresolver.SpringResourceTemplateResolver">
<property name="prefix" value="/WEB-INF/"/>
	<property name="suffix" value=".html"/>
	 <property name="templateMode" value="HTML"/>
	 <property name="cacheable" value="false"/>
	 <property name="characterEncoding" value="UTF-8"/>
	</bean>

	<bean id="templateEngine" class="org.thymeleaf.spring4.SpringTemplateEngine">
	 <property name="templateResolver" ref="templateResolver"/>
	</bean>

	<bean id="viewResolver" class="org.thymeleaf.spring4.view.ThymeleafViewResolver">
	 <property name="templateEngine" ref="templateEngine"/>
	 <property name="characterEncoding" value="UTF-8"/>
	 </bean>


<!--	&lt;!&ndash; 配置视图解析器 &ndash;&gt;-->
<!--	<bean class=-->
<!--    "org.springframework.web.servlet.view.InternalResourceViewResolver">-->
<!--		<property name="prefix" value="/WEB-INF/" />-->
<!--		<property name="suffix" value=".jsp" />-->
<!--	</bean>-->
</beans>

pom.xml

  <properties>
    <maven.compiler.source>8</maven.compiler.source>
    <maven.compiler.target>8</maven.compiler.target>
    <junit.version>4.12</junit.version>
    <spring.version>4.3.8.RELEASE</spring.version>
    <mybatis.version>3.4.5</mybatis.version>
    <mybatis.spring.version>1.3.0</mybatis.spring.version>
    <mysql.version>5.1.38</mysql.version>
    <slf4j.version>1.6.4</slf4j.version>
    <jackson.version>2.9.7</jackson.version>
    <c3p0.version>0.9.5-pre10</c3p0.version>
    <jstl.version>1.2</jstl.version>
    <servlet-api.version>3.1.0</servlet-api.version>
    <jsp-api.version>2.2.1</jsp-api.version>
    <commons-lang3.version>3.3.2</commons-lang3.version>
    <commons-io.version>1.3.2</commons-io.version>
  </properties>
  <dependencies>


    <!-- 单元测试 -->
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>${junit.version}</version>
      <scope>test</scope>
    </dependency>

    <!-- Spring -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</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-webmvc</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-aspects</artifactId>
      <version>${spring.version}</version>
    </dependency>



    <!--代码生成 -->
    <!-- Apache Velocity的依赖 -->
    <dependency>
      <groupId>org.apache.velocity</groupId>
      <artifactId>velocity-engine-core</artifactId>
      <version>2.0</version>
    </dependency>


    <!-- MySql -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>${mysql.version}</version>
    </dependency>

    <dependency>
      <groupId>org.slf4j</groupId>
      <artifactId>slf4j-log4j12</artifactId>
      <version>${slf4j.version}</version>
    </dependency>

    <!-- Jackson Json处理工具包 -->
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-databind</artifactId>
      <version>${jackson.version}</version>
    </dependency>


    <dependency>
      <groupId>com.baomidou</groupId>
      <artifactId>mybatis-plus</artifactId>
      <version>2.1-gamma</version>
    </dependency>
    <dependency>
      <groupId>org.apache.velocity</groupId>
      <artifactId>velocity</artifactId>
      <version>1.7</version>
    </dependency>



    <!-- c3p0数据源 -->
    <dependency>
      <groupId>com.mchange</groupId>
      <artifactId>c3p0</artifactId>
      <version>${c3p0.version}</version>
    </dependency>

    <!-- JSP相关 -->
    <dependency>
      <groupId>jstl</groupId>
      <artifactId>jstl</artifactId>
      <version>${jstl.version}</version>
    </dependency>

    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>javax.servlet-api</artifactId>
      <version>${servlet-api.version}</version>
      <scope>provided</scope>
    </dependency>

        <dependency>
            <groupId>javax.servlet.jsp</groupId>
            <artifactId>javax.servlet.jsp-api</artifactId>
            <version>${jsp-api.version}</version>
            <scope>provided</scope>
        </dependency>

  <!-- 引入thymeleaf -->
    <dependency>
    <groupId>org.thymeleaf</groupId>
    <artifactId>thymeleaf</artifactId>
   <version>3.0.0.RELEASE</version>
 </dependency>

 <dependency>
  <groupId>org.thymeleaf</groupId>
     <artifactId>thymeleaf-spring4</artifactId>
   <version>3.0.0.RELEASE</version>
 <exclusions>
 <exclusion>
 <artifactId>javassist</artifactId>
    <groupId>org.javassist</groupId>
</exclusion>
 </exclusions>
  </dependency>

     <dependency>
   <groupId>org.thymeleaf.extras</groupId>
  <artifactId>thymeleaf-extras-springsecurity4</artifactId>
  <version>3.0.0.RELEASE</version>
 </dependency>

   <dependency>
  <groupId>org.thymeleaf.extras</groupId>
  <artifactId>thymeleaf-extras-java8time</artifactId>
    <version>3.0.0.RELEASE</version>
</dependency>

    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-databind</artifactId>
      <version>2.6.0</version>
    </dependency>

    <dependency>
      <groupId>org.projectlombok</groupId>
      <artifactId>lombok</artifactId>
      <version>1.18.16</version>
    </dependency>

    <!-- Apache工具组件 -->
    <dependency>
      <groupId>org.apache.commons</groupId>
      <artifactId>commons-lang3</artifactId>
      <version>${commons-lang3.version}</version>
    </dependency>
    <dependency>
      <groupId>org.apache.commons</groupId>
      <artifactId>commons-io</artifactId>
      <version>${commons-io.version}</version>
    </dependency>
    <dependency>
      <groupId>com.baomidou</groupId>
      <artifactId>mybatis-plus-core</artifactId>
      <version>3.1.2</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-test</artifactId>
      <version>5.3.3</version>
      <scope>test</scope>
    </dependency>


  </dependencies>