-集成mybatisplus实现mybatis增强

admin

2025-01-02 d52d5f7884203945f2433e27c7cf231c7dafd529

-集成mybatisplus实现mybatis增强

 dema-common/pom.xml

@@ -119,6 +119,13 @@
            <artifactId>javax.servlet-api</artifactId>
        </dependency>

        <!-- mybatis-plus å¢žå¼ºCRUD -->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.5.1</version>
        </dependency>

    </dependencies>

</project>

 dema-framework/src/main/java/com/dema/framework/config/MyBatisConfig.java

ÎļþÒÑɾ³ý

 dema-framework/src/main/java/com/dema/framework/config/MybatisPlusConfig.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,63 @@
package com.dema.framework.config;

import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.BlockAttackInnerInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.OptimisticLockerInnerInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.transaction.annotation.EnableTransactionManagement;

/**
 * Mybatis Plus é…ç½®
 *
 * @author ruoyi
 */
@EnableTransactionManagement(proxyTargetClass = true)
@Configuration
public class MybatisPlusConfig
{
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor()
    {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        // åˆ†é¡µæ’件
        interceptor.addInnerInterceptor(paginationInnerInterceptor());
        // ä¹è§‚锁插件
        interceptor.addInnerInterceptor(optimisticLockerInnerInterceptor());
        // é˜»æ–­æ’件
        interceptor.addInnerInterceptor(blockAttackInnerInterceptor());
        return interceptor;
    }

    /**
     * åˆ†é¡µæ’件，自动识别数据库类型 https://baomidou.com/guide/interceptor-pagination.html
     */
    public PaginationInnerInterceptor paginationInnerInterceptor()
    {
        PaginationInnerInterceptor paginationInnerInterceptor = new PaginationInnerInterceptor();
        // è®¾ç½®æ•°æ®åº“类型为mysql
        paginationInnerInterceptor.setDbType(DbType.MYSQL);
        // è®¾ç½®æœ€å¤§å•é¡µé™åˆ¶æ•°é‡ï¼Œé»˜è®¤ 500 æ¡ï¼Œ-1 ä¸å—限制
        paginationInnerInterceptor.setMaxLimit(-1L);
        return paginationInnerInterceptor;
    }

    /**
     * ä¹è§‚锁插件 https://baomidou.com/guide/interceptor-optimistic-locker.html
     */
    public OptimisticLockerInnerInterceptor optimisticLockerInnerInterceptor()
    {
        return new OptimisticLockerInnerInterceptor();
    }

    /**
     * å¦‚果是对全表的删除或更新操作，就会终止该操作 https://baomidou.com/guide/interceptor-block-attack.html
     */
    public BlockAttackInnerInterceptor blockAttackInnerInterceptor()
    {
        return new BlockAttackInnerInterceptor();
    }
}

 dema-main/src/main/java/com/dema/main/am/mapper/AmWorkHourInfoMapper.java

@@ -1,6 +1,8 @@
package com.dema.main.am.mapper;

import java.util.List;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dema.main.am.domain.AmWorkHourInfo;

/**
@@ -9,7 +11,7 @@
 * @author HDY
 * @date 2024-12-25
 */
public interface AmWorkHourInfoMapper
public interface AmWorkHourInfoMapper extends BaseMapper<AmWorkHourInfo>
{
    /**
     * æŸ¥è¯¢å·¥æ—¶æ˜Žç»†

 dema-main/src/main/java/com/dema/main/am/service/IAmWorkHourInfoService.java

@@ -1,6 +1,8 @@
package com.dema.main.am.service;

import java.util.List;

import com.baomidou.mybatisplus.extension.service.IService;
import com.dema.main.am.domain.AmWorkHourInfo;

/**
@@ -9,7 +11,7 @@
 * @author HDY
 * @date 2024-12-25
 */
public interface IAmWorkHourInfoService
public interface IAmWorkHourInfoService extends IService<AmWorkHourInfo>
{
    /**
     * æŸ¥è¯¢å·¥æ—¶æ˜Žç»†

 dema-main/src/main/java/com/dema/main/am/service/impl/AmWorkHourInfoServiceImpl.java

@@ -3,6 +3,7 @@
import java.util.Date;
import java.util.List;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.dema.common.core.domain.entity.SysDept;
import com.dema.common.core.domain.entity.SysUser;
import com.dema.common.core.domain.model.LoginUser;
@@ -23,7 +24,7 @@
 * @date 2024-12-25
 */
@Service
public class AmWorkHourInfoServiceImpl implements IAmWorkHourInfoService
public class AmWorkHourInfoServiceImpl extends ServiceImpl<AmWorkHourInfoMapper,AmWorkHourInfo> implements IAmWorkHourInfoService
{
    @Autowired
    private AmWorkHourInfoMapper amWorkHourInfoMapper;

 dema-main/src/main/java/com/dema/main/bs/controller/BsProjectInfoController.java

@@ -6,6 +6,7 @@
import com.dema.common.annotation.Log;
import com.dema.common.core.controller.BaseController;
import com.dema.common.core.domain.AjaxResult;
import com.dema.common.core.domain.R;
import com.dema.common.core.page.TableDataInfo;
import com.dema.common.enums.BusinessType;
import com.dema.common.utils.poi.ExcelUtil;
@@ -70,6 +71,12 @@
        util.exportExcel(response, list, "项目信息数据");
    }

    @PostMapping("/test")
    public R test()
    {
        return R.fail(bsProjectInfoService.list());
    }

    /**
     * èŽ·å–项目信息详细信息
     */

 dema-main/src/main/java/com/dema/main/bs/domain/BsProjectInfo.java

@@ -5,13 +5,15 @@
import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;

import java.io.Serializable;

/**
 * é¡¹ç›®ä¿¡æ¯å¯¹è±¡ bs_project_info
 * 
 * @author HDY
 * @date 2024-12-24
 */
public class BsProjectInfo extends BaseEntity
public class BsProjectInfo implements Serializable
{
    private static final long serialVersionUID = 1L;

@@ -112,9 +114,6 @@
            .append("projectCode", getProjectCode())
            .append("projectName", getProjectName())
            .append("projectType", getProjectType())
            .append("remark", getRemark())
            .append("createTime", getCreateTime())
            .append("updateTime", getUpdateTime())
            .append("createUser", getCreateUser())
            .append("updateUser", getUpdateUser())
            .append("delFlag", getDelFlag())

 dema-main/src/main/java/com/dema/main/bs/mapper/BsProjectInfoMapper.java

@@ -1,6 +1,8 @@
package com.dema.main.bs.mapper;

import java.util.List;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dema.main.bs.domain.BsProjectInfo;

/**
@@ -9,7 +11,7 @@
 * @author HDY
 * @date 2024-12-24
 */
public interface BsProjectInfoMapper 
public interface BsProjectInfoMapper extends BaseMapper<BsProjectInfo>
{
    /**
     * æŸ¥è¯¢é¡¹ç›®ä¿¡æ¯

 dema-main/src/main/java/com/dema/main/bs/service/IBsProjectInfoService.java

@@ -1,6 +1,8 @@
package com.dema.main.bs.service;

import java.util.List;

import com.baomidou.mybatisplus.extension.service.IService;
import com.dema.main.bs.domain.BsProjectInfo;

/**
@@ -9,7 +11,7 @@
 * @author HDY
 * @date 2024-12-24
 */
public interface IBsProjectInfoService 
public interface IBsProjectInfoService extends IService<BsProjectInfo>
{
    /**
     * æŸ¥è¯¢é¡¹ç›®ä¿¡æ¯

 dema-main/src/main/java/com/dema/main/bs/service/impl/BsProjectInfoServiceImpl.java

@@ -1,6 +1,8 @@
package com.dema.main.bs.service.impl;

import java.util.List;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.dema.main.bs.mapper.BsProjectInfoMapper;
import com.dema.main.bs.domain.BsProjectInfo;
import com.dema.main.bs.service.IBsProjectInfoService;
@@ -14,7 +16,7 @@
 * @date 2024-12-24
 */
@Service
public class BsProjectInfoServiceImpl implements IBsProjectInfoService 
public class BsProjectInfoServiceImpl extends ServiceImpl<BsProjectInfoMapper, BsProjectInfo> implements IBsProjectInfoService
{
    @Autowired
    private BsProjectInfoMapper bsProjectInfoMapper;