Program Java (Input Data)

//Listing Program inputdata.java
import java.io.*;
import java.sql.*;

public class database{

static BufferedReader baca= new BufferedReader(new InputStreamReader(System.in));
static String m, nim, nama, alamat, kota; static char hasil;
static String database = “jdbc:odbc:latihan”;
static Connection con;
static Statement stmt;
static String query = “select * from tblmhs”;
static ResultSet rs;
static String s1;
static String s2;
static String s3;
static String s4;

public static void main(String args[]) throws IOException{
//String database = “jdbc:odbc:latihan”;
//Connection con;
//Statement stmt;
//String query = “select * from tblmhs”;

System.out.println(“\n###### M E N U U T A M A ######”);
System.out.println(“1. Input Data.”);
System.out.println(“2. Edit Data.”);
System.out.println(“3. Hapus Data.”);
System.out.println(“4. Tampil Data.”);
System.out.println(“0. Keluar”);
System.out.print(“Pilihan Anda : “);
m=baca.readLine();

if (m.equals(“1”)) {
input();
}
else if (m.equals(“2”)) {
edit();
}
else if (m.equals(“3”)) {
hapus();
}
else if (m.equals(“4”)) {
tampil();
}
else if (m.equals(“0”)) {
System.out.print(“\n:::::==T E R I M A K A S I H==:::::”);
}

else {
System.out.print(“\n:::::==Inputan Salah!!!==:::::”);
}

}

public static void input() throws IOException {

try {
Class.forName (“sun.jdbc.odbc.JdbcOdbcDriver”);
} catch (java.lang.ClassNotFoundException e) {
System.err.print(“ClassNotFoundException: “);
System.err.println(e.getMessage());
}

try {
con = DriverManager.getConnection(database,””,””);
stmt = con.createStatement();

System.out.println(“\n:::::::::: Input Data ::::::::::”);
System.out.print(“Masukkan NIM : “);
nim=baca.readLine();
System.out.print(“Masukkan Nama : “);
nama=baca.readLine();
System.out.print(“Masukkan Alamat : “);
alamat=baca.readLine();
System.out.print(“Masukkan Kota : “);
kota=baca.readLine();

System.out.print(“Input Data ? (y/t)”);
hasil=(char)baca.read();

if ((hasil==’y’) || (hasil==’Y’)) {
stmt.executeUpdate(“insert into tblmhs (nim, nama, alamat, kota) values(”
+ “‘” + nim + “‘,”
+ “‘” +nama+ “‘,”
+ “‘” +alamat + “‘,”
+ “‘” +kota + “‘”
+ “)”);
}
else if ((hasil==’t’) || (hasil==’t’)) {
System.out.print(“Inputan Gagal”);
return;
}
else {
System.out.print(“Inputan Salah!!! “);
return;
}

System.out.println(“\nDaftar Mahasiswa”);

rs = stmt.executeQuery(query);
while (rs.next()) {
s1 = rs.getString(“nim”);
s2 = rs.getString(“nama”);
s3 = rs.getString(“alamat”);
s4 = rs.getString(“kota”);
System.out.println(s1+ ” ” +s2+ ” ” +s3+ ” ” +s4);
}
stmt.close();
con.close();

} catch(SQLException ex) {
System.err.println(“SQLException:”+ex.getMessage());
}
}

public static void edit() throws IOException {

try {
Class.forName (“sun.jdbc.odbc.JdbcOdbcDriver”);
} catch (java.lang.ClassNotFoundException e) {
System.err.print(“ClassNotFoundException: “);
System.err.println(e.getMessage());
}

try {
con = DriverManager.getConnection(database,””,””);
stmt = con.createStatement();

System.out.println(“Program Edit Data Mahasiswa”);
System.out.print(“Masukkan NIM : “);
nim=baca.readLine();
System.out.print(“Masukkan Nama : “);
nama=baca.readLine();
System.out.print(“Masukkan Alamat : “);
alamat=baca.readLine();
System.out.print(“Masukkan Kota : “);
kota=baca.readLine();

System.out.print(“Edit Data ? dengan NIM :”+nim+ “(y/t)”);
hasil=(char)baca.read();

if ((hasil==’y’) || (hasil==’Y’)) {
stmt.executeUpdate(“update tblmhs set ”
+ “nama ='” + nama+ “‘,”
+ “alamat ='” + alamat + “‘,”
+ “kota ='” + kota + “‘”
+ “where nim =” +nim );
}
else if ((hasil==’t’) || (hasil==’t’)) {
System.out.print(“Update Gagal”);
return;
}
else {
System.out.print(“Inputan Salah!!! “);
return;
}

System.out.println(“\nDaftar Mahasiswa”);

rs = stmt.executeQuery(query);
while (rs.next()) {
s1 = rs.getString(“nim”);
s2 = rs.getString(“nama”);
s3 = rs.getString(“alamat”);
s4 = rs.getString(“kota”);
System.out.println(s1+ ” ” +s2+ ” ” +s3+ ” ” +s4);
}
stmt.close();
con.close();

} catch(SQLException ex) {
System.err.println(“SQLException:”+ex.getMessage());
}
}

public static void hapus() throws IOException {

try {
Class.forName (“sun.jdbc.odbc.JdbcOdbcDriver”);
} catch (java.lang.ClassNotFoundException e) {
System.err.print(“ClassNotFoundException: “);
System.err.println(e.getMessage());
}

try {
con = DriverManager.getConnection(database,””,””);
stmt = con.createStatement();

System.out.println(“Program Hapus Data Mahasiswa: “);
System.out.print(“Masukkan NIM yang akan di Hapus: “);
nim=baca.readLine();
//System.out.print(“Masukkan Nama : “);
//nama=baca.readLine();

System.out.print(“Hapus Data dengan NIM=”+nim+”? (y/t)”);
hasil=(char)baca.read();

if ((hasil==’y’) || (hasil==’Y’)) {
stmt.executeUpdate(“delete from tblmhs where nim = ‘”+nim+ “‘” );
}
else if ((hasil==’t’) || (hasil==’t’)) {
System.out.print(“Delete Gagal”);
return;
}
else {
System.out.print(“Inputan Salah!!! “);
return;
}

System.out.println(“\nDaftar Mahasiswa”);

rs = stmt.executeQuery(query);
while (rs.next()) {
s1 = rs.getString(“nim”);
s2 = rs.getString(“nama”);
s3 = rs.getString(“alamat”);
s4 = rs.getString(“kota”);
System.out.println(s1+ ” ” +s2+ ” ” +s3+ ” ” +s4);
}
stmt.close();
con.close();

} catch(SQLException ex) {
System.err.println(“SQLException:”+ex.getMessage());
}
}

public static void tampil() throws IOException {

try {
Class.forName (“sun.jdbc.odbc.JdbcOdbcDriver”);
} catch (java.lang.ClassNotFoundException e) {
System.err.print(“ClassNotFoundException: “);
System.err.println(e.getMessage());
}

try {
con = DriverManager.getConnection(database,””,””);
stmt = con.createStatement();

System.out.println(“\nDaftar Mahasiswa”);

rs = stmt.executeQuery(query);
while (rs.next()) {
s1 = rs.getString(“nim”);
s2 = rs.getString(“nama”);
s3 = rs.getString(“alamat”);
s4 = rs.getString(“kota”);
System.out.println(s1+ ” ” +s2+ ” ” +s3+ ” ” +s4);
}
stmt.close();
con.close();

} catch(SQLException ex) {
System.err.println(“SQLException:”+ex.getMessage());
}
}

}