Transcript Document 9652604

Matakuliah : M0864/Programming I
Tahun
: 2009
Database Operation
Pertemuan 12
Learning Outcomes
Pada akhir pertemuan ini, diharapkan mahasiswa akan
mampu:
– Mahasiswa dapat menerapkan penggunaan
konsep operasi database pada pemograman GUI
di Java.
Bina Nusantara
Outline Materi
•
•
•
•
Insert
Update
Delete
PreparedStatement
Bina Nusantara
• Memasukan data pada table Insert
di database
• Sintak SQL :
– Untuk insert ke semua field dalam 1 record:
insert into tableName values (value1, value2, …, valueN)
– Untuk insert ke beberapa field dalam 1 record :
insert into tableName (column1, cloumn2, …, columnN) values (value1, value2, …,
valueN)
Contoh :
insert into Enrollment values (‘0800755660’, ‘CS001’,’8/14/2009’,’A’)
binusianId
1100755660
courseId
CS001
dataRegisted
8/14/2009
grade
A
insert into Enrollment
(binusianId,
courseId, grade)
values (‘0800755660’,
‘CS001’,’A’)
binusianId
courseId
dataRegisted
grade
1100755660
CS001
A
• Mengubah data pada tableUpdate
di database
• Sintak SQL :
Update tableName set column1= newValue1, column2 =newNalue2 , …, columnN =
newValueN where [condition]
Jika tidak menggunakan where condition maka akan mengupdate 1 table tersebut.
Contoh :
Data sebelumnya :
binusianId
courseId
dataRegisted
grade
1100755660
CS001
8/14/2009
A
1100755660
CS002
8/14/2009
B
1100755660
CS003
8/14/2009
C
Update grade-nya menjadi B untuk binusian id : 1100755660 dan course id : cs001
update Enrollment set grade =‘B’ where binusianId =‘1100755660’ and courseId = ‘CS001’
binusianId
courseId
dataRegisted
grade
1100755660
CS001
8/14/2009
B
1100755660
CS002
8/14/2009
B
1100755660
CS003
8/14/2009
C
Delete
• Mengubah data pada table di database
• Sintak SQL :
delete from tableName where [condition]
binusianId
Contoh :
Data sebelumnya :
courseId
dataRegisted
grade
1100755660
CS001
8/14/2009
A
1100755660
CS002
8/14/2009
B
1100755660
CS003
8/14/2009
C
Delete data untuk binusian id : 1100755660 dan course id : cs001
delete Enrollment where binusianId =‘1100755660’ and courseId = ‘CS001’
binusianId
courseId
dataRegisted
grade
1100755660
CS002
8/14/2009
B
1100755660
CS003
8/14/2009
C
Referensi
• Introduction to Java Programming. 7ed. Liang. 2009. Chapter 37,
hal 1261
•
Introduction to SQL
 http://www.w3schools.com/SQL/sql_intro.asp
•
Java Tutorial - Insert Update Delete
 http://www.java2s.com/Tutorial/Java/0340__Database/0500__In
sert-Update-Delete.htm
•
Using Prepared Statement
 http://java.sun.com/docs/books/tutorial/jdbc/basics/prepared.html
Bina Nusantara