基于SQL SERVER的SQL自动练习系统的设计

The design and implement of automatic SQL exercise system for MS SQL Server

只有在具体的数据库环境中进行练习才能真正学会SQL语言。主要针对MS SQL SERVER数据库管理系统环境设计了一个基于B/S结构的SQL语言的自动练习及测试系统,该系统在学生练习完毕后能及时自动评判并给出反馈。自动评判的实现分两步执行:(1)在数据库环境中执行参考答案与学生给出的练习答案,比较执行结果,执行结果非空,则直接判断正误;(2)否则,在(1)基础上辅以简单的语法分析来判断。实际运行结果表明,本系统能较好满足SQL语言的教学需求。

When learning SQL language, students must practice to improve their practical ability to grasp it. It is important to judge the students＇ practices and to give timely feedback for improving students＇ learning motivation and ability. This system mainly designs a SQL language automatic exercise system for SQL SERVER database. Its main difficulty is to determine the correctness of the SQL statements. This automatic evaluation algorithm performed in two steps： （1） execute SQL statements directly, if the result set is not empty, then judge directly; （2） if the execution result set is empty, using a simple syntax analysis auxiliary judge. Thus issues get a satisfactory solution.