Menyambungkan Database Ms. Acces dengan Program Sederhana Java

kemaren kita sudah membahas mengenai cara membuat dan men set Database dengan ms. Acces…
sekarang kita aplikasikan terhadap sebuah program..
pertama sobat buat Database dengan field sebagai berikut:


ada empat field: npm, nama, alamat, no_hp.
nama tabel: bio
namadatabase: terserah sobat sesuai selera.
trs database diset seperti kemaren baca di sini.
set database dengan nama: biodataq
langsung aja sekarang menuju pembuatan program dengan Netbeans.
desain program seperti berikut:

komponennt:
6 jlabel,
5 jButton:
- CREATE: btncreate
- UPDATE: btnupdate
- DELETE: btndelete
- EXIT: btnexit
- SEARCH: btnsearch
4 jTextField:
- NPM: txtnpm
- NAMA: txtnama
- ALAMAT: txtalamat
- NO HP: txthp
1jTable: tabeldata
langsung aja ke scriptnya.
pertama buat class koneksi database dengan nama conect.java
Scriptnya:
import java.sql.*;
import javax.swing.*;
/**
*
* @author Excel.Os
*/
public class conect {
void testKoneksi(){
try{String dbname=”jdbc:odbc:biodataq”;
// nama ODBC// ingat-ingat, biodataq adalah nama ODBC kita yang udah kitaatur sebelumnya
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);
Connection con = DriverManager.getConnection(dbname,”admin”,”admin”);// user n passwordnya// user database samakan dengan yang kita atur di ODBC tadi, yaitu// ‘Admin’, dengan password ‘admin’
JOptionPane.showMessageDialog(null, “Koneksi berhasil”,”InsertData”,JOptionPane.INFORMATION_MESSAGE);
con.close();
}catch (Exception e){JOptionPane.showMessageDialog(null, “Eror:”+e,”Gagal”,JOptionPane.WARNING_MESSAGE);
}
}
public static void main (String args[]){
conect test = new conect();
test.testKoneksi();
System.exit(0);}
}
yang kedua kita buat koneksi tabelnya, dengan nama jt.java
scriptnya:
import java.sql.ResultSet;
import javax.swing.table.AbstractTableModel;
import java.util.ArrayList;
/**
*
* @author Excel.Os
*/
public class jt extends AbstractTableModel {
public String getColumnName(int column) {
switch(column){
case 0 : return “NPM”;
case 1 : return “NAMA”;
case 2 : return “ALAMAT”;
case 3 : return “NO HP”;
default: return null;
}
}
private String[]coulumnNames={“NPM”,”NAMA”,”ALAMAT”,”NO HP”};
private Object[][]data=new Object[50][4];
public jt(ResultSet rs){
int brs=0;
try{
while(rs.next()){
data[brs][0]=rs.getString(“npm”);
data[brs][1]=rs.getString(“nama”);
data[brs][2]=rs.getString(“alamat”);
data[brs][3]=rs.getString(“no_hp”);
brs++;}
}catch(Exception e){
System.out.println(“biodata”);
}
}
public int getRowCount(){
return data.length;
}
public int getColumnCount(){
return coulumnNames.length;
}
public Object getValueAt(int rowIndex, int coulumnIndex){
return data[rowIndex][coulumnIndex];
}
public String getCoulumnName(int parameter){
return coulumnNames[parameter];
}
}
langkah terakhir kita masukkan scriptnya dari desain td…
buat JFrame Form dengan nama data
scriptnya:
import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.table.DefaultTableModel;
import javax.swing.*;
public class data extends javax.swing.JFrame {
public data() {
initComponents();
testKoneksi();
ResultSet rs=biodata();
tabeldata.setModel(new jt(rs));
}
void testKoneksi(){
try{String dbname=”jdbc:odbc:biodataq”;
// nama ODBC// ingat-ingat, CobaDatabase adalah nama ODBC kita yang udah kitaatur sebelumnya
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);
Connection con = DriverManager.getConnection(dbname,”admin”,”admin”);// user n passwordnya// user database samakan dengan yang kita atur di ODBC tadi, yaitu// ‘Admin’, dengan password ‘admin’
JOptionPane.showMessageDialog(null, “Koneksi berhasil”,”InsertData”,JOptionPane.INFORMATION_MESSAGE);
con.close();
}catch (Exception e){JOptionPane.showMessageDialog(null, “Eror:”+e,”Gagal”,JOptionPane.WARNING_MESSAGE);
}
}
public ResultSet biodata(){
ResultSet rs=null;
try{
String dbname=”jdbc:odbc:biodataq”;
try {
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);
} catch (ClassNotFoundException ex) {
Logger.getLogger(data.class.getName()).log(Level.SEVERE, null, ex);
}
Connection con = DriverManager.getConnection(dbname,”admin”,”admin”);
Statement statement = con.createStatement();
String sql=”SELECT * FROM bio”;
rs = statement.executeQuery(sql);
}catch(SQLException e){
e.printStackTrace();
}
return (rs);
}
private void btncreateActionPerformed(java.awt.event.ActionEvent evt) {
String npm=txtnpm.getText();
String nama=txtnama.getText();
String alamat=txtalamat.getText();
String nope=txthp.getText();
try{
String dbname=”jdbc:odbc:biodataq”;
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);
Connection con = DriverManager.getConnection(dbname,”admin”,”admin”);
Statement statement = con.createStatement();
String sql=”insert into bio values(‘”+npm+”‘,’”+nama+”‘,’”+alamat+”‘,’”+nope+”‘);”;
statement.executeUpdate(sql);
statement.close();
JOptionPane.showMessageDialog(null, “Success New Entry..”,”Insert new Data”,JOptionPane.INFORMATION_MESSAGE);
con.close();
ResultSet rs=biodata();
tabeldata.setModel(new jt(rs));
}catch(Exception e){
JOptionPane.showMessageDialog(null, “Eror:”+e,”Gagal”,JOptionPane.WARNING_MESSAGE);
//System.err.println(“Exception: “+e.getMessage());
}
// TODO add your handling code here:
}
private void btnsearchActionPerformed(java.awt.event.ActionEvent evt) {
String npm=txtnpm.getText();
try{
String dbname=”jdbc:odbc:biodataq”;
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);
Connection con = DriverManager.getConnection(dbname,”admin”,”admin”);
Statement statement = con.createStatement();
String sql=”SELECT * FROM bio WHERE npm like ‘”+npm+”‘”;
ResultSet rs = statement.executeQuery(sql);
if (rs.next()){
JOptionPane.showMessageDialog(null, “Success, Search data “,”Search Data”,JOptionPane.INFORMATION_MESSAGE);
txtnama.setText(rs.getString(2));
txtalamat.setText(rs.getString(3));
txthp.setText(rs.getString(4));
}else{
JOptionPane.showMessageDialog(null, “not Success, Search data “,”Search Data”,JOptionPane.INFORMATION_MESSAGE);
txtnpm.requestFocus();
}statement.close();
con.close();
}catch(Exception e){
JOptionPane.showMessageDialog(null, “Eror:”+e,”Gagal”,JOptionPane.WARNING_MESSAGE);
//System.err.println(“Exception: “+e.getMessage());
}
// TODO add your handling code here:
}
private void btnupdateActionPerformed(java.awt.event.ActionEvent evt) {
String npm=txtnpm.getText();
String nama=txtnama.getText();
String alamat=txtalamat.getText();
String nope=txthp.getText();
try{
String dbname=”jdbc:odbc:biodataq”;
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);
Connection con = DriverManager.getConnection(dbname,”admin”,”admin”);
Statement statement = con.createStatement();
String sql=”UPDATE bio SET nama=’”+nama+”‘, alamat=’”+alamat+”‘,no_hp=’”+nope+”‘WHERE npm LIKE ‘”+npm+”‘”;
statement.executeUpdate(sql);
statement.close();
JOptionPane.showMessageDialog(null, “Success Update data”,”Update Data”,JOptionPane.INFORMATION_MESSAGE);con.close();
ResultSet rs=biodata();
tabeldata.setModel(new jt(rs));
} catch (Exception e) {
JOptionPane.showMessageDialog(null, “Eror:”+e,”Gagal”,JOptionPane.WARNING_MESSAGE);
}//System.err.println(“Exception: “+e.getMessage());}
// TODO add your handling code here:
}
private void btndeleteActionPerformed(java.awt.event.ActionEvent evt) {
String npm=txtnpm.getText();
try{
String dbname=”jdbc:odbc:biodataq”;
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);
Connection con = DriverManager.getConnection(dbname,”admin”,”admin”);
Statement statement = con.createStatement();
String sql=”DELETE FROM bio WHERE npm like ‘”+npm+”‘”;
statement.executeUpdate(sql);
statement.close();
txtnama.setText(“”);
txtalamat.setText(“”);
txthp.setText(“”);
JOptionPane.showMessageDialog(null, “Success, Delete data”,”Delete Data”,JOptionPane.INFORMATION_MESSAGE);
con.close();
ResultSet rs=biodata();
tabeldata.setModel(new jt(rs));
}catch(Exception e){
JOptionPane.showMessageDialog(null, “Eror:”+e,”Gagal”,JOptionPane.WARNING_MESSAGE);
//System.err.println(“Exception: “+e.getMessage());
}
// TODO add your handling code here:
}
private void btnexitActionPerformed(java.awt.event.ActionEvent evt) {
System.exit(0);
// TODO add your handling code here:
}
udah selesai tinggal dijalankan :) maka hasilnya sebagai berikut :

demikian contoh yang dapat saya berikaN..
semoga bermanfaat untuk kalian semua ^_^