摘要
随机抽题功能的实现是基于B/S网页考试系统的难点,通过newid()方法和临时表变量实现了较为复杂的不定项选择题随机抽取的功能,并且利用了SQL的存储过程和UDF实现了整个抽题过程的封装和松耦合,并且由于SQL存储过程的执行高效性提高了抽题的效率。
The realization of the function of random problems is the difficulty of the online test system,by newid() method and the temporary table variable can handle a more sophisticated random function,and the use of SQL stored procedures and UDF achieves extracting and packaging of the whole process,and loosely coupled.Because of the efficiency of the implementation of SQL stored procedures,improving efficiency of the pumping efficiency issues.
出处
《现代机械》
2010年第5期55-58,共4页
Modern Machinery