query.js

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

function access2()//查询ID  
{
	var ms = document.form1.stidd.value;
	
	if(ms == "")
	{
		alert("ID不能为空!");
		
	}
	else
	{
		
		//连接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 danta"; 查询全部信息
		
		//查询指定信息
		var sqls = "select * from danta where stid = "+parseInt(document.form1.stidd.value);
		
	
		
		//打开access数据库
		dbconn.open(connstr);
		rs.open(sqls, dbconn, 1);
		
		if(rs.EOF)
		{
			alert("sorry!没有该信息");
			//关闭数据库
			
		}
		
		var id,stid,stname,stclass,stemail,stsex,styear,stluna,stday,stone,sttwo,stthree,stfour,stfive;
	
		
		
		
		var stidd = document.form1.stidd.value;
		
		
		stid = rs("stid").value;
		document.form1.stid.value = stid;
		
		stname = rs("stname").value;
		document.form1.stname.value = stname;
		
		stclass = rs("stclass").value;
		document.form1.stclass.value = stclass;
		
		stemail = rs("stemail").value;
		document.form1.stemail.value = stemail;
		
		stsex = rs("stsex").value;
		document.form1.stsex.value = stsex;
		
		styear = rs("styear").value;
		document.form1.styear.value = styear;
		
		stluna = rs("stluna").value;
		document.form1.stluna.value = stluna;
		
		stday = rs("stday").value;
		document.form1.stday.value = stday;
		
		stone = rs("stone").value;
		document.form1.stone.value = stone;
		
		sttwo = rs("sttwo").value;
		document.form1.sttwo.value = sttwo;
		
		stthree = rs("stthree").value;
		document.form1.stthree.value = stthree;
		
		stfour = rs("stfour").value;
		document.form1.stfour.value = stfour;
		
		stfive = rs("stfive").value;
		document.form1.stfive.value = stfive;
		
		
		var stsum,stsum2;
		
		stsum = stone + sttwo + stthree + stfour + stfive;
		
		stsum2 = stsum / 5; 
		
		document.form1.stsum.value = stsum;
		document.form1.stsum2.value = stsum2;
		
		//关闭数据库
			rs.close();
		dbconn.close();
		
	}
	
	
}



function access3() //显示注册信息
{
	//连接数据库
	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 zcname,zccode,zcemail,zcsex,zcyear,zcluna,zcday,zcissue,zckey,zcqq,zccard,zcphone,zcaddress;

	dbconn.open(connstr);
	rs.open(sqls, dbconn, 1);
	
	zcname = rs("zcname").value;
	document.zhuce.zcname.value = zcname;
	
	stcode = rs("zccode").value;
	document.zhuce.zccode.value = zccode;
	
	zcemail = rs("zcemail").value;
	document.zhuce.zcemail.value = zcemail;
	
	zcyear = rs("zcyear").value;
	document.zhuce.zcyear.value = zcyear;
	
	zcluna = rs("zcluna").value;
	document.zhuce.zcluna.value = zcluna;
	
	zcday = rs("zcday").value;
	document.zhuce.zcday.value = zcday;
	
	zcissue = rs("zcissue").value;
	document.zhuce.zcissue.value = zcissue;
	
	zckey = rs("zckey").value;
	document.zhuce.zckey.value = zckey;
	
	zcqq = rs("zcqq").value;
	document.zhuce.zcqq.value = zcqq;
	
	zccard = rs("zccard").value;
	document.zhuce.zccard.value = zccard;
	
	zcphone = rs("zcphone").value;
	document.zhuce.zcphone.value = zcphone;
	
	zcaddress = rs("zcaddress").value;
	document.zhuce.zcaddress.value = zcaddress;
	
	
	//关闭数据库
	rs.close();
	dbconn.close();
	
}

function access7() //修改
{
	var plug = document.form1;
	
	//判断数据正确
	if(plug.xgid.value == "请输入新ID")
	{
		alert("ID不能为空!");
		plug.xgid.focus();
		return false;
		
		
	}
	if(plug.name.value == "")
	{
		alert("姓名不能为空!")
		plug.xgname.focus();
		return false;
		;
		
	}
	if(plug.xgclass.value == "")
	{
		alert("班级不能为空!");
		plug.xgclass.focus();
		return false;
		
		
	}
	if(plug.xgyear.value == "")
	{
		alert("日期不能为空!");
		plug.xgyear.focus();
		return false;
		
		
	}
	if(plug.xgluna.value == "")
	{
		alert("日期不能为空!");
		plug.xgluna.focus();
		return false;
		
		
	}
	
	if(plug.xgday.value == "")
	{
		alert("日期不能为空!");
		plug.xgday.focus();
		return false;
		
		
	}
	if(plug.xgone.value == "")
	{
		alert("成绩最小为零!");
		plug.xgone.focus();
		return false;
		
		
	}
	
	if(plug.xgtwo.value == "")
	{
		alert("成绩最小为零!");
		plug.xgtwo.focus();
		return false;
		
		
	}
	if(plug.xgthree.value == "")
	{
		alert("成绩最小为零!");
		plug.xgthree.focus();
		return false;
		
		
	}
	if(plug.xgfour.value == "")
	{
		alert("成绩最小为零!");
		plug.xgfour.focus();
		return false;
		
		
	}
	if(plug.xgfive.value == "")
	{
		alert("成绩最小为零!");
		plug.xgfive.focus();
		return false;
		
		
	}
	
	
	
	
	//连接数据库
	if(document.form1.xgid.value != "请输入新ID")
	{
		var connstr="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=E:\\data.mdb";
		var dbconn = new ActiveXObject("ADODB.Connection");
	
		var rs = new ActiveXObject("ADODB.RecordSet");
		
		var stid,stname,stclass,stemail,stsex,styear,stluna,stday,stone,sttwo,stthree;//,stfour,stfive;
		
		stid = document.form1.xgid.value;
		stname = document.form1.xgname.value;
		stclass = document.form1.xgclass.value;
		stemail = document.form1.xgemail.value;
		if(document.form1.xgsex[0].checked = true)
		{
			
			xgsex = "男";
			
		}
		else
		{
			xgsex = "女";
			
		}
		styear = document.form1.xgyear.value;
		stluna = document.form1.xgluna.value;
		stday = document.form1.xgday.value;
		stone = document.form1.xgday.value;
		sttwo = document.form1.xgtwo.value;
		stthree = document.form1.xgthree.value;
	//	stfour = document.form1.xgfour.value;
	//	stfive = document.form1.xgfive.value;
		
		 
		dbconn.open(connstr);
		//rs.open(sqls,dbconn,1);
		
		
		//sqls = "update danta set stid='"+document.form1.xgid.value+"',"+"stname='"+document.form1.xgname.value+"',"+"stclass='"+xgsex+"',"+"stemail='"+document.form1.xgemail.value+"',"+"stfive='"+document.form1.xgfive.value+"',"+"stfourl='"+document.form1.xgfour.value+"',"+"stthree='"+document.form1.xgthree.value+"',"+"styear='"+document.form1.xgyear.value+"',"+"stluna='"+document.form1.xgluna.value+"',"+"stday='"+document.form1.xgday.value+"',"+"stone='"+document.form1.xgone.value+"'" +"where sttwo ="+document.form1.xgtwo.value;
	
	
	//录入数据库
	  sqls="update danta set stid="+stid+",stname="+stname+",stclass="+stclass+",stemail="+stemail+",stsex="+stsex+",styear="+styear+",stluna="+stluna+",stday="+stday+",stone="+stone+",sttwo="+sttwo+" where stthree ="+stthree;

	
		dbconn.execute(sqls);
	
		//alert(sqls);
		
	
		
		//	rs.close();
		
		dbconn.close();
		
	}
	
}







function access8() //全部学员信息
{
	//打印信息
	document.write("<body background-color = #003300>");
	document.write("<table bgcolor= #003300>");
	document.write("<tr><td width = 30></td><td width = 100><font color = #FFFFFF>ID</td><td width = 100><font color = #FFFFFF>姓名</td><td width = 100><font color = #FFFFFF>班级</td><td width = 120><font color = #FFFFFF>性别</td><td width = 100><font color = #FFFFFF>C++</td><td width = 100><font color = #FFFFFF>HTML</td><td width = 100><font color = #FFFFFF>JAVA</td><td width = 100><font color = #FFFFFF>SQL</td><td width = 100><font color = #FFFFFF>C#</td><td width = 100><font color = #FFFFFF>Email</td></tr>");
	
	//连接数据库
	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";
	var stid,stname,stclass,stemail,stsex,stone,sttwo,stthree,stfour,stfive;
	
	
	//打开数据库
	dbconn.open(connstr);
	rs.open(sqls, dbconn, 1);
	
		if(rs.EOF)
		{
			alert("sorry!没有信息!");
			
			
		}
		
		
	while(!rs.EOF)
	{	 
		document.write("<tr>");
		
		document.write("<td width = 30></td>");
		
		stid = rs("stid").value;
		document.write("<td><font color = #FFFFFF>" +stid+"</td>");
		
		stname = rs("stname").value;
		document.write("<td><font color = #FFFFFF>" +stname+"</td>");
		
		stclass = rs("stclass").value;
		document.write("<td><font color = #FFFFFF>" +stclass+"</td>");
		
		stsex = rs("stsex").value;
		document.write("<td><font color = #FFFFFF>" +stsex+"</td>");
		
		stone = rs("stone").value;
		document.write("<td><font color = #FFFFFF>" +stone+"</td>");
		
		sttwo = rs("sttwo").value;
		document.write("<td><font color = #FFFFFF>" +sttwo+"</td>");
		
		stthree = rs("stthree").value;
		document.write("<td><font color = #FFFFFF>" +stthree+"</td>");
		
		stfour = rs("stfour").value;
		document.write("<td><font color = #FFFFFF>" +stfour+"</td>");
		
		stfive = rs("stfive").value;
		document.write("<td><font color = #FFFFFF>" +stfive+"</td>");
		
		stemail = rs("stemail").value;
		document.write("<td><font color = #FFFFFF>" +stemail+"</td>");
		
		rs.moveNext();
		document.write("</tr>");
	}
	document.write("</table>");
	
	//关闭数据库
	rs.close();
	dbconn.close();
}

function access9() //查询姓名
{
	var stidd = document.form1.stidd.value;
	
	if(stidd == "")
	{
		alert("姓名不能为空!");
		
	}
	else
	{
		
		//连接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 danta"; 查询全部信息
		
		//查询指定信息
		
		
	//var sss = document.form1.stidd.value;
	//var sqls="select * from  danta  where stid ="+sss;//数字
		
		

	 var sss = document.form1.stidd.value;
	 
	 var sqls="select * from  danta  where stname ='"+sss+"'"; //字符

		
	
		
		//打开access数据库
		dbconn.open(connstr);
		rs.open(sqls, dbconn, 1);
		
		if(rs.EOF)
		{
			alert("sorry!没有该信息");
			//关闭数据库
			
		}
		
		var stid,stname,stclass,stemail,stsex,styear,stluna,stday,stone,sttwo,stthree,stfour,stfive;
	
		
		
		
		//var stidd = document.form1.stidd.value;
		
		
		stid = rs("stid").value;
		document.form1.stid.value = stid;
		
		stname = rs("stname").value;
		document.form1.stname.value = stname;
		
		stclass = rs("stclass").value;
		document.form1.stclass.value = stclass;
		
		stemail = rs("stemail").value;
		document.form1.stemail.value = stemail;
		
		stsex = rs("stsex").value;
		document.form1.stsex.value = stsex;
		
		styear = rs("styear").value;
		document.form1.styear.value = styear;
		
		stluna = rs("stluna").value;
		document.form1.stluna.value = stluna;
		
		stday = rs("stday").value;
		document.form1.stday.value = stday;
		
		stone = rs("stone").value;
		document.form1.stone.value = stone;
		
		sttwo = rs("sttwo").value;
		document.form1.sttwo.value = sttwo;
		
		stthree = rs("stthree").value;
		document.form1.stthree.value = stthree;
		
		stfour = rs("stfour").value;
		document.form1.stfour.value = stfour;
		
		stfive = rs("stfive").value;
		document.form1.stfive.value = stfive;
		
		
		var stsum,stsum2;
		
		stsum = stone + sttwo + stthree + stfour + stfive;
		
		stsum2 = stsum / 5; 
		
		document.form1.stsum.value = stsum;
		document.form1.stsum2.value = stsum2;
		
		//关闭数据库
			rs.close();
		dbconn.close();
		
	}
	
	
}


function access13() //查询班级
{
	var stidd = document.form1.stidd.value;
	
	if(stidd == "")
	{
		alert("班级不能为空!");
		
	}
	else
	{
		
		//连接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 danta"; 查询全部信息
		
		//查询指定信息
		
		
	//var sss = document.form1.stidd.value;
	//var sqls="select * from  danta  where stid ="+sss;//数字
		
		

	 var sss = document.form1.stidd.value;
	 
	 var sqls="select * from  danta  where stclass ='"+sss+"'"; //字符

		
	
		
		//打开access数据库
		dbconn.open(connstr);
		rs.open(sqls, dbconn, 1);
		
		if(rs.EOF)
		{
			alert("sorry!没有该信息");
			//关闭数据库
			
		}
		
		var stid,stname,stclass,stemail,stsex,styear,stluna,stday,stone,sttwo,stthree,stfour,stfive;
	
		
		
		
		//var stidd = document.form1.stidd.value;
		
		
		stid = rs("stid").value;
		document.form1.stid.value = stid;
		
		stname = rs("stname").value;
		document.form1.stname.value = stname;
		
		stclass = rs("stclass").value;
		document.form1.stclass.value = stclass;
		
		stemail = rs("stemail").value;
		document.form1.stemail.value = stemail;
		
		stsex = rs("stsex").value;
		document.form1.stsex.value = stsex;
		
		styear = rs("styear").value;
		document.form1.styear.value = styear;
		
		stluna = rs("stluna").value;
		document.form1.stluna.value = stluna;
		
		stday = rs("stday").value;
		document.form1.stday.value = stday;
		
		stone = rs("stone").value;
		document.form1.stone.value = stone;
		
		sttwo = rs("sttwo").value;
		document.form1.sttwo.value = sttwo;
		
		stthree = rs("stthree").value;
		document.form1.stthree.value = stthree;
		
		stfour = rs("stfour").value;
		document.form1.stfour.value = stfour;
		
		stfive = rs("stfive").value;
		document.form1.stfive.value = stfive;
		
		
		var stsum,stsum2;
		
		stsum = stone + sttwo + stthree + stfour + stfive;
		
		stsum2 = stsum / 5; 
		
		document.form1.stsum.value = stsum;
		document.form1.stsum2.value = stsum2;
		
		//关闭数据库
			rs.close();
		dbconn.close();
		
	}
	
	
}