基于MySQL数据库的工程水力学试题库系统的开发探索
|
摘要
为了便于数据集中管理,改进工程水力学这门学科的教学质量,节约教师以及学生的时间成本,本文对于工程水力学试题库进行了基于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 My SQL database system.During the development of the system,we use navicat for My SQL 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 My SQL 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.
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 My SQL database system.During the development of the system,we use navicat for My SQL 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 My SQL 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.
引文
[1]高先娟.药学本科分析化学试题库的建设及思考[J].检验医学与临床,2016,13(2):374-376.
[2]徐中良,沈正泽,向萍,等.临床合理用药试题库应用与试卷分析[J].重庆医学,2018,47(8):1135-1137.
[3]孙蕾,梁冀鲁.《口腔修复学》试题库的构建与思考[J].全科口腔医学电子杂志,2018,5(6):12-13.
[4]宋杰,郝舒欣,徐东群,等.My SQL在健康相关数据清理中的应用[J].中国卫生统计,2017,34(3):515-517.
[5]周勇强.SQL Server数据库备份与恢复的研究与实践[J].电脑知识与技术,2018,14(18):3-5.
[6]蔡伟珊.SQLServer数据库维护与管理教学研究[J].信息通信,2015,(5):71-72.
[7]李瑞森,张树有,伊国栋,等.多属性多关联的工程图学试题库与多路径智能组卷系统研究[J].图学学报,2018,39(2):373-380.
[2]徐中良,沈正泽,向萍,等.临床合理用药试题库应用与试卷分析[J].重庆医学,2018,47(8):1135-1137.
[3]孙蕾,梁冀鲁.《口腔修复学》试题库的构建与思考[J].全科口腔医学电子杂志,2018,5(6):12-13.
[4]宋杰,郝舒欣,徐东群,等.My SQL在健康相关数据清理中的应用[J].中国卫生统计,2017,34(3):515-517.
[5]周勇强.SQL Server数据库备份与恢复的研究与实践[J].电脑知识与技术,2018,14(18):3-5.
[6]蔡伟珊.SQLServer数据库维护与管理教学研究[J].信息通信,2015,(5):71-72.
[7]李瑞森,张树有,伊国栋,等.多属性多关联的工程图学试题库与多路径智能组卷系统研究[J].图学学报,2018,39(2):373-380.