Materi JDBC

download

Tugas JDBC

download

Materi Swing

download

Ini contoh program menggunakan database access.
(ini ga' pake driver, tapi sebenarnya ga disarankan. bisa mengganggu JVMnya. ga' disarankan juga pake access, mending pake MySQL ato Derby. lebih stabil pake java)

import java.sql.*;

public class JDBCTest01 {

public static void main(String[] args) {

Connection conn = null;

Statement stmt = null;

ResultSet rs = null;

try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // step1

} catch (ClassNotFoundException cnfe) {

System.err.println(cnfe);

} catch (Exception E) {

E.printStackTrace();

} // end catch

try {

conn = DriverManager.getConnection("jdbc:odbc:db1");

// step 2 and 3

stmt = conn.createStatement(); // step 4

rs = stmt.executeQuery("SELECT * FROM tabel02");

while (rs.next()) { // step 6

System.out.print(rs.getString("Nomer") + " ");

System.out.print(rs.getString("Judul") + " ");

System.out.print(rs.getString("Pengarang") + " ");

System.out.print(rs.getString("Penerbit") + " ");

System.out.print(rs.getString("harga") + " ");

System.out.println("Oke");

} // while

stmt.close();

conn.close();

} catch(SQLException sqle) {

System.err.println("SQLException : " + sqle.getMessage());

} // end cacth

}

}

Selamat mencoba dan selamat ngerjain tugasnya pak adi..
cheers.

teman - teman,,

karena ada beberapa masalah teknis yang ga bisa dihindari,,

maka tugas PBO yg kmaren yg sudah saya janjikan terpaksa DIBATALKAN..

maap ya..

matur tengkyu..

hehehehe..

regard.

Welcome to my blog..

let's think at the other side and the story will never end

Membagi apa yang bisa dibagi..
-maR-