你的位置:| 首页网站建设javascript操作ACCESS数据库代码→文章正文  
文章导航


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'><td>au_id</td><td>au_lname</td><td>au_fname</td></tr>";
while(!rs.EOF)
{
shtml += "<tr><td>" + rs("friend_id") + "</td><td>" + rs("friend_name") + "</td><td>" + 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'><td>friend_name</td><td>friend_nickname</td></tr>
<tr><td><input name=username id=username type=text value="" /></td>
<td><input 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'><td>friend_id</td><td>friend_name</td><td>friend_nickname</td></tr>";
  while(!rs.EOF)
  {
 shtml += "<tr><td>" + rs("friend_id") + "</td><td>" + rs("friend_name") + "</td><td>" + rs("friend_nickname") + "</td></tr>";
 shtml += "<tr><td>" + rs("friend_id") + "<input name=userid id=userid type=hidden value=" + rs("friend_id") + " /></td><td><input name=username id=username type=text value=" + rs("friend_name") + " /></td><td><input 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)"/>

 

 

  上一页 1 2 3 4 5 下一页
 
公司简介 在线客服 客服中心 意见反馈 相关法律 隐私条款 广告服务 友情链接
Q链:515347638  电子邮箱:hanen@126.com 粤ICP备05086553