快捷導(dǎo)航

JS操作數(shù)據(jù)庫(kù)的實(shí)例代碼

更新時(shí)間：2013年10月17日 14:53:39 作者：

這篇文章介紹了JS操作數(shù)據(jù)庫(kù)的實(shí)例代碼，有需要的朋友可以參考一下

一、創(chuàng)建SQL Server數(shù)據(jù)庫(kù)
建庫(kù)：test
建表：

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50520
Source Host           : localhost:3306
Source Database       : mo

Target Server Type    : MYSQL
Target Server Version : 50520
File Encoding         : 65001

Date: 2013-10-17 12:00:56
*/

-- ----------------------------
-- Table structure for [user]
-- ----------------------------
USE test
GO

DROP TABLE [user];
CREATE TABLE [user] (
id bigint NOT NULL PRIMARY KEY IDENTITY(1000, 1),
create_date datetime DEFAULT NULL,
edit_date datetime DEFAULT NULL,
is_delete int DEFAULT NULL,
[name] varchar(255) DEFAULT NULL,
sex varchar(255) DEFAULT NULL,
age int DEFAULT NULL
);

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO [user] VALUES ('2013-04-02 16:01:00', '2013-04-02 16:01:17', '0', 'Oppo', '男', '20');
INSERT INTO [user] VALUES ('2013-04-02 16:01:02', '2013-04-02 16:01:17', '0', 'Mini', '女', '18');
INSERT INTO [user] VALUES ('2013-04-02 16:01:04', '2013-04-02 16:01:17', '0', 'Kina', '女', '18');
INSERT INTO [user] VALUES ('2013-04-02 16:01:06', '2013-04-02 16:01:17', '0', 'Lora', '男', '19');
INSERT INTO [user] VALUES ('2013-04-02 16:01:08', '2013-04-02 16:01:17', '0', '榕Sir', '女', '18');
INSERT INTO [user] VALUES ('2013-04-02 16:01:10', '2013-04-02 16:01:17', '0', '兼容', '女', '19');
INSERT INTO [user] VALUES ('2013-04-02 16:01:13', '2013-04-02 16:01:17', '0', 'Sir云', '男', '18');
INSERT INTO [user] VALUES ('2013-04-02 16:01:17', '2013-04-02 16:01:17', '0', '明白了', '男', '18');
INSERT INTO [user] VALUES ('2013-04-02 16:37:00', '2013-04-02 16:37:00', '0', 'Guro Go Sir', '女', '19');

二、在頁(yè)面JS代碼操作數(shù)據(jù)庫(kù)

復(fù)制代碼代碼如下:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>JS操作數(shù)據(jù)庫(kù)</title>
<script language="javascript" type="text/javascript">
var conn, rs;

/*獲取數(shù)據(jù)庫(kù)連接*/
function getConnection() {
    conn = new ActiveXObject("ADODB.Connection");
    // 1.JavaScript操作數(shù)據(jù)庫(kù)JS操作Access數(shù)據(jù)庫(kù)
    // 在F盤(pán)有文件abc.mdf，表名為user，一共2個(gè)字段，id數(shù)字類型主鍵，name文本類型
    // conn.Open("DBQ=f://abc.mdb;DRIVER={Microsoft Access Driver (*.mdb)};");

    // 2.JavaScript操作數(shù)據(jù)庫(kù)JS操作SQL Server數(shù)據(jù)庫(kù)
    // 數(shù)據(jù)庫(kù)名為：test，表名為user，id為int類型，自增列，name為用戶名，為varchar類型；數(shù)據(jù)庫(kù)用戶名為sa，密碼是sasa。
    conn.Open("Driver={SQL Server};Server=.;DataBase=test;UID=sa;Password=sasa");       //打開(kāi)數(shù)據(jù)庫(kù)
    return conn;
}

/*執(zhí)行增刪改的方法*/
function executeUpdate(sql) {
    getConnection();
    try {
        conn.execute(sql);
        return true;
    } catch (e) {
        document.write(e.description);
    } finally {
        closeAll();
    }
    return false;
}

/*執(zhí)行查詢的方法*/
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();
    }
}

/*關(guān)閉所有資源*/
function closeAll() {
    if(rs != null) {
        rs.close();
        rs = null;
    }
    if(conn != null) {
        conn.close();
        conn = null;
    }
}

// 增
// executeUpdate("INSERT INTO [user](create_date, edit_date, is_delete, [name], sex, age) VALUES ('2013-10-17 12:00:00', '2013-10-17 12:00:00', 0, '空', '男', 20)");
// 刪
// executeUpdate("DELETE FROM [user] WHERE id = 1009");
// 改
// executeUpdate("UPDATE [user] SET sex = '女', age = 18 WHERE id = 1009");
// 查
executeQuery("select * from [user]");
</script>
</head>

<body>
</body>
</html>

您可能感興趣的文章: