record.frm

试卷生成和评分系统 试卷生成和评分系统

VERSION 5.00
Begin VB.Form record 
   Caption         =   "试卷录入"
   ClientHeight    =   5805
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   7875
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   ScaleHeight     =   5805
   ScaleWidth      =   7875
   StartUpPosition =   2  '屏幕中心
   Begin VB.Frame Frame4 
      Caption         =   "操作"
      Height          =   1095
      Left            =   0
      TabIndex        =   9
      Top             =   4680
      Width           =   7935
      Begin VB.CommandButton Command3 
         Caption         =   "退出"
         Height          =   495
         Left            =   5400
         TabIndex        =   12
         Top             =   360
         Width           =   1215
      End
      Begin VB.CommandButton Command2 
         Caption         =   "新试题"
         Height          =   495
         Left            =   3240
         TabIndex        =   11
         Top             =   360
         Width           =   1215
      End
      Begin VB.CommandButton Command1 
         Caption         =   "保存"
         Height          =   495
         Left            =   1200
         TabIndex        =   10
         Top             =   360
         Width           =   1215
      End
   End
   Begin VB.Frame Frame1 
      Caption         =   "试题录入"
      Height          =   4575
      Left            =   0
      TabIndex        =   0
      Top             =   0
      Width           =   7815
      Begin VB.TextBox Text2 
         Height          =   375
         Left            =   840
         MultiLine       =   -1  'True
         TabIndex        =   14
         Top             =   1103
         Width           =   6735
      End
      Begin VB.Frame Frame3 
         Caption         =   "答案"
         Height          =   2775
         Left            =   4080
         TabIndex        =   4
         Top             =   1680
         Width           =   3495
         Begin VB.TextBox Text9 
            Height          =   375
            Left            =   1440
            TabIndex        =   24
            Top             =   2160
            Width           =   1575
         End
         Begin VB.TextBox Text4 
            Height          =   375
            Left            =   1440
            TabIndex        =   8
            Top             =   1320
            Width           =   1575
         End
         Begin VB.TextBox Text3 
            Height          =   375
            Left            =   1440
            TabIndex        =   6
            Top             =   480
            Width           =   1575
         End
         Begin VB.Label Label9 
            AutoSize        =   -1  'True
            Caption         =   "难度"
            Height          =   180
            Left            =   480
            TabIndex        =   23
            Top             =   2280
            Width           =   360
         End
         Begin VB.Label Label4 
            AutoSize        =   -1  'True
            Caption         =   "课程"
            Height          =   180
            Left            =   480
            TabIndex        =   7
            Top             =   1440
            Width           =   360
         End
         Begin VB.Label Label3 
            AutoSize        =   -1  'True
            Caption         =   "答案"
            Height          =   180
            Left            =   480
            TabIndex        =   5
            Top             =   600
            Width           =   360
         End
      End
      Begin VB.Frame Frame2 
         Caption         =   "选项"
         Height          =   2775
         Left            =   240
         TabIndex        =   3
         Top             =   1680
         Width           =   3735
         Begin VB.TextBox Text8 
            Height          =   375
            Left            =   1080
            MultiLine       =   -1  'True
            TabIndex        =   22
            Top             =   2160
            Width           =   2415
         End
         Begin VB.TextBox Text7 
            Height          =   375
            Left            =   1080
            MultiLine       =   -1  'True
            TabIndex        =   21
            Top             =   1560
            Width           =   2415
         End
         Begin VB.TextBox Text6 
            Height          =   375
            Left            =   1080
            MultiLine       =   -1  'True
            TabIndex        =   20
            Top             =   960
            Width           =   2415
         End
         Begin VB.TextBox Text5 
            Height          =   375
            Left            =   1080
            MultiLine       =   -1  'True
            TabIndex        =   19
            Top             =   360
            Width           =   2415
         End
         Begin VB.Label Label8 
            AutoSize        =   -1  'True
            Caption         =   "选项四"
            Height          =   180
            Left            =   360
            TabIndex        =   18
            Top             =   2257
            Width           =   540
         End
         Begin VB.Label Label7 
            AutoSize        =   -1  'True
            Caption         =   "选项三"
            Height          =   180
            Left            =   360
            TabIndex        =   17
            Top             =   1650
            Width           =   540
         End
         Begin VB.Label Label6 
            AutoSize        =   -1  'True
            Caption         =   "选项二"
            Height          =   180
            Left            =   360
            TabIndex        =   16
            Top             =   1050
            Width           =   540
         End
         Begin VB.Label Label5 
            AutoSize        =   -1  'True
            Caption         =   "选项一"
            Height          =   180
            Left            =   360
            TabIndex        =   15
            Top             =   457
            Width           =   540
         End
      End
      Begin VB.TextBox Text1 
         Height          =   375
         Left            =   840
         TabIndex        =   2
         Top             =   240
         Width           =   1215
      End
      Begin VB.Label Label2 
         AutoSize        =   -1  'True
         Caption         =   "题目"
         Height          =   180
         Left            =   240
         TabIndex        =   13
         Top             =   1200
         Width           =   360
      End
      Begin VB.Label Label1 
         AutoSize        =   -1  'True
         Caption         =   "题号"
         Height          =   180
         Left            =   240
         TabIndex        =   1
         Top             =   360
         Width           =   360
      End
   End
End
Attribute VB_Name = "record"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim mrc As ADODB.Recordset

Private Sub Command1_Click()
    If Text1 <> "" And Text2 <> "" And Text3 <> "" And Text4 <> "" And Text5 <> "" And Text6 <> "" And Text7 <> "" And Text8 <> "" And Text9 <> "" Then
        txtsql = "select * from 选择题"
        Set mrc = exesql(txtsql)
        mrc.AddNew
        mrc.Fields("题号") = Text1
        mrc.Fields("题目") = Text2
        mrc.Fields("答案") = Text3
        mrc.Fields("课程") = Text4
        mrc.Fields("选项1") = Text5
        mrc.Fields("选项2") = Text6
        mrc.Fields("选项3") = Text7
        mrc.Fields("选项4") = Text8
        mrc.Fields("难度") = Text9
        mrc.Update
        Else
        MsgBox "请填写完整", vbOKOnly
    End If
End Sub

Private Sub Command2_Click()
    Text1 = ""
    Text2 = ""
    Text3 = ""
    Text4 = ""
    Text5 = ""
    Text6 = ""
    Text7 = ""
    Text8 = ""
    Text9 = ""
End Sub

Private Sub Command3_Click()
    Unload Me
End Sub