Java 数据库表格类型 - 适用于 Bukkit 1.20 插件开发

Bukkit 1.20 \u662f\u4e00\u4e2a Minecraft \u7684\u63d2\u4ef6\u5f00\u53d1\u6846\u67b6\uff0c\u4e0d\u5305\u62ec\u6570\u636e\u5e93\u64cd\u4f5c\u3002\u4f46\u662f\uff0c\u4f60\u53ef\u4ee5\u4f7f\u7528\u5176\u4ed6\u7684 Java \u6570\u636e\u5e93\u5e93\u52a0\u8d2f\u96c6\uff08\u5982 JDBC\uff09\u6765\u64cd\u4f5c\u6570\u636e\u5e93\u3002\n\n\u4ee5\u4e0b\u662f\u4e00\u4e9b\u5e38\u89c1\u7684\u6570\u636e\u5e93\u8868\u683c\u53ef\u7528\u7c7b\u578b\u7684\u4f8b\u5b50\uff1a\n\n1\u3002\u5b57\u7b26\u4e32\u7c7b\u578b\uff1a\n\t-\u00a0VARCHAR(n)\uff1a\u53ef\u53d8\u957f\u5ea6\u7684\u5b57\u7b26\u4e32\uff0c\u6700\u5927\u957f\u5ea6\u4e3a n\u3002\n\t-\u00a0TEXT\uff1a\u7528\u4e8e\u5b58\u50a8\u5927\u6bb5\u7684\u6587\u672c\u4fe1\u606f\u3002\n\n2\u3002\u6574\u6570\u7c7b\u578b\uff1a\n\t-\u00a0INT\uff1a\u7528\u4e8e\u5b58\u50a8\u6574\u6570\uff0c\u53ef\u8868\u793a\u8303\u56f4\u4e3a -2^31 \u5230 2^31-1\u3002\n\t-\u00a0BIGINT\uff1a\u7528\u4e8e\u5b58\u50a8\u5927\u6574\u6570\uff0c\u53ef\u8868\u793a\u8303\u56f4\u4e3a -2^63 \u5230 2^63-1\u3002\n\n3\u3002\u6d6e\u70b9\u6570\u7c7b\u578b\uff1a\n\t-\u00a0FLOAT\uff1a\u5355\u7cbe\u5ea6\u6d6e\u70b9\u6570\uff0c\u7528\u4e8e\u5b58\u50a8\u5c0f\u6570\uff0c\u53ef\u8868\u793a\u8303\u56f4\u4e3a -3.4E38 \u5230 3.4E38\u3002\n\t-\u00a0DOUBLE\uff1a\u53cc\u7cbe\u5ea6\u6d6e\u70b9\u6570\uff0c\u7528\u4e8e\u5b58\u50a8\u5c0f\u6570\uff0c\u53ef\u8868\u793a\u8303\u56f4\u4e3a -1.7E308 \u5230 1.7E308\u3002\n\n4\u3002\u65e5\u671f\u65f6\u95f4\u7c7b\u578b\uff1a\n\t-\u00a0DATE\uff1a\u7528\u4e8e\u5b58\u50a8\u65e5\u671f\uff0c\u683c\u5f0f\u4e3a YYYY-MM-DD\u3002\n\t-\u00a0TIME\uff1a\u7528\u4e8e\u5b58\u50a8\u65f6\u95f4\uff0c\u683c\u5f0f\u4e3a HH:MM:SS\u3002\n\t-\u00a0DATETIME\uff1a\u7528\u4e8e\u5b58\u50a8\u65e5\u671f\u548c\u65f6\u95f4\uff0c\u683c\u5f0f\u4e3a YYYY-MM-DD HH:MM:SS\u3002\n\n5\u3002\u5e03\u5c14\u7c7b\u578b\uff1a\n\t-\u00a0BOOLEAN\uff1a\u7528\u4e8e\u5b58\u50a8\u5e03\u5c14\u503c\uff0c\u53ef\u8868\u793a\u4e3a true \u6216\u8005 false\u3002\n\n6\u3002\u81ea\u5b9a\u4e49\u7c7b\u578b\uff1a\n\t-\u00a0ENUM\uff1a\u7528\u4e8e\u5b58\u50a8\u9884\u5b9a\u4e49\u7684\u6570\u4e32\u503c\u3002\n\n\u4ee5\u4e0b\u662f\u4e00\u4e2a\u4f7f\u7528 Java \u548c JDBC \u8fde\u63a5\u5230 MySQL \u6570\u636e\u5e93\uff0c\u5e76\u521b\u5efa\u4e00\u4e2a\u5305\u542b\u4e0d\u540c\u7c7b\u578b\u7684\u8868\u683c\u7684\u4f8b\u5b50\uff1a\n\njava\nimport java.sql.Connection;\nimport java.sql.DriverManager;\nimport java.sql.SQLException;\nimport java.sql.Statement;\n\npublic class MySQLExample {\n\tpublic static void main(String[] args) {\n\t\tString url = "jdbc:mysql://localhost:3306/mydatabase";\n\t\tString username = "root";\n\t\tString password = "password";\n\n\t\ttry (Connection conn = DriverManager.getConnection(url, username, password);\n\t\t\t\t Statement stmt = conn.createStatement()) {\n\t\t\t\t// \u521b\u5efa\u8868\u683c\n\t\t\t\tString sql = "CREATE TABLE mytable (" +\n\t\t\t\t\t\t"id INT PRIMARY KEY AUTO_INCREMENT," +\n\t\t\t\t\t\t"name VARCHAR(50)," +\n\t\t\t\t\t\t"age INT," +\n\t\t\t\t\t\t"balance DOUBLE," +\n\t\t\t\t\t\t"created_at DATETIME)";\n\t\t\t\tstmt.executeUpdate(sql);\n\t\t\t\tSystem.out.println("\u8868\u683c\u521b\u5efa\u6210\u529f\uff01");\n\t\t\t} catch (SQLException e) {\n\t\t\t\te.printStackTrace();\n\t\t\t}\n\t}\n}\n\n\n\u8fd9\u4e2a\u4f8b\u5b50\u4f1a\u521b\u5efa\u4e00\u4e2a\u540d\u4e3a mytable \u7684\u8868\u683c\uff0c\u5305\u542b id\u3001name\u3001age\u3001balance \u548c created_at \u7b49\u5217\uff0c\u5206\u522b\u5bf9\u5e94 INT\u3001VARCHAR\u3001INT\u3001DOUBLE \u548c DATETIME \u7c7b\u578b\u3002\u8bf7\u6839\u636e\u4f60\u7684\u9700\u6c42\u4fee\u6539\u8868\u683c\u7684\u7ed3\u6784\u548c\u7c7b\u578b\u3002