从Java创建MySQL数据库

CREATE TABLE users (
  id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(30) NOT NULL,
  password VARCHAR(255) NOT NULL,
  email VARCHAR(255) NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class Main {
  public static void main(String[] args) {
    String url = "jdbc:mysql://localhost:3306/mydatabase";
    String user = "root";
    String password = "mypassword";

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

      String sql = "INSERT INTO users (username, password, email) VALUES (?, ?, ?)";
      PreparedStatement pstmt = conn.prepareStatement(sql);
      pstmt.setString(1, "johndoe");
      pstmt.setString(2, "password123");
      pstmt.setString(3, "johndoe@example.com");
      pstmt.executeUpdate();

      pstmt.close();
      conn.close();
    } catch (Exception e) {
      e.printStackTrace();
    }
  }
}