SpringBoot整合Mybatis自动建表

我不是女神ヾ 2023-06-07 12:11 10阅读 0赞

# 运行环境 #

jdk版本：jdk1.8.0_202
    springboot版本：2.2.0
    mysql版本：5.6.31

# 代码实现 #

1、在pom.xml中添加依赖包

<dependency>
                <groupId>com.gitee.sunchenbin.mybatis.actable</groupId>
                <artifactId>mybatis-enhance-actable</artifactId>
                <version>1.0.3</version>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.47</version>
                <scope>runtime</scope>
            </dependency>
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>2.1.0</version>
            </dependency>
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.1.16</version>
            </dependency>
            <dependency>
                <groupId>commons-lang</groupId>
                <artifactId>commons-lang</artifactId>
                <version>2.6</version>
            </dependency>

2、创建自动建表配置类（AutoTableConfig.java ）

package com.jeff.config;
    
    /** * @author Jeff * @description 自动建表配置类 * @date 2019/10/27 */
    import com.alibaba.druid.pool.DruidDataSource;
    import org.mybatis.spring.SqlSessionFactoryBean;
    import org.springframework.beans.factory.annotation.Value;
    import org.springframework.beans.factory.config.PropertiesFactoryBean;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.ComponentScan;
    import org.springframework.context.annotation.Configuration;
    import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
    import org.springframework.jdbc.datasource.DataSourceTransactionManager;
    
    @Configuration
    @ComponentScan(basePackages = {  "com.gitee.sunchenbin.mybatis.actable.manager.*" })
    public class AutoTableConfig { 
    
        @Value("${spring.datasource.driver-class-name}")
        private String driver;
    
        @Value("${spring.datasource.url}")
        private String url;
    
        @Value("${spring.datasource.username}")
        private String username;
    
        @Value("${spring.datasource.password}")
        private String password;
    
        @Bean
        public PropertiesFactoryBean configProperties() throws Exception{ 
            PropertiesFactoryBean propertiesFactoryBean = new PropertiesFactoryBean();
            PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
            propertiesFactoryBean.setLocations(resolver.getResources("classpath*:application.properties"));
            return propertiesFactoryBean;
        }
    
        @Bean
        public DruidDataSource dataSource() { 
            DruidDataSource dataSource = new DruidDataSource();
            dataSource.setDriverClassName(driver);
            dataSource.setUrl(url);
            dataSource.setUsername(username);
            dataSource.setPassword(password);
            dataSource.setMaxActive(30);
            dataSource.setInitialSize(10);
            dataSource.setValidationQuery("SELECT 1");
            dataSource.setTestOnBorrow(true);
            return dataSource;
        }
    
        @Bean
        public DataSourceTransactionManager dataSourceTransactionManager() { 
            DataSourceTransactionManager dataSourceTransactionManager = new DataSourceTransactionManager();
            dataSourceTransactionManager.setDataSource(dataSource());
            return dataSourceTransactionManager;
        }
    
        @Bean
        public SqlSessionFactoryBean sqlSessionFactory() throws Exception{ 
            SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
            sqlSessionFactoryBean.setDataSource(dataSource());
            PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
            sqlSessionFactoryBean.setMapperLocations(resolver.getResources("classpath*:com/gitee/sunchenbin/mybatis/actable/mapping/*/*.xml"));
            //实体类的位置
            sqlSessionFactoryBean.setTypeAliasesPackage("com.jeff.entity.*");
            return sqlSessionFactoryBean;
        }
    
    }

3、创建mybatis配置类（MyBatisMapperScannerConfig.java）

package com.jeff.config;
    
    /** * @author Jeff * @description mybatis配置类 * @date 2019/10/27 */
    import org.mybatis.spring.mapper.MapperScannerConfigurer;
    import org.springframework.boot.autoconfigure.AutoConfigureAfter;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    
    @Configuration
    @AutoConfigureAfter(AutoTableConfig.class)
    public class MyBatisMapperScannerConfig { 
    
        @Bean
        public MapperScannerConfigurer mapperScannerConfigurer() throws Exception{ 
            MapperScannerConfigurer mapperScannerConfigurer = new MapperScannerConfigurer();
            mapperScannerConfigurer.setBasePackage("com.jeff.mapper.*;com.gitee.sunchenbin.mybatis.actable.dao.*");
            mapperScannerConfigurer.setSqlSessionFactoryBeanName("sqlSessionFactory");
            return mapperScannerConfigurer;
        }
    
    }

4、创建用户实体类（SysUser.java）

package com.jeff.entity;
    
    import com.gitee.sunchenbin.mybatis.actable.annotation.Column;
    import com.gitee.sunchenbin.mybatis.actable.annotation.Table;
    import com.gitee.sunchenbin.mybatis.actable.constants.MySqlTypeConstant;
    
    import java.util.Date;
    
    /** * @author Jeff * @description 用户实体类 * @date 2019/10/27 */
    @Table(name = "sys_user")
    public class SysUser { 
    
        @Column(name = "id", type = MySqlTypeConstant.BIGINT, isKey = true, isAutoIncrement = true)
        private Long id;//主键id
    
        @Column(name = "login_name", type = MySqlTypeConstant.VARCHAR, length = 64, isNull = false, isUnique = true)
        private String loginName;//登陆名
    
        @Column(name = "password", type = MySqlTypeConstant.VARCHAR, length = 64, isNull = false)
        private String password;//密码
    
        @Column(name = "salt", type = MySqlTypeConstant.VARCHAR, length = 64, isNull = false)
        private String salt;//盐
    
        @Column(name = "sex", type = MySqlTypeConstant.INT)
        private Integer sex;//性别
    
        @Column(name = "status", type = MySqlTypeConstant.INT, isNull = false)
        private Integer status;//状态
    
        @Column(name = "name", type = MySqlTypeConstant.VARCHAR, length = 64)
        private String name;//真实姓名
    
        @Column(name = "nick_name", type = MySqlTypeConstant.VARCHAR, length = 64)
        private String nickName;//昵称
    
        @Column(name = "phone", type = MySqlTypeConstant.VARCHAR, length = 64)
        private String phone;//手机号
    
        @Column(name = "email", type = MySqlTypeConstant.VARCHAR, length = 64)
        private String email;//邮箱
    
        @Column(name = "birthday", type = MySqlTypeConstant.DATETIME)
        private Date birthday;//生日
    
        @Column(name = "headimg_url", type = MySqlTypeConstant.VARCHAR, length = 255)
        private String headimgUrl;//用户头像
    
        @Column(name = "role_id", type = MySqlTypeConstant.BIGINT, isNull = false)
        private Long roleId;//角色id
    
        @Column(name = "create_time", type = MySqlTypeConstant.DATETIME)
        private Date createTime;//创建时间
    
        @Column(name = "create_name", type = MySqlTypeConstant.VARCHAR, length = 20)
        private String createName;//创建人
    
        @Column(name = "modify_time", type = MySqlTypeConstant.DATETIME)
        private Date modifyTime;//修改时间
    
        @Column(name = "modify_name", type = MySqlTypeConstant.VARCHAR, length = 20)
        private String modifyName;//修改人
    }

5、创建全局配置文件（application.properties）

spring.datasource.driver-class-name=com.mysql.jdbc.Driver
    spring.datasource.url=jdbc:mysql://192.168.1.106:3306/jeff?characterEncoding=UTF-8
    spring.datasource.username=root
    spring.datasource.password=123456
    
    # MySql自动建表
    #create，系统启动后，会将所有表删除，然后根据路径包中的实体类进行重新建表（会破坏原有数据）
    #none，不做任何处理
    #update，系统启动是会自动判断哪些表需要新建，哪些字段需要修改（不会破坏原有数据）
    mybatis.table.auto=update
    #建表的对象包路径
    mybatis.model.pack=com.jeff.entity
    mybatis.database.type=mysql

6、启动SpringBoot项目，会自动创建sys\_user表和sys\_user表结构  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTczOTcyMA_size_16_color_FFFFFF_t_70]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTczOTcyMA_size_16_color_FFFFFF_t_70 1]

# 源码地址： #

[https://gitee.com/jiefu813/jf-springboot/tree/jf\_mybatis/][https_gitee.com_jiefu813_jf-springboot_tree_jf_mybatis]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTczOTcyMA_size_16_color_FFFFFF_t_70]: /images/20230601/4a64fec3bb794acf9d52cf49cce6a21c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTczOTcyMA_size_16_color_FFFFFF_t_70 1]: /images/20230601/7c6ca46bf91048aaaa01ef9f3a73e82c.png
[https_gitee.com_jiefu813_jf-springboot_tree_jf_mybatis]: https://gitee.com/jiefu813/jf-springboot/tree/jf_mybatis/