Sales Inventory System in JAVA with database SQL

Hello guys please after you download this code please comment to improve my Code blogging and to inspire me blog more codes :) thanks and Godbless ..

ok so First Step download and unzip the files of the sourcode program ..

Step 1 : Unzip the files of the code ..

Step 2: Open the create a database name finaltipid and copy and paste the database source file below and paste into SQL command line please follow the image nad click GO to run the code ..

-- phpMyAdmin SQL Dump

-- version 3.3.9

-- http://www.phpmyadmin.net

-- Host: localhost

-- Generation Time: Oct 14, 2014 at 04:02 PM

-- Server version: 5.5.8

-- PHP Version: 5.3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

-- Database: `finaltipid`

-- --------------------------------------------------------

-- Table structure for table `bill`

CREATE TABLE IF NOT EXISTS `bill` (

`Stock_id` varchar(200) NOT NULL,

`Product_name` varchar(200) NOT NULL,

`qty` varchar(200) NOT NULL,

`price` varchar(200) NOT NULL,

`total` varchar(200) NOT NULL,

`date` varchar(200) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table `bill`

INSERT INTO `bill` (`Stock_id`, `Product_name`, `qty`, `price`, `total`, `date`) VALUES

('1455', 'Hp', '1', '1000', '1000', '10/14/14'),

('2589', 'Computer', '1', '10000', '10000', 'null');

-- --------------------------------------------------------

-- Table structure for table `customer`

CREATE TABLE IF NOT EXISTS `customer` (

`num` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(200) NOT NULL,

`lastname` varchar(200) NOT NULL,

`address` varchar(200) NOT NULL,

`city` varchar(200) NOT NULL,

`contact` varchar(200) NOT NULL,

`email` varchar(200) NOT NULL,

`gender` varchar(200) NOT NULL,

`date` varchar(200) NOT NULL,

PRIMARY KEY (`num`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

-- Dumping data for table `customer`

INSERT INTO `customer` (`num`, `name`, `lastname`, `address`, `city`, `contact`, `email`, `gender`, `date`) VALUES

(4, 'gezel', 'ramos', 'mangaldan', 'dagupan', '09096333336666', 'gezel@yahoo.com', 'Female', '10/7/14'),

(5, 'girlie', 'instagram', 'san fabian', 'dagupan city', '0696633696', 'Female', 'Female', '10/7/14'),

(6, 'gezzele', 'pangilinan', 'la union', 'dagupan ', '069754', 'Male', 'Female', '10/8/14'),

(7, 'girlie', 'ramos', 'mangaldan', 'dagupan', '06966333', '@yahoo.com', 'Male', '10/8/14'),

(8, 'gezels', 'ramos', 'mangaldan', 'dagupan', '09096333336666', 'Female', 'Male', '10/12/14'),

(10, 'irsh', 'prado', 'dagupan', 'dagupan', '6546464', 'Male', 'Female', '10/14/14'),

(13, 'philips', 'gwapos', 'sta barbara', 'dagupan', '09098888', 'Male', 'Male', '10/16/14');

-- --------------------------------------------------------

-- Table structure for table `employee`

CREATE TABLE IF NOT EXISTS `employee` (

`emp_num` varchar(2000) NOT NULL,

`name` varchar(200) NOT NULL,

`lastname` varchar(200) NOT NULL,

`address` varchar(200) NOT NULL,

`contact` varchar(200) NOT NULL,

`email` varchar(200) NOT NULL,

`age` varchar(200) NOT NULL,

`gender` varchar(200) NOT NULL,

`date` varchar(200) NOT NULL,

`position` varchar(200) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table `employee`

INSERT INTO `employee` (`emp_num`, `name`, `lastname`, `address`, `contact`, `email`, `age`, `gender`, `date`, `position`) VALUES

('', 'dasd', 'dsad', 'asdas', 'das', 'ddasd', 'asdas', 'Female', '10/11/14', 'Technician'),

('', 'dasdsss', 'dsad', 'fdasf', 'fadfa', 'sadagfdgdf', '21', 'Male', '10/11/14', 'Manager'),

('', 'ds', 'dss', 'sfds', 'fdsf', 'dsfsd', 'fsdf', 'Female', '10/11/14', 'Manager'),

('', 'ds', 'dss', 'sfds', 'fdsf', 'dsfsd', 'fsdf', 'Male', '10/11/14', 'Manager'),

('', 'philip', 'dsadss', 'asdasss', 'das', 'ddasd', 'asdas', 'Male', '10/11/14', 'Manager'),

('245', 'sd', 'adsa', 'dsad', 'asdas', 'das', 'dasdas', 'Male', '10/11/14', 'Manager'),

('256699', 'irish', 'prado', 'sta barbara', '09666', 'Irish@yahoo.com', '21', 'Female', '10/12/14', 'Technician');

-- --------------------------------------------------------

-- Table structure for table `info`

CREATE TABLE IF NOT EXISTS `info` (

`inum` varchar(100) NOT NULL,

`name` varchar(200) NOT NULL,

`lastname` varchar(200) NOT NULL,

`address` varchar(200) NOT NULL,

`contact` varchar(200) NOT NULL,

`date` varchar(200) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table `info`

INSERT INTO `info` (`inum`, `name`, `lastname`, `address`, `contact`, `date`) VALUES

('6', 'gezzele', 'pangilinan', 'la union', '069754', '10/14/14'),

('5', 'girlie', 'instagram', 'san fabian', '0696633696', '10/14/14'),

('6', 'gezzele', 'pangilinan', 'la union', '069754', '10/14/14'),

('7', 'girlie', 'ramos', 'mangaldan', '06966333', '10/14/14'),

('5', 'girlie', 'instagram', 'san fabian', '0696633696', '10/14/14'),

('8', 'gezels', 'ramos', 'mangaldan', '09096333336666', '10/14/14'),

('6', 'gezzele', 'pangilinan', 'la union', '069754', '10/14/14'),

('13', 'philips', 'gwapos', 'sta barbara', '09098888', '10/14/14'),

('5', 'girlie', 'instagram', 'san fabian', '0696633696', '10/14/14'),

('4', 'gezel', 'ramos', 'mangaldan', '09096333336666', '10/14/14'),

('8', 'gezels', 'ramos', 'mangaldan', '09096333336666', '10/14/14'),

('7', 'girlie', 'ramos', 'mangaldan', '06966333', '10/14/14'),

('5', 'girlie', 'instagram', 'san fabian', '0696633696', '10/14/14'),

('8', 'gezels', 'ramos', 'mangaldan', '09096333336666', '10/14/14'),

('4', 'gezel', 'ramos', 'mangaldan', '09096333336666', '10/14/14'),

('7', 'girlie', 'ramos', 'mangaldan', '06966333', '10/14/14'),

('8', 'gezels', 'ramos', 'mangaldan', '09096333336666', '10/14/14'),

('10', 'irsh', 'prado', 'dagupan', '6546464', '10/14/14'),

('8', 'gezels', 'ramos', 'mangaldan', '09096333336666', '10/14/14'),

('7', 'girlie', 'ramos', 'mangaldan', '06966333', '10/14/14'),

('8', 'gezels', 'ramos', 'mangaldan', '09096333336666', '10/14/14'),

('7', 'girlie', 'ramos', 'mangaldan', '06966333', '10/14/14'),

('10', 'irsh', 'prado', 'dagupan', '6546464', '10/14/14'),

('7', 'girlie', 'ramos', 'mangaldan', '06966333', '10/14/14'),

('10', 'irsh', 'prado', 'dagupan', '6546464', '10/14/14'),

('6', 'gezzele', 'pangilinan', 'la union', '069754', '10/14/14'),

('10', 'irsh', 'prado', 'dagupan', '6546464', '10/14/14'),

('8', 'gezels', 'ramos', 'mangaldan', '09096333336666', '10/14/14'),

('10', 'irsh', 'prado', 'dagupan', '6546464', '10/14/14'),

('7', 'girlie', 'ramos', 'mangaldan', '06966333', '10/14/14'),

('6', 'gezzele', 'pangilinan', 'la union', '069754', '10/14/14'),

('7', 'girlie', 'ramos', 'mangaldan', '06966333', '10/14/14');

-- --------------------------------------------------------

-- Table structure for table `payment`

CREATE TABLE IF NOT EXISTS `payment` (

`nums` int(11) NOT NULL AUTO_INCREMENT,

`total` varchar(100) NOT NULL,

`discount` varchar(100) NOT NULL,

`grandtotal` varchar(100) NOT NULL,

PRIMARY KEY (`nums`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;

-- Dumping data for table `payment`

INSERT INTO `payment` (`nums`, `total`, `discount`, `grandtotal`) VALUES

(50, '11000', '10', '9900');

-- --------------------------------------------------------

-- Table structure for table `product`

CREATE TABLE IF NOT EXISTS `product` (

`stockid` varchar(200) NOT NULL,

`productname` varchar(200) NOT NULL,

`features` varchar(200) NOT NULL,

`price` varchar(200) NOT NULL,

`total` varchar(200) NOT NULL,

`supplier` varchar(100) NOT NULL,

`date` mediumtext NOT NULL,

`inserts` varchar(10000) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table `product`

INSERT INTO `product` (`stockid`, `productname`, `features`, `price`, `total`, `supplier`, `date`, `inserts`) VALUES

('576', 'Laptop', 'AMD', '1000', '1000', 'AMD', '10/14/14', 'admin');

-- --------------------------------------------------------

-- Table structure for table `stockout`

CREATE TABLE IF NOT EXISTS `stockout` (

`Stock_id` varchar(200) NOT NULL,

`Product_name` varchar(200) NOT NULL,

`qty` varchar(200) NOT NULL,

`price` varchar(200) NOT NULL,

`total` varchar(200) NOT NULL,

`date` varchar(20) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table `stockout`

INSERT INTO `stockout` (`Stock_id`, `Product_name`, `qty`, `price`, `total`, `date`) VALUES

('1455', 'Hp', '1', '1000', '1000', '10/14/14'),

('2589', 'Computer', '1', '10000', '10000', 'null');

-- --------------------------------------------------------

-- Table structure for table `supplier`

CREATE TABLE IF NOT EXISTS `supplier` (

`supplier` varchar(20) NOT NULL,

`supplier_add` varchar(200) NOT NULL,

`supplier_contact` varchar(200) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table `supplier`

INSERT INTO `supplier` (`supplier`, `supplier_add`, `supplier_contact`) VALUES

('cisco', 'sta barbara', '06986663'),

('hp', 'manila', '06966'),

('Hp', 'Manila', '06966'),

('AMD', 'manila', '096688'),

('Intel', 'Manila', '096666');

-- --------------------------------------------------------

-- Table structure for table `tbluser`

CREATE TABLE IF NOT EXISTS `tbluser` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`username` varchar(200) NOT NULL,

`user_pass` varchar(200) NOT NULL,

`name` varchar(200) NOT NULL,

`usertype` varchar(200) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

-- Dumping data for table `tbluser`

INSERT INTO `tbluser` (`id`, `username`, `user_pass`, `name`, `usertype`) VALUES

(1, 'admin', 'admin', 'gerlie', 'administrator'),

(2, 'admins', 'admins', 'admin', 'Administrator'),

(3, '123', '123', '123', 'assistant'),

(4, 'gez', 'gez', 'gez', 'administrator'),

(5, 'phi', 'phi', 'phi', 'assistant'),

(6, 'user', 'user', 'user', 'assistant'),

(7, '1234', '1234', '1234', 'assistant'),

(8, 'gez', 'gez', 'gez', 'administrator');

Step 3: After executing the command in database and successful you can now open the netbeans in my case i used netbeans vesrsion 8.0.2 open the project and find the source code files and then run the program..

Step 4: this is the final output of the program ..

for admin module 1.1

module 1.2 main page for admin

module 1.3

module 1.4

module 1.5

module 1.6

module 1.7

module 1.8

module 1.9

module 1.10

module 1.11

module 1.12

For user Module 1.1

Module 1.2

Module 1.3

Sorry guys for this system hopefully that you can used this for your advance coding for beginner and hopefully you leave a comment bellow about this to inspire me creating ang sharing code happy coding :)

please email me if there is error in this system actually i create this system almost 5hours and 30 mins only so if you encountered error please email me and i will debug this for you but this system is 90% running :)

Download the source code at a seconds ..

Download the file...

DOWNLOAD THE LIBRARY AT THIS LINK: LIB LINK

Follow me in my google: https://plus.google.com/118054808074315176404

Like my page for more codes to come : https://www.facebook.com/Educatorcode/

please leave a comment after you test the code or you can email me in my account maruph01@yahoo.com thanks and enjoy coding guys :)

Pitscon Academy

Sales Inventory System in JAVA with database SQL

If You Enjoyed This, Take 5 Seconds To Share It

2 comments:

Search

Popular Posts

Total Pageviews