Contoh program connection dabase sqlite3 dengan java JDBC

import java.sql.Connection;

import java.sql.SQLException;
import java.sql.Statement;

import java.sql.ResultSet;
import java.sql.DriverManager;

public class simpel

{
    public static void main (String []args)
 throws ClassNotFoundException//bisa juga dengan throws Execption
 
  {
       
Class.forName ("org.sqlite.JDBC");
//mengakses class JDBC
       
Connection con = null;
        try
    

   {
            con = DriverManager.getConnection ("jdbc:sqlite:D:/isnu/db/coba.db");//membuat/mengakses coba.db
       
    Statement Stat = con.createStatement ();
          
 Stat.executeUpdate ("drop table if exists person");//executeUpdate untuk menjalankan sebuah command dan hasil tidak langsung tampil di window
          
 Stat.executeUpdate ("create table person (ID integer,Name String)");
            Stat.executeUpdate ("insert into person values (1,'Amel')");
          
 Stat.executeUpdate ("insert into person values (2,'Andi')");
          

 ResultSet rs = Stat.executeQuery ("Select * from person");//executeQuery menampilkan isi dari command yg dijalankan
         
  while (rs.next())
            {
                System.out.println ("name = "+rs.getString ("name"));
              
 System.out.println ("id = "+rs.getInt ("id"));
            }
        }
        catch (SQLException e)
        {
       
    System.err.println (e.getMessage ());
        }
    }
}