当前位置：首页 > Java

java如何添加表

2026-03-21 02:38:44Java

使用JDBC创建数据库表

在Java中通过JDBC API创建数据库表需要连接数据库并执行SQL语句。以下是具体实现方式：

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/mydatabase";
        String username = "root";
        String password = "password";

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

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

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

使用Hibernate框架创建表

通过Hibernate ORM框架可以基于实体类自动生成数据库表：

import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name = "employees")
public class Employee {
    @Id
    private int id;
    private String name;
    private int age;
    private double salary;
    // getters and setters
}

// Hibernate配置文件中设置自动建表
<property name="hibernate.hbm2ddl.auto">update</property>

使用Spring Data JPA创建表

Spring Boot结合JPA可以简化表创建过程：

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;

@Entity
public class Product {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String name;
    private Double price;
    // getters and setters
}

// application.properties配置
spring.jpa.hibernate.ddl-auto=update
spring.datasource.url=jdbc:mysql://localhost:3306/mydb
spring.datasource.username=root
spring.datasource.password=secret

使用MyBatis创建表

MyBatis需要手动编写SQL映射文件来创建表：

<!-- mapper.xml文件 -->
<mapper namespace="com.example.TableMapper">
    <update id="createEmployeeTable">
        CREATE TABLE IF NOT EXISTS employees (
            id INT PRIMARY KEY AUTO_INCREMENT,
            name VARCHAR(50),
            position VARCHAR(50)
        )
    </update>
</mapper>