Question

ASp中执行sql语句回显

select strarea from usermg where struser="maoxi"
查询maoxi管理用户对应的区服

select count(*) as strGameGroup from GameInfo where strGameGroup="华容小道"
查询华容小道这个区服 有多少用户

我用access数据库查询工具查询执行成功

怎么写一个ASP文件执行这两个命令并且有回显

Answer 1

我来写写吧，哈哈
a="maoxi"
sql="select strarea from usermg where struser='"&a&"'"
set rs=server.createobject("adodb.recordset")
rs.open conn,sql,1,1
response.write rs("strarea")

sql="select count(*) as strGameGroup from GameInfo where strGameGroup='华容小道'"
conn.execute("sql")
response.write strgamegroup

Answer 2

<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath(你的access数据库名称)

sql="select strarea from usermg where struser='maoxi'"
set rs=conn.execute(sql)
if not(rs.eof and rs.bof) then
response.write "maoxi管理用户对应的区服为"&rs(0)&"<br>"
end if

sql="select count(*) as strGameGroup from GameInfo where strGameGroup='华容小道'"
set rs=conn.execute(sql)
if not(rs.eof and rs.bof) then
response.write "华容小道这个区服有"&rs(0)&"个用户"
end if
%>

Answer 3

郁闷，没听懂