Dibawah ini adalah sourcecode yang dapat digunakan untuk membuat tampilan menu pada program aplikasi anda. Dalam program aplikasi ini akan menggunakan Database Microsoft Access dan fungsi-fungsi java lainnya. Silahkan mencoba…!
import java.sql.*;
import java.io.*;
class menu {
public static void main(String args[]) throws IOException{
BufferedReader stdin=new
BufferedReader(new InputStreamReader(System.in));
String buff;
int pilih;
try {
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);
Connection connection = DriverManager.getConnection
(“jdbc:odbc:databasis”,”root”,”");
System.out.println(“Anda terhubung!!”);
System.out.println(” Menu : “);
System.out.println(” 1. Lihat Data “);
System.out.println(” 2. Tambah Data “);
System.out.println(” 3. Exit “);
System.out.print(” Pilih nomor : “);
buff = stdin.readLine();
pilih=Integer.parseInt(buff);
ResultSet hasilQuery = null;
Statement stm = connection.createStatement();
switch(pilih){
case 1:
hasilQuery = stm.executeQuery(“SELECT * FROM mahasiswa”);
while (hasilQuery.next()) {
String nim_mhs = hasilQuery.getString(“nim”);
String nama_mhs = hasilQuery.getString(“nama”);
String email_mhs = hasilQuery.getString(“email”);
System.out.println(nim_mhs+” -> ” + nama_mhs+” -> ” + email_mhs); }
break;
case 2:
String nim_t, nama_t, email_t;
System.out.print(“nim : “);
nim_t = stdin.readLine();
System.out.print(“nama : “);
nama_t = stdin.readLine();
System.out.print(“email : “);
email_t = stdin.readLine();
String sql=”INSERT into mahasiswa values(‘”+nim_t+”‘,’”+nama_t+”‘,’”+email_t+”‘)”;
stm.executeUpdate(sql);
break;
default:
System.out.println(“Bye”);
break;
}
connection.close();
} catch (Exception e) {
System.out.println(“Error : “+e);
}
}
}