基于MySQL数据库的工程水力学试题库系统的开发探索

Development and Exploration of Examination Question Database System on Engineering Hydraulics Based on My SQL Database

为了便于数据集中管理,改进工程水力学这门学科的教学质量,节约教师以及学生的时间成本,本文对于工程水力学试题库进行了基于My SQL数据库系统的开发。研究过程中,采用Navicat for My SQL为数据库平台,以java为语言编写,用SQL语句完成试题信息的添加、删减、更改、检索的操作,用JDBC驱动实现Java前台与My SQL后台数据库的连接。本系统设计通过试题id、名称得出试题,根据参考答案得出成绩。通过设置管理员身份的权限,来达到维护和系统登录的作用。试题库的维护与备份,使得数据更加完整,降低了丢失的风险,为教师的教学环节以及学生熟练掌握知识提供了极大的便利性和安全性。

In order to facilitate centralized data management,improve the teaching quality of engineering hydraulics,and save the time cost of teachers and students,the engineering hydraulics test database was developed based on MySQL database system.During the development of the system,we use navicat for MySQL as the database platform, apply java language to write,complete the test information addition,deletion,modification,retrieval by means of SQL statements,achieve the foreground Java and background MySQL database connection by dint of JDBC driver.The design of the system is based on the test id,the name be used to get the test questions,and the results are obtained based on the reference answers.Finally,by setting the administrator identity,the login system and maintenance are implemented. The maintenance and backup of the test question database makes the data complete,reduces the risk of loss,and greatly facilitates the convenience and security of the teacher's teaching process and the students' proficiency in knowledge.