如何在JAVA中从MySQL获取当前年份和月份？

   <groupId>mysql</groupId>
   <artifactId>mysql-connector-java</artifactId>
   <version>8.0.26</version>
</dependency>

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class Main {
    public static void main(String[] args) {
        try {
            // 1. 加载驱动程序
            Class.forName("com.mysql.cj.jdbc.Driver");

            // 2. 创建数据库连接
            Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/your_database_name", "your_username", "your_password");

            // 3. 创建一个Statement对象
            Statement statement = connection.createStatement();

            // 4. 执行SQL查询以获取当前年份和月份
            ResultSet resultSet = statement.executeQuery("SELECT YEAR(CURRENT_DATE()), MONTH(CURRENT_DATE());");

            // 5. 处理查询结果
            if (resultSet.next()) {
                int year = resultSet.getInt(1);
                int month = resultSet.getInt(2);
                System.out.println("当前年份：" + year);
                System.out.println("当前月份：" + month);
            }

            // 6. 关闭资源
            resultSet.close();
            statement.close();
            connection.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}