form8.frm

基于VB和SQL的邮件自动处理辅助教学系统原码

VERSION 5.00
Object = "{6B7E6392-850A-101B-AFC0-4210102A8DA7}#1.3#0"; "COMCTL32.OCX"
Begin VB.Form Form8 
   Caption         =   "单个学生信息"
   ClientHeight    =   5730
   ClientLeft      =   60
   ClientTop       =   510
   ClientWidth     =   8250
   LinkTopic       =   "Form8"
   ScaleHeight     =   5730
   ScaleWidth      =   8250
   StartUpPosition =   3  '窗口缺省
   Begin VB.TextBox Text1 
      Height          =   615
      Index           =   5
      Left            =   2280
      TabIndex        =   14
      Top             =   4200
      Width           =   2415
   End
   Begin VB.TextBox Text1 
      Height          =   615
      Index           =   4
      Left            =   2280
      TabIndex        =   13
      Top             =   3480
      Width           =   2415
   End
   Begin VB.TextBox Text1 
      Height          =   615
      Index           =   3
      Left            =   2280
      TabIndex        =   12
      Top             =   2640
      Width           =   2415
   End
   Begin VB.TextBox Text1 
      Height          =   615
      Index           =   2
      Left            =   2280
      TabIndex        =   11
      Top             =   1800
      Width           =   2415
   End
   Begin VB.TextBox Text1 
      Height          =   615
      Index           =   1
      Left            =   2280
      TabIndex        =   10
      Top             =   1080
      Width           =   2415
   End
   Begin VB.TextBox Text1 
      Height          =   615
      Index           =   0
      Left            =   2280
      TabIndex        =   9
      Top             =   240
      Width           =   2415
   End
   Begin VB.CommandButton Command2 
      Caption         =   "修改"
      Height          =   495
      Left            =   6240
      TabIndex        =   7
      Top             =   3240
      Width           =   1455
   End
   Begin VB.CommandButton Command1 
      Caption         =   "返回"
      Height          =   495
      Left            =   6240
      TabIndex        =   6
      Top             =   3960
      Width           =   1455
   End
   Begin ComctlLib.StatusBar StatusBar1 
      Align           =   2  'Align Bottom
      Height          =   495
      Left            =   0
      TabIndex        =   8
      Top             =   5235
      Width           =   8250
      _ExtentX        =   14552
      _ExtentY        =   873
      SimpleText      =   ""
      _Version        =   327682
      BeginProperty Panels {0713E89E-850A-101B-AFC0-4210102A8DA7} 
         NumPanels       =   3
         BeginProperty Panel1 {0713E89F-850A-101B-AFC0-4210102A8DA7} 
            Object.Width           =   4410
            MinWidth        =   4410
            Text            =   "邮件自动处理系统欢迎您"
            TextSave        =   "邮件自动处理系统欢迎您"
            Key             =   ""
            Object.Tag             =   ""
         EndProperty
         BeginProperty Panel2 {0713E89F-850A-101B-AFC0-4210102A8DA7} 
            Style           =   6
            Alignment       =   2
            AutoSize        =   1
            Object.Width           =   6959
            TextSave        =   "2006-5-24"
            Key             =   ""
            Object.Tag             =   ""
         EndProperty
         BeginProperty Panel3 {0713E89F-850A-101B-AFC0-4210102A8DA7} 
            Style           =   5
            Alignment       =   2
            TextSave        =   "19:15"
            Key             =   ""
            Object.Tag             =   ""
         EndProperty
      EndProperty
   End
   Begin VB.Label Label6 
      Caption         =   "邮箱"
      Height          =   375
      Left            =   360
      TabIndex        =   5
      Top             =   4200
      Width           =   1815
   End
   Begin VB.Label Label5 
      Caption         =   "班级"
      Height          =   375
      Left            =   360
      TabIndex        =   4
      Top             =   3600
      Width           =   1695
   End
   Begin VB.Label Label4 
      Caption         =   "性别"
      Height          =   495
      Left            =   360
      TabIndex        =   3
      Top             =   2760
      Width           =   1695
   End
   Begin VB.Label Label3 
      Caption         =   "年龄"
      Height          =   495
      Left            =   360
      TabIndex        =   2
      Top             =   1920
      Width           =   1695
   End
   Begin VB.Label Label2 
      Caption         =   "姓名"
      Height          =   375
      Left            =   360
      TabIndex        =   1
      Top             =   1200
      Width           =   1455
   End
   Begin VB.Label Label1 
      Caption         =   "学号"
      Height          =   495
      Left            =   360
      TabIndex        =   0
      Top             =   360
      Width           =   1455
   End
End
Attribute VB_Name = "Form8"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public db1 As New ADODB.Connection
Public rs1 As New ADODB.Recordset

Private Sub Command1_Click()
Form8.Hide
Form10.Show
End Sub

Private Sub Command2_Click()
On Error Resume Next
If Command2.Caption = "修改" Then
Command2.Caption = "确认"
Else
Command2.Caption = "修改"
rs1.Update
End If
End Sub

Private Sub Form_Load()
Set db1 = New ADODB.Connection
Set rs1 = New ADODB.Recordset
rs1.CursorLocation = adUseClient
db1.ConnectionString = "driver={SQL Server};server=(local);database=邮件系统;persist security info=false;user id=;"
db1.Open
rs1.Open "select * from 学生 where 学号='" & Form10.Text1.Text & "'", db1, adOpenDynamic, adLockOptimistic, -1

Set Text1(0).DataSource = rs1
Text1(0).DataField = "学号"
Set Text1(1).DataSource = rs1
Text1(1).DataField = "姓名"
Set Text1(2).DataSource = rs1
Text1(2).DataField = "年龄"
Set Text1(3).DataSource = rs1
Text1(3).DataField = "性别"
Set Text1(4).DataSource = rs1
Text1(4).DataField = "班级"
Set Text1(5).DataSource = rs1
Text1(5).DataField = "邮箱"
End Sub