Facebook Twitter Gplus RSS
Home Java Contoh Sederhana Sistem Informasi Penjualan Menggunakan Java
formats

Contoh Sederhana Sistem Informasi Penjualan Menggunakan Java

Published on January 31, 2013, by in Java.

Program ini hanyalah contoh sederhana  mengenai sistem penjualan menggunakan Java Netbeans.

Screenshot tampilan programnya bisa di lihat dibawah ini, sebelumnya maaf klo sederhana banget.

1. Menu Utama

main menu

2. Form Master Barang

master barang

3. Form Master Karyawan

master karyawan

Untuk pembuatannya pertama kita buat databasenya dulu sebagai berikut:

CREATE DATABASE IF NOT EXISTS sis_penjualan;
USE sis_penjualan;
CREATE TABLE `detail` (
`no_faktur` varchar(9),
`qty_jual` int(10) unsigned,
`kd_barang` varchar(8),
`nama_barang` varchar(50),
`harga_jual` int(11),
`jumlah` bigint(21) unsigned
);

CREATE TABLE `barang` (
`kd_barang` varchar(8) NOT NULL,
`nama_barang` varchar(50) DEFAULT NULL,
`harga_beli` int(11) DEFAULT NULL,
`harga_jual` int(11) DEFAULT NULL,
`quantity` int(11) DEFAULT NULL,
PRIMARY KEY (`kd_barang`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `divisi` (
`kd_divisi` varchar(9) NOT NULL,
`divisi` varchar(45) NOT NULL,
`gapok` int(10) unsigned NOT NULL,
PRIMARY KEY (`kd_divisi`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `faktur` (
`no_faktur` varchar(9) NOT NULL DEFAULT '',
`kd_pelanggan` varchar(9) NOT NULL,
`tgl_jual` datetime NOT NULL,
`total_jual` int(11) NOT NULL,
`nik` varchar(9) NOT NULL,
`penerima` varchar(50) NOT NULL,
PRIMARY KEY (`no_faktur`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `karyawan` (
`nik` varchar(9) NOT NULL,
`nama` varchar(50) NOT NULL,
`alamat` varchar(50) NOT NULL,
`jk` varchar(5) NOT NULL,
PRIMARY KEY (`nik`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `pelanggan` (
`kd_pelanggan` varchar(9) NOT NULL,
`nama_pelanggan` varchar(50) NOT NULL,
`alamat` varchar(50) NOT NULL,
`no_telp` varchar(15) NOT NULL,
PRIMARY KEY (`kd_pelanggan`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `trans_jual` (
`no_faktur` varchar(9) NOT NULL,
`qty_jual` int(10) unsigned NOT NULL,
`kd_barang` varchar(9) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 

download database

download source code

2 Responses

  1. I was suggested this blog by my cousin.
    I am not sure whether this post is written by him as nobody else know such detailed about my difficulty.
    You are incredible! Thanks!

  2. What are good blog posts for a writer who wants to start a blog that even non-readers might want to visit?

Leave a Reply

Your email address will not be published. Required fields are marked *

*


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

© Media Belajar