JDBC ODBC bridge

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.

0 komentar: