form11.frm

该程序采VB6作为前端开发工具,以SQL Server 2000作为后台数据库开发平台.

VERSION 5.00
Begin VB.Form Form11 
   Caption         =   "密码修改"
   ClientHeight    =   2925
   ClientLeft      =   3555
   ClientTop       =   2850
   ClientWidth     =   4230
   LinkTopic       =   "Form11"
   ScaleHeight     =   2925
   ScaleWidth      =   4230
   Begin VB.Frame Frame3 
      Height          =   735
      Left            =   120
      TabIndex        =   8
      Top             =   2040
      Width           =   3975
      Begin VB.CommandButton Command1 
         Caption         =   "修改"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   14.25
            Charset         =   134
            Weight          =   700
            Underline       =   0   'False
            Italic          =   -1  'True
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Left            =   960
         TabIndex        =   10
         Top             =   240
         Width           =   975
      End
      Begin VB.CommandButton Command2 
         Caption         =   "取消"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   12
            Charset         =   134
            Weight          =   700
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Left            =   2640
         TabIndex        =   9
         Top             =   240
         Width           =   975
      End
   End
   Begin VB.Frame Frame2 
      Caption         =   "密码修改窗"
      Height          =   1815
      Left            =   120
      TabIndex        =   1
      Top             =   120
      Width           =   3975
      Begin VB.ComboBox Combo1 
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   12
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   360
         Left            =   1680
         TabIndex        =   4
         Top             =   240
         Width           =   1455
      End
      Begin VB.TextBox Text1 
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   10.5
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   315
         IMEMode         =   3  'DISABLE
         Left            =   1680
         PasswordChar    =   "*"
         TabIndex        =   3
         Top             =   810
         Width           =   1455
      End
      Begin VB.TextBox Text2 
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   10.5
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   315
         IMEMode         =   3  'DISABLE
         Left            =   1680
         PasswordChar    =   "*"
         TabIndex        =   2
         Top             =   1320
         Width           =   1455
      End
      Begin VB.Label Label1 
         Caption         =   "用户名"
         Height          =   255
         Left            =   840
         TabIndex        =   7
         Top             =   360
         Width           =   615
      End
      Begin VB.Label Label2 
         Caption         =   "原密码"
         Height          =   255
         Left            =   840
         TabIndex        =   6
         Top             =   840
         Width           =   735
      End
      Begin VB.Label Label3 
         Caption         =   "新密码"
         Height          =   255
         Left            =   840
         TabIndex        =   5
         Top             =   1320
         Width           =   735
      End
   End
   Begin VB.Frame Frame1 
      Height          =   135
      Left            =   120
      TabIndex        =   0
      Top             =   1920
      Width           =   3975
   End
End
Attribute VB_Name = "Form11"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
On Error Resume Next
Set db = New ADODB.Connection
 Set rs = New ADODB.Recordset
 db.ConnectionString = "driver={SQL Server};server=04;database=酒店管理;Persist Security Info=False;User ID=sa"

db.Open
Dim m As String

If Combo1.Text <> "" Then

rs.Open "select 用户名,密码 from 密码表 where 用户名='" & Trim(Combo1.Text) & "' and 密码='" & Trim(Text1.Text) & "'", db, adOpenDynamic, adLockReadOnly
If rs.EOF = False And rs.BOF = False Then
  
  If m = 1 Then
  m = MsgBox("你确定修改吗？", vbOKCancel)

rs.Close
'rs.Open "update 密码 表 set 密码='" & Trim(Text2.Text) & "' where 用户名='" & Trim(Combo1.Text) & "'", db, adOpenDynamic, adLockReadOnly
rs.Open "UPDATE 密码表 SET 密码 = '" & Text2.Text & "' WHERE 用户名 = '" & Combo1.Text & "'", db, adOpenDynamic, adLockReadOnly
Text1.Text = ""
Text2.Text = ""
Combo1.Text = ""
Combo1.SetFocus
Else
Text1.Text = ""
Text2.Text = ""
Combo1.Text = ""
Combo1.SetFocus
End If
'rs.Open "select * from 密码表 where 用户名='" & Trim(Combo1.Text) & "' and 密码='" & Trim(Text1.Text) & "'", db, adOpenDynamic, adLockReadOnly
  
  Else
m = MsgBox("原密码错误！请重试。", 48)
  Text1.Text = ""
  Text1.SetFocus
End If

Else
m = MsgBox("没选用户名，请重试！", 48)
End If



End Sub

Private Sub Command2_Click()
Unload Form11
End Sub

Private Sub Form_Load()
Dim t As Integer
 
Set db = New ADODB.Connection
 Set rs = New ADODB.Recordset
db.ConnectionString = "driver={SQL Server};server=04;database=酒店管理;Persist Security Info=False;User ID=sa"
 
 'db.ConnectionString = "driver={SQL Server};server=04;database=酒店管理;"
db.Open
rs.Open "select 用户名 from 密码表", db, adOpenStatic, adLockReadOnly

 Dim i As String
  For t = 0 To Val(rs.RecordCount) - 1
  i = Trim(rs.Fields("用户名").Value)
   rs.MoveNext
   
  Combo1.AddItem i
 Next t
rs.Close
End Sub