20.素數(shù):只能被1和它本身整除的自然數(shù).要求編寫VB程序找出任意兩個整數(shù)之間中所有的素數(shù)及個數(shù),程序運行界面如圖所示. 請根據(jù)算法將下列程序補充完整. Function prime(a As Integer) As Boolean Dim j As Integer prime=True j=2 Do While prime And j<=a\2 If a Mod j=0Then prime=False Exit Do End If
Loop End Function Private Sub Command1_Click ( ?。?br />Dim i As Integer,a As Integer,b As Integer Dim count As Integer a=Val(Text1.Text) b=Val(Text2.Text) For i=a To b If
=True Then List1.AddItem Str(i) count=count+1 End If Next i Label1.Caption=“素數(shù)共有“+Str(count)+“個!“ End Sub.
21.某商場元月舉行VIP客戶積分換購活動,VIP客戶根據(jù)卡內(nèi)積分多少可換取不同額度的代金券.假設VIP客戶共有n名,VIP卡內(nèi)積分存放在數(shù)據(jù)庫“customer.jye.ai”的Integral表中,換購活動的VB程序代碼如下,程序運行時界面如第7題圖所示.工作人員在文本框Text1中輸入VIP卡號后,單擊“換購”按鈕Command1,在文本框Text2中輸出VIP客戶的積分數(shù),在標簽Label3中顯示可以換購的代金券額度,積分清零.按此要求編寫程序如下,但加框處代碼有錯,請改正. Dim ID As String'用于存放客戶卡號 Dim total As Long'用于存放積分數(shù) Dim sc As Long'VIP客戶人數(shù) Dim jf As Long'積分數(shù) Private Sub Command1_Click ( ?。?br />Dim k As String'客戶卡號 Dim q As Long'代金券額度 Dim i As Long k=Text1.Text For i=1To sc’順序查找 If ID(i)=k Then jf=total(i) cash(jf)=q’① Exit For End If Text2.Text=Str(jf) Label3.Caption=“您可換購的代金券總額為:”+Str(q)+“元” Next i End If End Sub 'cash函數(shù)用于計算VIP客戶可換購的代金券額度 Function cash(jf As Long) As Long If jf>=2000And jf<=20000Then Cash=jf\2000*10 ElseIf jf>20000And jf<=50000Then Cash=jf\2000*11 ElseIf jf>50000And jf<=100000Then Cash=jf\2000*12 ElseIf jf>100000And jf<=150000Then Cash=jf\2000*13 Else jf>150000Then’② Cash=jf\2000*14 End If End Function Private Sub Form_Load ( ?。?br />Dim conn As New ADODB.Connection,rs As New ADODB.Recordset Dim intSQL As Long conn.ConnectionString=“Provider=Microsoft.ACE.OLEDB.12.0;Data Source=“+App.Path+“\customer.jye.ai“ conn.Open intSQL=“SELECT score FROM Integral“ Set rs.ActiveConnection=conn rs.CursorType=adOpenStatic rs.Open intSQL sc=0 Do While Not rs.EOF sc=sc+1 total(sc)=rs.Fields(“score“) rs.MoveNext Loop rs.Close conn.Close Set rs=Nothing Set conn=Nothing End Sub (1)加框處①有錯,應改為