UAS Pemrograman 1 - Fernando R - 181021400222

/*
 * 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 RumahSakit;

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
/**
 *
 * @author Fernando
 */
public class crud {
    static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
    static final String DB_URL = "jdbc:mysql://localhost/rumahsakit";
    static final String USER = "root";
    static final String PASS = "";

    static Connection conn;
    static Statement stmt;
    static ResultSet rs;
    static InputStreamReader inputStreamReader = new InputStreamReader(System.in);
    static BufferedReader input = new BufferedReader(inputStreamReader);

    public static void main (String[] args){
        try{
Class.forName(JDBC_DRIVER);
conn = DriverManager.getConnection(DB_URL, USER, PASS);

stmt = conn.createStatement();
while(!conn.isClosed()){
Menu();
}
stmt.close();
conn.close();
}catch(Exception e){
e.printStackTrace();
}
}

static void Menu(){
    System.out.println("\nMENU UTAMA");
    System.out.println("1. Insert Data Pasien Rawat Inap");
    System.out.println("2. Show Data Pasien Rawat Inap");
    System.out.println("3. Edit Data Pasien Rawat Inap");
    System.out.println("4. Delete Data Pasien Rawat Inap");
    System.out.println("0. Keluar");
    System.out.println("");
    System.out.println("PILIHAN> ");

    try{
        int pilihan = Integer.parseInt(input.readLine());
        switch(pilihan){
            case 0:
                System.exit(0);
                break;
            case 1:
                insertrumahsakit();
                break;
            case 2:
                showData();
                break;
            case 3:
                updaterumahsakit();
                break;
            case 4:
                deleterumahsakit();
                break;
            default:
                System.out.println("Pilihan Salah!");
        }

    }
    catch(Exception e){
        e.printStackTrace();
    }
}

static void showData(){
    String sql = "SELECT*FROM rumahsakit";
    try{
        rs = stmt.executeQuery(sql);

        System.out.println("-----------------------");
        System.out.println("DATA PASIEN RAWAT INAP");
        System.out.println("-----------------------");
        while (rs.next()){
            int id_pasien = rs.getInt("id_pasien");
            String nm_pasien = rs.getString("nm_pasien");
            String alamat = rs.getString("alamat");
            String jenis_kelamin = rs.getString("jenis_kelamin");
            String tgl_masuk = rs.getString("tgl_masuk");

            System.out.println(String.format("%d.%s--%s--%s--%s",id_pasien,nm_pasien,alamat,jenis_kelamin,tgl_masuk));
        }

    }catch(Exception e){
        e.printStackTrace();
    }
}

static void insertrumahsakit(){
    try{
        System.out.print("ID Pasien: ");
        String id_pasien = input.readLine().trim();
        System.out.print("Nama Pasien : ");
        String nm_pasien = input.readLine().trim();
        System.out.print("Alamat Pasien: ");
        String alamat = input.readLine().trim();
        System.out.print("Jenis Kelamin Pasien: ");
        String jenis_kelamin = input.readLine().trim();
        System.out.print("Tanggal Masuk Pasien: ");
        String tgl_masuk = input.readLine().trim();

        String sql = "INSERT INTO rumahsakit (nm_pasien,alamat,id_pasien,jenis_kelamin,tgl_masuk)VALUE('%s','%s','%s','%s','%s')";
        sql = String.format(sql,nm_pasien,alamat,id_pasien,jenis_kelamin,tgl_masuk);

        stmt.execute(sql);

    }catch(Exception e){
        e.printStackTrace();
    }
}

static void updaterumahsakit(){
    try{
        System.out.print("ID Pasien: ");
        int id_pasien = Integer.parseInt(input.readLine());
        System.out.print("Nama Pasien: ");
        String nm_pasien = input.readLine().trim();
        System.out.print("Alamat Pasien: ");
        String alamat = input.readLine().trim();
        System.out.print("Jenis Kelamin Pasien: ");
        String jenis_kelamin = input.readLine().trim();
        System.out.print("Tanggal Masuk Pasien: ");
        String tgl_masuk = input.readLine().trim();

        String sql = "UPDATE rumahsakit SET nm_pasien='%s',alamat='%s',jenis_kelamin='%s',tgl_masuk='%s'WHERE id_pasien=%d";
        sql = String.format(sql, nm_pasien, alamat, jenis_kelamin, tgl_masuk, id_pasien);

        stmt.execute(sql);

    }catch(Exception e){
        e.printStackTrace();
    }
}

static void deleterumahsakit(){
    try{

    System.out.print("id_pasien yang akan dihapus: ");
    int id_pasien = Integer.parseInt(input.readLine());

    String sql = String.format("DELETE FROM rumahsakit WHERE id_pasien=%d",id_pasien);

    stmt.execute(sql);
    System.out.println("Data telah terhapus");
    }catch(Exception e){
        e.printStackTrace();

    }
}

}