package com.rongyichuang.judge;

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

public class DescribeTable {
    public static void main(String[] args) {
        String url = "jdbc:mysql://140.143.152.226:3308/ryc?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai";
        String user = "openai";
        String password = "Xml@uk2025";
        String tableName = "t_media";

        System.out.println("--- Connecting to database to describe table: " + tableName + " ---");

        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            try (Connection conn = DriverManager.getConnection(url, user, password);
                 Statement stmt = conn.createStatement()) {

                System.out.println("Database connection successful.");

                // Using DESCRIBE is simpler
                try (ResultSet rs = stmt.executeQuery("DESCRIBE " + tableName)) {
                    System.out.println("\n--- Structure of table '" + tableName + "' ---");
                    System.out.printf("%-20s | %-20s | %-5s | %-5s | %-20s | %s%n", "Field", "Type", "Null", "Key", "Default", "Extra");
                    System.out.println("----------------------------------------------------------------------------------------------------");
                    while (rs.next()) {
                        System.out.printf("%-20s | %-20s | %-5s | %-5s | %-20s | %s%n",
                                rs.getString("Field"),
                                rs.getString("Type"),
                                rs.getString("Null"),
                                rs.getString("Key"),
                                rs.getString("Default"),
                                rs.getString("Extra"));
                    }
                    System.out.println("----------------------------------------------------------------------------------------------------");
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}