Siapkan databasenya dan Tabelnya
badi@localhost ~]$ mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 32
Server version: 5.1.32 Source distribution
Type help; or \h for help. Type \c to clear the buffer.
mysql> use simpeg;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select * from pegawai;
+-------+-----------------------+--------+------+-------+
| NIP | NAMA | ALAMAT | SEKS | AGAMA |
+-------+-----------------------+--------+------+-------+
| 10002 | Endang Susilowati sss | Madiun | P | ISLAM |
| 10003 | Made Saputra | Bali | L | HINDU |
| 10004 | Bejo | Bantul | L | BUDHA |
+-------+-----------------------+--------+------+-------+
3 rows in set (0.00 sec)
Membuat Program Koneksi dalam Kelas
Lihat contoh program berkut :
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package jdbc1a;
import [Link].*;
import [Link].*;
/*****************************************
*
* @author badiyanto
* STMIK AKAKOM Yogyakarta
*******************************************/
public class KoneksiDb {
public Connection conn;
public Statement st;
public ResultSet rs;
// Fungsi koneksi
public void koneksi()
{
// memangil fungsi konek() untuk melakukan koneksi
konek("localhost","simpeg","root","");
}
// Program untuk melakukan koneksi
public void konek(String server,String db, String user,String passwd){
[Link]("Keterangan");
//memanggil driver
try {
[Link]("[Link]");
} catch (ClassNotFoundException e) {
[Link](
"Ada kesalahan Driver ODBC tidak barhasil Load");
[Link]();
return;
}
[Link]("Mysql JDBC Driver berhasil di Load");
conn = null;
try {
conn = [Link]("jdbc:mysql://"+
server+":3306/"+db,user,passwd);
} catch (SQLException e) {
[Link]("Tidak bisa koneksi ke database");
[Link]();
return;
}
if (conn != null)
[Link]("Berhasil Koneksi!");
else
[Link]("Koneksi Gagal........ !");
}
// program mengisikan kombobox
public void IsiKombo(JComboBox kombo, String tabel, String isi, String urut
){
koneksi();
String sql="SELECT "+isi+" as hasil FROM "+tabel+" ORDER BY "+urut;
[Link]();
try
{
st = [Link]();
rs = [Link](sql);
}
catch (SQLException e){
return;
}
try{
while ([Link]())
{
[Link]([Link]("hasil").toString());
}
[Link]();
[Link]();
}
catch (SQLException e){
return;
}
}
// Program mencari data dengan kunci
public String CariData(String tabel, String fHasil, String fKunci, String
fCari ){
String hs="";
String sql="SELECT "+fHasil+" as hasil FROM "+tabel+" WHERE
"+fKunci+"='"+fCari+"'";
koneksi();
try
{
st = [Link]();
rs = [Link](sql);
}
catch (SQLException e){
return("");
}
try{
while ([Link]())
{
hs = [Link]("hasil").toString();
}
[Link]();
[Link]();
}
catch (SQLException e){
return("");
}
return(hs);
}
// Program menampilkan isikombo
public void CariIsiKombo(JComboBox k,String c){
int i=0;
int ketemu=0;
while (i<=[Link]()-1 )
{
if ([Link]([Link](i).toString()))
{
ketemu=i;
}
i++;
}
[Link](ketemu);
}
}
Rancangan Form untuk input data
Buatlah seperti rancangan berikut :
<!-- @page { margin: 0.79in } P { margin-bottom: 0.08in } A:link { so-
language: zxx } -->
Kode Program :
package jdbc1a;
import [Link].*;
/****************************************
*
* @author badiyanto
* STMIK AKAKOM Yogyakarta
*******************************************/
public class NewJFrame1 extends [Link] {
KoneksiDb x; //deklarasi kelas
/** Creates new form NewJFrame1 */
public NewJFrame1() {
initComponents();
x = new KoneksiDb();
[Link](); //panggil koneksi
}
/** This method is called from within the constructor to
* initialize the form.
* WARNING: Do NOT modify this code. The content of this method is
* always regenerated by the Form Editor.
*
*/
public void konek(String server,String db, String user,String passwd){
[Link]("Keterangan");
try {
[Link]("[Link]");
} catch (ClassNotFoundException e) {
[Link]("Driver JDBC tidak barhasil Load");
[Link]();
return;
}
[Link]("Driver berhasil di Load");
[Link] = null;
try {
[Link] = [Link](
"jdbc:mysql://"+server+":3306/"+db,user,passwd);
} catch (SQLException e) {
[Link]("Tidak bisa koneksi ke database");
[Link]();
return;
}
if ([Link] != null)
[Link]("Berhasil Koneksi!");
else
[Link]("Koneksi Gagal........ !");
}
private void jButtonSimpanMouseClicked([Link] evt) {
// TODO add your handling code here:
String nip,nama,alamat,jk,agama,sql;
nip = [Link]();
nama =[Link]();
alamat=[Link]();
if ([Link]("") )
{
[Link]("Nip tidak boleh kosong");
[Link]();
return;
}
if ([Link](""))
{
[Link]("Nama tidak boleh kosong");
[Link]();
return;
}
if ([Link]()==true)
jk ="L";
else
jk="P";
agama=[Link](
[Link]()).toString();
sql="INSERT INTO pegawai(nip,nama,alamat,seks,agama) VALUES "+
"('"+nip+"','"+nama+"','"+alamat+"','"+jk+"','"+agama+"')";
[Link](sql);
try
{
[Link] = [Link]();
[Link](sql);
}
catch (SQLException e){
[Link]("Penyimpanan Gagal ");
return;
}
[Link]("Data sudah tersimpan!");
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
[Link](new Runnable() {
public void run() {
new NewJFrame1().setVisible(true);
}
});
}
// Variables declaration - do not modify
private [Link] buttonGroup1;
private [Link] jButtonSimpan;
private [Link] jComboBoxAgama;
private [Link] jLabel1;
private [Link] jLabel2;
private [Link] jLabel3;
private [Link] jLabel4;
private [Link] jPanel1;
private [Link] jRadioButton1;
private [Link] jRadioButton2;
private [Link] jTextField1;
private [Link] jTextFieldAlamat;
private [Link] jTextFieldNama;
private [Link] jTextFieldNip;
// End of variables declaration
}
Mengubah Rekaman
Buatlah rancangan berikut :
Kode Program :
/*
* [Link]
*
* Created on May 22, 2011, 9:27:12 PM
*/
package jdbc1a;
import [Link].*;
/***************************************
*
* @author badiyanto
* STMIK AKAKOM Yogyakarta
*******************************/
public class NewJFrame2 extends [Link] {
KoneksiDb x;
/** Creates new form NewJFrame2 */
public NewJFrame2() {
initComponents();
x = new KoneksiDb();
[Link]();
}
private void jButtonSimpanMouseClicked([Link] evt) {
// TODO add your handling code here:
String nip,nama,alamat,jk,agama,sql;
nip = [Link]([Link]()).toString();
nama =[Link]();
alamat =[Link]();
agama
=[Link]([Link]()).toString();
if ([Link]()==true)
jk="L";
else
jk="P";
sql = "UPDATE pegawai SET nama='"+nama+"',"+
"alamat='"+alamat+"',"+
"seks='"+jk+"',"+
"agama='"+agama+"'"+
" WHERE nip='"+nip+"'";
[Link](sql);
try {
[Link] = [Link]();
[Link](sql);
} catch (SQLException e){
[Link]("Penyimpanan Gagal ");
return;
}
[Link]("data sudah tersimpan!");
}
private void formWindowOpened([Link] evt) {
// TODO add your handling code here:
// Memgisi kombo dengan tidak memanggil fungsi di kelas KonekDB
String sql="SELECT nip FROM pegawai ORDER BY nip";
[Link](sql);
[Link]();
try
{
[Link] = [Link]();
[Link] = [Link](sql);
}
catch (SQLException e){
return;
}
try{
while ([Link]())
{
[Link]([Link]("nip").toString());
}
[Link]();
[Link]();
}
catch (SQLException e){
return;
}
}
private void jComboBoxNipMouseClicked([Link] evt) {
// TODO add your handling code here:
// Menampilkan data ketika comboNip di Klik
String
nip=[Link]([Link]()).toString();
String sql="SELECT * FROM pegawai WHERE nip='"+nip+"';";
try
{
[Link] = [Link]();
[Link] = [Link](sql);
}
catch (SQLException e){
return;
}
try{
while ([Link]())
{
[Link]([Link]("nama").toString());
[Link]([Link]("alamat").toString());
if ([Link]("seks").equals("L"))
[Link](true);
else
[Link](true);
int i=0;
int ketemu=0;
while (i<=[Link]()-1 )
{
if ([Link]("agama").equals(
[Link](i).toString()))
{
ketemu=i;
}
i++;
}
[Link](ketemu);
}
[Link]();
[Link]();
}
catch (SQLException e){
return;
}
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
[Link](new Runnable() {
public void run() {
new NewJFrame2().setVisible(true);
}
});
}
// Variables declaration - do not modify
private [Link] buttonGroup1;
private [Link] jButton1;
private [Link] jButtonSimpan;
private [Link] jComboBoxAgama;
private [Link] jComboBoxNip;
private [Link] jLabel1;
private [Link] jLabel2;
private [Link] jLabel3;
private [Link] jLabel4;
private [Link] jPanel1;
private [Link] jRadioButton1;
private [Link] jRadioButton2;
private [Link] jTextField1;
private [Link] jTextFieldAlamat;
private [Link] jTextFieldNama;
// End of variables declaration
}
Menghapus Rekaman
Rancangan Form Berikut :
Kode Program
<!-- @page { margin: 0.79in } P { margin-bottom: 0.08in } -->
/***********************************************
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/************************************************
/***********************************************
* [Link]
*
* Created on May 30, 2011, 9:28:42 PM
***********************************************/
package jdbc1a;
import [Link].*;
import [Link];
/*********************************************
*
* @author badiyanto
* STMIK AKAKOM Yogyakarta
*********************************************/
public class NewJFrame3 extends [Link] {
KoneksiDb y;
/** Creates new form NewJFrame3 */
public NewJFrame3() {
initComponents();
y=new KoneksiDb();
[Link]();
}
/** This method is called from within the constructor to
private void formWindowOpened([Link] evt) {
// TODO add your handling code here:
// memanggil fungsi kosongkan isian
kosongkan();
}
private void jComboBoxNipMouseClicked([Link] evt) {
// TODO add your handling code here:
String
nip=[Link]([Link]()).toString();
///menampilkan isian dengan memanggil fungsi [Link](......);
[Link]([Link]("pegawai","nama","nip", nip));
[Link]([Link]("pegawai","alamat","nip", nip));
if ([Link]("pegawai","seks","nip", nip).equals("L"))
[Link](true);
else
[Link](true);
[Link](jComboBoxAgama,[Link]("pegawai","agama","nip",
nip).toString());
}
//proses menghapus rekaman//
private void jButton1ActionPerformed([Link] evt) {
String
nip=[Link]([Link]()).toString();
// dialog konfirmasi //
int jawab=[Link](this,"Anda yakin ingim menghapus
data ini","Konfimasi",JOptionPane.YES_NO_OPTION);
if (jawab == 0)
{
try
{
[Link] = [Link]();
[Link]("DELETE FROM pegawai WHERE nip='"+nip+"'");
}
catch (SQLException e){
[Link]("Gagal mengapus Gagal ");
return;
}
[Link]("Data Berhasil dihapus!");
kosongkan();
}
}
void kosongkan()
{
[Link]("");
[Link]("");
[Link](false);
[Link](false);
[Link](0);
[Link]();
[Link](jComboBoxNip,"pegawai","nip", "nip");
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
[Link](new Runnable() {
public void run() {
new NewJFrame3().setVisible(true);
}
});
}
// Variables declaration - do not modify
private [Link] buttonGroup1;
private [Link] jButton1;
private [Link] jButton3;
private [Link] jComboBoxAgama;
private [Link] jComboBoxNip;
private [Link] jLabel1;
private [Link] jLabel2;
private [Link] jLabel3;
private [Link] jLabel4;
private [Link] jPanel1;
private [Link] jRadioButton1;
private [Link] jRadioButton2;
private [Link] jTextFieldAlamat;
private [Link] jTextFieldNama;
// End of variables declaration
}