Menambahkan kemampuan untuk menghubungkan database ke aplikasi Express hanyalah masalah memuat Node.js yang sesuai. js driver untuk database di aplikasi Anda. Dokumen ini secara singkat menjelaskan cara menambahkan dan menggunakan beberapa Node.js yang paling populer. modul js untuk sistem database di aplikasi Express Anda
Driver database ini adalah di antara banyak driver yang tersedia. Untuk opsi lain, cari di situs npm
Cassandra
Modul. cassandra-driver
Instalasi
$ npm install cassandra-driverContoh
const cassandra = require('cassandra-driver') const client = new cassandra.Client({ contactPoints: ['localhost'] }) client.execute('select key from system.local', (err, result) => { if (err) throw err console.log(result.rows[0]) }) _Dasar sofa
Modul. sofanode
Instalasi
$ npm install couchbaseContoh
const couchbase = require('couchbase') const bucket = (new couchbase.Cluster('//localhost:8091')).openBucket('bucketName') // add a document to a bucket bucket.insert('document-key', { name: 'Matt', shoeSize: 13 }, (err, result) => { if (err) { console.log(err) } else { console.log(result) } }) // get all documents with shoe size 13 const n1ql = 'SELECT d.* FROM `bucketName` d WHERE shoeSize = $1' const query = N1qlQuery.fromString(n1ql) bucket.query(query, [13], (err, result) => { if (err) { console.log(err) } else { console.log(result) } })CouchDB
Modul. nano
Instalasi
$ npm install nano _Contoh
const nano = require('nano')('//localhost:5984') nano.db.create('books') const books = nano.db.use('books') // Insert a book document in the books database books.insert({ name: 'The Art of war' }, null, (err, body) => { if (err) { console.log(err) } else { console.log(body) } }) // Get a list of all books books.list((err, body) => { if (err) { console.log(err) } else { console.log(body.rows) } })LevelDB
Modul. naik tingkat
Instalasi
$ npm install level levelup leveldown _Contoh
const levelup = require('levelup') const db = levelup('./mydb') db.put('name', 'LevelUP', (err) => { if (err) return console.log('Ooops!', err) db.get('name', (err, value) => { if (err) return console.log('Ooops!', err) console.log(`name=${value}`) }) })MySQL
Modul. mysql
Instalasi
$ npm install mysql _Contoh
const mysql = require('mysql') const connection = mysql.createConnection({ host: 'localhost', user: 'dbuser', password: 's3kreee7', database: 'my_db' }) connection.connect() connection.query('SELECT 1 + 1 AS solution', (err, rows, fields) => { if (err) throw err console.log('The solution is: ', rows[0].solution) }) connection.end() _MongoDB
Modul. mongodb
Instalasi
const cassandra = require('cassandra-driver') const client = new cassandra.Client({ contactPoints: ['localhost'] }) client.execute('select key from system.local', (err, result) => { if (err) throw err console.log(result.rows[0]) }) _0Contoh (v2. *)
const cassandra = require('cassandra-driver') const client = new cassandra.Client({ contactPoints: ['localhost'] }) client.execute('select key from system.local', (err, result) => { if (err) throw err console.log(result.rows[0]) }) _1Contoh (v3. *)
const cassandra = require('cassandra-driver') const client = new cassandra.Client({ contactPoints: ['localhost'] }) client.execute('select key from system.local', (err, result) => { if (err) throw err console.log(result.rows[0]) }) _2Jika Anda menginginkan driver model objek untuk MongoDB, lihat Mongoose
Neo4j
Modul. neo4j-driver
Instalasi
const cassandra = require('cassandra-driver') const client = new cassandra.Client({ contactPoints: ['localhost'] }) client.execute('select key from system.local', (err, result) => { if (err) throw err console.log(result.rows[0]) }) _3Contoh
const cassandra = require('cassandra-driver') const client = new cassandra.Client({ contactPoints: ['localhost'] }) client.execute('select key from system.local', (err, result) => { if (err) throw err console.log(result.rows[0]) }) _4Peramal
Modul. oracledb
Instalasi
CATATAN.
const cassandra = require('cassandra-driver') const client = new cassandra.Client({ contactPoints: ['localhost'] }) client.execute('select key from system.local', (err, result) => { if (err) throw err console.log(result.rows[0]) }) _5Contoh
const cassandra = require('cassandra-driver') const client = new cassandra.Client({ contactPoints: ['localhost'] }) client.execute('select key from system.local', (err, result) => { if (err) throw err console.log(result.rows[0]) }) _6PostgreSQL
Modul. pg-janji
Instalasi
const cassandra = require('cassandra-driver') const client = new cassandra.Client({ contactPoints: ['localhost'] }) client.execute('select key from system.local', (err, result) => { if (err) throw err console.log(result.rows[0]) }) _7Contoh
const cassandra = require('cassandra-driver') const client = new cassandra.Client({ contactPoints: ['localhost'] }) client.execute('select key from system.local', (err, result) => { if (err) throw err console.log(result.rows[0]) }) _8Redis
Modul. redis
Instalasi
const cassandra = require('cassandra-driver') const client = new cassandra.Client({ contactPoints: ['localhost'] }) client.execute('select key from system.local', (err, result) => { if (err) throw err console.log(result.rows[0]) }) _9Contoh
$ npm install couchbase 0Server SQL
Modul. membosankan
Instalasi
$ npm install couchbase 1Contoh
$ npm install couchbase 2SQLite
Modul. sqlite3
Instalasi
$ npm install couchbase _3Contoh
$ npm install couchbase _4Pencarian elastis
Modul. elasticsearch
Instalasi
$ npm install couchbase 5Contoh
$ npm install couchbase 6Bisakah Anda terhubung ke database menggunakan JavaScript?
Tidak ada cara umum untuk terhubung ke database SQL Server dari klien JavaScript , setiap browser memiliki API dan paketnya sendiri untuk terhubung ke SQL Server.
Bagaimana cara terhubung ke database SQL menggunakan JavaScript?
var connection = new ActiveXObject("ADODB. Connection") ; var connectionstring="Data Source=;Initial Catalog=;User ID=;Password=;Provider=SQLOLEDB"; connection. Open(connectionstring); var rs = new ActiveXObject("ADODB. Recordset"); rs.
Bagaimana cara membuat koneksi database di JavaScript?
Instal Driver MySQL .
C. \Users\Nama Anda>npm instal mysql
var mysql = membutuhkan('mysql');
Jalankan "demo_db_connection. js"C. \Users\Nama Anda>node demo_db_connection. js
Terhubung
menipu. connect(function(err) { if (err) throw err; console. log("Terhubung. " ); kon. query(sql, function (err, result) { if (err) throw err;
Bagaimana cara mendapatkan data dari database ke JavaScript?
$(dokumen). .
$('#dataTabel'). .
"ajax". {
"url". "/Beranda/Dapatkan Data",
"Tipe". "DAPATKAN",
"tipe data". "json"