form8.frm

英语字典

VERSION 5.00
Begin VB.Form frmDic 
   BackColor       =   &H00FFC0C0&
   Caption         =   "字典信息管理"
   ClientHeight    =   3150
   ClientLeft      =   60
   ClientTop       =   390
   ClientWidth     =   4680
   LinkTopic       =   "Form8"
   ScaleHeight     =   11550
   ScaleWidth      =   19080
   StartUpPosition =   3  '窗口缺省
   WindowState     =   2  'Maximized
   Begin VB.PictureBox Picture1 
      Height          =   4335
      Left            =   1920
      Picture         =   "Form8.frx":0000
      ScaleHeight     =   4275
      ScaleWidth      =   15315
      TabIndex        =   10
      Top             =   120
      Width           =   15375
   End
   Begin VB.Frame Frame1 
      BackColor       =   &H00FFC0C0&
      Caption         =   "字典信息管理"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   15.75
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   5895
      Left            =   1800
      TabIndex        =   0
      Top             =   4920
      Width           =   15495
      Begin VB.CommandButton cmdReturn 
         Caption         =   "返回"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   15
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   735
         Left            =   4560
         TabIndex        =   9
         Top             =   4680
         Width           =   2295
      End
      Begin VB.CommandButton cmdAdd 
         Caption         =   "添加"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   15
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   735
         Left            =   1440
         TabIndex        =   8
         Top             =   3480
         Width           =   2295
      End
      Begin VB.TextBox txtTranslate 
         Height          =   3495
         Left            =   8400
         TabIndex        =   7
         Top             =   1800
         Width           =   6735
      End
      Begin VB.CommandButton cmdCheck 
         Caption         =   "查找"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   14.25
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   735
         Left            =   3120
         TabIndex        =   6
         Top             =   2040
         Width           =   2055
      End
      Begin VB.CommandButton cmdCancel 
         Caption         =   "取消"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   15
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   735
         Left            =   1440
         TabIndex        =   3
         Top             =   4680
         Width           =   2295
      End
      Begin VB.CommandButton cmdChange 
         Caption         =   "修改"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   15
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   735
         Left            =   4560
         TabIndex        =   2
         Top             =   3480
         Width           =   2295
      End
      Begin VB.TextBox txtWord 
         Height          =   495
         Left            =   3840
         TabIndex        =   1
         Top             =   840
         Width           =   2895
      End
      Begin VB.Label Label4 
         BackColor       =   &H00FFC0C0&
         Caption         =   "汉语翻译（词性，解释，例句等）："
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   15
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   495
         Left            =   8520
         TabIndex        =   5
         Top             =   840
         Width           =   5655
      End
      Begin VB.Label Label1 
         BackColor       =   &H00FFC0C0&
         Caption         =   "英文单词："
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   15
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   495
         Left            =   1560
         TabIndex        =   4
         Top             =   960
         Width           =   2295
      End
   End
End
Attribute VB_Name = "frmDic"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False



Private Sub cmdCancel_Click()
txtWord.Text = ""
txtTranslate.Text = ""
cmdCheck.Visible = True
cmdCheck.Enabled = True
cmdChange.Visible = True
cmdChange.Enabled = True
cmdAdd.Visible = True
cmdAdd.Enabled = True
cmdCancel.Visible = False
cmdCancel.Enabled = False
End Sub

Private Sub cmdCheck_Click()
cmdAdd.Visible = False            '查询按钮被按下后，添加按钮无效，修改按钮有效
cmdAdd.Enabled = False
cmdChange.Visible = True
cmdChange.Enabled = True
txtWord.SetFocus
txtsql = "select * from 单词表 where 英文单词='" & Text1 & "' "
 Set Rs = ExecuteSQL(txtsql, MsgText)
If Rs.EOF = True Then
 MsgBox "输入单词错误，请重新输入", vbexlamation, "警告"
 txtWord.Text = ""
 Else
 txtTranslate.Text = Rs!汉语翻译
 End If
End Sub

Private Sub cmdAdd_Click()
cmdCheck.Visible = False
cmdCheck.Enabled = False
cmdChange.Visible = False
cmdChange.Enabled = False
MsgBox "请输入添加内容", vbexlamation, "警告"
txtWord.SetFocus
strsql = "select * form 单词表"
'Rs.Open straql
Set Rs = ExecuteSQL(txtsql, MsgText)
txtWord.SetFocus
If txtWord.Text = "" Then   '判断单词输入是否为空
MsgBox "单词不能为空", vbOKOnly + vbExclamation, "警告"
Exit Sub
txtWord.SetFocus
Else
    While (Rs.EOF = False)    '判断是否有重复记录
    If Rs!英文单词 = txtWord.Text Then
     MsgBox "该单词已存在，请重新输入", vbOKOnly + vbExclamation, "警告"
     txtWord.Text = ""
     txtTranslate.Text = ""
     txtWord.SetFocus
     Exit Sub
    Else
    Rs.MoveNext
    End If
    Wend
    Rs.AddNew
    Rs!英文单词 = txtWord.Text
    Rs!汉语翻译 = txtTranslate.Text
    Rs.Update
    txtWord.SetFocus
    MsgBox "新单词:" & txtUserName.Text & "添加成功", vbInformation, "提示"
    Rs.Close
    Set Rs = Nothing
End If
txtWord.Text = ""
txtTranslate.Text = ""
Rs.Update
txtWord.SetFocus
End Sub

Private Sub cmdReturn_Click()
Unload Me
frmAdmainUser.Show
End Sub

Private Sub Form_Load()
Call Module1.connection
Dim textsql As String
Dim MsgText As String
Dim Rs As New ADODB.Recordset
End Sub

Private Sub cmdChange_Click()
MsgBox "请输入修改内容", vbexlamation, "警告"
txtWord.SetFocus
strsql = "select * form 单词表"
'Rs.Open straql
Set Rs = ExecuteSQL(txtsql, MsgText)
Rs.Update
Rs!英文单词 = txtWord.Text
Rs!汉语翻译 = txtTranslate.Text
End Sub


Private Sub Form_Unload(Cancel As Integer)
Rs.Close
End Sub