以下是对于SqlServer数据库的操作
查询:
<span style="font-size:18px;"><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></span><span style="font-size:24px;"> </span>
/*操作数据库*/
var conn, rs;
/*获取数据库连接*/
function getConnection() {
conn = new ActiveXObject("ADODB.Connection");
// 1.JavaScript操作数据库JS操作Access数据库
// 在F盘有文件abc.mdf,表名为user,一共2个字段,id数字类型主键,name文本类型
// conn.Open("DBQ=f://abc.mdb;DRIVER={Microsoft Access Driver (*.mdb)};");
// 2.JavaScript操作数据库JS操作SQL Server数据库
// 数据库名为:test,表名为user,id为int类型,自增列,name为用户名,为varchar类型;数据库用户名为sa,密码是sasa。
conn.Open("Driver={SQL Server};Server=.;DataBase=combook;UID=sa;Password=123"); //打开数据库
return conn;
}
//获取选中那个的checkbox行的某一列值
function getCheckBoxId(n) {
var ids = document.getElementsByName("checkbox");
var temp = "";
//var ids = chkId.split(",");
for (var i = 0; i < ids.length; i++) {
if (ids[i].checked == true) {
var tr = ids[i].parentElement.parentElement;
if (temp == "") {
temp = tr.cells[n].innerText;
}
else {
temp += "," + tr.cells[n].innerText;
}
}
}
return temp;
//alert(temp);
}
/*执行查询的方法*/
function executeQuery(name) {
getConnection();
var sql = "select * from groups where groupname='"+name+"'";
try {
rs = new ActiveXObject("ADODB.Recordset");
rs.open(sql, conn);
if (!rs.EOF) {
return true;
}
else{
return false;
}
} catch (e) {
document.write(e.description);
closeAll();
}
}
/*执行增删改的方法*/
function executeDeleteGroup() {
getConnection();
var sql = "update ... set ... ";
try {
conn.execute(sql);
return true;
} catch (e) {
document.write(e.description);
} finally {
closeAll();
}
return false;
}
/*关闭所有资源*/
function closeAll() {
if (rs != null) {
rs.close();
rs = null;
}
if (conn != null) {
conn.close();
conn = null;
}
}