Belajar Java Hari ini :)
Syntax Connetion ke Database
|
//membuat objek
konek yang bertipe conection
Connection
Konek=DriverManager.getConnection("jdbc:mysql://localhost/latihan","root","");
System.out.println("Koneksi
Berhasil");
|
Syntax
Insert Database
|
Statement status = Konek.createStatement();
status.executeUpdate("INSERT INTO `siswa`
(`nis`, `nama`, `jurusan`, `alamat`) VALUES ('3',
'DIAN INDRIANI', 'RPL', 'Bandung')");
System.out.println("Input Data Behasil");
|
Syntax
Delete & Update
|
status.executeUpdate("DELETE FROM 'siswa'
WHERE nis=2");
status.executeUpdate("UPDATE
`siswa` SET nama = 'INDRI' WHERE nis='3'");
|
Syntax
Select
|
ResultSet res = status.executeQuery("SELECT *
FROM siswa");
while (res.next()){
Integer
nis = res.getInt("nis");
String
nama = res.getString("nama");
String
jurusan = res.getString("jurusan");
String
alamat = res.getString("alamat");
System.out.println("NIS :
"+nis);
System.out.println("NAMA :
"+nama);
System.out.println("JURUSAN :
"+jurusan);
System.out.println("ALAMAT :
"+alamat);
System.out.println("..........");
}
|
*With Pak Ali Nasirudin :)
Reply to this post
Posting Komentar