java storm mysql 连接操作

    private static Map<String, Object> hikariConfigMap = new HashMap<String, Object>() {{
        put("dataSourceClassName", "com.mysql.jdbc.jdbc2.optional.MysqlDataSource");
        put("dataSource.url", "jdbc:mysql://127.0.0.1:3306/h2e");
        put("dataSource.user", "root");
        put("dataSource.password", "");
    }};
    

	@Test
	public void mytest(){

        ConnectionProvider connectionProvider = new HikariCPConnectionProvider(hikariConfigMap);
        connectionProvider.prepare();
        int queryTimeoutSecs = 60;
        JdbcClient jdbcClient = new JdbcClient(connectionProvider, queryTimeoutSecs);
        for (String sql : setupSqls) {
            System.out.println("sql:" + sql);
            try {
            	jdbcClient.executeSql(sql);
			} catch (Exception e) {
				// TODO: handle exception
				System.out.println(e);
			}
            
        }
        connectionProvider.cleanup();

    private static final List<String> setupSqls = Lists.newArrayList(
            "insert into user_department values (3, 3)",
            "insert into h_test(name) values ('zhan san')"
    );