JavaScriptOperation database JS operates Access database, which is similar to other language operations. I have summarized the custom code. Friends who need it can refer to
JavaScript operation database JS operates Access database, follow The operations in other languages are similar. I have summarized the custom codes for reference only.
Now there is a file abc.mdf on the F drive, the table name is Student, there are 2 fields in total, Id numeric type primary key, stuName text type, now add, delete, modify and check the table:
1. Query
The code is as follows:
<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. Add operation
The code is as follows:
<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.Delete operation
Copy code The code is as follows:
<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. Modification operation
The code is as follows:
<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>
In addition, JS can also operate SQL Server database
The database name is: MySchool, the table name is Student, StudentId is int type, auto-increment column, studentName is the student name, which is varchar type. The database user name is sa and the password is ok.
The code is as follows:
<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>
The above is the detailed content of How to add, delete, modify and check the database in js. For more information, please follow other related articles on the PHP Chinese website!

去掉重复并排序的方法:1、使用“Array.from(new Set(arr))”或者“[…new Set(arr)]”语句,去掉数组中的重复元素,返回去重后的新数组;2、利用sort()对去重数组进行排序,语法“去重数组.sort()”。

本篇文章给大家带来了关于JavaScript的相关知识,其中主要介绍了关于Symbol类型、隐藏属性及全局注册表的相关问题,包括了Symbol类型的描述、Symbol不会隐式转字符串等问题,下面一起来看一下,希望对大家有帮助。

怎么制作文字轮播与图片轮播?大家第一想到的是不是利用js,其实利用纯CSS也能实现文字轮播与图片轮播,下面来看看实现方法,希望对大家有所帮助!

本篇文章给大家带来了关于JavaScript的相关知识,其中主要介绍了关于对象的构造函数和new操作符,构造函数是所有对象的成员方法中,最早被调用的那个,下面一起来看一下吧,希望对大家有帮助。

方法:1、利用“点击元素对象.unbind("click");”方法,该方法可以移除被选元素的事件处理程序;2、利用“点击元素对象.off("click");”方法,该方法可以移除通过on()方法添加的事件处理程序。

本篇文章给大家带来了关于JavaScript的相关知识,其中主要介绍了关于面向对象的相关问题,包括了属性描述符、数据描述符、存取描述符等等内容,下面一起来看一下,希望对大家有帮助。

foreach不是es6的方法。foreach是es3中一个遍历数组的方法,可以调用数组的每个元素,并将元素传给回调函数进行处理,语法“array.forEach(function(当前元素,索引,数组){...})”;该方法不处理空数组。

本篇文章给大家带来了关于JavaScript的相关知识,其中主要介绍了关于BOM操作的相关问题,包括了window对象的常见事件、JavaScript执行机制等等相关内容,下面一起来看一下,希望对大家有帮助。


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Zend Studio 13.0.1
Powerful PHP integrated development environment

SublimeText3 English version
Recommended: Win version, supports code prompts!

Dreamweaver Mac version
Visual web development tools

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools