Membuat Aplikasi menggunakan Database XAMPP

Membuat Aplikasi menggunakan Database XAMPP

 Untuk membuat form pembelian, kita perlu membuat data pembelian pada database.
Contohnya :
create table pembelian (
Id transaksi user char(50) not null primary key
Nama barang varchar(50) not null,
Harga barang varchar(50) not null,
Jumlah barang varchar(50),
Total varchar(50),
Diskon varchar(50) not null,
Jumlah bayar varchar(50) not null )

Untuk membuat database  pada netbeans dengan mengkoneksikan program XAMPP.

Berikut ini, source code form Pembelian pada Java Netbean :

/* * To change this template, choose Tools | Templates * and open the template in the editor.

*/ package tokomulya;

import java.awt.EventQueue;

import java.beans.Beans;

import java.util.ArrayList;

import java.util.List;

import javax.persistence.RollbackException;

import javax.swing.JFrame;

import javax.swing.JPanel;

/**

* @author Nurul

public class form_tokomulya extends JPanel {

   

    public form_tokomulya() {

        initComponents();

        if (!Beans.isDesignTime()) {

            entityManager.getTransaction().begin();

        }

    }

    private void deleteButtonActionPerformed(java.awt.event.ActionEvent evt) {                                            

        int[] selected = masterTable.getSelectedRows();

        List<tokomulya.Transaksi> toRemove = new ArrayList<tokomulya.Transaksi>(selected.length);

        for (int idx = 0; idx < selected.length; idx++) {

            tokomulya.Transaksi t = list.get(masterTable.convertRowIndexToModel(selected[idx]));

            toRemove.add(t);

            entityManager.remove(t);

        }

        list.removeAll(toRemove);

    }                                           

   

    private void newButtonActionPerformed(java.awt.event.ActionEvent evt) {                                         

        tokomulya.Transaksi t = new tokomulya.Transaksi();

        entityManager.persist(t);

        list.add(t);

        int row = list.size() - 1;

        masterTable.setRowSelectionInterval(row, row);

        masterTable.scrollRectToVisible(masterTable.getCellRect(row, 0, true));

    }                                         

   

    private void saveButtonActionPerformed(java.awt.event.ActionEvent evt) {                                          

        try {

            entityManager.getTransaction().commit();

            entityManager.getTransaction().begin();

        } catch (RollbackException rex) {

            rex.printStackTrace();

            entityManager.getTransaction().begin();

            List<tokomulya.Transaksi> merged = new ArrayList<tokomulya.Transaksi>(list.size());

            for (tokomulya.Transaksi t : list) {

                merged.add(entityManager.merge(t));

            }

            list.clear();

            list.addAll(merged);

        }

    }                                         

 private void jumlahBarangFieldFocusLost(java.awt.event.FocusEvent evt) {                                           

int a,b,c,d,e,f;a=Integer.parseInt(hargaBarangField.getText());

b=Integer.parseInt(jumlahBarangField.getText());

c=a*b;

totalField.setText(""+c);

d=Integer.parseInt(totalField.getText());

if (d>=50000){

e=d*5/100;

diskonField.setText(""+e);

f= c-e;

jumlahBayarField.setText(""+f);

}else if (d>100000){

e=d*10/100;

diskonField.setText(""+e);

f= c-e;

jumlahBayarField.setText(""+f);

   

}else {

c=a*b;

totalField.setText(""+c);

jumlahBayarField.setText(""+c);

}

private void jumlahBarangFieldFocusLost(java.awt.event.FocusEvent evt) {                                           

int a,b,c,d,e,f;a=Integer.parseInt(hargaBarangField.getText());

b=Integer.parseInt(jumlahBarangField.getText());

c=a*b;

totalField.setText(""+c);

d=Integer.parseInt(totalField.getText());

if (d>=50000){

e=d*5/100;

diskonField.setText(""+e);

f= c-e;

jumlahBayarField.setText(""+f);

}else if (d>100000){

e=d*10/100;

diskonField.setText(""+e);

f= c-e;

jumlahBayarField.setText(""+f);

   

}else {

c=a*b;

totalField.setText(""+c);

jumlahBayarField.setText(""+c);

}