5_关于外部属性配置文件存储数据库连接信息

墨蓝 2023-09-27 15:48 104阅读 0赞

在resources下准备jdbc.properties属性配置文件

![2b90e52483575bd649bf91b40f9e22a7.png][]

配置文件中的内容

jdbc_driver=com.mysql.cj.jdbc.Driver
    jdbc_url=jdbc:mysql://127.0.0.1:3306/mydb?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
    jdbc_username=root
    jdbc_password=root

![61f24ef8b17ba7cf07f0f8ae4a80826c.gif][]

![ace8b0f63a92424541b767e5413d2dab.gif][]

在核心配置文件中引入db.properties属性文件

<?xml version="1.0" encoding="UTF-8" ?>
    
    <!DOCTYPE configuration
            PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
        <properties resource="jdbc.properties"></properties>
        <settings>
            
            <setting name="logImpl" value="LOG4J"/>
        </settings>
        
        <typeAliases>
            
            <package name="com.msb.pojo"/>
        </typeAliases>
        
        <environments default="mysql">
            
            <environment id="mysql">
                <transactionManager type="JDBC"/>
                
                <dataSource type="POOLED">
                    <property name="driver" value="${jdbc_driver}"/>
                    <property name="url" value="${jdbc_url}"/>
                    <property name="username" value="${jdbc_username}"/>
                    <property name="password" value="${jdbc_password}"/>
                </dataSource>
            </environment>
        </environments>
        
        <mappers>
            <mapper resource="com/msb/mapper/DeptMapper.xml"/>
        </mappers>
    </configuration>

![44abdd2a9da0d6121ee8b1acd6cfc50c.gif][]

![cef98f451a7119889f5ea93d10da16eb.gif][]

[2b90e52483575bd649bf91b40f9e22a7.png]: https://img-blog.csdnimg.cn/img_convert/2b90e52483575bd649bf91b40f9e22a7.png
[61f24ef8b17ba7cf07f0f8ae4a80826c.gif]: https://img-blog.csdnimg.cn/img_convert/61f24ef8b17ba7cf07f0f8ae4a80826c.gif
[ace8b0f63a92424541b767e5413d2dab.gif]: https://img-blog.csdnimg.cn/img_convert/ace8b0f63a92424541b767e5413d2dab.gif
[44abdd2a9da0d6121ee8b1acd6cfc50c.gif]: https://img-blog.csdnimg.cn/img_convert/44abdd2a9da0d6121ee8b1acd6cfc50c.gif
[cef98f451a7119889f5ea93d10da16eb.gif]: https://img-blog.csdnimg.cn/img_convert/cef98f451a7119889f5ea93d10da16eb.gif