16.某數的平方與它的逆序數的平方互為逆序數,則該數被稱為奇妙平方數。 如122=144,212=441,12與21互逆,144與441互逆,12就是奇妙平方數,小明編寫了一個找出200以內的所有奇妙平方數的VB程序,運行界面如圖所示。實現上述功能 的VB程序如下,但加框處代碼有誤,請改正。 Private Sub Commandl-Click( ) Dim a As Integer,b As Integer,al As Integer,sum As Integer Dim t1 As Long,t2 As Long sum=0 For a=1 To 200 b=0:a1=a Do While a1>0 b=b*10+a1 Mod 10 a1=a1\10 Loop t1=a^2Lt2=b^2 If And a<>b Then Listl.AddItem Str(a) &“^2“&“=“&Str(t1) List2.AddItem Str(b) &“^2“&“=“& Str(t2) sum=sum+1 End If Next a Labell.Caption=“共有“+Str(sum)+“個” End Sub Function compare(x As Long,y As Long) As Boolean Dim k1 As Integer,s1 As String,s2 As String s1=trim(Str(x)):s2=Trim(Str(y))'Trim( )函數用于刪除字符串首尾空格 k1=Len(s1) compare=True For i=1 to k1 If Mid(s1,i,1)<>Then copare=False Next i End Function。
。 (2)請在劃線填入合適的代碼。 Dim sType(1 to 200)As String'存放圖書類別 Dim sNumber(1 to 200)As Integer'存放圖書數量 Dim n As Integer Private Sub Commandl-Click( ) Dim conn As New ADODB.Connection Dim rs As New ADOB.Recordset conn.ConnectionString=“provider=Microsoft.ACE,OLEDB.12.0data source =“& App.Path &“\Library.jye.ai“ conn.Open Set rs.ActiveConnection=conn rs.Open“select*from Book“ '本過程從靈長據庫中讀取圖書數據,存儲在相應的變量中,并在Listl 中顯示 '代碼略 End Sub Private Sub Command2-Click( ) Dim i As Integer,j As Integer,t As Integer,y As Integer Dim x As String,s As String Dim flag As Boolean List2.Clear x=Textl.Text y=Val(Text2.Text) For i=1 to n If sType(i)=x Then
flag=False Exit For End If
sType(n)=x sNumber(n)=y End If For i=1 to n-1 Forj=i+1Ton If=
Then t=sNumber(j):sNumber(j)=sNumber(i):sNumber(i)=t s=sType(j):sType(j)=sType(i):sType(i)=s End If Next j Next i List2.AddItem(“類別 數量“) FOr i=1 to n List2.AddItem sType(i) &““&Str(sUmber(i)) Next i End Sub。