Buat tabel baru di dalam
database data_barang1.
Buatlah seperti di bawah ini
Kemudian masuk ke netbeans
Buat JFrame baru di dalam package tugas_akhir.
Atur design menjadi seperti di bawah ini atau sesuai kreatifitas dengan menu tampilan yang sama.
Masuk kedalam source nya.
Import library ke dalam package tugas_akhir
import java.awt.Dimension;
import java.awt.Toolkit;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JOptionPane;
Lalu buat private class di dalam public class Partner
private Connection con;
private Statement stat;
private ResultSet res;
private String t;
private DefaultTableModel dtm;
Kemmudian di dalam public Partner
Deklarasikan fungsi” yang akan dipakai
initComponents();
koneksi();
kosongkan();
Lalu tuliskan source codenya
private void koneksi(){
try{
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://127.0.0.1/data_barang1", "root", "");
stat=con.createStatement();
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "Error Connecting to database because " +e);
}
}
private void kosongkan(){
idpart.setText("");
namepart.setText("");
nopart.setText("");
alpart.setText("");
}
private void table(){
DefaultTableModel t= new DefaultTableModel();
t.addColumn("ID Partner");
t.addColumn("Nama Partner");
t.addColumn("Kontak Partner");
t.addColumn("Alamat Partner");
table.setModel(t);
try{
res=stat.executeQuery("select * from partner");
while (res.next()){
t.addRow(new Object[]
{
res.getString("id_partner"),
res.getString("nama_partner"),
res.getString("nomor"),
res.getString("alamat"),
});
}
} catch (Exception e){
JOptionPane.showMessageDialog(rootPane, e);
}
Kemudian kembali ke design, double klik di Save Button
Tuliskan source codenya
try{
stat.executeUpdate("insert into partner values ("
+"'"+idpart.getText()+"',"
+"'"+namepart.getText()+"',"
+"'"+nopart.getText()+"',"
+"'"+alpart.getText()+"')");
kosongkan();
JOptionPane.showMessageDialog(null, "Succes Save Data");
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "Error to save because "+e);
}
DefaultTableModel t= new DefaultTableModel();
t.addColumn("ID Partner");
t.addColumn("Nama Partner");
t.addColumn("Kontak Partner");
t.addColumn("Alamat Partner");
table.setModel(t);
try{
res=stat.executeQuery("select * from partner");
while (res.next()){
t.addRow(new Object[]
{
res.getString("id_partner"),
res.getString("nama_partner"),
res.getString("nomor"),
res.getString("alamat"),
});
}
} catch (Exception e){
JOptionPane.showMessageDialog(rootPane, e);
Kemudian kembali ke design, double klik di textfield id
try{
res=stat.executeQuery("select * from partner where" + "id_partner='"+idpart.getText()
+"'"); while (res.next())
{
namepart.setText(res.getString("nama_partner"));
nopart.setText(res.getString("nomor"));
alpart.setText(res.getString("alamat"));
}
} catch (Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}
Kemudian kembali ke design, double klik di refresh button
Tuliskan source codenya
DefaultTableModel t= new DefaultTableModel();
t.addColumn("ID Partner");
t.addColumn("Nama Partner");
t.addColumn("Kontak Partner");
t.addColumn("Alamat Partner");
table.setModel(t);
try{
res=stat.executeQuery("select * from partner");
while (res.next()){
t.addRow(new Object[]
{
res.getString("id_partner"),
res.getString("nama_partner"),
res.getString("nomor"),
res.getString("alamat"),
});
}
} catch (Exception e){
JOptionPane.showMessageDialog(rootPane, e);
Kemudian kembali ke design, double klik di Back button
Tuliskan source codenya
new Home().setVisible(true);
dispose();
Kemudian kembali ke design, double klik di Hapus button
Tuliskan source codenya
int del=JOptionPane.showConfirmDialog(null, "Are you sure want to delete?", "Confirmation", JOptionPane.YES_NO_OPTION);
if(del==0){
try {
String sql="delete from partner where id_partner='"+idpart.getText()+"'";
PreparedStatement ps=con.prepareStatement(sql);
ps.executeUpdate();
JOptionPane.showMessageDialog(null, "Success delete data");
kosongkan();
} catch (Exception e){
JOptionPane.showMessageDialog(null, "Failed to delete");
}
DefaultTableModel t= new DefaultTableModel();
t.addColumn("ID Partner");
t.addColumn("Nama Partner");
t.addColumn("Kontak Partner");
t.addColumn("Alamat Partner");
table.setModel(t);
try{
res=stat.executeQuery("select * from partner");
while (res.next()){
t.addRow(new Object[]
{
res.getString("id_partner"),
res.getString("nama_partner"),
res.getString("nomor"),
res.getString("alamat"),
});
}
} catch (Exception e){
JOptionPane.showMessageDialog(rootPane, e);
}
}
private void tableMouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
int i = table.getSelectedRow();
if (i==-1){
return;
}
String code = (String)table.getValueAt(i, 0);
String code1 = (String)table.getValueAt(i, 1);
String code2 = (String)table.getValueAt(i, 2);
String code3 = (String)table.getValueAt(i, 3);
idpart.setText(code);
namepart.setText(code1);
nopart.setText(code2);
alpart.setText(code3);
Kemudian kembali ke design, double klik di Edit button
Tuliskan source codenya
int ok=JOptionPane.showConfirmDialog(null, "Are you sure want to update?", "Confirmation", JOptionPane.YES_NO_OPTION);
try {
t = "update partner set id_partner=?, nama_partner=?, nomor=?, alamat=? where id_partner='"+idpart.getText()+"'";
ps=con.prepareStatement(t);
if ( ok == JOptionPane.YES_OPTION){
try {
ps.setString(1, idpart.getText());
ps.setString(2, namepart.getText());
ps.setString(3, nopart.getText());
ps.setString(4, alpart.getText());
ps.executeUpdate();
JOptionPane.showMessageDialog(null, "Success Edit");
kosongkan();
} catch (Exception e){
JOptionPane.showMessageDialog(null, "Failed to Update");
}
}} catch (Exception e){}
DefaultTableModel t= new DefaultTableModel();
t.addColumn("ID Partner");
t.addColumn("Nama Partner");
t.addColumn("Kontak Partner");
t.addColumn("Alamat Partner");
table.setModel(t);
try{
res=stat.executeQuery("select * from partner");
while (res.next()){
t.addRow(new Object[]
{
res.getString("id_partner"),
res.getString("nama_partner"),
res.getString("nomor"),
res.getString("alamat"),
});
}
} catch (Exception e){
JOptionPane.showMessageDialog(rootPane, e);
}
0 comments:
Post a Comment