form10.frm

以VC为前台

VERSION 5.00
Begin VB.Form 登陆 
   Caption         =   "登陆"
   ClientHeight    =   8550
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   11535
   LinkTopic       =   "Form1"
   Picture         =   "form10.frx":0000
   ScaleHeight     =   8550
   ScaleWidth      =   11535
   StartUpPosition =   3  'Windows Default
   Begin VB.Frame Frame1 
      BackColor       =   &H00FFFFFF&
      BorderStyle     =   0  'None
      ForeColor       =   &H00FFFFFF&
      Height          =   3135
      Left            =   1920
      TabIndex        =   0
      Top             =   1920
      Width           =   4695
      Begin VB.CommandButton Command1 
         BackColor       =   &H00FFFFFF&
         Caption         =   "确 定"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   10.5
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Left            =   600
         MaskColor       =   &H80000016&
         Style           =   1  'Graphical
         TabIndex        =   5
         Top             =   2400
         Width           =   1335
      End
      Begin VB.CommandButton Command2 
         BackColor       =   &H00FFFFFF&
         Caption         =   "取 消"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   10.5
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Left            =   2760
         MaskColor       =   &H80000016&
         Style           =   1  'Graphical
         TabIndex        =   4
         Top             =   2400
         Width           =   1455
      End
      Begin VB.ComboBox Combo1 
         Height          =   315
         Left            =   2040
         TabIndex        =   3
         Text            =   "管理员"
         Top             =   480
         Width           =   2175
      End
      Begin VB.TextBox Text1 
         Height          =   375
         Left            =   2040
         TabIndex        =   1
         Top             =   1080
         Width           =   2175
      End
      Begin VB.TextBox Text2 
         Height          =   375
         IMEMode         =   3  'DISABLE
         Left            =   2040
         PasswordChar    =   "*"
         TabIndex        =   2
         Top             =   1680
         Width           =   2175
      End
      Begin VB.Label Label1 
         BackColor       =   &H00FFFFFF&
         Caption         =   "用户身份："
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   10.5
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Left            =   600
         TabIndex        =   8
         Top             =   480
         Width           =   1095
      End
      Begin VB.Label Label2 
         BackColor       =   &H00FFFFFF&
         Caption         =   "用户名："
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   10.5
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Left            =   600
         TabIndex        =   7
         Top             =   1080
         Width           =   975
      End
      Begin VB.Label Label3 
         BackColor       =   &H00FFFFFF&
         Caption         =   "密 码："
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   10.5
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   255
         Left            =   600
         TabIndex        =   6
         Top             =   1800
         Width           =   855
      End
   End
End
Attribute VB_Name = "登陆"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit

Private Sub Command1_Click()

Dim objCn As New Connection
Dim objRs As New Recordset
Dim strCn As String, strSQL As String
'以下代码用于给按钮分配权限
If Combo1.Text = "匿名登入" Then
       Unload Me
       学生成绩管理系统.Show
       学生成绩管理系统.Width = 15000
       学生成绩管理系统.Height = 10000
       学生成绩管理系统.cjwh.Enabled = False
       学生成绩管理系统.student.Enabled = False
       学生成绩管理系统.password.Enabled = False
Else

With objCn
      .Provider = "SQLOLEDB"
      .ConnectionString = "User ID=sa;PWD=sa;Data Source=(local);" & "Initial Catalog=学生管理"
      .Open
End With
      
strSQL = "SELECT 密码 from admin where 用户=" & Text1.Text & ""
Set objRs.ActiveConnection = objCn
objRs.Open (strSQL)

If objRs.EOF Then
      MsgBox "用户名不存在，请重试!", vbOKOnly, "登录"
            Text1.Text = ""
            Text1.SetFocus
Else
      If Text2.Text <> Trim(objRs.Fields("密码").Value) Then
      MsgBox "密码错误，请重试!", vbOKOnly, "登录"
            Text2.Text = ""
            Text2.SetFocus
        
      Else
         Unload Me
         学生成绩管理系统.Show
         学生成绩管理系统.Width = 15000
         学生成绩管理系统.Height = 10000
         学生成绩管理系统.new.Enabled = False
      End If
End If
objCn.Close
Set objRs = Nothing
Set objCn = Nothing
End If
Exit Sub

End Sub

Private Sub Combo1_Click()

'以下代码用于当用户改变时的行为
If Combo1.Text = "匿名登入" Then
   Text1.BackColor = &H8000000F
   Text2.BackColor = &H8000000F
   Text1.Enabled = False
   Text2.Enabled = False
Else
   Text1.Enabled = True
   Text2.Enabled = True
   Text1.BackColor = RGB(255, 255, 255)
   Text2.BackColor = RGB(255, 255, 255)
   Text1.SetFocus
End If


End Sub




Private Sub Command2_Click()
End
End Sub

Private Sub Form_Load()

Combo1.Text = "管理员"
Combo1.AddItem "管理员"
Combo1.AddItem "匿名登入"
End Sub