Skip to main content

Install & Configure

Hint

This article is generated by AI translation.

Add Dependency​

Before using jdbc-redis, add the Maven dependency. Current version: 6.3.1

<dependency>
    <groupId>net.hasor</groupId>
    <artifactId>jdbc-redis</artifactId>
    <version>6.3.0</version>
    <!-- Use the latest version -->
</dependency>

JDBC Connection​

Use a standard JDBC URL to connect.

jdbc:dbvisitor:jedis://<host>:<port>?database=<database>&<parameters>
  • host: Redis server address.
  • port: Redis server port (default 6379).
  • database: database index (default 0).
  • parameters: connection parameters; see Connection Parameters.

Example​

public class RedisJdbcExample {
    public static void main(String[] args) throws Exception {
        String url = "jdbc:dbvisitor:jedis://127.0.0.1:6379/0";
        try (Connection conn = DriverManager.getConnection(url)) {
            // Statement Example
            try (Statement stmt = conn.createStatement()) {
                try (ResultSet rs = stmt.executeQuery("GET mykey")) {
                    while (rs.next()) {
                        System.out.println(rs.getString(1));
                    }
                }
            }

            // PreparedStatement Example
            try (PreparedStatement pstmt = conn.prepareStatement("SET ? ?")) {
                pstmt.setString(1, "acc");
                pstmt.setString(2, "123");
                pstmt.executeUpdate();
            }
        }
    }
}