1、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 qu
2、estion 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 quali
3、ty 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 gener
4、ating 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,WROD-
5、WORD*.DOC 1.2-!-empirenews.page-12345678910 2 2.1 Visual Basic Visual BasicBasic-IDEIntegrated Development EnvironmentIDE-VB-VBVBVBVB6.02.1.1 FormPictureVisibleBackColorFontStartUpPositionImageListImageHeightImageWidthMSFlexGridRows MSHFlexGrid Cols MSHFlexGrid AllowBigSelectorBoolean: /,EnterCell:C
6、ommandButtonCaptionCommandButtonClickTreeView Node Node ImageListImageListNode!-empirenews.page-Node8NodeClick2.1.2 Visual basic 6.0ADO(Active Data Objects)OLE-DBADO,ActiveActive Data ObjectsADOODBCODBCSQL ServerOracleAccessExcelADOOLE-DBADOADOADOConnectionConnectionRecordsetRecordset UpdateAddNewUp
7、dateFieldRecordsetFieldFieldsFieldRecordsetFieldValueAddNewRecordsetOpen(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 Server
8、UNIX 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)SQLANSIS
9、QLSQLSQLOracle 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/XPSQLServ