Question

Access数据库模糊查询

Answer 1

问题可以再详细点么~是编译个程序用来查询ACC数据库,还是用ACC数据库做一个查询系统啊? 这是基于ASP的菏泽医学专科学校成绩查询系统的部分源代码,不知道对你有没有用 < html > < head > < title > 菏泽医学专科学校成绩查询系统< / title > < / head > < body bgcolor = ”pink”> < center > < h1 > 欢迎进入计算机成绩检索系统< / h1 > < table width = 300 > < tr > < td > < b > < font size = 2 > 姓名< / font > < font size = 2 > : < / font > < / b > < / td > < td > < form action = ”search0 . asp”method = ”post”> < input type = ”text”name = ”xm”> < / td > < / tr > < tr > < td > < b > < font size = ”2”> 学号< / font > < / b > < / td > < td > < input type = ”text”name = ”xh”value = ””> < / td > < / tr > < tr > < td > < / td > < td > < br > < input type = ”submit”value = ”确定”> < input type = ”button”value = ”重写”> < / form > < / td > < / tr > < / table > < / body > < / html > [2] shiyan0 表单程序把姓名、学号传递到search0 . asp,即可 快速查找到符合条件的记录,并显示对成绩相关的说明。 search0 表单源程序代码如下: < HTML > < head > < title > 菏泽医学专科学校计算机统考成绩查询< / title > < TITLE > student < / TITLE > < / head > < body bgcolor = ”pink”> < h1 align = ”center”> 欢迎进入计算机成绩检索系统 < font > < / h1 > < / font > < %Xm = request . form(”Xm”) Xh = request . form(”Xh”)% > < %If IsObjec(t Sessio(n ”test-conn”))Then Set conn = Session(”test-conn”) Else Set conn = Server . CreateObjec(t ”ADODB . Connection”) datasource = ”Data Source = d:. . . . . . . . .(注) student . mdb; Server .MapPath( . / student .mdb)” conn .Open ”Provider = Microsoft . Jet .OLEDB .4 .0;datasource” Set Session(”test-conn”)= conn End If% > < %If IsObjec(t Sessio(n ”student-rs”))Then Set rs = Session(”student-rs”) Else Set rs = Server . CreateObjec(t ”ADODB .Recordset”) sql = ”SELECT * FROM student ” rs .Open sql,conn,3,3 If rs . eof Then rs .AddNew End If Set Session(”student-rs”) = rs End If% >[3] < div align = ”center”> < center > < TABLE BORDER = 1 width = ”419”height = ”7”> < FONT > < CAPTION > < p align = ”center”> < / CAPTION > < / FONT > < THEAD > < TR > < TH align = ”center”width = ”99”height = ”11”> < font > 姓名< / font > < / TH > < TH align = ”center”width = ”106”height = ”11”> < font > 学号< / font > < / TH > < TH align = ”center”width = ”53”height = ”11”> < font > 性别< / font > < / TH > < TH align = ”center”width = ”75”height = ”11”> < font > 分数< / font > < / TH > < / TR > < / THEAD > < TBODY > < %On Error Resume Next rs .MoveFirst do while Not rs . eof % > < % If Xm = rs(”Xm”)then % > < TR VALIGN = TOP > < TD align = ”center”width = ”99”height = ”1”> < p align = ”center”> < FONT > < % = Server .HTMLEncode(rs . Fields(”xm”).Value)% > < BR > < / FONT > < / p > < / TD > < TD align = ”center”width = ”106”height = ”1”> < p align = ”center”> < FONT > < % = Server .HTMLEncode(rs . Fields(”kh”).Value)% > < BR > < / FONT > < / p > < / TD > < % If rs(”Xb”)= 1 then xxbb = ”男” else xxbb = ”女” End if% > < TD align = ”center”width = ”53”height = ”1”> < p align = ”center”> < FONT >

Answer 2

没用过access，但我估计跟mssql差不多吧，sql语句这样写吧，你试试，select * from tableA where name like '%模糊查询的字%'