yonghu.asp

部分功能：1.查询旅游信息：主要查询景点和酒店的信息

<%
function YongHu(ming,leiXing) {
	this.Ming = ming;
	this.LeiXing = leiXing;
};

YongHu.prototype.Ming;
YongHu.prototype.LeiXing;

// 用户注册
YongHu.ZhuCe = function (ming, leiXing, miMa) {
	if (ming==null) throw new Error("缺少ming参数");
	if (!/^[a-zA-Z0-9_]{6,16}$/.test(ming)) throw new Error("ming参数错误");
	if (leiXing==null) throw new Error("缺少leiXing参数");
	if (!/^[01]$/.test(leiXing)) throw new Error("leiXing参数错误");
	if (miMa==null) throw new Error("缺少miMa参数");
	if (!/^.{40}$/.test(miMa)) throw new Error("miMa参数错误");

	// 写入数据库
	var conn = new ActiveXObject("ADODB.Connection");
	conn.Open(Application("ConnectionString"));
	var sql = "INSERT INTO YongHu (Ming,LeiXing,MiMa) Values ('" + ming + "'," + leiXing + ",'" + miMa + "');";
	conn.Execute(sql);
	conn.Close();


};

// 用户登陆，返回false表示登录失败，返回true表示登录成功
YongHu.DengLu = function (ming, leiXing, miMa) {
	if (ming==null) throw new Error(2689,"缺少ming参数");
	if (!/^[a-zA-Z0-9_]{6,16}$/.test(ming)) throw new Error(2690,"ming参数错误");
	if (leiXing==null) throw new Error(2691,"");
	if (!/^[01]$/.test(leiXing)) throw new Error(2692,"leiXing参数错误");
	if (miMa==null) throw new Error(2693,"缺少miMa参数");
	if (!/^.{40}$/.test(miMa)) throw new Error(2694,"miMa参数错误");

	var Connection = new ActiveXObject("ADODB.Connection");
	Connection.ConnectionString = Application("ConnectionString");
	Connection.CursorLocation = 3;
	var sql = "SELECT * FROM YongHu WHERE Ming='" + ming + "' AND LeiXing=" + leiXing + " AND MiMa='" + miMa + "'";
	var result;

	try {
		Connection.Open();
		var rsCount = Connection.Execute(sql);

		if (rsCount.RecordCount > 0) {
			Session("YongHu") = new YongHu(ming,leiXing);
			result = true;
		} else {
			result = false;
		}
		Connection.Close();
	}
	catch (e) {
		if (Connection.State != 0)
			Connection.Close();
		throw new Error(2695,"查询数据据出错!");
	}
	return result;

};


%>