achievement-management-system
本系统从功能上划分可分为以下几大模块：功能模块管理，组权限管理,学生信息管理,课程信息管理,学生成绩管理,授课信息管理,学生信息查询,学生成绩统计等几大模块。以下将对各子模块进行说明。
功能模块管理：将系统功能模块保存到数据库中以便于动态地进行不同用户组权限的分配等操作。本模块包括功能模块的添加，删除，修改等。
组权限管理：对用户进行分组，并将权限设置到不同的用户组。
学生信息管理模块：输入学生基本信息，并可以对学生信息进行添加、查询、修改、删除。还可以关键字查询并从数据库里调出的学生基本信息.输出学生基本信息，学号、班号、姓名查询的信息结果。
课程信息管理：设置课程号，课程名，先修课等课程信息。
成绩信息管理模块：输入成绩信息，并可以对成绩信息进行添加、查询、修改、删除。还可以用关键字查询并调出数据库里的学生基本成绩信息的修改、删除等。输出查询的学生成绩信息。
授课信息管理:对教师授课信息的调度，安排等信息的管理。
学生信息查询:本模块是可对学生成绩进行查询，可按学号，姓名，年龄，所在院系，入学年份等不同条件独立查询或进行模糊查询。
学生成绩统计：对学生成绩总分，平均分等进行统计。(The system functions can be divided into several modules of the following major modules: the management of functional modules, groups, rights management, student information management, curriculum management, student performance management, teaching information management, student inquiries, student achievement statistics, etc.. The following will be the sub-module for instructions.
Management of functional modules: the system function module is saved to the database in order to facilitate dynamic allocation of operations of different user group permissions. This module includes the function module to add, delete, modify.
Group rights management: the user group and permission settings to different groups of users.
Student information management module: Enter the students basic information, and student information to add, query, modify, delete. Can also be a keyword query and bring up the students basic information from the database. Output student, st)
- 2012-07-03 08:55:56下载
- 积分：1
students_name-productor
批量生成学生信息的SQL语句，主要包括生成随机姓名的功能，如下：
insert into name(name,age,sex,yuwen_score,shuxue_score)values(林洁凡,93,女,71,13)
insert into name(name,age,sex,yuwen_score,shuxue_score)values(范贞晶,83,女,4,37)
insert into name(name,age,sex,yuwen_score,shuxue_score)values(黎丹莉,10,女,96,28)
insert into name(name,age,sex,yuwen_score,shuxue_score)values(康兰蓉,49,女,73,100)
insert into name(name,age,sex,yuwen_score,shuxue_score)values(毕艳艳,62,女,57,42)(Batch SQL statements generated student information, including the name of the function to generate a random, as follows:
insert into name (name, age, sex, yuwen_score, shuxue_score) values (Anna Fan, 93, female, 71,13)
insert into name (name, age, sex, yuwen_score, shuxue_score) values (Fan Zhen Jing, 83, female, 4,37)
insert into name (name, age, sex, yuwen_score, shuxue_score) values (Li Danli, 10, female, 96,28)
insert into name (name, age, sex, yuwen_score, shuxue_score) values (Kanglan Rong, 49, female, 73,100)
insert into name (name, age, sex, yuwen_score, shuxue_score) values (Bi Yanyan, 62, female, 57,42))
- 2013-12-07 21:37:09下载
- 积分：1
