时间:2021-07-01 10:21:17 帮助过:24人阅读
JavaScript操作数据库JS操作Access数据库,跟其他语言操作差不多,总结了一下习惯代码,仅供参考学习。
现在在F盘有文件abc.mdf,表名为Student,一共2个字段,Id数字类型主键,stuName文本类型,现对该表进行增删改查的操作:
1.查询
代码如下:
<HTML> <HEAD> <TITLE>数据查询</TITLE> <Script > var conn = new ActiveXObject("ADODB.Connection"); conn.Open("DBQ=f://abc.mdb;DRIVER={Microsoft Access Driver (*.mdb)};"); var rs = new ActiveXObject("ADODB.Recordset"); var sql="select * from Student"; rs.open(sql, conn); var html=""; while(!rs.EOF) { html=html+rs.Fields("Id")+" "+rs.Fields("stuName"); rs.moveNext(); } document.write(html); rs.close(); rs = null; conn.close(); conn = null; </script> </HEAD> <BODY> </BODY> </HTML>
2.增加操作
代码如下:
<HTML> <HEAD> <TITLE>增加操作</TITLE> <script language="javascript"> function addUser(id,stuName) { //用 JavaScript 写服务器端连接数据库的代码示例 var conn = new ActiveXObject("ADODB.Connection"); conn.Open("DBQ=F://abc.mdb;DRIVER={Microsoft Access Driver (*.mdb)};"); var sql="insert into Student(ID,stuName) values("+id+",'"+stuName+"')"; try{ conn.execute(sql); alert("添加成功"); } catch(e){ document.write(e.description); alert("添加失败~~~"); } conn.close(); } </script> </HEAD> <BODY> <table width=100 border=1> <tr bgcolor='#f4f4f4'> <td>编号</td> <td>姓名</td> </tr> <tr> <td><input id="stuId" /></td> <td><input id="stuName"/></td> </tr> </table> <input name="1" type="button" value="添加" onclick="addUser(stuId.value,stuName.value)"/> </BODY> </HTML>
3.删除操作
代码如下:
<HTML> <HEAD> <TITLE>删除操作</TITLE> <script language="javascript"> function delStu(id) { var conn = new ActiveXObject("ADODB.Connection"); conn.Open("DBQ=F://abc.mdb;DRIVER={Microsoft Access Driver (*.mdb)};"); var sql="delete from Student where Id=2"; conn.execute(sql); conn.close(); conn = null; alert("修改成功"); } </script> </HEAD> <BODY> <input name="1" type="button" value="删除" onclick="delStu(1)"/> </BODY> </HTML>
4.修改操作
代码如下:
<HTML> <HEAD> <TITLE>修改操作 </TITLE> </HEAD> <script> function updateUser(userId,userName) { var conn = new ActiveXObject("ADODB.Connection"); conn.Open("DBQ=F://abc.mdb;DRIVER={Microsoft Access Driver (*.mdb)};"); var rs = new ActiveXObject("ADODB.Recordset"); var sql="update Student set stuName='" + userName + "' where Id=" + userId + ""; conn.execute(sql); conn.close(); conn = null; alert("修改成功"); } </script> <BODY> <table width=100 border=1> <tr bgcolor='#f4f4f4'> <td>编号</td> <td>姓名</td> </tr> <tr> <td><input id="stuId" /></td> <td><input id="stuName"/></td> </tr> </table> <input name="1" type="button" value="修改" onclick="updateUser(stuId.value,stuName.value)"/> </BODY> </HTML>
另外,JS也可以操作SQL Server数据库
数据库名为:MySchool,表名为Student,StudentId为int类型,自增列,studentName为学生姓名,为varchar类型。数据库用户名为sa,密码是ok,
代码如下:
<HTML> <HEAD> <TITLE>SQL数据查询</TITLE> <Script > var conn = new ActiveXObject("ADODB.Connection"); conn.Open("Driver={SQL server};Server=.;DataBase=MySchool;UID=sa;Password=ok;");//打开数据库 var rs = new ActiveXObject("ADODB.Recordset"); var sql="select * from Student"; rs.open(sql, conn); var html=""; while(!rs.EOF) { html=html+rs.Fields("StudentId")+" "+rs.Fields("studentName")+"<br/>"; rs.moveNext(); } document.write(html); rs.close(); rs = null; conn.close(); conn = null; </script> </HEAD> <BODY> </BODY> </HTML>
以上就是js怎么对数据库进行增删改查的详细内容,更多请关注Gxl网其它相关文章!