初始化

lrj

2 天以前 c61d4fe27c97d2ecc907756aa571a4ef14a7b9b6

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
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();
        }
    }
}