Java项目 1 - 学生成绩管理系统---采用 Servlet+Jsp+JavaBean+MySql 设计方式，

最新推荐文章于 2024-05-05 20:08:03 发布

MAGANG255

最新推荐文章于 2024-05-05 20:08:03 发布

阅读量8.5k

点赞数 3

本文链接：https://blog.csdn.net/MAGANG255/article/details/52698799

版权

本文介绍了使用Servlet+Jsp+JavaBean+MySql设计的学生成绩管理系统，通过创建数据库class_db，包含admin、student、classes、course、enrol、teacher等表，实现了学生、课程、班级等数据的存储。同时，展示了如何插入数据及可能出现的错误处理，涉及数据库操作和Java连接数据库的sqlBean类文件。

摘要由CSDN通过智能技术生成

Enter password: ***
Welcome to the MySQL monitor. Commands end with ; or \g.

create database class_db ;

mysql> use class_db;
Database changed

mysql> create table admin ( id int(8) not null primary key auto_increment,
-> name varchar(30) ,
-> password varchar(30) );
Query OK, 0 rows affected (0.64 sec)

mysql> show tables;
+--------------------+
| Tables_in_class_db |
+--------------------+
| admin |
+--------------------+
1 row in set (0.06 sec)

mysql> create table student( id varchar(50) not null primary key ,
    -> name varchar(10) not null ,
    -> password varchar(50) ,
    -> jiguan varchar(10) not null ,
    -> department varchar(10) ,
    -> sex varchar(10) ,
    -> mark int(11) ,
    -> tel varchar(50) ,
    -> e_mail varchar(50) );
Query OK, 0 rows affected (0.23 sec)

mysql> create table classes ( id varchar(50) not null ,
    -> tea_id varchar(10) not null primary key ,
    -> cour_id varchar(10) not null ,
    -> room_id varchar(50) not null ,
    -> cour_time varchar(10) not null );
Query OK, 0 rows affected (0.25 sec)

mysql> create table course ( id varchar(10) not null primary key ,
    -> name varchar(20) not null ,
    -> mark int(11) not null ,
    -> prepare varchar(10)   ,
    -> dep varchar(10)   );
Query OK, 0 rows affected (0.20 sec)

mysql> create table enrol ( stu_id varchar(50) not null primary key ,
    -> class_id varchar(50) not null ,
    -> accept tinyint(1) ,
    -> score varchar(50) );
Query OK, 0 rows affected (0.25 sec)

mysql> create table teacher ( id varchar(10) not null   ,
    -> name varchar(50) not null ,
    -> title varchar(50) not null ,
    -> password varchar(50) not null );
Query OK, 0 rows affected (0.25 sec)

各表插入数据：

mysql> insert into admin values(1 , 'limq',1 ) ;
Query OK, 1 row affected (0.48 sec)

mysql> insert into student values(1 , '韩博', 1, '山东' , '机械系', '女', 9, 3317138,'123@qq.com' ) ;

Enter password: ***
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.1.68-community MySQL Community Server (GPL)

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> insert into student values(1 , '韩博', 1, '山东' , '机械系', '女', 9,
3317138, 123@qq.com ) ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '@qq.c
om )' at line 1
mysql> insert into student values(1 , '韩博', 1, '山东' , '机械系', '女', 9,
3317138, '123@qq.com' ) ;
Query OK, 1 row affected (0.33 sec)

mysql> select * from student;
+----+------+----------+--------+------------+------+------+---------+----------
--+
| id | name | password | jiguan | department | sex | mark | tel | e_mail
|
+----+------+----------+--------+------------+------+------+---------+----------
--+
| 1 | 韩博 | 1 | 山东 | 机械系 | 女 | 9 | 3317138 | 123@qq.co
m |
+----+------+----------+--------+------------+------+------+---------+----------
--+
1 row in set (0.09 sec)

mysql> insert into student values( 2 , '王强', 1, '陕西' , '机械系', '男', 5,
3317138, '124@qq.com' ) ;
Query OK, 1 row affected (0.13 sec)

mysql> select * from student;
+----+------+----------+--------+------------+------+------+---------+----------
--+
| id | name | password | jiguan | department | sex | mark | tel     | e_mail
|
+----+------+----------+--------+------------+------+------+---------+----------
--+
| 1 | 韩博 | 1        | 山东   | 机械系     | 女   |    9 | 3317138 | 123@qq.co
m |
| 2 | 王强 | 1        | 陕西   | 机械系     | 男   |    5 | 3317138 | 124@qq.co
m |
+----+------+----------+--------+------------+------+------+---------+----------
--+
2 rows in set (0.00 sec)

mysql> insert into student values( 3 , '张永', 1, '河南' , '电子系', '男', 0,
113317138, '125@qq.com' ) ;
Query OK, 1 row affected (0.14 sec)

mysql> select * from student;
+----+------+----------+--------+------------+------+------+-----------+--------
----+
| id | name | password | jiguan | department | sex | mark | tel       | e_mail
    |
+----+------+----------+--------+------------+------+------+-----------+--------
----+
| 1 | 韩博 | 1        | 山东   | 机械系     | 女   |    9 | 3317138   | 123@qq.
com |
| 2 | 王强 | 1        | 陕西   | 机械系     | 男   |    5 | 3317138   | 124@qq.
com |
| 3 | 张永 | 1        | 河南   | 电子系     | 男   |    0 | 113317138 | 125@qq.
com |
+----+------+----------+--------+------------+------+------+-----------+--------
----+
3 rows in set (0.00 sec)