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();
}
}