。 (2)請在橫線處填上合適的代碼。 Const max=1000 Dim n As Integer’存放學生人數(shù) Dim xh(1 To max) As String,xm(1 To max) As String Dim bj(1 To max) As Integer’fs(0 To max) As Single Dim ffcj(1 To max) As Integer’數(shù)組ffdj存儲學生的賦分等級 Dim ffdj(0 To max) As String’數(shù)組ffcj存儲學生的賦分成績 Private Sub Form_Load
( ?。?/div>
( ?。?/div> Dim i As Integer,km As String Dim conn As New ADODB.Connection Dim rs As New ADODB.Recordset conn.ConnectionString=“provider=microsoft.ace.jye.ai.12.0;data source=“+App.Path+“\student.jye.ai” conn.Open Set rs.ActiveConnection=conn rs.Open“select*from stu_info“ ’本過程其它代碼從數(shù)據(jù)庫中讀入學生學號、姓名、班級和原始成績存儲到數(shù)組xh、xm、bj和fs中,并在List1中顯示。學生數(shù)存儲在變量n中。 Loop End Sub Private Sub Command1_Click
( )
( ?。?/div> Dim q(1 To max) As Integer’p(1 To 8)As Single,dj(1 To 8)As String Dim i As Integer,j As Integer,t As Integer,pos As Integer,last As Integer Dim t1 As Integer,t2 As Integer,s1 As Single,s2 As Single p(1)=0.03:p(2)=0.07:p(3)=0.16:p(4)=0.24 p(5)=0.24:p(6)=0.16:p(7)=0.07:p(8)=0.03 dj(1)=“A“:dj(2)=“B+“:dj(3)=“B“:dj(4)=“C+“ dj(5)=“C“:dj(6)=“D+“:dj(7)=“D“:dj(8)=“E“ For i=2 To 8 p(i)=
p(i)+p(i-1)
p(i)+p(i-1)
’計算到該等級累計所占比例 Next i Fori=1Ton q(i)=i Next i For i=1 Ton-1 For j=n To i+1 Step-1 If fs(q(j))>fs(q(j-1)) Then t=q(j):q(j)=q(j-1):q(j-1)=t End If Next j Next i pos=1 t1=100:t2=91 For i=1 To 8 last=Int(n*p(i)+0.5) Do While
fs(q(last+1))=fs(q(last))
fs(q(last+1))=fs(q(last))
last=last+1’處理切分位置的同分數(shù)學生 Loop s1=fs(q(pos)):s2=fs(q(last)) Do While pos<=last
ffdj(q(pos))=i
ffdj(q(pos))=i
ffcj(q(pos))=t2+(fs(q(pos))-s2)/(s1-s2)*(t1-t2) pos=pos+1 Loop t1=t1-10:t2=t2-10 Next i For i=1 Ton List2.AddItem xh(q(i))+xm(q(i))+Str(bj(q(i)))+dj(ffdj(q(i)))+Str(ffcj(q(i))) Next i End Sub
1.大部分社交軟件都有好友推薦的功能,當用戶 A 和用戶 B 的共同好友數(shù)量超過閾值 p 時,由系統(tǒng)向用戶 A 推薦用戶 B。 編寫 VB 程序,實現(xiàn)好友推薦功能。運行程序,列表框 Listl 中顯示用戶 id 及好友列表,在文本框 Textl 中 輸入推薦目標用戶 id,在文本框 Text2 中輸入閾值 p,點擊“推薦”按鈕,在列表框List2 中顯示用戶之間的關(guān)系,在標簽 Label5 中顯示向目標用戶推薦的好友列表。程序運行界面如圖: (1)根據(jù)如圖所示數(shù)據(jù),若輸入用戶 id 為“3”,輸入閾值為“3”,則推薦好友為: