JS连接sqlserver【MyCode】:
<script language="javascript">
function logn() { //函数功能仅仅是判断输入的用户名和密码是否正确,没有考虑sql注入等
var conn = new ActiveXObject("ADODB.Connection");
conn.Open("Provider=SQLOLEDB.1; Data Source=127.1.1.0; User ID=sa; " + "Password=123456; Initial Catalog=database1");
var rs = new ActiveXObject("ADODB.Recordset");
var oUserName = document.getElementById("username");
var oPwd = document.getElementById("pwd");
var sql = "select pwd from yonghu where name='" + oUserName.value + "'";
//alert(sql);
rs.open(sql, conn);
if (!rs.EOF && rs(0) == oPwd.value)
alert(rs(0)); //取出第一个来
else
alert("用户名或密码错误!")
rs.close();
rs = null;
conn.close();
conn = null;
}
</script>
以下内容参考自:http://blog.csdn.net/yxp200401/article/details/7738845
1.查询
- <html>
- <head>
- <title>表格显示数据表记录</title>
- </head>
- <body>
- <h2>表格显示数据表记录</h2>
- <hr>
- <mce:script language="JavaScript"><!--
- // 创建数据库对象
- var objdbConn = new ActiveXObject("ADODB.Connection");
- // DSN字符串
- var strdsn = "Driver={SQL Server};SERVER=.;UID=sa;PWD=haiweisoft;DATABASE=PointCard";
- // 打开数据源
- objdbConn.Open(strdsn);
- // 执行SQL的数据库查询
- var objrs = objdbConn.Execute("SELECT * FROM news");//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(); // 关闭数据库链接
- // --></mce:script>
- </body>
- </html>
2.增加操作
- <HTML>
- <HEAD>
- <TITLE>增加操作</TITLE>
- <mce: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();
- }
- // --></mce: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="添加" οnclick="addUser(stuId.value,stuName.value)"/>
- </BODY>
- </HTML>
3.删除操作
- <HTML>
- <HEAD>
- <TITLE>删除操作</TITLE>
- <mce: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("修改成功");
- }
- // --></mce:script>
- </HEAD>
- <BODY>
- <input name="1" type="button" value="删除" οnclick="delStu(1)"/>
- </BODY>
- </HTML>
4.修改操作
- <HTML>
- <HEAD>
- <TITLE>修改操作 </TITLE>
- </HEAD>
- <mce:script type="text/javascript"><!--
- 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("修改成功");
- }
- // --></mce: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="修改" οnclick="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>