javascript操作数据库js操作access数据库，跟其他语言操作差不多，总结了一下习惯代码，仅供参考学习。
现在在f盘有文件abc.mdf，表名为student，一共2个字段，id数字类型主键，stuname文本类型，现对该表进行增删改查的操作：
1.查询
复制代码 代码如下:
<script> <br>var conn = new ActiveXObject("ADODB.Connection"); <br>conn.Open("DBQ=f://abc.mdb;DRIVER={Microsoft Access Driver (*.mdb)};"); <br>var rs = new ActiveXObject("ADODB.Recordset"); <br>var sql="select * from Student"; <br>rs.open(sql, conn); <br>var html=""; <br>while(!rs.EOF) <br>{ <br>html=html+rs.Fields("Id")+" "+rs.Fields("stuName"); <br>rs.moveNext(); <br>} <br>document.write(html); <br>rs.close(); <br>rs = null; <br>conn.close(); <br>conn = null; <br></script>
2.增加操作
复制代码 代码如下:
<script language="javascript"> <br>function addUser(id,stuName) <br>{ <br>//用 JavaScript 写服务器端连接数据库的代码示例 <br>var conn = new ActiveXObject("ADODB.Connection"); <br>conn.Open("DBQ=F://abc.mdb;DRIVER={Microsoft Access Driver (*.mdb)};"); <br>var sql="insert into Student(ID,stuName) values("+id+",'"+stuName+"')"; <br>try{ <br>conn.execute(sql); <br>alert("添加成功"); <br>} <br>catch(e){ <br>document.write(e.description); <br>alert("添加失败~~~"); <br>} <br>conn.close(); <br>} <br></script>
| 编号 | 姓名 |
3.删除操作
复制代码 代码如下:
<script language="javascript"> <br>function delStu(id) <br>{ <br>var conn = new ActiveXObject("ADODB.Connection"); <br>conn.Open("DBQ=F://abc.mdb;DRIVER={Microsoft Access Driver (*.mdb)};"); <br>var sql="delete from Student where Id=2"; <br>conn.execute(sql); <br>conn.close(); <br>conn = null; <br>alert("修改成功"); <br>} <br></script>
4.修改操作
复制代码 代码如下:
<script> <br>function updateUser(userId,userName) <br>{ <br>var conn = new ActiveXObject("ADODB.Connection"); <br>conn.Open("DBQ=F://abc.mdb;DRIVER={Microsoft Access Driver (*.mdb)};"); <br>var rs = new ActiveXObject("ADODB.Recordset"); <br>var sql="update Student set stuName='" + userName + "' where Id=" + userId + ""; <br>conn.execute(sql); <br>conn.close(); <br>conn = null; <br>alert("修改成功"); <br>} <br></script>
| 编号 | 姓名 |
另外，JS也可以操作SQL Server数据库
数据库名为：MySchool，表名为Student，StudentId为int类型，自增列，studentName为学生姓名，为varchar类型。数据库用户名为sa，密码是ok，
立即学习“Java免费学习笔记（深入）”；
复制代码 代码如下:
<script> <br>var conn = new ActiveXObject("ADODB.Connection"); <br>conn.Open("Driver={SQL server};Server=.;DataBase=MySchool;UID=sa;Password=ok;");//打开数据库 <br>var rs = new ActiveXObject("ADODB.Recordset"); <br>var sql="select * from Student"; <br>rs.open(sql, conn); <br>var html=""; <br>while(!rs.EOF) <br>{ <br>html=html+rs.Fields("StudentId")+" "+rs.Fields("studentName")+"<br/>"; <br>rs.moveNext(); <br>} <br>document.write(html); <br>rs.close(); <br>rs = null; <br>conn.close(); <br>conn = null; <br></script>
