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 RedisMySQLCache {
    private static final String REDIS_HOST = "localhost";
    private static final int REDIS_PORT = 6379;
    private static final String MYSQL_URL = "jdbc:mysql://localhost:3306/mydb";
    private static final String MYSQL_USER = "user";
    private static final String MYSQL_PASSWORD = "password";

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

        if (name == null) {
            try (Connection conn = DriverManager.getConnection(MYSQL_URL, MYSQL_USER, MYSQL_PASSWORD);
                 Statement stmt = conn.createStatement();
                 ResultSet rs = stmt.executeQuery("SELECT name FROM users WHERE id = 1")) {
                if (rs.next()) {
                    name = rs.getString("name");
                    jedis.setex(key, 3600, name); // 缓存1小时
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
        }

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