QuestDB测试类

由于使用官网jdbc示例无法进行数据插入，可能问题为使用try with resource写法造成，具体原因未知。

改后示例：

public static void main(String[] args) throws Exception{
    Properties properties = new Properties();
    properties.setProperty("user", "admin");
    properties.setProperty("password", "quest");
    properties.setProperty("sslmode", "disable");

    final Connection connection = DriverManager.getConnection("jdbc:postgresql://127.0.0.1:8812/qdb", properties);
    //connection.setAutoCommit(false);

    final PreparedStatement statement = connection.prepareStatement("CREATE TABLE IF NOT EXISTS trades (ts TIMESTAMP, date DATE, name STRING, value INT) timestamp(ts);");
    statement.execute();

    PreparedStatement preparedStatement = connection.prepareStatement("INSERT INTO trades VALUES (?, ?, ?, ?);");
    preparedStatement.setTimestamp(1, new Timestamp(System.currentTimeMillis()));
    preparedStatement.setDate(2, new java.sql.Date(System.currentTimeMillis()));
    preparedStatement.setString(3, "abc");
    preparedStatement.setInt(4, 11);
    boolean execute = preparedStatement.execute();
    //connection.commit();
    System.out.println("execute:"+execute);

    System.out.println("Done");

    connection.close();
}