当前位置：首页 > Java

java 如何创建表

2026-03-22 17:51:31Java

使用JDBC创建表

在Java中通过JDBC创建数据库表需要以下步骤。假设使用MySQL数据库，需确保已添加JDBC驱动依赖（如mysql-connector-java）。

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

public class CreateTableExample {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/your_database";
        String user = "your_username";
        String password = "your_password";

        try (Connection conn = DriverManager.getConnection(url, user, password);
             Statement stmt = conn.createStatement()) {

            String sql = "CREATE TABLE employees (" +
                         "id INT PRIMARY KEY AUTO_INCREMENT," +
                         "name VARCHAR(100) NOT NULL," +
                         "age INT," +
                         "salary DECIMAL(10, 2))";

            stmt.executeUpdate(sql);
            System.out.println("Table created successfully");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

使用Hibernate创建表

通过Hibernate的实体类映射自动生成表结构，需配置hibernate.hbm2ddl.auto为update或create。

@Entity
@Table(name = "employees")
public class Employee {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int id;

    @Column(name = "name", nullable = false)
    private String name;

    @Column(name = "age")
    private int age;

    @Column(name = "salary")
    private double salary;

    // Getters and setters
}

配置文件hibernate.cfg.xml示例：

<property name="hibernate.hbm2ddl.auto">update</property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>

使用Spring Data JPA创建表

在Spring Boot中通过JPA实体类自动建表，需在application.properties中配置：

spring.jpa.hibernate.ddl-auto=update
spring.datasource.url=jdbc:mysql://localhost:3306/your_database
spring.datasource.username=your_username
spring.datasource.password=your_password

实体类定义与Hibernate类似：

@Entity
public class Employee {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String name;
    // 其他字段及注解
}

使用SQL脚本初始化表

在Spring Boot中可通过schema.sql文件定义表结构，放置在src/main/resources目录下：

CREATE TABLE IF NOT EXISTS employees (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    age INT,
    salary DECIMAL(10, 2)
);

启用脚本需在application.properties中添加：

java 如何创建表