delete.js

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

function access4()  //删除信息
{
	var del = document.form1.stidd.value;
	
	
	
	if(del == "")
	{
		
		alert("信息不能为空!");
		
	}
	
	
	if(del != "")
	{
		
	//连接数据库
		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 = document.form1.stidd.value;
	
	//打开数据库
		dbconn.open(connstr);
		rs.open(sqls, dbconn, 1);
		if(rs.EOF)
		{
			alert("sorry!没有信息!");
			
			
		}
		
		//删除指定数据信息
		
		
		//提取数据
		var sqlss = "delete from danta where stid="+parseInt(stid); 
		
		dbconn.execute(sqlss);
		
		if(!rs.EOF)
		{
			alert("删除成功");
			rs.close();
			dbconn.close();
				
		}
	
	}

	
}
function access10() //修改信息
{
	var del = document.form1.stidd.value;
	
	if(del == "")
	{
		
		alert("信息不能为空!");
		
	}
	
	
	if((del != "") && (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 sqls = "select * from danta";
		var stid = document.form1.stidd.value;
	
	//打开数据库
		dbconn.open(connstr);
		rs.open(sqls, dbconn, 1);
		if(rs.EOF)
		{
			alert("sorry!没有信息!");
			
			
		}
		
		//删除指定数据信息
		
		
		//提取信息
		var sqlss = "delete from danta where stid="+parseInt(stid); 
		
		dbconn.execute(sqlss);
		
		if(!rs.EOF)
		{
			alert("请点确认修改!");
			//关闭数据库
			rs.close();
			dbconn.close();
				
		}
	
	}

	
}

function access11() //确认修改
{
	
	var plug = document.form1;
	
	
	if(plug.xgid.value == "请输入新ID")
	{
		alert("ID不能为空!");
		plug.xgid.focus();
		return false;
		
		
	}
	if(plug.xgname.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 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)
		{
			stsex = "男";
		}
		else
		{
			stsex = "女";
		}
		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;
		
	//连接数据库
	
		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();
		
	}
	

	
	
}