Database Java dengan MySQL

Pada project ini terdapat dua file yaitu :

= bahan.java =

/**

author@adhi cahyaningrat

*/

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

import java.sql.*;

public class bahan{

public bahan(){

final JButton btnHasil;

try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();

}

catch (Exception exc){

System.err.println("Error = " +exc);

}

final JFrame f = new JFrame ("bahan");

final JLabel No = new JLabel("No");

JLabel kecepatan = new JLabel ("massa");

JLabel waktu = new JLabel ("percepatan");

JLabel jarak = new JLabel ("gaya");

final JTextField FieldNo = new JTextField(20);

final JTextField Fieldkecepatan = new JTextField (20);

final JTextField Fieldwaktu = new JTextField (20);

final JTextField Fieldjarak = new JTextField (20);

btnHasil = new JButton("hasil");

btnHasil.setMnemonic('H');

btnHasil.addActionListener(new ActionListener () {tn

public void actionPerformed (ActionEvent e){

if (e.getSource () == btnHasil){

double s = (Double.parseDouble(Fieldkecepatan.getText().trim()));

double t = (Double.parseDouble(Fieldwaktu.getText().trim()));

double jarak = s*t;

Fieldjarak.setText(String.valueOf (jarak));

}

}

});

JButton btnbahan = new JButton("Edit Data");

btnbahan.setMnemonic('e');

btnbahan.addActionListener(new ActionListener () {

public void actionPerformed (ActionEvent e) {

String sql = "update gaya set Hasil ="

+ Fieldjarak.getText() + ", waktu = "+Fieldwaktu.getText()+" where No="

+ FieldNo.getText().trim();

if (FieldNo.getText().trim().equals("")) {

JOptionPane.showMessageDialog(f, "field masih kosong!",

"Simpan data",JOptionPane.WARNING_MESSAGE);

FieldNo.requestFocus();

}

else {

try {

Connection conn = DriverManager.getConnection("jdbc:odbc:gaya");

Statement statement=conn.createStatement();

statement.executeUpdate(sql);

statement.close();

FieldNo.setText("");

Fieldkecepatan.setText("");

Fieldwaktu.setText("");

Fieldjarak.setText("");

FieldNo.requestFocus();

}

catch (Exception exc) {

System.err.println(sql);

System.err.println("Error:" + exc);

}

}

}

});

JButton btnClear = new JButton("clear ");

btnClear.setMnemonic ('c');

btnClear.addActionListener(new ActionListener() {

public void actionPerformed (ActionEvent e) {

FieldNo.setText("");

Fieldkecepatan.setText("");

Fieldwaktu.setText("");

Fieldjarak.setText("");

FieldNo.requestFocus();

}

});

JButton btnSimpan = new JButton("Simpan Data");

btnSimpan.setMnemonic('S');

btnSimpan.addActionListener(new ActionListener () {

public void actionPerformed (ActionEvent e) {

String sql = "insert into gaya values ('"

+ FieldNo.getText() +"','"

+ Fieldkecepatan.getText() + "','"

+ Fieldwaktu.getText() + "','"

+ Fieldjarak.getText() + "')";

if (FieldNo.getText().trim().equals("")) {

JOptionPane.showMessageDialog(f, "field masih kosong!",

"Simpan data",JOptionPane.WARNING_MESSAGE);

}

else {

try {

Connection conn = DriverManager.getConnection("jdbc:odbc:gaya");

Statement statement=conn.createStatement();

statement.executeUpdate(sql);

statement.close();

FieldNo.setText("");

Fieldkecepatan.setText("");

Fieldwaktu.setText("");

Fieldjarak.setText("");

FieldNo.requestFocus();

}

catch (Exception exc) {

System.err.println("Error:" + exc);

}

}

}

});

JButton btnHapus = new JButton("Hapus Data");

btnHapus.setMnemonic('p');

btnHapus.addActionListener(new ActionListener () {

public void actionPerformed (ActionEvent e) {

String sql = "delete from gaya where No='"

+ FieldNo.getText().trim() + "'";

if (FieldNo.getText().trim().equals("")) {

JOptionPane.showMessageDialog(f, "field masih kosong!",

"Simpan data",JOptionPane.WARNING_MESSAGE);

FieldNo.requestFocus();

}

else {

try {

Connection conn = DriverManager.getConnection("jdbc:odbc:gaya");

Statement statement=conn.createStatement();

statement.executeUpdate(sql);

statement.close();

FieldNo.setText("");

Fieldkecepatan.setText("");

Fieldwaktu.setText("");

Fieldjarak.setText("");

FieldNo.requestFocus();

}

catch (Exception exc) {

System.err.println(sql);

System.err.println("Error:" + exc);

}

}

}

});

Container konten;

konten=f.getContentPane();

konten.setLayout(new GridBagLayout());

GridBagConstraints pos = new GridBagConstraints();

pos.anchor=GridBagConstraints.WEST;

pos.gridx=7;

pos.gridy=10;

konten.add(No,pos);

pos.gridx ++;

konten.add(FieldNo,pos);

pos.gridx = 7;

pos.gridy ++;

konten.add(kecepatan,pos);

pos.gridx ++;

konten.add(Fieldkecepatan,pos);

pos.gridy ++;

pos.gridx = 7;

konten.add(waktu,pos);

pos.gridx ++;

konten.add(Fieldwaktu,pos);

pos.gridy ++;

pos.gridx = 7;

konten.add(jarak,pos);

pos.gridx ++;

konten.add(Fieldjarak,pos);

pos.gridy ++;

pos.gridx = 7;

konten.add(btnHasil,pos);

pos.gridx ++;

konten.add(btnClear,pos);

pos.gridy ++;

pos.gridx = 7;

konten.add(btnbahan,pos);

pos.gridx ++;

konten.add(btnSimpan,pos);

pos.gridx ++;

konten.add(btnHapus,pos);

pos.gridx ++;

f.pack();

f.setVisible(true);

f.setLocationRelativeTo(null);

}

}

= gaya.java =

/**

author@adhi cahyaningrat

*/

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

public class gaya extends JFrame{

private JFrame f = new JFrame("DATABASE PERHITUNGAN GAYA (KELOMPOK 1)");

private JLabel jLabel1 = new JLabel("Adhy Cahyaningrat"),

jLabel2 = new JLabel("Pizaini"),

jLabel3 = new JLabel("Jelly"),

jLabel4 = new JLabel("Heru Wibowo"),

jLabel5 = new JLabel("Rivai Frolan");

private JMenuBar jMenuBar1 = new javax.swing.JMenuBar();

private JMenu jMenu1 = new javax.swing.JMenu();

private JMenuItem jMenuItem3 = new javax.swing.JMenuItem();

private JButton jButton1 = new JButton(" Data ");

private JPanel jPanel1 = new JPanel();

public gaya(){

f.getContentPane().setLayout(null);

jButton1.setBounds(150,150,250,20);

f.getContentPane().add(jButton1);

jLabel1.setBounds(220,25,200,20);

f.getContentPane().add(jLabel1);

jLabel2.setBounds(230,40,200,20);

f.getContentPane().add(jLabel2);

jLabel3.setBounds(240,55,200,20);

f.getContentPane().add(jLabel3);

jLabel4.setBounds(250,70,200,20);

f.getContentPane().add(jLabel4);

jLabel5.setBounds(260,85,200,20);

f.getContentPane().add(jLabel5);

jButton1.addActionListener(new ActionListener(){

public void actionPerformed(ActionEvent e){

new bahan();

}

});

f.setSize(600,350);

f.setVisible(true);

f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

f.setLocationRelativeTo(null);

}

public static void main(String args[]){

new gaya();

}

}