静态页面下用javascript操作ACCESS数据库(读增改删)的代码
2016-02-19 09:34
今天天气好晴朗处处好风光，好天气好开始，图老师又来和大家分享啦。下面给大家推荐静态页面下用javascript操作ACCESS数据库(读增改删)的代码，希望大家看完后也有个好心情，快快行动吧！
代码如下：
script language="javascript"
//用 JavaScript 写服务器端连接数据库的代码示例
var conn = new ActiveXObject("ADODB.Connection");
conn.Open("DBQ=E:\a.mdb;DRIVER={Microsoft Access Driver (*.mdb)};");
var rs = new ActiveXObject("ADODB.Recordset");
var sql="select * from friends_infor";
rs.open(sql, conn);
shtml = "table width='100%' border=1";
shtml +="tr bgcolor='#f4f4f4'tdau_id/tdtdau_lname/tdtdau_fname/td/tr";
while(!rs.EOF)
{
shtml += "trtd" + rs("friend_id") + "/tdtd" + rs("friend_name") + "/tdtd" + rs("friend_nickname") + "/td/tr";
rs.moveNext;
}
shtml += "/table";
document.write(shtml);
rs.close();
rs = null;
conn.close();
conn = null;
/script
添加数据到数据库页面-Insert.htm
代码如下：
table width='100%' border=1
tr bgcolor='#f4f4f4'tdfriend_name/tdtdfriend_nickname/td/tr
trtdinput name=username id=username type=text value="" //td
tdinput name=nickname id=nickname type=text value=""//td/tr
/table
script language="javascript"
function editmdb(username,nickname)
{
//用 JavaScript 写服务器端连接数据库的代码示例
var conn = new ActiveXObject("ADODB.Connection");
conn.Open("DBQ=E:\a.mdb;DRIVER={Microsoft Access Driver (*.mdb)};");
var rs = new ActiveXObject("ADODB.Recordset");
var sql="insert into friends_infor(friend_name,friend_nickname) values('" + username + "','" + nickname + "')";
//rs.open(sql, conn);
//rs.close();
//rs = null;
conn.execute(sql);
conn.close();
conn = null;
alert("添加成功");
}
/script
input name="1" type="button" value="添加" onclick="editmdb (username.value,nickname.value)"/
删除功能-Delete.htm
代码如下：
input name="1" type="button" value="修改" onclick=""/
script language="javascript"
//function deldata(userid)
//{
//用 JavaScript 写服务器端连接数据库的代码示例
var conn = new ActiveXObject("ADODB.Connection");
conn.Open("DBQ=E:\a.mdb;DRIVER={Microsoft Access Driver (*.mdb)};");
var rs = new ActiveXObject("ADODB.Recordset");
var sql="delete from friends_infor where friend_id=135";
//rs.open(sql, conn);
//rs.close();
//rs = null;
conn.execute(sql);
conn.close();
conn = null;
alert("修改成功");
//}
/script
修改功能 Updata.htm
代码如下：
script language="javascript"
function getdata()
{
//用 JavaScript 写服务器端连接数据库的代码示例
var conn = new ActiveXObject("ADODB.Connection");
conn.Open("DBQ=E:\a.mdb;DRIVER={Microsoft Access Driver (*.mdb)};");
var rs = new ActiveXObject("ADODB.Recordset");
var sql="select * from friends_infor where friend_id=100";
rs.open(sql, conn);
shtml = "table width='100%' border=1";
shtml +="tr bgcolor='#f4f4f4'tdfriend_id/tdtdfriend_name/tdtdfriend_nickname/td/tr";
while(!rs.EOF)
{
shtml += "trtd" + rs("friend_id") + "/tdtd" + rs("friend_name") + "/tdtd" + rs("friend_nickname") + "/td/tr";
shtml += "trtd" + rs("friend_id") + "input name=userid id=userid type=hidden value=" + rs("friend_id") + " //tdtdinput name=username id=username type=text value=" + rs("friend_name") + " //tdtdinput name=nickname id=nickname type=text value=" + rs("friend_nickname") + " //td/tr";
rs.moveNext;
}
shtml += "/table";
document.write(shtml);
rs.close();
rs = null;
conn.close();
conn = null;
}
getdata()
/script
script language="javascript"
function editmdb(userid,username,nickname)
{
//用 JavaScript 写服务器端连接数据库的代码示例
var conn = new ActiveXObject("ADODB.Connection");
conn.Open("DBQ=E:\a.mdb;DRIVER={Microsoft Access Driver (*.mdb)};");
var rs = new ActiveXObject("ADODB.Recordset");
var sql="update friends_infor set friend_name='" + username + "',friend_nickname='" + nickname + "' where friend_id=" + userid + "";
//rs.open(sql, conn);
//rs.close();
//rs = null;
conn.execute(sql);
conn.close();
conn = null;
alert("修改成功");
getdata()
}
/script
input name="1" type="button" value="修改" onclick="editmdb (userid.value,username.value,nickname.value)"/
