JdbcUtil.java
import io.vertx.core.Vertx;
import io.vertx.core.json.JsonObject;
import io.vertx.ext.jdbc.JDBCClient;
public class JdbcUtils {
private JDBCClient dbClient;
public JdbcUtils(Vertx vertx){
JsonObject dbConfig = new JsonObject();
//serverTimezone=GMT%2B8 解决连接数据库时区问题
dbConfig.put("url", "jdbc:mysql://localhost:3306/ssm_model?serverTimezone=GMT%2B8");
dbConfig.put("driver_class", "com.mysql.cj.jdbc.Driver");
dbConfig.put("user", "root");
dbConfig.put("password", "root");
//创建客户端
dbClient = JDBCClient.createShared(vertx, dbConfig);
}
public JDBCClient getDbClient(){
return dbClient;
}
}
JdbcTest.java
import io.vertx.core.AbstractVerticle;
import io.vertx.core.Vertx;
import io.vertx.core.json.Jso