Vert.x JDBC Client简单实例

1、添加依赖

   <dependencies>
        <dependency>
            <groupId>io.vertx</groupId>
            <artifactId>vertx-core</artifactId>
            <version>4.0.2</version>
        </dependency>
        <dependency>
            <groupId>io.vertx</groupId>
            <artifactId>vertx-web</artifactId>
            <version>3.4.2</version>
        </dependency>
        <dependency>
            <groupId>io.vertx</groupId>
            <artifactId>vertx-web-client</artifactId>
            <version>3.4.2</version>
        </dependency>
        <dependency>
            <groupId>io.vertx</groupId>
            <artifactId>vertx-jdbc-client</artifactId>
            <version>4.0.3</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.13</version>
        </dependency>
        <dependency>
            <groupId>c3p0</groupId>
            <artifactId>c3p0</artifactId>
            <version>0.9.1.2</version>
        </dependency>
        <dependency>
            <groupId>io.vertx</groupId>
            <artifactId>vertx-sql-common</artifactId>
            <version>3.8.1</version>
        </dependency>
    </dependencies>

配置数据源：

package com.wang.config;

import io.vertx.core.Vertx;
import io.vertx.core.json.JsonObject;
import io.vertx.ext.jdbc.JDBCClient;

/**
 * @author ：wangtaisheng
 * @date ：Created in 2021/3/17 0017 15:15
 */
public class JdbcConfig {
    private static JDBCClient jdbcClient;
    private static JsonObject config;
    private static JdbcConfig jdbcConfig;

    static {
        config = new JsonObject();
        config.put("url", "jdbc:mysql://127.0.0.1:3306/vertx?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=GMT%2B8&useAffectedRows=true");
        config.put("driver_class", "com.mysql.jdbc.Driver");
        config.put("user", "root");
        config.put("password", "root");
    }

    public static JdbcConfig create(Vertx vertx){
        if (jdbcClient == null){
           synchronized (JdbcConfig.class) {
               jdbcConfig = new JdbcConfig();
               jdbcConfig.init(vertx);
            }
        }
        return jdbcConfig;
    }

    private void init(Vertx vertx) {
        jdbcClient = JDBCClient.createShared(vertx, config);
    }

    public JDBCClient getJdbcClient(){
        return jdbcClient;
    }


}

测试

import com.wang.config.JdbcConfig;
import io.vertx.core.Vertx;
import io.vertx.core.json.JsonObject;
import io.vertx.ext.jdbc.JDBCClient;
import io.vertx.ext.sql.ResultSet;
import io.vertx.ext.sql.SQLConnection;

/**
 * @author ：wangtaisheng
 * @date ：Created in 2021/3/17 0017 11:59
 */
public class JdbcTest {

    public static void main(String[] args) {
        Vertx vertx = Vertx.vertx();
        JdbcConfig jdbcConfig = JdbcConfig.create(vertx);
        jdbcConfig.getJdbcClient().getConnection(res -> {
            SQLConnection connection = res.result();
            if (res.succeeded()){
                connection.query("select * from test",e -> {
                    ResultSet result = e.result();
                    System.out.println(result.getRows());
                });
            }else {

            }
        });

    }

}

over！！！