redis 缓存mysql

import redis.clients.jedis.Jedis;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class RedisCacheExample {
    private static final String DB_URL = "jdbc:mysql://localhost:3306/mydb";
    private static final String DB_USER = "user";
    private static final String DB_PASSWORD = "password";
    private static final String REDIS_HOST = "localhost";
    private static final int REDIS_PORT = 6379;

    public static void main(String[] args) {
        Jedis jedis = new Jedis(REDIS_HOST, REDIS_PORT);
        String key = "user:1";
        String value = jedis.get(key);

        if (value == null) {
            try (Connection conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD);
                 Statement stmt = conn.createStatement();
                 ResultSet rs = stmt.executeQuery("SELECT * FROM users WHERE id = 1")) {

                if (rs.next()) {
                    value = rs.getString("name");
                    jedis.setex(key, 3600, value); // 缓存1小时
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
        }

        System.out.println("User name: " + value);
    }
}