【正文】 打印。其主要代碼如下： Private Sub Command1_Click Dim strCourseID As String Dim strClassRoomID As String Dim i As Integer, j As Integer If Then MsgBox 請輸入要查詢的班級編號！ Exit Sub End If strSQL SELECT * FROM bTempTableA where classid amp。 strClassRoomID classroomID classroomID 39。準(zhǔn)確無誤地反映在課表上。 strClassRoomID classroomID classroomID 39。 Select Case Ttime Case Is 1 9, 3 coursename 10, 3 classroomName 12, 3 classname Case Is 2 13, 3 coursename 14, 3 classroomName 16, 3 classname Case Is 3 17, 3 coursename 18, 3 classroomName 20, 3 classname Case Is 4 21, 3 coursename 22, 3 classroomName 24, 3 classname Case Is 5 9, 4 coursename 10, 4 classroomName 12, 4 classname Case Is 6 13, 4 coursename 14, 4 classroomName 16, 4 classname Case Is 7 17, 4 coursename 18, 4 classroomName 20, 4 classname Case Is 8 21, 4 coursename 22, 4 classroomName 24, 4 classname Case Is 9 9, 5 coursename 10, 5 classroomName 12, 5 classname Case Is 10 13, 5 coursename 14, 5 classroomName 16, 5 classname Case Is 11 17, 5 coursename 18, 5 classroomName 20, 5 classname Case Is 12 21, 5 coursename 22, 5 classroomName 24, 5 classname Case Is 13 9, 6 coursename 10, 6 classroomName 12, 6 classname Case Is 14 13, 6 coursename 14, 6 classroomName 16, 6 classname Case Is 15 17, 6 coursename 18, 6 classroomName 20, 6 classname Case Is 16 21, 6 coursename 22, 6 classroomName 24, 6 classname Case Is 17 9, 7 coursename 10, 7 classroomName 12, 7 classname Case Is 18 13, 7 coursename 14, 7 classroomName 16, 7 classname Case Is 19 17, 7 coursename 18, 7 classroomName 20, 7 classname Case Is 20 21, 7 coursename 22, 7 classroomName 24, 7 classname Case Is 21 9, 8 coursename 10, 8 classroomName 12, 8 classname Case Is 22 13, 8 coursename 14, 8 classroomName 16, 8 classname Case Is 23 17, 8 coursename 18, 8 classroomName 20, 8 classname Case Is 24 21, 8 coursename 22, 8 classroomName 24, 8 classname Case Is 25 9, 9 coursename 10, 9 classroomName 12, 9 classname Case Is 26 13, 9 coursename 14, 9 classroomName 16, 9 classname Case Is 27 17, 9 coursename 18, 9 classroomName 20, 9 classname Case Is 28 21, 9 coursename 22, 9 classroomName 24, 9 classname Case Else MsgBox 數(shù)據(jù)溢出，請檢查系統(tǒng)！ End Select i i 1 Wend 教室課程表查詢打印設(shè)計(jì) 教室課程表是為了方便查詢某一確定教室是否有課，確定是哪個(gè)班上課，而且方便無課的學(xué)生選 擇自修的教室。 39?？筛鶕?jù)用戶的不同需求來打印出不同的班級，不同的教室和具體的某一位教師的上課時(shí)間安排，地點(diǎn)安排，以及具體上課的課程名稱。針對這些問題，在此專門對數(shù)據(jù)庫設(shè)計(jì)作了一些探索，并于架構(gòu)的選擇和模塊的劃分上經(jīng)過精心調(diào)整，在菜單的設(shè)計(jì)上也體現(xiàn)了人性化的操作。界面的設(shè)計(jì)也更是煞 廢苦心，努力實(shí)現(xiàn)風(fēng)格統(tǒng)一，方便用戶的做法。 該系統(tǒng)的不足和改進(jìn)方案該系統(tǒng)的不足之處在于，由于數(shù)據(jù)信息的缺乏，不能對輸入的任意一學(xué)期 的課程進(jìn)行現(xiàn)場排課，只能進(jìn)行的是指定某一確定學(xué)期，通過該學(xué)期的教學(xué)計(jì)劃來進(jìn)行排課。利用自動排課來完成本系統(tǒng)的核心內(nèi)容，進(jìn)行計(jì)算機(jī)的自動排課，接下來發(fā)生沖突的