form2.frm

VB和ACCESS作的管理酒店住书软件

VERSION 5.00
Begin VB.Form Form2 
   BackColor       =   &H00C0E0FF&
   Caption         =   "旅客退房"
   ClientHeight    =   4305
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   5700
   LinkTopic       =   "Form2"
   ScaleHeight     =   4305
   ScaleWidth      =   5700
   StartUpPosition =   2  'CenterScreen
   Begin VB.CommandButton Command2 
      Caption         =   "返回"
      Height          =   375
      Left            =   3720
      TabIndex        =   14
      Top             =   3720
      Width           =   1215
   End
   Begin VB.CommandButton Command1 
      Caption         =   "退房"
      Height          =   375
      Left            =   960
      TabIndex        =   13
      Top             =   3720
      Width           =   975
   End
   Begin VB.Frame Frame2 
      BackColor       =   &H00C0E0FF&
      Caption         =   "基本情况"
      Height          =   2295
      Left            =   120
      TabIndex        =   4
      Top             =   1200
      Width           =   5535
      Begin VB.TextBox sf 
         Height          =   375
         Left            =   3720
         TabIndex        =   12
         Top             =   1560
         Width           =   1335
      End
      Begin VB.TextBox jg 
         Height          =   375
         Left            =   960
         TabIndex        =   10
         Top             =   1560
         Width           =   1335
      End
      Begin VB.TextBox xb 
         Height          =   375
         Left            =   3720
         TabIndex        =   8
         Top             =   480
         Width           =   1355
      End
      Begin VB.TextBox xm 
         Height          =   375
         Left            =   960
         TabIndex        =   6
         Top             =   480
         Width           =   1335
      End
      Begin VB.Label Label5 
         AutoSize        =   -1  'True
         BackColor       =   &H00C0E0FF&
         Caption         =   "身份证号码"
         Height          =   195
         Left            =   2640
         TabIndex        =   11
         Top             =   1560
         Width           =   900
      End
      Begin VB.Label Label4 
         AutoSize        =   -1  'True
         BackColor       =   &H00C0E0FF&
         Caption         =   "籍贯"
         Height          =   195
         Left            =   240
         TabIndex        =   9
         Top             =   1560
         Width           =   360
      End
      Begin VB.Label Label3 
         AutoSize        =   -1  'True
         BackColor       =   &H00C0E0FF&
         Caption         =   "性别"
         Height          =   195
         Left            =   3000
         TabIndex        =   7
         Top             =   480
         Width           =   360
      End
      Begin VB.Label Label2 
         AutoSize        =   -1  'True
         BackColor       =   &H00C0E0FF&
         Caption         =   "姓名"
         Height          =   195
         Left            =   240
         TabIndex        =   5
         Top             =   480
         Width           =   360
      End
   End
   Begin VB.Frame Frame1 
      BackColor       =   &H00C0E0FF&
      Height          =   855
      Left            =   120
      TabIndex        =   0
      Top             =   120
      Width           =   6615
      Begin VB.CommandButton cx 
         Caption         =   "查询"
         Height          =   375
         Left            =   4200
         TabIndex        =   3
         Top             =   240
         Width           =   975
      End
      Begin VB.TextBox zj 
         BackColor       =   &H00FFFFFF&
         Height          =   390
         Left            =   2040
         TabIndex        =   2
         Top             =   230
         Width           =   1695
      End
      Begin VB.Label Label1 
         AutoSize        =   -1  'True
         BackColor       =   &H00C0E0FF&
         Caption         =   "请输入身份证号码："
         Height          =   195
         Left            =   120
         TabIndex        =   1
         Top             =   240
         Width           =   1620
      End
   End
End
Attribute VB_Name = "Form2"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Public rs As ADODB.Recordset
Public db As ADODB.Connection
Public Sub clearfiled()
xm.Text = ""
xb.Text = ""
jg.Text = ""
sf.Text = ""
End Sub
Private Sub Command1_Click()
rs.Close
If MsgBox("真的要删除吗？", vbYesNo, "信息提示") = vbYes Then
rs.Open "delete from 酒店登记 where 身份证号码='" & Trim(sf.Text) & "'"
MsgBox ("记录已删除")
Else
clearfiled
rs.Close
End If
End Sub

Private Sub Command2_Click()
Form2.Hide
Form1.Show
End Sub

Private Sub cx_Click()
rs.Open "select * from 酒店登记 where 身份证号码='" & Trim(zj.Text) & "'", db
If rs.EOF Then
MsgBox ("查无此人")
Else
xm.Text = rs.Fields(0)
xb.Text = rs.Fields(1)
jg.Text = rs.Fields(2)
sf.Text = rs.Fields(7)
End If
zj.Text = ""
End Sub
Private Sub Form_Load()
Set db = New ADODB.Connection
Set rs = New ADODB.Recordset
db.Open "Provider=MSDASQL.1;Persist Security Info=False;Data Source=hxh"
rs.Open "select * from 酒店登记", db
rs.Close
End Sub

Private Sub zj_click()
clearfiled
End Sub