Nodejs: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
Line 3: | Line 3: | ||
npm i -D @types/cors @types/express @types/ip types/mysql2 nodemon ts-node typescript | npm i -D @types/cors @types/express @types/ip types/mysql2 nodemon ts-node typescript | ||
Baru | |||
npm install express mysql body-parser | |||
const express = require('express'); | |||
const mysql = require('mysql'); | |||
const bodyParser = require('body-parser'); | |||
const app = express(); | |||
const port = process.env.PORT || 3000; | |||
app.use(bodyParser.json()); | |||
// Konfigurasi koneksi ke database MySQL | |||
const db = mysql.createConnection({ | |||
host: 'localhost', | |||
user: 'username', | |||
password: 'password', | |||
database: 'nama_database', | |||
}); | |||
// Terhubung ke database | |||
db.connect((err) => { | |||
if (err) { | |||
console.error('Koneksi ke database gagal: ' + err.stack); | |||
return; | |||
} | |||
console.log('Terhubung ke database dengan ID ' + db.threadId); | |||
}); | |||
// Contoh endpoint untuk mengambil data dari database | |||
app.get('/data', (req, res) => { | |||
const query = 'SELECT * FROM nama_tabel'; | |||
db.query(query, (err, result) => { | |||
if (err) { | |||
console.error('Error dalam pengambilan data: ' + err); | |||
res.status(500).json({ error: 'Gagal mengambil data' }); | |||
return; | |||
} | |||
res.json(result); | |||
}); | |||
}); | |||
// Mulai server | |||
app.listen(port, () => { | |||
console.log(`Server berjalan pada port ${port}`); | |||
}); | |||
== Referensi == | == Referensi == | ||
https://www.youtube.com/watch?v=aUMGAFE5pPM&t=4535s | https://www.youtube.com/watch?v=aUMGAFE5pPM&t=4535s |
Revision as of 07:19, 29 September 2023
mkdir nodejsapi
cd nodejsapi
npm i -D @types/cors @types/express @types/ip types/mysql2 nodemon ts-node typescript
Baru
npm install express mysql body-parser
const express = require('express'); const mysql = require('mysql'); const bodyParser = require('body-parser');
const app = express(); const port = process.env.PORT || 3000;
app.use(bodyParser.json());
// Konfigurasi koneksi ke database MySQL const db = mysql.createConnection({
host: 'localhost', user: 'username', password: 'password', database: 'nama_database',
});
// Terhubung ke database db.connect((err) => {
if (err) { console.error('Koneksi ke database gagal: ' + err.stack); return; } console.log('Terhubung ke database dengan ID ' + db.threadId);
});
// Contoh endpoint untuk mengambil data dari database app.get('/data', (req, res) => {
const query = 'SELECT * FROM nama_tabel'; db.query(query, (err, result) => { if (err) { console.error('Error dalam pengambilan data: ' + err); res.status(500).json({ error: 'Gagal mengambil data' }); return; } res.json(result); });
});
// Mulai server app.listen(port, () => {
console.log(`Server berjalan pada port ${port}`);
});