1、添加依赖

<dependency>
  <groupId>com.alibaba</groupId>
  <artifactId>druid</artifactId>
  <version>1.2.10</version>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.28</version>
</dependency>
<dependency>
    <groupId>javax.servlet</groupId>
    <artifactId>javax.servlet-api</artifactId>
    <version>3.1.0</version>
</dependency>
<dependency>
  <groupId>com.baomidou</groupId>
  <artifactId>mybatis-plus</artifactId>
  <version>2.3</version>
</dependency>
<dependency>
    <groupId>org.singledog</groupId>
    <artifactId>mybatis-spring</artifactId>
    <version>1.3.3</version>
</dependency>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
    <version>5.2.22.RELEASE</version>
</dependency>

2、配置springmvc配置文件

<bean id="sqlSessionFactoryBean" class="com.baomidou.mybatisplus.spring.MybatisSqlSessionFactoryBean">
    <property name="typeAliasesPackage" value="com.gzh.entity"/>
    <property name="dataSource" ref="dataSource"/>
     <!--2.3 配置mybatis-plus插件-->
    <property name="plugins">
        <list>
            <!--配置分页插件-->
            <bean class="com.baomidou.mybatisplus.plugins.PaginationInterceptor"/>
            <!--配置拦截器属性-->
            <bean class="com.baomidou.mybatisplus.plugins.PerformanceInterceptor">
                <property name="maxTime" value="1000"/>
                <property name="format" value="true"/>
            </bean>
        </list>
    </property>
    <!--全局配置 例如主键自增策略-->
    <property name="globalConfig" ref="globalConfiguration"/>
    <property name="mapperLocations" value="classpath:mapper/*.xml"/>
</bean>



<!--3、配置Mybatis-Plus全局属性-->
<bean id="globalConfiguration" class="com.baomidou.mybatisplus.entity.GlobalConfiguration">
    <!--2.3以后的版本中dbColumnUnderline默认为true，即开启驼峰命名-->
    <property name="dbColumnUnderline" value="true"/>
    <!--全局主键策略
      0 ：AUTO(主键自增)
      1 ：INPUT(用户输入ID)
      2 ：ID_WORKER(全局唯一ID)
      3 ：UUID(全局唯一ID)
    -->
    <property name="idType" value="0"/>
    <property name="tablePrefix" value="tbl_"/>
    <property name="logicDeleteValue" value="1"/>
    <property name="logicNotDeleteValue" value="0"/>
</bean>

<context:property-placeholder location="classpath:druid.properties"/>
<!--一定要在username...前加前缀-->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
    <property name="url" value="${jdbc.url}"/>
    <property name="driverClassName" value="${jdbc.driverClassName}"/>
    <property name="username" value="${jdbc.username}"/>
    <property name="password" value="${jdbc.password}"/>
    <property name="maxWait" value="${maxWait}"/>
    <property name="maxWaitThreadCount" value="${maxWaitThreadCount}"/>
    <property name="loginTimeout" value="${loginTimeout}"/>
    <property name="keepAlive" value="${keepAlive}"/>
    <property name="minIdle" value="${minIdle}"/>
</bean>

<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    <property name="sqlSessionFactoryBeanName" value="sqlSessionFactoryBean"/>
    <property name="basePackage" value="com.gzh.mapper"/>
</bean>

3、继承BaseMapper<T>

public interface UserMapper extends BaseMapper<User> //可以执行单表操作了