Releases · CarmJos/EasySQL

15 Mar 15:12

CarmJos

0.4.7

6f15897

[0.4.7] 版本更新 Latest

Latest

feat(query): 添加 containsResult(column) 以便快速验证结果。

What's Changed

chore(deps): bump maven-shade-plugin from 3.3.0 to 3.4.0 by @dependabot in #63
chore(deps): bump maven-jar-plugin from 3.2.2 to 3.3.0 by @dependabot in #64
chore(deps): bump log4j.version from 2.18.0 to 2.19.0 by @dependabot in #65
chore(deps): bump beecp from 3.3.8 to 3.3.9 by @dependabot in #68
chore(deps): bump maven-shade-plugin from 3.4.0 to 3.4.1 by @dependabot in #67
chore(deps): bump annotations from 23.0.0 to 23.1.0 by @dependabot in #70
chore(deps): bump annotations from 23.1.0 to 24.0.0 by @dependabot in #71
chore(deps): bump maven-javadoc-plugin from 3.4.1 to 3.5.0 by @dependabot in #72
chore(deps): bump beecp from 3.3.9 to 3.4.0 by @dependabot in #73
chore(deps): bump log4j.version from 2.19.0 to 2.20.0 by @dependabot in #74
chore(deps): bump maven-compiler-plugin from 3.10.1 to 3.11.0 by @dependabot in #75
chore(deps): bump annotations from 24.0.0 to 24.0.1 by @dependabot in #76
chore(deps): bump maven-surefire-plugin from 2.22.2 to 3.0.0 by @dependabot in #77

Full Changelog: 0.4.6...0.4.7

Contributors

dependabot

Assets 7

16 Aug 19:22

CarmJos

0.4.6

274b54b

[0.4.6] 版本更新: Metadata读取

feat(metadata) 提供方便高效的metadata读取操作方法 [ #59 | #60 ]
chore(demo) 提供方便高效的metadata读取操作方法示例。
chore(async) 将默认的连接池参数改为 nThreads=4 。

Metadata快捷操作实例

public class EasySQLDemo {

    public void metadata(SQLManager sql) {

        // 操作数据库元数据，直接返回结果。
        CompletableFuture<Boolean> roFuture = sql.fetchMetadata(DatabaseMetaData::isReadOnly);
        CompletableFuture<Integer> maxColumnFuture = sql.fetchMetadata(DatabaseMetaData::getMaxColumnsInSelect);

        // 操作有 ResultSet 元数据。该方法会自动关闭ResultSet。
        CompletableFuture<Boolean> tableExists = sql.fetchMetadata(
                meta -> meta.getTables(null, null, "表名", new String[]{"TABKE"}),
                resultSet -> resultSet.next()
        );

        // SQLManager附带了几个常用元数据的获取方法。
        CompletableFuture<Boolean> tableExists2 = sql.fetchTableMetadata("表名").validateExist();
        CompletableFuture<Boolean> columnExists = sql.fetchTableMetadata("表名").isColumnExists("字段名");
        // 更多方法详见 TableMetadataBuilder 。
    }


}