Some Mysql stored procedure example

DELIMITER $$

CREATE DEFINER=`root`@`%` FUNCTION `titlecase`(input TEXT) RETURNS text CHARSET latin1
BEGIN
DECLARE pointercari INT;
DECLARE pointerlama INT;
DECLARE n INT;
DECLARE output TEXT;
SET n := LENGTH(input);

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".

Learn From Sun Tzu

- War is a matter of vital importance to the state. It is a matter of life and death, survival or ruin

- No nation has ever benefitted from prolonged war
Pre-War:
- Know your enemy and know yourself and in 100 battles you will from never be in Peril