试卷生成系统.doc

Windows 98me2000XPAbstract Value of teaching is an important tathe for teaching,usually a value of teaching is from a exam ,so a quality paper straight touches the value of teaching. The general situation ,teacher thinks out a paperreach huge exam pool each finds out the question, or shoulder the question together out from several relevant books. Time-consuming and also strenuous like this, and very difficult to guarantee coverage rate and paper degree of difficulty of examination question. Helping the teacher disengages from the burdensome proposition about exam, In order to improve the quality and management proposition of the modern, scientific, standardized, the paper developed a test generation system.Paper Generation System is designed and implemented based on the sufficient needs analysis in this paper,It mainly implements some functions include in manually and automatically generating papers,extrating some of existing papers,maintaining user information and so on ,the system can operate stably in Windows 98/me/2000/XP platform ,reach the expected goal and have some practical value.Keywords: test library system;paper generation;algorithmicPC!-empirenews.page-1 1.1 KB,WRODWORD*.DOC 1.2!-empirenews.page-12345678910 2 2.1 Visual Basic Visual BasicBasicIDEIntegrated Development EnvironmentIDEVBVBVBVBVB6.02.1.1 FormPictureVisibleBackColorFontStartUpPositionImageListImageHeightImageWidthMSFlexGridRows MSHFlexGrid Cols MSHFlexGrid AllowBigSelectorBoolean: /,EnterCell:CommandButtonCaptionCommandButtonClickTreeView Node Node ImageListImageListNode!-empirenews.page-Node8NodeClick2.1.2 Visual basic 6.0ADO(Active Data Objects)OLE-DBADO,ActiveActive Data ObjectsADOODBCODBCSQL ServerOracleAccessExcelADOOLE-DBADOADOADOConnectionConnectionRecordsetRecordset UpdateAddNewUpdateFieldRecordsetFieldFieldsFieldRecordsetFieldValueAddNewRecordsetOpen(ADO Connection)Open(ADO Recordset)CloseExecuteSQL2.2 SQL Server2000SQL Server ,Microsoft Sybase Ashton-Tate1988 OS/2 Windows NT ,MicrosoftSybase SQL Server Microsoft SQL Server Windows NTSQL Server Windows NT ,Sybase SQL ServerUNIX Microsoft SQL Server SQL ServerMS SQL ServerSQL Server 2000 Microsoft SQL Server SQL Server 7.0 ,Microsoft Windows 98 Microsoft Windows 2000 !-empirenews.page-SQL ServerOracleAccessAccessWindowsaccess100MiisSQL ServerAccessSQLSQLSQL ServerSQL Server2.3 SQL SQL(Structured Query Language)SQLANSISQLSQLSQLOracle Sybase Microsoft SQL Server AccessSQLSQLSelect Insert Update Delete Create DropMS SQL Server Transact- SQLSQLSQLSQLSQLSQL SQLSQLSQLSQLDB SQLSQLRDBMS()SQLSQLSQL SQL!-empirenews.page-DMLData Manipulation LanguageDDLData Definition Language DCLData Control Language 12 345678910 3 Computer Aided InstructionCAI3.1CAI12345word6word73.212 !-empirenews.page-33.3 3-1SHAPE * MERGEFORMAT 3-1 3.4 3.4.1 ,24,5 3.4.2 ,1024*768,3.5 3.5.1 Windows98/ME/2000/XPSQLServer2000: Visual Basic: VB6.03.5.2 CPUP = 2 * ROMAN II200256MB2.1GB160MB4 !-empirenews.page-4.1 4-1SHAPE * MERGEFORMAT 4-1 !-empirenews.page-12345678910 (1) 4-2SHAPE * MERGEFORMAT 4-2 (2) n n n 4-3SHAPE * MERGEFORMAT !-empirenews.page- 4-3 (3) 4-4SHAPE * MERGEFORMAT 4-4 (4) 4-5SHAPE * MERGEFORMAT 4-5 4.2 STGLSQL Server 200019 (usermanagement)NameIDchar20PWDchar20QXint2 (TX)Typechar10TypeNamechar10 (NYD)!-empirenews.page-BHint4NDchar44 (selects)BHchar10Typechar10Topicchar100AAchar100BBchar100CCchar100DDchar100Answerchar1NDchar4ZJchar25 (adds)BHchar10Typechar10TMchar1001K1char502K2char503K3char50NDchar4ZJchar26 (ask)BHchar10!-empirenews.page-Typechar10TMchar100Answerchar200NDchar4ZJchar27 (YD