以下是使用Java語言創(chuàng)建包含以上數(shù)據(jù)類型的MySQL表，并提供批量新增數(shù)據(jù)、批量修改數(shù)據(jù)、刪除數(shù)據(jù)以及字段的DDL語句的詳細(xì)代碼示例：
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class MySQLTableCreation {
private static final String DB_URL = "jdbc:mysql://localhost:3306/mydatabase";
private static final String USER = "username";
private static final String PASS = "password";
public static void main(String[] args) {
try (Connection conn = DriverManager.getConnection(DB_URL, USER, PASS);
Statement stmt = conn.createStatement()) {
// 創(chuàng)建表格
String createTableSQL = "CREATE TABLE my_table (" +
"id INT PRIMARY KEY AUTO_INCREMENT," +
"tinyint_col TINYINT COMMENT '1字節(jié)有符號整數(shù)'," +
"smallint_col SMALLINT COMMENT '2字節(jié)有符號整數(shù)'," +
"mediumint_col MEDIUMINT COMMENT '3字節(jié)有符號整數(shù)'," +
"int_col INT COMMENT '4字節(jié)有符號整數(shù)'," +
"bigint_col BIGINT COMMENT '8字節(jié)有符號整數(shù)'," +
"float_col FLOAT COMMENT '單精度浮點(diǎn)數(shù)'," +
"double_col DOUBLE COMMENT '雙精度浮點(diǎn)數(shù)'," +
"decimal_col DECIMAL(10, 2) COMMENT '定點(diǎn)數(shù)'," +
"char_col CHAR(10) COMMENT '固定長度字符串'," +
"varchar_col VARCHAR(255) COMMENT '可變長度字符串'," +
"binary_col BINARY(10) COMMENT '固定長度二進(jìn)制字符串'," +
"varbinary_col VARBINARY(255) COMMENT '可變長度二進(jìn)制字符串'," +
"tinyblob_col TINYBLOB COMMENT '最大長度為255字節(jié)的二進(jìn)制字符串'," +
"blob_col BLOB COMMENT '最大長度為65535字節(jié)的二進(jìn)制字符串'," +
"mediumblob_col MEDIUMBLOB COMMENT '最大長度為16777215字節(jié)的二進(jìn)制字符串'," +
"longblob_col LONGBLOB COMMENT '最大長度為4294967295字節(jié)的二進(jìn)制字符串'," +
"tinytext_col TINYTEXT COMMENT '最大長度為255字節(jié)的文本字符串'," +
"text_col TEXT COMMENT '最大長度為65535字節(jié)的文本字符串'," +
"mediumtext_col MEDIUMTEXT COMMENT '最大長度為16777215字節(jié)的文本字符串'," +
"longtext_col LONGTEXT COMMENT '最大長度為4294967295字節(jié)的文本字符串'," +
"enum_col ENUM('Male', 'Female') COMMENT '枚舉類型'," +
"set_col SET('Red', 'Green', 'Blue') COMMENT '集合類型'," +
"date_col DATE COMMENT '日期'," +
"time_col TIME COMMENT '時(shí)間'," +
"datetime_col DATETIME COMMENT '日期和時(shí)間'," +
"timestamp_col TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '自動(dòng)更新的日期和時(shí)間'," +
"year_col YEAR COMMENT '年份'," +
"json_col JSON COMMENT 'JSON數(shù)據(jù)'," +
"geometry_col GEOMETRY COMMENT '二進(jìn)制幾何類型'," +
"point_col POINT COMMENT '點(diǎn)類型'," +
"linestring_col LINESTRING COMMENT '線類型'," +
"polygon_col POLYGON COMMENT '多邊形類型'," +
"multipoint_col MULTIPOINT COMMENT '多點(diǎn)類型'," +
"multilinestring_col MULTILINESTRING COMMENT '多線類型'," +
"multipolygon_col MULTIPOLYGON COMMENT '多多邊形類型'" +
")";
stmt.executeUpdate(createTableSQL);
System.out.println("Table created successfully.");
// 批量新增數(shù)據(jù)
String insertDataSQL = "INSERT INTO my_table (tinyint_col, smallint_col, mediumint_col, int_col, bigint_col, " +
"float_col, double_col, decimal_col, char_col, varchar_col, binary_col, varbinary_col, tinyblob_col, " +
"blob_col, mediumblob_col, longblob_col, tinytext_col, text_col, mediumtext_col, longtext_col, enum_col, " +
"set_col, date_col, time_col, datetime_col, year_col, json_col, geometry_col, point_col, linestring_col, " +
"polygon_col, multipoint_col, multilinestring_col, multipolygon_col) VALUES " +
"(10, 1000, 100000, 1000000, 1000000000, 3.14, 3.14159265358979, 12345.67, 'Hello', 'World', " +
"0x1234, 0x5678, 0xABCDEF, 0x123456789ABCDEF, 0x123456789ABCDEF0123456789, 0x123456789ABCDEF0123456789ABCDEF0123456789, " +
"'Hello', 'World', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit.', " +
"'Lorem ipsum dolor sit amet, consectetur adipiscing elit...', 'Male', 'Red', '2021-07-01', '12:30:45', " +
"'2021-07-01 12:30:45', 2021, '{\"name\": \"John\", \"age\": 25}', " +
"0x0101000000000000000000F03F000000000000F03F, POINT(1, 2), LINESTRING(1 2, 3 4, 5 6), " +
"POLYGON((0 0, 0 1, 1 1, 1 0, 0 0)), MULTIPOINT((1 2), (3 4), (5 6)), " +
"MULTILINESTRING((1 2, 3 4), (5 6, 7 8)), MULTIPOLYGON(((0 0, 0 1, 1 1, 1 0, 0 0)), ((2 2, 2 3, 3 3, 3 2, 2 2))) )";
stmt.executeUpdate(insertDataSQL);
System.out.println("Data inserted successfully.");
// 批量修改數(shù)據(jù)
String updateDataSQL = "UPDATE my_table SET varchar_col = 'New Value' WHERE id = 1";
stmt.executeUpdate(updateDataSQL);
System.out.println("Data updated successfully.");
// 刪除數(shù)據(jù)
String deleteDataSQL = "DELETE FROM my_table WHERE id = 1";
stmt.executeUpdate(deleteDataSQL);
System.out.println("Data deleted successfully.");
} catch (SQLException e) {
e.printStackTrace();
}
}
}
請注意，上述代碼中的DB_URL、USER和PASS需要根據(jù)實(shí)際情況進(jìn)行修改，以連接到正確的MySQL數(shù)據(jù)庫。另外，需要確保已經(jīng)導(dǎo)入了適當(dāng)?shù)腏DBC驅(qū)動(dòng)程序。文章來源：http://www.zghlxwxcb.cn/news/detail-611701.html
以上代碼示例可以創(chuàng)建一個(gè)名為my_table的表，并在其中插入一條數(shù)據(jù)，然后進(jìn)行批量修改和刪除操作。請根據(jù)實(shí)際需求進(jìn)行調(diào)整和擴(kuò)展。文章來源地址http://www.zghlxwxcb.cn/news/detail-611701.html
到了這里，關(guān)于Java語言創(chuàng)建包含以上數(shù)據(jù)類型的MySQL表，并提供批量新增數(shù)據(jù)、批量修改數(shù)據(jù)、刪除數(shù)據(jù)以及字段的DDL語句的詳細(xì)代碼示例的文章就介紹完了。如果您還想了解更多內(nèi)容，請?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
