nih

import java.sql.*;
import java.io.*;
//import java.sql.Connection;
//import java.sql.DriverManager;
//import java.sql.SQLException;

public class konek_db
{
    public static void main (String [] args)
    throws Exception
    {
        String i; int p;

        BufferedReader br=new BufferedReader (new InputStreamReader (System.in));

        Class.forName("org.sqlite.JDBC");
        Connection conn = null;
        conn =    DriverManager.getConnection ("jdbc:sqlite:folder_produk.db");

        Statement stm = conn.createStatement();

        System.out.print ("==========Menu Utama============\n");

        System.out.print ("==========1.Lihat Data==========\n");

        System.out.print ("==========2.Tambah Data=========\n");

        System.out.print ("==========3.Update Data=========\n");

        System.out.print ("==========4.Delete Data=========\n");

        System.out.print ("Input: [y/t]");

        try
        {
            while ((i=br.readLine()).equalsIgnoreCase("y"))
            {
                System.out.print ("Masukkan angka pilihan 1/4 :");
                p=Integer.parseInt(br.readLine());
                switch (p)

                {

                    case 1:
                    System.out.println("\n\nLihat Data");
                    ResultSet rs=stm.executeQuery ("select * from dataproduk");
                    while (rs.next())

                    {

                        System.out.print (rs.getString ("code"));
                        System.out.print ("\t"+rs.getString ("nama"));

                        System.out.print ("\t" + rs.getString ("stok"));
                        System.out.print ("\t" + rs.getString ("satuan"));
                        System.out.print ("\t" + rs.getString ("kurv"));
                        System.out.print ("\t" + rs.getString ("harga"));
                        System.out.print ("\t" + rs.getString ("jenis"));
                        System.out.print ("\t" + rs.getString ("tanggal"));

                        System.out.println ();

                    }
                    System.out.print ("Apakah anda ingin menginput lagi [y/t] : ");
                    break;

                    case 2:
                    System.out.println("\n\nTambah Data");
                    System.out.print ("Masukkan code barang: ");
                    String code = br.readLine();

                    System.out.print ("Masukkan nama barang : ");
                    String nama = br.readLine();

                    System.out.print ("Masukkan stock barang : ");
                    String stock = br.readLine();

                    System.out.print ("Masukkan satuan barang : ");
                    String satuan = br.readLine();

                    System.out.print ("input mata uang RP/USD : ");
                    String kurv = br.readLine();

                    System.out.print ("Masukkan harga barang : ");
                    String harga = br.readLine();

                    System.out.print ("Masukkan jenis barang : ");
                    String jenis = br.readLine();

                    System.out.print ("Masukkan tanggal barang : ");
                    String tanggal = br.readLine();

                    stm.executeUpdate ("insert into dataproduk values ('"+code+"','"+nama+"','"+stock+"','"+satuan+"','"+kurv+"','"+harga+"','"+jenis+"','"+tanggal+"')");
                    System.out.print ("Apakah anda ingin menginput lagi [y/t]");
                    break;

                    default:System.out.print ("Salah Ketik");

                    case 3:
                    System.out.print ("\n\nUpdate Data ");
                    System.out.print ("Masukkan code barang yang akan di ubah : ");
                    code = br.readLine();
                    System.out.print ("Masukkan nama baru : ");
                    nama = br.readLine ();
                    System.out.print ("Masukkan stock yang akan diubah : ");
                    stock = br.readLine ();
                    System.out.print ("Masukkan satuan yang akan diubah : ");
                    satuan = br.readLine ();
                    System.out.print ("Masukkan mata uang yang akan diubah : ");
                    kurv = br.readLine ();
                    System.out.print ("Masukkan harga yang akan diubah : ");
                    harga = br.readLine ();
                    System.out.print ("Masukkan jenis yang akan diubah : ");
                    jenis = br.readLine ();
                    System.out.print ("Masukkan tanggal pembaharuan : ");
                    tanggal = br.readLine ();

                    stm.executeUpdate ("update dataproduk set nama='"+nama+"',stock='"+stock+"',satuan='"+satuan+"',kurv='"+kurv+"',harga='"+harga+"',jenis='"+jenis+"',tanggal='"+tanggal+"' where code='"+code+"';");
                    System.out.print ("Apakah anda ingin menginput lagi [y/t]");
                    break;

                    case 4:
                    System.out.print ("\n\nDelete Data");
                    System.out.print ("Masukkan code yang akan dihapus : ");
                    code = br.readLine ();

                    stm.executeUpdate ("delete from dataproduk where code='"+code+"';");
                    System.out.print ("Apakah anda ingin menginput lagi [y/t]");

                    break;

                }
                conn.close();
            }
        }

        catch (SQLException e)

        {
            System.err.print (e.getMessage ());
        }
    }
}