var conn,rs;
//获取数据库连接
function getConnection() {
conn = new ActiveXObject("ADODB.Connection");
// 数据库名为:test,表名为user,id为int类型,自增列,name为用户名,为varchar类型;数据库用户名为root,密码是root。
conn.Open("Driver={MySQL ODBC 5.2w Driver};Server=localhost;Database=online_oj;User=root; Password=root;Option=3;Port=3306"); //打开数据库
return conn;
}
/*执行增删改的方法*/
function executeUpdate(sql) {
getConnection();
try {
conn.execute(sql);
return true;
} catch (e) {
document.write(e.description);
} finally {
closeAll();
}
return false;
}
/*执行查询的方法*/
function executeQuery(sql) {
getConnection();
try {
rs = new ActiveXObject("ADODB.Recordset");
rs.open(sql, conn);
var html = "";
while(!rs.EOF) {
html = html + rs.Fields("id") + " " + rs.Fields("name")+"<br/>";
rs.moveNext();
}
document.write(html);
} catch (e) {
document.write(e.description);
} finally {
closeAll();
}
}
/*关闭所有资源*/
function closeAll() {
if(rs != null) {
rs.close();
rs = null;
}
if(conn != null) {
conn.close();
conn = null;
}
}