Java课程设计_数据库代码

---

title: Java课程设计代码
date: 2024-12-02 03:03:51
tags: java

数据库设计代码

//创建数据库
create database Student;
use student;
//创建学生信息表
create table student(
    stuid1 char(20) unique comment '学号',
    name char(20)  comment '姓名',
    telenumber int comment '电话号码',
    qqmail char(20) comment '邮箱',
    classnumber char (20) comment '班级'
)comment'学生信息表';

//插入学生信息
insert into student (stuid1,name,telenumber,qqmail,classnumber ) values
    ('2023131051' ,'何圆',123456,'123456@qq.com','区块链232班'),
    ('2023131041','洪汇淇',123456,'123456@qq.com','区块链232班'),
    ('2023131043','成璐',123456,'123456@qq.com','区块链232班');
select * from student ;

//创建学生成绩表
CREATE TABLE studentgrade (
    stuid2 char(20) COMMENT '学号',
    name CHAR(20) COMMENT '姓名',
    math INT COMMENT '高数',
    MaYuan INT COMMENT '马原',
    English INT COMMENT '英语',
    linemath INT COMMENT '线性代数'

) COMMENT '学生成绩表';

//插入学生成绩
INSERT INTO studentgrade (stuid2, name, math, MaYuan, linemath, English) VALUES
    ('2023131051', '何圆', 94, 83, 87, 78)
    ('2023131041', '洪汇淇', 95, 82, 80, 92),
    ('2023131043', '成璐', 91, 87, 84, 97);
SELECT * FROM studentgrade;