konekdb

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package konekdb;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Scanner;


/**
 *
 * @author LABCOM3-25
 */
public class KonekDb {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        // TODO code application logic here
        String url = "jdbc:mysql://localhost:3306/indonesia";
        String username = "root";
        String password = "";

        System.out.println("Connecting database...");

        Scanner sc = new Scanner(System.in);
        System.out.print("Masukkan ID Kelurahan : ");
        String idKelurahan = sc.nextLine();
        System.out.print("Masukkan Nama Kelurahan : ");
        String namaKelurahan = sc.nextLine();

        try (Connection connection = DriverManager.getConnection(url, username, password)) {
            System.out.println("Database connected!");

            String query = "INSERT INTO kelurahan "
                    + "(ID_KELURAHAN, ID_KOTA_KABUPATEN, "
                    + "NAMA_KELURAHAN) VALUES "
                    + "('"+idKelurahan+"', '1101', \""+namaKelurahan+"\");";

            Statement st = connection.createStatement();
            st.executeUpdate(query);



            /*
            String query = "SELECT * FROM kelurahan";
            ResultSet rs = st.executeQuery(query);

            ArrayList<Kelurahan> k = new ArrayList<>();

            while (rs.next()) {
                Kelurahan newK = new Kelurahan(rs.getString(1), rs.getString(2), rs.getString(3));
                k.add(newK);
            }*/

        } catch (SQLException e) {
            throw new IllegalStateException("Cannot connect the database!", e);
        }

    }

}