MVC, duet: Ubuntu, MySQL, Java, Netbeans, Tomcat, ZK, iReport (part 6)

Laporan Rekap Transaksi - iReport
1. Open explorer, locate project "pfm", open folder "web", then create a folder named "laporan".
2. Open folder "iReport-3.0.0"
3. Right click "open" or just double click on file "iReport.sh", if question appear, choose "execute".
4. After iReport appear, press "ctrl+n". Appear window "Report properties", set option as you wish, don't forget to give a name with "rekap transaksi".

MVC, duet: Ubuntu, MySQL, Java, Netbeans, Tomcat, ZK, iReport (Part 5)

MVC, duet: Ubuntu, MySQL, Java, Netbeans, Tomcat, ZK, iReport (Part 4)

Create a new project
1. Open the Netbeans
2. Create a new project by opening the menu "File"> "New Project ..." ("ctrl + shift + n"), it will display the "New Project ".
3. In the "Categories", select "Java Web". In the "Projects", select "ZK363 Application". Click the "Next>".
4. Name the project "PFM" and specify the storage location. Click the "Finish".
5. In the window "Project" appears a new project with the name of the PFM. Right-click and select "Properties", then it will appear the window "Project Properties - PFM".
6. In the category "Sources", change "Sources / Binary Format" into the JDK version that the highest (this time JDK6).

MVC, duet: Ubuntu, MySQL, Java, Netbeans, Tomcat, ZK, iReport (Part 3)

Creating a container for all objects that can be used (result: object-pfm.jar)
Actually at the time of implementation, the project was made ​​in the midst of development, not before making project, but, as it requires a process and the modified source code, it does not need to be shown all the process. Only the last process that is so, it is shown. So, readers do not have a headache, just developers that feel. The explanation will be divided per file. Maybe there is some code that is never used in this tutorial at all, but still displayed because it is important to note and add insight.

The first step
1. Create a new project named "object-PFM".

MVC, duet: Ubuntu, MySQL, Java, Netbeans, Tomcat, ZK, iReport (Part 2)

Making a connection to the database:1. Open the Netbeans2. In the "Services" window, right click on "Databases", select "New Connection",  then pop up, "New Database Connection" window.
3. Fill existing items as you wish, for example: host = localhost, port = 3306, database = PFM, username = root, password = root. Check "Remember password" option.
4. Press the "OK".

Creating a model for the database (results: dao-persistence-pfm.jar):
1. Open the Netbeans

MVC, duet: Ubuntu, MySQL, Java, NetBeans, Tomcat, ZK, iReport (Part 1)

Database:The design of the database is made as simple as possible for ease in understanding. Do not get dizzy first before the war. For the connections will be staying in are generated from Netbeans, but patiently, one at a time. Each table must have primary keys.

CREATE TABLE  `pfm`.`item` (  `iditem` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'primary key', `namaitem` varchar(20) NOT NULL COMMENT 'transaction item name',  `alurkas` tinyint(4) unsigned NOT NULL COMMENT 'cash flow, in: 1, out: 0',  PRIMARY KEY (`iditem`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='transaction item';

MVC, duet: Ubuntu, MySQL, Java, NetBeans, Tomcat, ZK, iReport (Preparation)

Model View Controller (MVC)MVC is a software architecture, which is currently used as a pattern-making in manufacturing engineering software. The pattern of the isolate "the realm of logic" (logic applications to users) from the interface (input and presentation), an independent development, testing and maintenance for each component separately.
Though MVC comes offer different flavors, control flow generally as follows:1. Users interact with the interface in different ways, for example, pressing the mouse, drag & drop, hit enter.