Skip to main content

v6.1.0 (2025-11-04)

<dependency>
    <groupId>net.hasor</groupId>
    <artifactId>jdbc-redis</artifactId>
    <version>6.1.0</version>
</dependency>

Impact​

  • None

Changes​

  • [Added] New dbvisitor-driver subproject providing a flexible JDBC driver adapter to abstract implementation details and let non-relational databases integrate quickly into JDBC apps via request/response.
  • [Added] New jdbc-redis driver adapter so developers can operate Redis data using standard JDBC interfaces and commands.

How to use?​

Connect to Redis with a standard JDBC URL:

String url = "jdbc:dbvisitor:jedis://server:port?database=0&param1=value1&param2=value2";
Properties props = new Properties();
props.setProperty("username", "user");
props.setProperty("password", "pass");
Connection conn = DriverManager.getConnection(url, props);

Key connection parameters:

  • server: Redis address, ip or ip:port, cluster as ip:port;ip:port.
  • username/password: authentication.
  • database: default DB index, default 0.
  • connectTimeout: connection timeout (ms), default 5000.
  • socketTimeout: socket timeout (seconds), default 10.

Execute commands​

// Create connection
Connection conn = DriverManager.getConnection("jdbc:dbvisitor:jedis://localhost:6379");

// Execute command
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SET mykey hello");

// Handle result
rs = stmt.executeQuery("GET mykey");
if (rs.next()) {
    System.out.println(rs.getString(1)); // 输出: hello
}

// Parameterized query
PreparedStatement pstmt = conn.prepareStatement("HSET ? ? ?");
pstmt.setString(1, "myhash");
pstmt.setString(2, "field1");
pstmt.setString(3, "value1");
ResultSet rs = pstmt.executeQuery();