login.js

HMTL 加 JS 写的操作数据库 HMTL 加 JS 写的操作数据库

function login()
{
	
	one=document.zhuce;
	//判断数据是否正确
	if((one.zcname.value == "") || (one.zcname.value < 6))
	{
		alert("用户名少于6位字符!");
		one.zcname.focus();
		return false;
	}
	if((one.zccode.value == "") || (one.zccode.value < 6))
	{
		alert("密码少于6位数!");
		one.zccode.focus();
		return false;
	} 
	if(one.zccode2.value != one.zccode.value)
	{
		alert("两次输入的密码不一样!");
		one.zccode2.focus();
		return false;
	} 
	
	two = one.zcemail.value.indexOf("@");
	three = one.zcemail.value.indexOf(".com");
	if((two == -1) || (three == -1))
	{	
		alert("电子邮件地址无效!");
		one.zcemail.focus();
		return false;
	}
	if(one.zcsex[0].checked == false && one.zcsex[1].checked ==false)
	{
		alert("请指定性别!");
		one.zcsex[0].focus();
		return false;
	}
	if((one.zcyear.value <1000) || (one.zcyear.value > 2009) || (one.zcluna.value < 0) || (one.zcluna.value >12) || (one.zcday.value < 1) || (one.zcday.value >31))
	{
		alert("请输入有效年龄!");
		one.zcyear.focus();
		return false;
	}
	if((one.zcissue.value == "") || (one.zcissue.value < 8))
	{
		alert("密码问题少与8位!");
		one.zcissue.focus();
		return false;
	}
	if((one.zckey.value == one.zcissue.value) || (one.zckey.value < 8))
	{
		alert("问题答案少与8位!");
		one.zckey.focus();
		return false;
	}
	
	if(one.zckey.value == one.zcissue.value)
	{
		alert("问题答案不能相同!");
		one.zckey.focus();
		return false;
	}

	if(one.rad1.checked == false)
	{
		alert("你未同意用户守则!");
		one.rad1.focus();
		return false;
	}
	

	
	var zcname,zccode,zcemail,zcsex,zcyear,zcluna,zcday,zcissue,zckey,zcqq,zccard,zcphone,zcaddress;
		
		zcname = document.zhuce.zcname.value;
		zccode = document.zhuce.zccode.value;
		zcemail = document.zhuce.zcemail.value;
			
		if(document.zhuce.zcsex[0].checked == true)
		{
			zcsex = "男";
		}
		else
		{
			zcsex = "女";
		}
		zcyear = document.zhuce.zcyear.value;
		zcluna = document.zhuce.zcluna.value;
		zcday = document.zhuce.zcday.value;
		zcissue = document.zhuce.zcissue.value;
		zckey = document.zhuce.zckey.value;
		zcqq = document.zhuce.zcqq.value;
		zccard = document.zhuce.zccard.value;
		zcphone = document.zhuce.zcphone.value;
		zcaddress = document.zhuce.zcaddress.value;

		var connstr="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=E:\\data.mdb";
		var dbconn = new ActiveXObject("ADODB.Connection");
		var rs = new ActiveXObject("ADODB.RecordSet");
		var sqls = "select * from login";
		dbconn.open(connstr);
		rs.open(sqls,dbconn,1);
		
	

		
		//录入数据库
		sqls = "insert into login (zcname,zccode,zcemail,zcsex,zcyear,zcluna,zcday,zcissue,zckey,zcqq,zccard,zcphone,zcaddress) values("+"'"+zcname+"'"+","+"'"+zccode+"'"+","+"'"+zcemail+"'"+","+"'"+zcsex+"'"+","+"'"+zcyear+"'"+","+"'"+zcluna+"'"+","+"'"+zcday+"'"+","+"'"+zcissue+"'"+","+"'"+zckey+"'"+","+"'"+zcqq+"'"+","+"'"+zccard+"'"+","+"'"+zcphone+"'"+","+"'"+zcaddress+"'"+")";
			
			dbconn.execute(sqls);
			
			alert("注册成功!");
			
			//关闭数据库
			rs.close();
			dbconn.close();
		

}

function login2()
{
	
	
		
		//连接access数据库
		var connstr="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=E:\\data.mdb";
		var dbconn = new ActiveXObject("ADODB.Connection");
		var rs = new ActiveXObject("ADODB.RecordSet");
	//	var sqls = "select * from login"; //查询全部信息
		
		//查询指定信息
		
		
		//var sss = document.form1.stidd.value;
		//var sqls="select * from  danta  where stid ="+sss;//数字
		var sss;
		var sqls
		
		
		
		 sss = document.form1.dlname.value;
		 
		 lll = document.form1.dlcode.value;
		 
		 //验证帐号 密码

		 sqls="select * from  login  where zcname ='"+sss+"'"; //字符
		 
		 sqls="select * from  login  where zccode ='"+lll+"'"; //字符

	


		//打开access数据库
		
		
		dbconn.open(connstr);
		rs.open(sqls, dbconn, 1);
		
		if(rs.EOF)
		{
			alert("sorry!没有该信息");
			//关闭数据库
			
		}
		
		var stid;

		//var stidd = document.form1.stidd.value;
	
		stia = rs("zcname").value;
		stib = rs("zccode").value;
		
		var dlname = document.form1.dlname.value;
		var dlcode = document.form1.dlcode.value;
		
		
		//判断帐号密码
		if ((dlname == stia) && (dlcode == stib))
		{
			alert("登陆成功!");
			document.form1.dlname.focus();
			return true;
			
		}
		else
		{
			alert("帐号或密码错误!");	
			document.form1.dlname.focus();
			return false;
		}
		
		//document.form1.dlname.value = stid;
		
		//关闭数据库
			rs.close();
		dbconn.close();

	
}