Menyambungkan Java dengan MySql bukan pekerjaan mudah , paling tidak untuk saya..
dan dibawah ini adalah cara-cara menyambungkan java dan mysql , namun sebelum melakukan code dibawah
anda harus menambahkan library mysql ke java . kalau di netbeans caranya seperti ini
dikiri netbean ada list yang bernama library lalu click kanan dan pilih addLibrary teruskan dengan memilih MySql JDBC Driver ,
kalau MySql JDBC Driver tidak ditemukan di list silahkan download terlebih dahulu
package javaapplication1;
import java.awt.BorderLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.print.PrinterException;
import javax.swing.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.text.MessageFormat;
class database {
public Connection con;
private String user ;
private String passwd;
private String port ;
public String fuGetUser(){
return this.user;
}
public String fuGetPort(){
return this.port;
}
public String fuGetPassWd(){
return this.passwd;
}
public database(String port , String user, String passwd ) {
this.user = user;
this.passwd = passwd;
this.port = port ;
}
// menyambungkan ke mysql
public void fuSetConnection(){
try {
this.con =
DriverManager.getConnection("jdbc:mysql://localhost:"+this.fuGetPort()+"/",
this.fuGetUser(), this.fuGetPassWd());
JOptionPane.showMessageDialog(null,"Database Tersambung","Sukses",JOptionPane.INFORMATION_MESSAGE);
}
catch (java.sql.SQLException s) {
con = null;
JOptionPane.showMessageDialog(null,s.getMessage(),"Database Error",JOptionPane.ERROR_MESSAGE);
System.exit(0);
}
}
}
public class Main extends JFrame{
private database fuDatabase = null ;
public Main(){
fuDatabase = new database("3306","root","1");
this.fuDatabase.fuSetConnection();
this.fuSetFrame();
}
// tidak ada hubungannya dengan mysql , ini hanya untuk window
private void fuSetFrame(){
final Object rows[][] = {
{"go", "pergi"},
{"already", "sudah"},
{"exist", "ada"},
{"buy", "membeli"},
{"home", "rumah"},
{"window", "jendela"},
{"door", "pintu"},
{"floor", "lantai"},
{"mirror", "cermin"},
{"wall", "dinding"},
{"duplicate", "tiruan"},
{"unknown", "tidak diketahui"},
{"fail", "gagal"},
{"last", "terakhir"},
{"fetched", "diambil"},
{"entry", "masuk"},
{"return", "kembali"},
{"error", "kesalahan"},
};
final Object headers[] = {"bahasa inggris", "bahasa indonesia"};
JFrame frame = new JFrame("kamus sederhana");
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
final JTable table = new JTable(rows, headers);
JScrollPane scrollPane = new JScrollPane(table);
frame.add(scrollPane, BorderLayout.CENTER);
JButton button = new JButton("Print");
ActionListener printAction = new ActionListener() {
public void actionPerformed(ActionEvent e) {
try {
MessageFormat headerFormat = new MessageFormat("Page {0}");
MessageFormat footerFormat = new MessageFormat("- {0} -");
table.print(JTable.PrintMode.FIT_WIDTH, headerFormat, footerFormat);
} catch (PrinterException pe) {
System.err.println("Error printing: " + pe.getMessage());
}
}
};
button.addActionListener(printAction);
frame.add(button, BorderLayout.SOUTH);
frame.setSize(800, 500);
frame.setVisible(true);
}
public static void main(String[] args) {
new Main();
}
}
kalau anda menemukan Error ulangi langkah2nya..... !!!
hasil akhir =>
http://img003.picture2life.net/11013521/wkakakakaka_web-large_medium.jpg
java dan sql


Diberdayakan oleh Blogger.