班级修改.frm

功能强大的学生信息管理系统 用户:admin 密码:admin学生信息管理系统是典型的信息管理系统 (MIS)

   End
   Begin VB.TextBox Text5 
      Height          =   1215
      Left            =   720
      TabIndex        =   9
      Top             =   1440
      Width           =   8535
   End
   Begin VB.TextBox Text4 
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   375
      Left            =   5760
      TabIndex        =   7
      Top             =   960
      Width           =   2055
   End
   Begin VB.TextBox Text3 
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   375
      Left            =   1560
      TabIndex        =   6
      Top             =   960
      Width           =   2295
   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          =   375
      Left            =   5520
      TabIndex        =   3
      Top             =   360
      Width           =   2295
   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          =   375
      Left            =   1560
      TabIndex        =   1
      Top             =   360
      Width           =   2295
   End
   Begin VB.Label Label5 
      Caption         =   "备注："
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   375
      Left            =   120
      TabIndex        =   8
      Top             =   1560
      Width           =   735
   End
   Begin VB.Label Label4 
      Caption         =   "辅导员："
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   4920
      TabIndex        =   5
      Top             =   960
      Width           =   975
   End
   Begin VB.Label Label3 
      Caption         =   "人数："
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   375
      Left            =   840
      TabIndex        =   4
      Top             =   960
      Width           =   735
   End
   Begin VB.Label Label2 
      Caption         =   "专业："
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   375
      Left            =   4800
      TabIndex        =   2
      Top             =   360
      Width           =   855
   End
   Begin VB.Label Label1 
      Caption         =   "年级："
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   375
      Left            =   840
      TabIndex        =   0
      Top             =   360
      Width           =   735
   End
End
Attribute VB_Name = "Frm_UpdateClass"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
If admin = 1 Then
Dim myCon As New ADODB.Connection     '连接数据库
Dim myRs As New ADODB.Recordset       '操作数据
Dim NianJi, xi, RenShu, FuDaoYuan, BeiZu As String
NianJi = Text1.Text
ZhuanYe = Text2.Text
RenShu = Text3.Text
FuDaoYuan = Text4.Text
BeiZu = Text5.Text
If Trim(NianJi) = "" Or Trim(ZhuanYe) = "" Or Trim(RenShu) = "" Or Trim(FuDaoYuan) = "" Then
    MsgBox "请填写要修改班级资料的内容！"
    Exit Sub
End If

myCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=信息.mdb;"                    '打开数据库
myRs.Open "select * from 班级表 where 年级='" & Text1.Text & "'", myCon, 3, 2
    'myRs!年级 = Text1.Text
    myRs!专业 = Text2.Text
    myRs!人数 = Text3.Text
    myRs!辅导员 = Text4.Text
    If Text5.Text = "" Then
        Text5.Text = ""
    Else
        myRs!备注 = Text5.Text
    End If
myRs.Update
myRs.Close
myCon.Close
MsgBox "您确定要修改吗？", vbYesNo, "提示"
Adodc1.RecordSource = "select * from 班级表 order by 年级"
Frm_UpdateClass.Adodc1.Refresh
Frm_UpdateClass.DataGrid1.Refresh
Text1.Text = ""
Text2.Text = ""
Text3.Text = ""
Text4.Text = ""
Text5.Text = ""
Else
    MsgBox "对不起，您没有这个权限！", vbOKOnly + vbExclamation, "提示"
End If
    

End Sub

Private Sub Command2_Click()
    Unload Me
End Sub

Private Sub Command3_Click()
    Unload Me
    Frm_FindClass.Show 1
End Sub

Private Sub DataGrid1_Click()
'Adodc1.RecordSource = "select * from 班级表 where 年级 = '" & Trim(DataGrid1.Row) & "'"
 'Text1.Text = Adodc1.Recordset.Fields("年级")
 'Text2.Text = Adodc1.Recordset.Fields("专业")
 'Text3.Text = Adodc1.Recordset.Fields("人数")
 'Text4.Text = Adodc1.Recordset.Fields("辅导员")
 'Text5.Text = Adodc1.Recordset.Fields("备注")
End Sub

Private Sub Form_Activate()
Frm_FindClass.Adodc1.RecordSource = strTiaoJian
Frm_FindClass.Adodc1.Refresh
Set DataGrid1.DataSource = Frm_FindClass.Adodc1
End Sub