📄 frmxt.frm
字号:
VERSION 5.00
Begin VB.Form Frmxt
BorderStyle = 3 'Fixed Dialog
Caption = "确定考题题数"
ClientHeight = 2460
ClientLeft = 45
ClientTop = 330
ClientWidth = 4590
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 2460
ScaleWidth = 4590
ShowInTaskbar = 0 'False
StartUpPosition = 2 '屏幕中心
Begin VB.CommandButton Cmd_exit
Caption = "返回"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 450
Left = 3360
TabIndex = 6
Top = 1080
Width = 1000
End
Begin VB.CommandButton Cmd_qd
Caption = "确定"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 450
Left = 3360
TabIndex = 5
Top = 360
Width = 1000
End
Begin VB.Frame Frmnum
Caption = "输入考试题数"
Height = 1695
Left = 240
TabIndex = 0
Top = 120
Width = 2775
Begin VB.TextBox Txt_sele
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 1560
TabIndex = 2
Text = "20"
Top = 360
Width = 615
End
Begin VB.TextBox Txt_fill
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 1560
TabIndex = 1
Text = "10"
Top = 960
Width = 615
End
Begin VB.Label Label3
Caption = "选择题数目"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 360
TabIndex = 4
Top = 480
Width = 1215
End
Begin VB.Label Label4
Caption = "填充题数目"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 360
TabIndex = 3
Top = 1080
Width = 1215
End
End
Begin VB.Label Lblsm
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000000FF&
Height = 375
Left = 240
TabIndex = 7
Top = 1920
Width = 2895
End
End
Attribute VB_Name = "Frmxt"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim DbPath As String
Private Sub Cmd_exit_Click()
Unload Me
End Sub
Private Sub Cmd_qd_Click()
Dim i As Integer
Dim fillnum As Integer
Dim selenum As Integer
'--------------------------------------------------------------------
'分别打开TestDb.Mdb库中的考试库SeleDb和选择题库TestSeleDb
'--------------------------------------------------------------------
Set db = DBEngine.Workspaces(0).OpenDatabase(App.Path & "\testdb.mdb")
Set rsTest = db.OpenRecordset("TestSeleDb")
Set rsFill = db.OpenRecordset("TestFillDb")
'--------------------------------------------------------------------
'分别打开Test.Mdb库中的考试库FillDb和选择题库TestFillDb
'--------------------------------------------------------------------
Set dbstud = DBEngine.Workspaces(0).OpenDatabase(App.Path & "\test.mdb")
Set rsStudFill = dbstud.OpenRecordset("FillDb")
Set rsStud = dbstud.OpenRecordset("SeleDb")
'--------------------------------------------------------------------
'将原来考试选择题库SeleDb的记录都删除
'--------------------------------------------------------------------
While Not rsStud.EOF()
rsStud.Delete
rsStud.MoveNext
Wend
selenum = rsTest.RecordCount
'--------------------------------------------------------------------
'将原来考试填充题库FillDb的记录都删除
'--------------------------------------------------------------------
While Not rsStudFill.EOF()
rsStudFill.Delete
rsStudFill.MoveNext
Wend
fillnum = rsStudFill.RecordCount
'--------------------------------------------------------------------
'设置考试库和学生库的索引
'--------------------------------------------------------------------
rsTest.Index = "id" '设置考试选择题库TestSeleDb的索引
rsFill.Index = "primarykey" '设置考试填充库TestFillDb的索引
rsStud.Index = "primarykey" '设置学生选择题库SeleDb的索引
rsStudFill.Index = "primarykey" '设置学生填充题库FillD的索引
'--------------------------------------------------------------------
'在考试选择题库中查找，是否已有该条记录。如果没有找到，
'则将该条记录加入到学生考试选择库中
'--------------------------------------------------------------------
i = 0
While i < (Txt_sele.Text)
'-----------------------------------------------------------------------
'产生lowerbound~upperbound之间随机数的公式：
'Int((upperbound - lowerbound + 1) * Rnd + lowerbound)
'根据当前时间产生随机种子，随机产生1~selenum之间的考试选择题库随机数
'-----------------------------------------------------------------------
Randomize (Timer)
rn = Int((selenum) * Rnd + 1)
rsTest.Seek "=", rn
If Not rsTest.NoMatch Then
With rsStud
.Seek "=", rn
If .NoMatch Then
.AddNew
.Fields("id").Value = rsTest.Fields("id").Value
.Fields("se_ti").Value = rsTest.Fields("se_ti").Value
.Fields("se_da").Value = rsTest.Fields("se_da").Value
.Fields("se_dati1").Value = rsTest.Fields("se_dati1").Value
.Fields("se_dati2").Value = rsTest.Fields("se_dati2").Value
.Fields("se_dati3").Value = rsTest.Fields("se_dati3").Value
.Fields("se_dati4").Value = rsTest.Fields("se_dati4").Value
.Update
i = i + 1
End If
End With
End If
Wend
'--------------------------------------------------------------------
'在考试填充题库中查找，是否已有该条记录。如果没有找到，
'则将该条记录加入到学生考试填充库中
'--------------------------------------------------------------------
i = 0
While i < Txt_fill.Text
'根据当前时间产生随机种子，随机产生1~selenum之间的考试选择题库随机数
Randomize (Timer)
rn = Int((fillnum) * Rnd + 1)
rsFill.Seek "=", rn
If Not rsFill.NoMatch Then
With rsStudFill
.Seek "=", rn
If .NoMatch Then
.AddNew
.Fields("id").Value = rsFill.Fields("id").Value
.Fields("fill_da").Value = rsFill.Fields("fill_da").Value
.Fields("fill_ti").Value = rsFill.Fields("fill_ti").Value
.Update
i = i + 1
End If
End With
End If
Wend
'--------------------------------------------------------------------
'关闭考试库SeleDb和选择题库TestSeleDb
'--------------------------------------------------------------------
rsTest.Close
Set rsTest = Nothing
rsStud.Close
Set rsStud = Nothing
Cmd_qd.Enabled = False
Lblsm.Caption = "自动选题完成，请退出"
End Sub
Private Sub Form_Load()
'DbPath = "d:\"
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -