1,216
社区成员
发帖
与我相关
我的任务
分享
Private Sub Command1_Click()
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim connstr As String
connstr = "DRIVER={MySQL ODBC 5.1 Driver};" & "SERVER=127.0.0.1;" & "port=3306;" & "DATABASE=my;" & "UID=root;PWD=rufeng;OPTION=3"
conn.Open connstr
conn.CursorLocation = adUseClient
rs.Open "select question,answer1,answer2,answer3,answer4,result from cq_quiz where question like '%" & Text1.Text & "%';", conn
While Not rs.EOF
Debug.Print rs.Fields(0).Value, rs.Fields(1).Value
s = s & rs.Fields("question").Value & String(5, " ") & rs.Fields("answer1").Value & String(1, "|") & rs.Fields("answer2").Value & String(1, "|") & rs.Fields("answer3").Value & String(1, "|") & rs.Fields("answer4").Value & String(1, "|") & rs.Fields("result").Value & String(1, "|") & vbCrLf
rs.MoveNext
Wend
Text2.Text = s
rs.Close
conn.Close
Set rs = Nothing
Set conn = Nothing
End Sub