MybatisPlus：整合Spring

谁借莪１个温暖的怀抱￠ 2024-03-23 13:05 81阅读 0赞

### 依赖 ###

<dependency>
        <groupId>com.baomidou</groupId>
        <artifactId>mybatis-plus</artifactId>
        <version>3.1.1</version>
    </dependency>
    
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.47</version>
    </dependency>
    
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>1.0.11</version>
    </dependency>

### **配置文件** ###

**jdbc.properties**

jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://127.0.0.1:3306/mp?serverTimezone=GMT%2B8&useSSL=false
    jdbc.username=root
    jdbc.password=root

**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:context="http://www.springframework.org/schema/context"
           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">
    
        
        <context:property-placeholder location="classpath:jdbc.properties"/>
        
        
        <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
            <property name="driverClassName" value="${jdbc.driver}"/>
            <property name="url" value="${jdbc.url}"/>
            <property name="username" value="${jdbc.username}"/>
            <property name="password" value="${jdbc.password}"/>
        </bean>
    
        
        <bean id="sqlSessionFactory"
              class="com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean"
        >
            <property name="dataSource" ref="dataSource"/>
        </bean>
    
        
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            <property name="basePackage" value="com.wuxian.mapper"/>
        </bean>
    </beans>

### Bean ###

import com.baomidou.mybatisplus.annotation.*;
    import lombok.Data;
    import java.util.Date;
    
    @Data
    @TableName(value = "t_user")
    public class UserDO {
    
        @TableId(value = "id", type = IdType.INPUT)
        private Integer id;
    
        @TableField(value = "user_name")
        private String name;
    
        @TableField(value = "mobile")
        private String mobile;
    
        @TableField(value = "birthday")
        private Date birthday;
    
    }

### Mapper ###

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
    
    public interface UserMapper extends BaseMapper<UserDO> {
    }

### Service ###

import com.baomidou.mybatisplus.extension.service.IService;
    
    public interface UserService extends IService<UserDO>{
    
    }

### ServiceImpl ###

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
    import org.springframework.stereotype.Service;
    
    @Service
    public class UserServiceImpl extends ServiceImpl<UserMapper, UserDO> implements UserService {
    
    }