login.frm

一个资金管理系统的成品 开发环境：VB

VERSION 5.00
Object = "{F0D2F211-CCB0-11D0-A316-00AA00688B10}#1.0#0"; "MSDATLST.OCX"
Begin VB.Form frmlogin 
   Caption         =   "资金管理系统"
   ClientHeight    =   2220
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   5265
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   2220
   ScaleWidth      =   5265
   StartUpPosition =   1  '所有者中心
   Begin MSDataListLib.DataCombo Dacomyhmc 
      Height          =   330
      Left            =   2040
      TabIndex        =   5
      Top             =   240
      Width           =   2055
      _ExtentX        =   3625
      _ExtentY        =   582
      _Version        =   393216
      Text            =   ""
   End
   Begin VB.TextBox passTxt 
      Height          =   300
      IMEMode         =   3  'DISABLE
      Left            =   2040
      MaxLength       =   12
      PasswordChar    =   "*"
      TabIndex        =   1
      Top             =   735
      Width           =   2055
   End
   Begin VB.CommandButton Cmdok 
      Caption         =   "确定"
      Default         =   -1  'True
      Height          =   375
      Left            =   1080
      TabIndex        =   0
      Top             =   1485
      Width           =   975
   End
   Begin VB.CommandButton CmdCancel 
      Caption         =   "取消"
      Height          =   375
      Left            =   2880
      TabIndex        =   2
      Top             =   1485
      Width           =   975
   End
   Begin VB.Label Label1 
      AutoSize        =   -1  'True
      BackStyle       =   0  'Transparent
      Caption         =   "用 户 名："
      BeginProperty Font 
         Name            =   "黑体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00800080&
      Height          =   240
      Left            =   840
      TabIndex        =   4
      Top             =   285
      Width           =   1200
   End
   Begin VB.Label Label2 
      AutoSize        =   -1  'True
      BackStyle       =   0  'Transparent
      Caption         =   "密    码："
      BeginProperty Font 
         Name            =   "黑体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00800080&
      Height          =   240
      Left            =   840
      TabIndex        =   3
      Top             =   765
      Width           =   1200
   End
End
Attribute VB_Name = "frmlogin"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim num As Variant
Dim conn As New ADODB.Connection
Dim rsuser As New ADODB.Recordset

Private Sub CmdCancel_Click()
   Unload frmlogin
   End
End Sub

Private Sub Cmdok_Click()
If Trim(Dacomyhmc.Text) = "" Then
   MsgBox "用户名不能为空！", vbOKOnly + vbExclamation, "警告！"
   Dacomyhmc.SetFocus
   Exit Sub
End If
rsuser.MoveFirst
rsuser.Find "yhmc = '" & Dacomyhmc.Text & "'"
If rsuser.EOF Then
   MsgBox " 没有该用户！", vbOKOnly + vbExclamation
   Dacomyhmc.SetFocus
   Exit Sub
Else
   If rsuser.Fields("yhkl").Value = passTxt.Text Then
      userqx = rsuser.Fields("yhjb").Value
      username = rsuser.Fields("yhmc").Value
      Unload frmlogin
      Load frmMain
      frmMain.Show
   Else
      If num < 2 Then
          num = num + 1
          MsgBox "口令不对，请重输！你还有" & Str(3 - num) & "次机会。", vbOKOnly + vbExclamation
          passTxt.SetFocus
          Exit Sub
      Else
          Do While 1 > 0
          Loop
      End If
   End If
End If

End Sub


Private Sub Form_Load()
'connstring = "Provider=SQLOLEDB.1;Password=db0822;Persist Security Info=True;User ID=sa;Initial Catalog=promotetest;Server=192.168.1.123"
nowconnectstring = connectstring
If conn.State <> 1 Then
    conn.CursorLocation = adUseClient
    conn.Open nowconnectstring
End If
Set rsuser = conn.Execute("SELECT * FROM companyuser")
Set Dacomyhmc.RowSource = rsuser
Dacomyhmc.ListField = rsuser.Fields("yhmc").Name
Dacomyhmc.BoundColumn = rsuser.Fields("yhmc").Name
End Sub