Membuat crud dengan javascript – Pada Artikel kali ini, kita akan membahas bagaimana membuat CRUD sederhana dengan menggunakan JavaScript. Saat sekarang ini sudah banyak kita lihat berbagai macam dan jenis Framework dari JavaScript ini, tergantung dari fungsi dan kegunaannya. Namun kali ini kita akan mencoba membuat CRUD tanpa Framework, Murni menggunakan JavaScript.
Untuk membuat CRUD biasanya kita akan membutuhkan data. berikut ide dan langkah pembuatannya :
- Kita akan Store data JSON, ke tabel dinamis yang akan kita buat menggunakan HTML.
- Tiap baris akan kita berikan aksi Tombol Delete, Update dan Add.
- Tiap tiap tombol akan tampil secara dinamis.
Contoh Kasus : Membuat Crud Data Buku.
pada aplikasi ini kita akan membuat penambahan data buku, hapus data buku, dan ubah data buku hanya mengggunakan JavaScript saja
Langsung Praktek Belajar Javascript!
berikut Script HTML, CSS dan JavaScriptnya…
<!DOCTYPE html>
<html>
<head>
<title>CRUD Application using JavaScript</title>
<style>
table
{
width: 100%;
}
table, th, td
{
border: solid 1px #DDD;
border-collapse: collapse;
padding: 2px 3px;
text-align: center;
}
input[type=’button’]
{
cursor: pointer;
border: none;
color: #FFF;
}
input[type=’text’], select
{
text-align: center;
border: solid 1px #CCC;
width: auto;
padding: 2px 3px;
}
</style>
</head>
<body>
<!–Show the app here.–>
<div id=“container” style=“width:700px;”></div>
</body>
<script>
var crudApp = new function () {
// An array of JSON objects with values.
this.myBooks = [
{ ID: ‘1’, Book_Name: ‘Computer Architecture’, Category: ‘Computers’, Price: 125.60 },
{ ID: ‘2’, Book_Name: ‘Asp.Net 4 Blue Book’, Category: ‘Programming’, Price: 56.00 },
{ ID: ‘3’, Book_Name: ‘Popular Science’, Category: ‘Science’, Price: 210.40 }
]
this.category = [‘Business’, ‘Computers’, ‘Programming’, ‘Science’];
this.col = [];
this.createTable = function () {
// Extract value for table header.
for (var i = 0; i < this.myBooks.length; i++) {
for (var key in this.myBooks[i]) {
if (this.col.indexOf(key) === -1) {
this.col.push(key);
}
}
}
// CREATE A TABLE.
var table = document.createElement(‘table’);
table.setAttribute(‘id’, ‘booksTable’); // Seet table id.
var tr = table.insertRow(-1); // Create a row (for header).
for (var h = 0; h < this.col.length; h++) {
// Add table header.
var th = document.createElement(‘th’);
th.innerHTML = this.col[h].replace(‘_’, ‘ ‘);
tr.appendChild(th);
}
// Add rows using JSON data.
for (var i = 0; i < this.myBooks.length; i++) {
tr = table.insertRow(-1); // Create a new row.
for (var j = 0; j < this.col.length; j++) {
var tabCell = tr.insertCell(-1);
tabCell.innerHTML = this.myBooks[i][this.col[j]];
}
// Dynamically create and add elements to table cells with events.
this.td = document.createElement(‘td’);
// *** CANCEL OPTION.
tr.appendChild(this.td);
var lblCancel = document.createElement(‘label’);
lblCancel.innerHTML = ‘
lblCancel.setAttribute(‘onclick’, ‘crudApp.Cancel(this)’);
lblCancel.setAttribute(‘style’, ‘display:none;’);
lblCancel.setAttribute(‘title’, ‘Cancel’);
lblCancel.setAttribute(‘id’, ‘lbl’ + i);
this.td.appendChild(lblCancel);
// *** SAVE.
tr.appendChild(this.td);
var btSave = document.createElement(‘input’);
btSave.setAttribute(‘type’, ‘button’); // SET ATTRIBUTES.
btSave.setAttribute(‘value’, ‘Save’);
btSave.setAttribute(‘id’, ‘Save’ + i);
btSave.setAttribute(‘style’, ‘display:none;’);
btSave.setAttribute(‘onclick’, ‘crudApp.Save(this)’); // ADD THE BUTTON’s ‘onclick’ EVENT.
this.td.appendChild(btSave);
// *** UPDATE.
tr.appendChild(this.td);
var btUpdate = document.createElement(‘input’);
btUpdate.setAttribute(‘type’, ‘button’); // SET ATTRIBUTES.
btUpdate.setAttribute(‘value’, ‘Update’);
btUpdate.setAttribute(‘id’, ‘Edit’ + i);
btUpdate.setAttribute(‘style’, ‘background-color:#44CCEB;’);
btUpdate.setAttribute(‘onclick’, ‘crudApp.Update(this)’); // ADD THE BUTTON’s ‘onclick’ EVENT.
this.td.appendChild(btUpdate);
// *** DELETE.
this.td = document.createElement(‘th’);
tr.appendChild(this.td);
var btDelete = document.createElement(‘input’);
btDelete.setAttribute(‘type’, ‘button’); // SET INPUT ATTRIBUTE.
btDelete.setAttribute(‘value’, ‘Delete’);
btDelete.setAttribute(‘style’, ‘background-color:#ED5650;’);
btDelete.setAttribute(‘onclick’, ‘crudApp.Delete(this)’); // ADD THE BUTTON’s ‘onclick’ EVENT.
this.td.appendChild(btDelete);
}
// ADD A ROW AT THE END WITH BLANK TEXTBOXES AND A DROPDOWN LIST (FOR NEW ENTRY).
tr = table.insertRow(-1); // CREATE THE LAST ROW.
for (var j = 0; j < this.col.length; j++) {
var newCell = tr.insertCell(-1);
if (j >= 1) {
if (j == 2) { // WE’LL ADD A DROPDOWN LIST AT THE SECOND COLUMN (FOR Category).
var select = document.createElement(‘select’); // CREATE AND ADD A DROPDOWN LIST.
select.innerHTML = ‘<option value=“”></option>‘;
for (k = 0; k < this.category.length; k++) {
select.innerHTML = select.innerHTML +
‘<option value=“‘ + this.category[k] + ‘”>‘ + this.category[k] + ‘</option>‘;
}
newCell.appendChild(select);
}
else {
var tBox = document.createElement(‘input’); // CREATE AND ADD A TEXTBOX.
tBox.setAttribute(‘type’, ‘text’);
tBox.setAttribute(‘value’, ”);
newCell.appendChild(tBox);
}
}
}
this.td = document.createElement(‘td’);
tr.appendChild(this.td);
var btNew = document.createElement(‘input’);
btNew.setAttribute(‘type’, ‘button’); // SET ATTRIBUTES.
btNew.setAttribute(‘value’, ‘Create’);
btNew.setAttribute(‘id’, ‘New’ + i);
btNew.setAttribute(‘style’, ‘background-color:#207DD1;’);
btNew.setAttribute(‘onclick’, ‘crudApp.CreateNew(this)’); // ADD THE BUTTON’s ‘onclick’ EVENT.
this.td.appendChild(btNew);
var div = document.getElementById(‘container’);
div.innerHTML = ”;
div.appendChild(table); // ADD THE TABLE TO THE WEB PAGE.
};
// ****** OPERATIONS START.
// CANCEL.
this.Cancel = function (oButton) {
// HIDE THIS BUTTON.
oButton.setAttribute(‘style’, ‘display:none; float:none;’);
var activeRow = oButton.parentNode.parentNode.rowIndex;
// HIDE THE SAVE BUTTON.
var btSave = document.getElementById(‘Save’ + (activeRow – 1));
btSave.setAttribute(‘style’, ‘display:none;’);
// SHOW THE UPDATE BUTTON AGAIN.
var btUpdate = document.getElementById(‘Edit’ + (activeRow – 1));
btUpdate.setAttribute(‘style’, ‘display:block; margin:0 auto; background-color:#44CCEB;’);
var tab = document.getElementById(‘booksTable’).rows[activeRow];
for (i = 0; i < this.col.length; i++) {
var td = tab.getElementsByTagName(“td”)[i];
td.innerHTML = this.myBooks[(activeRow – 1)][this.col[i]];
}
}
// EDIT DATA.
this.Update = function (oButton) {
var activeRow = oButton.parentNode.parentNode.rowIndex;
var tab = document.getElementById(‘booksTable’).rows[activeRow];
// SHOW A DROPDOWN LIST WITH A LIST OF CATEGORIES.
for (i = 1; i < 4; i++) {
if (i == 2) {
var td = tab.getElementsByTagName(“td”)[i];
var ele = document.createElement(‘select’); // DROPDOWN LIST.
ele.innerHTML = ‘<option value=“‘ + td.innerText + ‘”>‘ + td.innerText + ‘</option>‘;
for (k = 0; k < this.category.length; k++) {
ele.innerHTML = ele.innerHTML +
‘<option value=“‘ + this.category[k] + ‘”>‘ + this.category[k] + ‘</option>‘;
}
td.innerText = ”;
td.appendChild(ele);
}
else {
var td = tab.getElementsByTagName(“td”)[i];
var ele = document.createElement(‘input’); // TEXTBOX.
ele.setAttribute(‘type’, ‘text’);
ele.setAttribute(‘value’, td.innerText);
td.innerText = ”;
td.appendChild(ele);
}
}
var lblCancel = document.getElementById(‘lbl’ + (activeRow – 1));
lblCancel.setAttribute(‘style’, ‘cursor:pointer; display:block; width:20px; float:left; position: absolute;’);
var btSave = document.getElementById(‘Save’ + (activeRow – 1));
btSave.setAttribute(‘style’, ‘display:block; margin-left:30px; float:left; background-color:#2DBF64;’);
// HIDE THIS BUTTON.
oButton.setAttribute(‘style’, ‘display:none;’);
};
// DELETE DATA.
this.Delete = function (oButton) {
var activeRow = oButton.parentNode.parentNode.rowIndex;
this.myBooks.splice((activeRow – 1), 1); // DELETE THE ACTIVE ROW.
this.createTable(); // REFRESH THE TABLE.
};
// SAVE DATA.
this.Save = function (oButton) {
var activeRow = oButton.parentNode.parentNode.rowIndex;
var tab = document.getElementById(‘booksTable’).rows[activeRow];
// UPDATE myBooks ARRAY WITH VALUES.
for (i = 1; i < this.col.length; i++) {
var td = tab.getElementsByTagName(“td”)[i];
if (td.childNodes[0].getAttribute(‘type’) == ‘text’ || td.childNodes[0].tagName == ‘SELECT’) { // CHECK IF ELEMENT IS A TEXTBOX OR SELECT.
this.myBooks[(activeRow – 1)][this.col[i]] = td.childNodes[0].value; // SAVE THE VALUE.
}
}
this.createTable(); // REFRESH THE TABLE.
}
// CREATE NEW.
this.CreateNew = function (oButton) {
var activeRow = oButton.parentNode.parentNode.rowIndex;
var tab = document.getElementById(‘booksTable’).rows[activeRow];
var obj = {};
// ADD NEW VALUE TO myBooks ARRAY.
for (i = 1; i < this.col.length; i++) {
var td = tab.getElementsByTagName(“td”)[i];
if (td.childNodes[0].getAttribute(‘type’) == ‘text’ || td.childNodes[0].tagName == ‘SELECT’) { // CHECK IF ELEMENT IS A TEXTBOX OR SELECT.
var txtVal = td.childNodes[0].value;
if (txtVal != ”) {
obj[this.col[i]] = txtVal.trim();
}
else {
obj = ”;
alert(‘all fields are compulsory’);
break;
}
}
}
obj[this.col[0]] = this.myBooks.length + 1; // NEW ID.
if (Object.keys(obj).length > 0) { // CHECK IF OBJECT IS NOT EMPTY.
this.myBooks.push(obj); // PUSH (ADD) DATA TO THE JSON ARRAY.
this.createTable(); // REFRESH THE TABLE.
}
}
// ****** OPERATIONS END.
}
crudApp.createTable();
</script>
</html>
Perhatikan Script diatas, kita memiliki Global Function crudApp(), fungsinya adalah untuk menampilkan aplikasi CRUD javascript kita. pada Aplikasi ini kita menggunakan JSON yang memiliki Array object pada myBooks. :
this.myBooks = [ ];
this.createTable = function () { }
Baca Juga : Pengertian dan Sejarah Bahasa Pemrograman
Penutup
dengan menggunakan script diatas kita sudah bisa mengaplikasikan CRUD dengan menggunakan JavaScript tanpa menggunakan Framework sama sekali. Kali ini kita mencoba store data yang kita inputkan menggunakan JSON. lain kali akan kita coba bahas bagaimana langsung Store data yang kita punya ke dalam database.
Silahkan dicobakan… Selamat belajar…