springboot学习(三):使用c3p0连接池集成mybatis及mybatis自动代码生成插件

忘是亡心i 2022-05-17 01:54 427阅读 0赞

\#说明  
springboot集成mybatis和使用c3p0连接池，当初学习时过程还是比较艰难的，以[翟永超][Link 1]的博客为基础，再找各种资料博客进行学习，还有在学习mybatis自动代码生成插件时，遇到的问题也不少，今天在这里进行回顾总结下。  
\#正文  
构建springboot项目，添加依赖mybatis和mysql-connector-java，[start.spring.io][]在构建也不支持c3p0的自动添加，需要到maven资源库找[c3p0][]的依赖。这里同样放到本地的tomcat中运行，添加web依赖。使用自动插件，要在pom.xml中添加插件

<dependencies>
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-web</artifactId>
    		</dependency>
    		<dependency>
    			<groupId>org.mybatis.spring.boot</groupId>
    			<artifactId>mybatis-spring-boot-starter</artifactId>
    			<version>1.3.2</version>
    		</dependency>
    		<dependency>
    			<groupId>mysql</groupId>
    			<artifactId>mysql-connector-java</artifactId>
    			<scope>runtime</scope>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>com.mchange</groupId>
    			<artifactId>c3p0</artifactId>
    			<version>0.9.5.2</version>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-test</artifactId>
    			<scope>test</scope>
    		</dependency>
    	</dependencies>
    	
    	<build>
    		<resources>
    			<resource>
    				<directory>src/main/java</directory>
    				<includes>
    					<include>**/*.xml</include>
    				</includes>
    				<filtering>false</filtering>
    			</resource>
    		</resources>
    
    		<plugins>
    			<plugin>
    				<groupId>org.springframework.boot</groupId>
    				<artifactId>spring-boot-maven-plugin</artifactId>
    			</plugin>
    			<plugin>
    				<groupId>org.mybatis.generator</groupId>
    				<artifactId>mybatis-generator-maven-plugin</artifactId>
    				<version>1.3.2</version>
    				<configuration>
    					<configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</configurationFile>
    					<overwrite>true</overwrite>
    					<verbose>true</verbose>
    				</configuration>
    			</plugin>
    		</plugins>
    	</build>

创建好项目后，需要对c3p0和mybatis进行配置，首先在application.properties文件中配置mysql

c3p0.datasource.driverClass=com.mysql.jdbc.Driver
    c3p0.datasource.jdbcUrl=jdbc:mysql://localhost:3306/springboot
    c3p0.datasource.user=root
    c3p0.datasource.password=123
    c3p0.datasource.minPoolSize=3
    c3p0.datasource.maxPoolSize=100
    c3p0.datasource.initialPoolSize=3

\#\#DataSourceConfig

@Configuration
    public class DataSourceConfig {
    
        @ConfigurationProperties(prefix = "c3p0.datasource")
        @Primary
        @Bean(name = "dataSource")
        public DataSource dataSource(){
            return DataSourceBuilder.create().type(com.mchange.v2.c3p0.ComboPooledDataSource.class).build();
        }
    }

\#\#MybatisConfig

@Configuration
    @MapperScan(basePackages = {"com.example.mybatis.dao"})
    public class MybatisConfig {
    
        @Autowired
        private DataSource dataSource;
    
        @Bean(name = "sqlSessionFactory")
        public SqlSessionFactoryBean sqlSessionFactory(ApplicationContext applicationContext) throws IOException {
            SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
            sessionFactory.setDataSource(dataSource);
            sessionFactory.setTypeAliasesPackage("com.example.mybatis.bean");
            Resource[] resources = new PathMatchingResourcePatternResolver()
                    .getResources("classpath*:com/example/mybatis/mapper/*Mapper.xml");
            sessionFactory.setMapperLocations(resources);
    
            return sessionFactory;
        }
    }

配置好c3p0和mybatis后，需要对插件进行配置，创建generatorConfig.xml  
更详细的配置请见：[http://www.mybatis.org/generator/configreference/xmlconfig.html][http_www.mybatis.org_generator_configreference_xmlconfig.html]

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE generatorConfiguration
            PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
            "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
    
    <generatorConfiguration>
        <classPathEntry location="./src/main/resources/lib/mysql-connector-java-5.1.25-bin.jar"></classPathEntry>
        <context id="DB2Tables" targetRuntime="Mybatis3">
            <commentGenerator>
                
                <property name="suppressAllComments" value="true"/>
            </commentGenerator>
            <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                            connectionURL="jdbc:mysql://localhost:3306/springboot"
                            userId="root"
                            password="123"
            />
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
            
            <javaModelGenerator targetPackage="com.example.mybatis.bean" targetProject="src/main/java">
                <property name="enableSubPackages" value="true" />
                <property name="trimStrings" value="true" />
            </javaModelGenerator>
    
            
            <sqlMapGenerator targetPackage="com.example.mybatis.mapper"  targetProject="src/main/java">
                <property name="enableSubPackages" value="true" />
            </sqlMapGenerator>
    
            
            <javaClientGenerator type="XMLMAPPER" targetPackage="com.example.mybatis.dao"  targetProject="src/main/java">
                <property name="enableSubPackages" value="true" />
            </javaClientGenerator>
    
            
            <table tableName="t_teacher" domainObjectName="Teacher" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table>
            
        </context>
    </generatorConfiguration>

配置好后需要在maven的插件中执行，也可以创建maven执行快捷方式  
![这里写图片描述][20180804201834546]  
![这里写图片描述][20180804201855457]  
![这里写图片描述][20180804201913507]

源码地址：[https://github.com/Edenwds/springboot\_study/tree/master/mybatis][https_github.com_Edenwds_springboot_study_tree_master_mybatis]

[Link 1]: http://blog.didispace.com/springbootmybatis/
[start.spring.io]: https://start.spring.io/
[c3p0]: http://mvnrepository.com/artifact/com.mchange/c3p0
[http_www.mybatis.org_generator_configreference_xmlconfig.html]: http://www.mybatis.org/generator/configreference/xmlconfig.html
[20180804201834546]: /images/20220517/51af6a86fff3444ca0d3927899b476cf.png
[20180804201855457]: /images/20220517/e7ac077677334d19a51e62b51156a0ec.png
[20180804201913507]: /images/20220517/a6e9f4e6ecda49a3acc37f708a716736.png
[https_github.com_Edenwds_springboot_study_tree_master_mybatis]: https://github.com/Edenwds/springboot_study/tree/master/mybatis