题干描述：食堂有很多卖饭的窗口在窗口买饭就会产生入账记录仅仅考虑卖饭窗口和入账记录这两个实体：窗口：窗口编号 窗口名字 餐饮类型 负责人手机号入账记录：记录编号 入账时间 入账金额 完成如下题目：1、【10分】完成两个表的创建2、【10分】分析表关系并添加外键字段实现表关系如何用java代码jdbc来生成以下条件3、【15分】完成向窗口表填加50条记录详细要求： 窗口名称任意不做要

1、完成两个表的创建

// 创建窗口表
String createWindowTable = "CREATE TABLE window (" +
        "window_id INT PRIMARY KEY AUTO_INCREMENT," +
        "window_name VARCHAR(100) NOT NULL," +
        "catering_type INT NOT NULL," +
        "phone_number VARCHAR(11) NOT NULL" +
        ")";

// 创建入账记录表
String createRecordTable = "CREATE TABLE record (" +
        "record_id INT PRIMARY KEY AUTO_INCREMENT," +
        "entry_time TIMESTAMP NOT NULL," +
        "entry_amount DECIMAL(10, 2) NOT NULL," +
        "window_id INT NOT NULL," +
        "FOREIGN KEY (window_id) REFERENCES window(window_id)" +
        ")";

2、分析表关系，并添加外键字段，实现表关系

窗口表（window）和入账记录表（record）之间的关系是一对多关系，一个窗口可以对应多条入账记录。

3、完成向窗口表填加50条记录

// 生成随机手机号
public String generatePhoneNumber() {
    String phoneNumber = "1";
    phoneNumber += (int) (Math.random() * 9) + 1; // 第二位不能是2
    for (int i = 0; i < 9; i++) {
        phoneNumber += (int) (Math.random() * 10);
    }
    return phoneNumber;
}

// 插入窗口记录
String insertWindowRecord = "INSERT INTO window (window_name, catering_type, phone_number) VALUES (?, ?, ?)";

try (Connection connection = DriverManager.getConnection(url, username, password);
     PreparedStatement statement = connection.prepareStatement(insertWindowRecord)) {
    for (int i = 0; i < 50; i++) {
        statement.setString(1, "窗口" + (i + 1));
        statement.setInt(2, (int) (Math.random() * 4) + 1);
        statement.setString(3, generatePhoneNumber());
        statement.executeUpdate();
    }
} catch (SQLException e) {
    e.printStackTrace();
}

4、完成向记录表添加10000条记录

// 生成随机入账时间
public Timestamp generateEntryTime() {
    long startTimestamp = Timestamp.valueOf("2022-07-24 00:00:00").getTime();
    long endTimestamp = Timestamp.valueOf("2022-07-30 23:59:59").getTime();
    long randomTimestamp = startTimestamp + (long) (Math.random() * (endTimestamp - startTimestamp));
    return new Timestamp(randomTimestamp);
}

// 插入入账记录
String insertRecord = "INSERT INTO record (entry_time, entry_amount, window_id) VALUES (?, ?, ?)";

try (Connection connection = DriverManager.getConnection(url, username, password);
     PreparedStatement statement = connection.prepareStatement(insertRecord)) {
    for (int i = 0; i < 10000; i++) {
        statement.setTimestamp(1, generateEntryTime());
        statement.setDouble(2, Math.random() * 100 + 1);
        statement.setInt(3, (int) (Math.random() * 50) + 1);
        statement.executeUpdate();
    }
} catch (SQLException e) {
    e.printStackTrace();
}
``