js实现对数据库的增删查改

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= border=>

<tr bgcolor='#f4f4f4'>

<td>编号</td>

<td>姓名</td>

</tr>

<tr>

<td><input id="stuId" /></td>

<td><input id="stuName"/></td>

</tr>

</table>

<input name="" 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="" 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= border=>

<tr bgcolor='#f4f4f4'>

<td>编号</td>

<td>姓名</td>

</tr>

<tr>

<td><input id="stuId" /></td>

<td><input id="stuName"/></td>

</tr>

</table>

<input name="" 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实现对数据库的增删查改

最新文章

热门文章