SQL table
CREATE TABLE [dbo].[test]( [id] [int] NOT NULL, [name] [nchar](10) NULL, [job] [nchar](10) NULL )
test.html
<html> <head> <title>introduction to the DOM</title> <script type="text/javascript" src="test.js"></script> </head> <body> <input name="myid" value="01"/> <input name="myname" value="name01"/> <input name="myjob" value="job01"/> <input id="select" type="button" value="select" onclick="connectDb();" /> <input id="insert" type="button" value="insert" onclick="insertItem(myid.value, myname.value, myjob.value);" /> <input id="update" type="button" value="update" onclick="updateItem(myid.value, myname.value, myjob.value);" /> <input id="delete" type="button" value="delete" onclick="deleteItem(myid.value);" /> </body> </html>
test.js
// function connectDb() { var objdbConn = new ActiveXObject("ADODB.Connection"); var strdsn = "Driver={SQL Server}; SERVER=RICO123\\ITWO; DATABASE=iTWO3; Trusted_Connection = SSPI"; objdbConn.ConnectionString = strdsn; objdbConn.Open(); var objrs = objdbConn.Execute("SELECT * FROM [dbo].[test]"); //Execute也可以执行增删改 var fdCount = objrs.Fields.Count - 1; if (!objrs.EOF) { document.write("<table border=1><tr>"); for (var i = 0; i <= fdCount; i++) document.write("<td><b>" + objrs.Fields(i).Name + "</b></td>"); document.write("</tr>"); while (!objrs.EOF) { document.write("<tr>"); for (i = 0; i <= fdCount; i++) document.write("<td valign='top'>" + objrs.Fields(i).Value + "</td>"); document.write("</tr>"); objrs.moveNext(); } document.write("</table>"); } else document.write("数据库内没有记录!<br>"); objrs.Close(); objdbConn.Close(); } function insertItem(idv, namev, jobv) { var conn = new ActiveXObject("ADODB.Connection"); var strdsn = "Driver={SQL Server}; SERVER=RICO123\\ITWO; DATABASE=iTWO3; Trusted_Connection = SSPI"; conn.connectionString = strdsn; try { conn.Open(); } catch (e) { alert(e.message); } var sql = "INSERT INTO test(id, name, job) VALUES(" + idv + ", '" + namev + "', '" + jobv + "')"; try { conn.execute(sql); alert("successfully inserted !"); } catch (e) { alert(e.description); } } function updateItem(idv, namev, jobv) { var conn = new ActiveXObject("ADODB.Connection"); var strdsn = "Driver={SQL Server}; SERVER=RICO123\\ITWO; DATABASE=iTWO3; Trusted_Connection = SSPI"; conn.connectionString = strdsn; try { conn.Open(); } catch (e) { alert(e.message); } var sql = "UPDATE test SET name='" +namev+ "', job='" +namev+"' WHERE id='" +idv+ "'"; try { conn.execute(sql); alert("successfully updated !"); } catch (e) { alert(e.description); } } function deleteItem(idv) { var conn = new ActiveXObject("ADODB.Connection"); var strdsn = "Driver={SQL Server}; SERVER=RICO123\\ITWO; DATABASE=iTWO3; Trusted_Connection = SSPI"; conn.connectionString = strdsn; try { conn.Open(); } catch (e) { alert(e.message); } var sql = "DELETE test WHERE id='" + idv + "'";; try { conn.execute(sql); alert("successfully deleted !"); } catch (e) { alert(e.description); } }