网页无刷新更新数据，但是access数据库的，想改成SQL的
<P><FONT face=Verdana size=2></FONT></P><P>
<P><FONT face=Verdana><FONT size=2></FONT></FONT></P><STRONG><FONT color=#0033ff></FONT></STRONG><STRONG></STRONG>想改成SQL的，但不会改，尤其是蓝字的地方<BR><FONT face=Verdana size=2>server.asp 服务器端处理.</FONT></P>
<P><FONT face=Verdana><FONT size=2><% @Language="JavaScript" %><BR><%<BR><STRONG><FONT color=#0033ff>function OpenDB(sdbname)<BR></FONT></STRONG>{<BR></FONT><FONT size=2><FONT color=#288328>/*<BR> *--------------- OpenDB(sdbname) -----------------<BR> * OpenDB(sdbname) <BR> * 功能:打开数据库sdbname,返回conn对象.<BR> * 参数:sdbname,字符串,数据库名称.<BR> * 实例:var conn = OpenDB("database.mdb");<BR> * author:wanghr100(灰豆宝宝.net)<BR> * update:2004-5-12 8:18<BR> *--------------- OpenDB(sdbname) -----------------<BR> */</FONT><BR> <STRONG><FONT color=#0000ff> var connstr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath(sdbname);<BR> var conn = Server.CreateObject("ADODB.Connection");<BR> conn.Open(connstr);<BR> return conn;<BR>}<BR>var sResult = "";<BR>var oConn = OpenDB("data.mdb");<BR></FONT></STRONG><FONT color=#288328>//特殊字符：+,%,&,=,?等的传输解决办法.客户端字符是经过escape编码的<BR>//所以服务器端先要经过unescape解码.<BR>//Update:2004-6-1 12:22</FONT><BR><STRONG><FONT color=#3809f7>var userid = unescape(Request("userid"));<BR>var sql = "select username from users where userid='"+userid+"'";<BR>var rs = oConn.Execute(sql);<BR></FONT></STRONG>if(!rs.EOF)<BR>{<BR> sResult = rs("username").Value;<BR>}<BR>else<BR>{<BR> <FONT color=#288328>//加入容错.2004-5-30 10:15<BR></FONT> sResult = "Sorry,没有找到..."<BR>}<BR><FONT color=#288328>//escape解决了XMLHTTP。中文处理的问题.</FONT><BR>Response.Write(<FONT color=#ff0000>escape(sResult)</FONT>);<BR>%></FONT></FONT></P>
<P><FONT face=Verdana><FONT size=2></FONT></FONT> </P> <P>没人知道么？</P> <P>帮你顶一下吧。</P>
页:
[1]