JDBC

package latihanjdbc;

import java.sql.*;
import java.util.Scanner;

public class LatihanJDBC {

    private static final String url = "jdbc:mysql://127.0.0.1:3306/karyawan";
    private static final String username = "root";
    private static final String password = "";

    public static void main(String[] args) {
        try {
            DriverManager.registerDriver(new com.mysql.jdbc.Driver());
            Connection koneksi = DriverManager.getConnection(url, username, password);
            Scanner sc = new Scanner(System.in);
            while(true) {
                antarmuka(koneksi, sc);
            }
        }
        catch(SQLException exc) {
            System.err.println(exc.toString());
        }
    }

    private static void antarmuka(Connection koneksi, Scanner sc) throws SQLException {
        System.out.println("[1] View");
        System.out.println("[2] Insert");
        System.out.println("[3] Update");
        System.out.println("[4] Delete");
        System.out.print("Masukkan pilihan anda: ");
        int pilihan = sc.nextInt();
        sc.nextLine();
        switch(pilihan) {
            case 1 :
                view(koneksi, sc);
                break;
                        case 2 :
                                insert(koneksi, sc);
                                break;
            case 3 :
                update(koneksi,sc);
                break;
                        case 4 :
                delete(koneksi,sc);
                break;
        }
    }

        private static void view(Connection koneksi, Scanner sc) throws SQLException {
              Statement pernyataan = koneksi.createStatement();

              String sql = "SELECT * FROM data_karyawan";
              ResultSet rs = pernyataan.executeQuery(sql);
              while(rs.next()){
                 int nik  = rs.getInt("nik");
                 String nama = rs.getString("nama");
                 String alamat = rs.getString("alamat");
                 String no_telp = rs.getString("no_telp");

                 System.out.println("Data Karyawan");
                 System.out.println("Nik: " + nik);
                 System.out.println("Nama: " + nama);
                 System.out.println("Alamat: " + alamat);
                 System.out.println("No Telp: " + no_telp + ",");
                 System.out.println("");
              }
              rs.close();
                }

    private static void insert(Connection koneksi, Scanner sc) throws SQLException {
            Statement pernyataan = koneksi.createStatement();
            System.out.print("masukan NIK: ");
                    String NIK = sc.nextLine();

                    System.out.print("masukan Nama: ");
                    String Nama = sc.nextLine();

                    System.out.print("masukan Alamat: ");
                    String Alamat = sc.nextLine();

                    System.out.print("masukan No Telpon: ");
                    String no_telp = sc.nextLine();
                    pernyataan.executeUpdate("INSERT INTO data_karyawan VALUES ('"+NIK+"', '"+Nama+"', '"+Alamat+"', "+no_telp+")");
                    System.out.println("Insert Sukses");
                    pernyataan.close();
        }

    private static void delete(Connection koneksi, Scanner sc) throws SQLException {
                    Statement pernyataan = koneksi.createStatement();

                    System.out.print("masukan NIK Yang Akan Di Hapus: ");
                    String NIK = sc.nextLine();

                    pernyataan.executeUpdate("DELETE FROM data_karyawan WHERE nik='"+NIK+"'");
                    System.out.println("Delete Sukses");
                    pernyataan.close();
    }

    private static void update(Connection koneksi, Scanner sc) throws SQLException {
                   Statement peryataan = koneksi.createStatement();

                    System.out.print("masukan NIK Yang Akan Di Update: ");
                    String NIK = sc.nextLine();

                    System.out.print("masukan Nama: ");
                    String Nama = sc.nextLine();

                    System.out.print("masukan Alamat: ");
                    String alamat = sc.nextLine();

                    System.out.print("masukan No Telpon: ");
                    String no_telp = sc.nextLine();
                    peryataan.executeUpdate("UPDATE data_karyawan SET Nama='"+Nama+"',"
                            + " alamat='"+alamat+"', no_telp='"+no_telp+"' WHERE nik='"+NIK+"'");
                    System.out.println("Update Sukses");
                    peryataan.close();
    }

}