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> //可以执行单表操作了