采用互联网技术管理实验课表的探讨

Management of experiments by Internet technology

介绍了为实验教学开发的实验课管理软件,包括主要功能和特点。软件使用自定义的Java类对象,完成对数据库的查询、插入、更改、删除、关闭等操作。通过调用后台程序,在管理页面上分别实现实验课记录的添加、编辑、删除功能。当新建或修改实验课记录时,检查输入信息,判断产生重复或冲突记录的必要条件和附加条件,防止数据库中录入重复或冲突的记录。借助数据库查询中的sum函数、group by子句获得实验课的统计信息,当同一实验课出现多行记录时,对数据进行必要的整合。

The characteristics and functions of the software which is developed for the management of experiments,are introduced.The software carries out query,insert,update,delete or close operations with database by means of the self-defined Java class objects.In the manager page,an experiment record is added,edited or deleted by executing the corresponding background programs.Before creating or modifying an experiment record,the input information is checked with the necessary and appended conditions for repetitions or conflicts,preventing that a repeated or conflict record is input into database.By means of the query with the sum function and the group-by clause in database,the statistics of experiments are obtained,and the multi-records with one experiment are combined if necessary.