Ads 468x60px

wibiya widget

Labels

Kamis, 12 Januari 2012

CONTOH SEDERHANA MENAMPILKAN ISI DARI DATABASE

import java.sql.*;

public class tes{
public static void main (String [] args) throws Exception {
Class.forName("org.sqlite.JDBC");
Connection conn = DriverManager.getConnection("jdbc:sqlite:datairfaan.db");
Statement stat  = conn.createStatement();
    ResultSet rs = stat.executeQuery("select * from mahasiswa; ");
    System.out.println("NPM\t\tNama \t\t\t Alamat\t\tjurusan");
    while (rs.next()) {
        System.out.print(rs.getString("npm")+"\t "+rs.getString("nama")+"\t\t"+rs.getString("alamat"));
        System.out.println("\t\t"+ rs.getString("jurusan"));
    }
    rs.close();
    conn.close();
   }
}