“学生成绩”表含有字段(学号,姓名,数学,外语,专业,总分)。下列程序的功能是:计算每名学生的总分(总分=数学+外语+专业)。请在程序空白处填入适当语句,使程序实现所需要的功能。 Private Sub Command1_Click() Dim cn As New ADODBConnection Dim rs As New ADODB.Recordset Dim zongfen As ADODB.Field Dim shuxue As ADODB.Field Dim waiyu As ADODB.Field Dim zhuanye As ADODB.field Dim strSQL As String Set cn=CurrentProject.Connection strSQL="Select *from 学生成绩" rs.OpenstrSQL,cn,adOpenDynamic,adLockOptimistic,adCmdText Set zongfen=rs.Fields("总分") Set shuxue=rs.Fields("数学") Set waiyu=rs.Fields("外语") Set zhuanye=rs.Fields("专业") Do While (14) zongfen=shuxue+waiyu+zhuanye (15) rs.MoveNext Loop rs.Close cn.Close Set rs=Nothing Set cn=Nothing End Sub