添加mysql依赖

13693261870

2023-10-05 3947e884db031e336548083e7e43b1f7c1e734f3

添加mysql依赖

 pom.xml

@@ -10,7 +10,7 @@
    </parent>
    <groupId>com.smartearth</groupId>
    <artifactId>poiExcel</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <version>0.0.1</version>
    <name>poiExcel</name>
    <description>poiExcel</description>
    <properties>
@@ -111,12 +111,38 @@
            <artifactId>cglib</artifactId>
            <version>3.1</version>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <!--mybatis-plus-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.5.1</version>
        </dependency>
        <!--druid-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.22</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.22</version>
        </dependency>
        <!--mysql-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <!--jdbc-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
    </dependencies>

    <build>

 src/main/java/com/smartearth/poiexcel/controller/OrgPoiController.java

@@ -218,7 +218,7 @@
                        String formatted_address = object.getString("formatted_address");
                        if (!StringUtils.isEmpty(formatted_address)) {
                            String encoding = getEncoding(formatted_address);
                            log.info("encoding: {}", encoding);
                            //log.info("encoding: {}", encoding);
                            if (!"UTF-8".equals(encoding) && !"".equals(encoding)) {
                                formatted_address = new String(formatted_address.getBytes(encoding), "UTF-8");
                            }

 src/main/resources/application.properties

@@ -4,4 +4,12 @@
#address.code.url=http://172.26.64.84/service/AddrCode/cmd
address.code.url=http://192.162.29.2:8081/proxy/address/service/AddrCode/cmd
excel.export.dir=D:\\excel\\
#excel.export.dir=/Users/mahui/excel
#excel.export.dir=/Users/mahui/excel

# 数据源配置
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driverClassName=com.mysql.jdbc.Driver
spring.datasource.url: jdbc:mysql://127.0.0.1:3306/yssh?useUnicode=true&rewriteBatchedStatements=true&characterEncoding=utf-8&useSSL=true&serverTimezone=GMT%2B8
spring.datasource.username=root
spring.datasource.password=mysql