| 摘 要: 近年来，技能抽考在高校正开展得如火如荼,技能抽考重在“抽考”，要抽取指定数量的学生参加技能考 试，对于参加考试的学生，还要从题库中随机抽取考试试题，为了让学生无论抽到还是没有抽到，参加考试的学生无论 抽到什么样的试题都没有怨言，公平性就显得至关重要，基于.NET技能抽考系统利用随机数解决了公平性的问题。在 抽取学生时，利用循环的嵌套保证了抽取学生不重复的问题；另外，本系统还能快速将EXCEL中的文件信息导入到数 据库，提高了系统应用的广泛性和实用性；此外，在保存更新后的数据时,后台提供一次性存取，减少了数据库访问的 次数，提高了数据库的访问效率，本软件还支持界面和文本文件之间数据的读取。 |
| 关键词: .NET框架；ADO.NET技术；数据库访问；技能抽考；内存 |
|
中图分类号: TP391
文献标识码: A
|
| 基金项目: 鄂州职业大学校级教研项目(J2015zd02). |
|
| Design and Implementation of the.NET-Based Skills Examination System |
|
XIA Xiaoxiang
|
( Dept.of Computer and Technology, Vocational University of Ezhou, Ezhou 436000, China)
|
| Abstract: In recent years,skills examination in colleges and universities are carried out like a raging fire.The key is to extract skills examination,which means to extract a specified number of students to take the examination and randomly extract the examination questions from the question bank.Fairness is quite important to avoid complaints from the students,whether they are extracted to take the examination and no matter what kind of questions are randomly extracted,which is achieved through the random number based on the .NET skills examination system.During the process of student extraction,Repetition is effectively avoided through loop nesting.Additionally,the system can quickly import EXCEL file information into the database,which improves the universality and practicality of the system.When saving the updated data,the skills examination system implements a one-time access in the backstage,which reduces database access and improves the efficiency of database access.The system also supports the reading between the interface and text files. |
| Keywords: NET framework;ADO.NET technology;database access;skills examination;memory |
