plug.js

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

function access()
{	
	plug = document.luru;
	
	if(plug.stid.value == "")
	{
		alert("ID不能为空!");
		plug.stid.focus();
		return false;
	}
	
	if(plug.stname.value == "")
	{
		alert("姓名不能为空!");
		plug.stname.focus();
		return false;
	}
	
	if(plug.stclass.value == "")
	{
		alert("班级不能为空!");
		plug.stclass.focus();
		return false;
	}
	
	
	var	bbs = plug.stemail.value.indexOf("@");
	var	bbt = plug.stemail.value.indexOf(".com");
	if((bbs == -1) || (bbt == -1))
	{	
		alert("电子邮件地址无效!");
		plug.stemail.focus();
		return false;
	}
	if(plug.stsex[0].checked == false && plug.stsex[1].checked ==false)
	{
		alert("请指定性别!");
		plug.stsex[0].focus();
		return false;
	}
	if((plug.styear.value <1000) || (plug.styear.value > 2009) || (plug.stluna.value < 0) || (plug.stluna.value >12) || (plug.stday.value < 1) || (plug.stday.value >31))
	{
		alert("请输入有效日期!");
		one.styear.focus();
		return false;
	}
	
	if(plug.stone.value > 100)
	{
		alert("分数太大");
		plug.stone.focus();
		return false;
	}
	if(plug.sttwo.value > 100)
	{
		alert("分数太大");
		plug.sttwo.focus();
		return false;
	}
	
	if(plug.stthree.value > 100)
	{
		alert("分数太大");
		plug.stthree.focus();
		return false;
	}
	
	if(plug.stfour.value > 100)
	{
		alert("分数太大");
		plug.stfour.focus();
		return false;
	}
	
	if(plug.stfive.value > 100)
	{
		alert("分数太大");
		plug.stfive.focus();
		return false;
	}
	
	if(plug.stone.value < 0)
	{
		alert("分数最少为零");
		plug.stone.focus();
		return false;
	}
	if(plug.sttwo.value < 0)
	{
		alert("分数最少为零");
		plug.sttwo.focus();
		return false;
	}
	if(plug.stthree.value < 0)
	{
		alert("分数最少为零");
		plug.stthree.focus();
		return false;
	}
	if(plug.stfour.value < 0)
	{
		alert("分数最少为零");
		plug.stfour.focus();
		return false;
	}
	if(plug.stfive.value < 0)
	{
		alert("分数最少为零");
		plug.stfive.focus();
		return false;
	}
	
	
	
	
	
	
	if(plug.five.value != "")
	{
		alert("录入成功!");	
	
	}




	if((plug.stid.value != "") && (plug.stname.value != "") && (plug.stclass.value != "") && (plug.stemail.value != ""))
	
	{
	
	var stid,stname,stclass,stemail,stsex,styear,stluna,stday,stone,sttwo,stthree,stfour,stfive;
	
	stid = document.luru.stid.value;
	stname = document.luru.stname.value;
	stclass = document.luru.stclass.value;
	stemail = document.luru.stemail.value;
	if(document.luru.stsex[0].checked == true)
	{
		stsex = "男";
	}
	else
	{
		stsex = "女";
	}
	styear = document.luru.styear.value;
	stluna = document.luru.stluna.value;
	stday = document.luru.stday.value;
	stone = document.luru.stone.value;
	sttwo = document.luru.sttwo.value;
	stthree = document.luru.stthree.value;
	stfour = document.luru.stfour.value;
	stfive = document.luru.stfive.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 danta";
	dbconn.open(connstr);
	rs.open(sqls,dbconn,1);

	sqls = "insert into danta (stid,stname,stclass,stemail,styear,stluna,stday,stone,sttwo,stthree,stfour,stfive,stsex) values("+"'"+stid+"'"+","+"'"+stname+"'"+","+"'"+stclass+"'"+","+"'"+stemail+"'"+","+"'"+styear+"'"+","+"'"+stluna+"'"+","+"'"+stday+"'"+","+"'"+stone+"'"+","+"'"+sttwo+"'"+","+"'"+stthree+"'"+","+"'"+stfour+"'"+","+"'"+stfive+"'"+","+"'"+stsex+"'"+")";
	
	dbconn.execute(sqls);
	
	rs.close();
	dbconn.close();
	
	}
	
	

}