1. INDONESIA

package Java1.Java;
import java.sql.*;
public class Indonesia {
private Connection conn;
// nama dsn di odbc private String url = "jdbc:odbc:kamus";
private Statement stmt; private String sql; private ResultSet rs;
// constructor // koneksi dibuka ketika class ini dipanggil
public Indonesia() { this.BukaKoneksi(); }
// Buka Koneksi DataBase
public void BukaKoneksi() { // coba try { // pengaksesan lewat JDBC-ODBC Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); conn = DriverManager.getConnection(url); } // kalau gagal catch (ClassNotFoundException clex) { System.out.println("Driver database tidak ada"); } catch (SQLException sqlex) { System.out.println("Koneksi gagal dilakukan"); } }
public String caridata(String kata){ String hasil = null; try{ stmt=conn.createStatement(); // query dengan parameter dan sorting sql="select * from DataKamus where English='"+ kata +"'"; rs=stmt.executeQuery(sql); while (rs.next()){ hasil = rs.getString("Indonesia"); //System.out.println("Arti : " + rs.getString("Arti")); } } catch (SQLException sqlex) { System.out.println("Query gagal dieksekusi"); } return hasil; } public String findword(String kata){ String hasil = null; try{ stmt=conn.createStatement(); // query dengan parameter dan sorting sql="select * from DataKamus where Indonesia='"+ kata +"'"; rs=stmt.executeQuery(sql); while (rs.next()){ hasil = rs.getString("English"); } } catch (SQLException sqlex) { System.out.println("Query gagal dieksekusi"); } return hasil; }
}


2. TERJEMAH

package Java1.Java;
import java.util.Scanner;import javax.swing.*;public class Terjemah {
public static void main(String[] args) { Indonesia db =new Indonesia(); Scanner input = new Scanner(System.in); int pilih; String hasil; do{ String input1 = ""; input1 = JOptionPane.showInputDialog ("Java Dictionary [2.16.1988]\n(C) Copyright 2006-2008\nManajemen Informatika\n\n1. English - Indonesia\n2. Indonesia - English\n3. About\n4. Exit\n\nPilihan Anda : ",""); pilih = Integer.parseInt(input1); System.out.println(); if (pilih >=1 && pilih <=4){ if (pilih==1) { String teks = JOptionPane.showInputDialog ("Masukkan kata : "); hasil= db.caridata(teks); if (hasil==null) JOptionPane.showMessageDialog(null,"Maaf, Data yang Anda cari tidak ditemukan!!","Informasi",JOptionPane.INFORMATION_MESSAGE); else JOptionPane.showMessageDialog(null,teks+" = "+hasil, "English - Indonesia", JOptionPane.INFORMATION_MESSAGE); } else if (pilih==2){ String text = JOptionPane.showInputDialog ("Masukkan kata : "); hasil = db.findword(text); if (hasil==null) JOptionPane.showMessageDialog(null,"Maaf, Data yang Anda cari tidak ditemukan!!","Informasi",JOptionPane.INFORMATION_MESSAGE); else JOptionPane.showMessageDialog(null,text+" = "+hasil,"Indonesia - English",JOptionPane.INFORMATION_MESSAGE); } else if (pilih==3) JOptionPane.showMessageDialog(null,"Java Dictionary [2.16.1988]\n(C) Copyright 2006-2008\nManajemen Informatika All right reserved\n\nThis Dictionary is freeware for everyone\nVisit http://www.kurkurcyber.blogspot.com by :\n1. Kurniawan hartanto,"Informasi",JOptionPane.INFORMATION_MESSAGE); else System.exit(0); } else JOptionPane.showMessageDialog(null,"Pilihan yang Anda masukkan salah !!!","Kesalahan",JOptionPane.ERROR_MESSAGE); } while (pilih != 4); }}

0 komentar: