实训管理系统在海口的应用与开发

CREATE DATABASE TraningSystem;

USE TraningSystem;

CREATE TABLE Student (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(50),

major VARCHAR(50)

);

CREATE TABLE Course (

id INT AUTO_INCREMENT PRIMARY KEY,

course_name VARCHAR(100),

teacher_name VARCHAR(50)

);

CREATE TABLE Record (

id INT AUTO_INCREMENT PRIMARY KEY,

student_id INT,

course_id INT,

attendance BOOLEAN,

FOREIGN KEY(student_id) REFERENCES Student(id),

FOREIGN KEY(course_id) REFERENCES Course(id)

);

]]>

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

public class Main {

private static final String DB_URL = "jdbc:mysql://localhost:3306/TraningSystem";

private static final String USER = "root";

private static final String PASS = "password";

public static void main(String[] args) {

try {

Connection conn = DriverManager.getConnection(DB_URL, USER, PASS);

String query = "INSERT INTO Student(name, major) VALUES (?, ?)";

PreparedStatement stmt = conn.prepareStatement(query);

stmt.setString(1, "张三");

stmt.setString(2, "软件工程");

stmt.executeUpdate();

ResultSet rs = stmt.executeQuery("SELECT * FROM Student");

while(rs.next()) {

System.out.println("学生ID: " + rs.getInt("id") + ", 姓名: " + rs.getString("name"));

}

conn.close();

} catch (Exception e) {

e.printStackTrace();

}

培训班排课源码

}

}

]]>