flash与数据库的通讯 加了 set 之后变成 缺少" ; " 号 ,指教指教吧!
加了 set 之后变成缺少" ; " 号
气死了....
怎么没人啊. 出来指教指教吧!
<%@ Language="JScript"%>
<%
var xmlReceive = new ActiveXObject("Msxml2.DomDocument");
xmlReceive.loadXML(Request.Form());
var reElement = xmlReceive.documentElement;
set password = reElement.attributes[0].value; //就是这里问题!
set username = reElement.attributes[1].value;
/*
set username = xmlReceive.documentElement.firstChild.childNodes[0];
username = objname.text;
set password = xmlReceive.documentElement.firstChild.childNodes[1] ;
password =objpwd.text;
righ = "-1";
*/
var conn = new ActiveXObject("ADODB.Connection");
conn.Open("Driver{SQL Server};Server=(Local);UID=sa;PWD=;"&"database=kagebookdata");
var rs = new ActiveXObject("ADODB.Recordset");
var sql="select * from users where userid='"+userId+"'";
rs.open(sql, conn);
/* SqlConnection con = DriverManager.getConnection("server=(local);userid=sa;password=a;database=kagebookdata");
SqlDataAdapter sda = new SqlDataAdapter("select * from users where userid='"+userId+"'" , con);
DataSet ds = new DataSet();
sda.Fill(ds, "users"); */
//开始验证
if (0==rs.Tables["users"].Rows.Count)
{
Msg = "找不到此使用者:" + userId + "请重新登入!";
}
else if (password!=rs.Tables["users"].Rows[0]["pw"].ToString())
{
Msg = "对不起,您填写的密码不正确,请返回重新填写!";
}
else if (password==rs.Tables["users"].Rows[0]["pw"].ToString())
{ Msg = "恭喜你," + userId + "你已经成功登陆!";
}