Date : 7th January 2009
Event : ELTP-19 first Anniversary
Place : KFC at Petronas Equine
Web Gallery : Picasa Picture Gallery

1. Amin
2. Anor
3. Audrey
4. Azlan
5. Bahyah
6. Bai
7. Chitra
8. Faizah
9. Fong
10. Hafiz
11. Haikal
12. Hairos
13. Intan
14. Izzati
15. Jeeva
16. Joanna
17. Joshua
18. Jothi
19. Kalai
20. Komathi
21. Kumar
22. Lihin
23. Liza
24. Mun Kit
25. Phooi Yee
26. Praveen
27. Raveen
28. Rehan
29. Ronny
30. Saad
31. Safura
32. Saha
33. Selvan
34. Shangiri
35. Sharmili
36. Suga
37. Sumi
38. Suren
39. Suresh
40. Thava
41. VJ
42. Wong Yee Hung
43. Yasmin

Elm Tree, the noble-mindedness (January 12 to January 24)

Pleasant shape, tasteful clothes, modest demands, tends not forgive mistakes, cheerful, likes to lead but not to obey, honest unfaithful partner, tends to a know-all-attitude and making decisions for others, noble-minded, generous, good sense of humour, practical.

Cypress, the Faithfulness (January 25 to February 3)

Strong, muscular, adaptable, takes what life has to give, happy,content,optimistic, needs enough money and acknowledgment, hates loneliness, passionate lover which cannot be satisfied, faithful, quick-tempered,unruly, pedantic and careless.

Poplar, the Uncertainty (February 4 to February 8)

Looks very decorative, no self-confident behaviour, only courageous if necessary, needs goodwill and pleasant surroundings, very choosy, often lonely, great animosity, artistic nature, good organiser, tends to philosophy, reliable in any situation, takes partnership serious.

Cedar, the Confidence (February 9 to February 18)

Of rare beauty, knows how to adapt, likes luxury, of good health not in the least shy, tends to look down on others, self-confident, determined, impatient, wants to impress others, many talents, industrious, healthy, optimism, waiting for the one true love, able to make quick decisions.

Pine Tree, the Particularity (February 19 to February 28)

Loves agreeable company, very robust, knows how to make life comfortable, very active, natural, good companion, but seldom friendly, falls easily in love but its passion burns out quickly, gives up easily, many disappointments till it finds its ideal, trustworthy, practical.

Weeping Willow, the Melancholy (March 1 to March 10)

Beautiful but full of melancholy, attractive, very empathic, loves anything beautiful and tasteful, loves to travel, dreamer, restless, capricious, honest, can be influenced but is not easy to live with, demanding, good intuition, suffers in love but finds sometimes an anchoring partner.

Lime Tree, the Doubt (March 11 to March 20)

Accepts what life dishes out in a composed way, hates fighting, stress and labour, tends to laziness and idleness, soft and relenting, makes sacrifices for friends, many talents but not tenacious enough to make them blossom, often wailing and complaining, very jealous, loyal.

Oak, robust nature (March 21)

Courageous, strong, unrelenting, independent, sensible, does not love changes, keeps its feet on the ground, person of action.

Hazelnut Tree, the Extraordinary (March 22 to March 31)

Charming, undemanding, very understanding, knows how to make an impression, active fighter for social cause, popular, moody and capricious lover, honest and tolerant partner, precise sense of judgement.

Rowan, the Sensitivity (April 1 to April 10)

Full of charm, cheerful, gifted, without egoism, likes to draw attention, loves life, motion, unrest and even complications, is both dependent and independent, good taste, artistic, passionate, emotional, good company, does not forgive.

Maple, Independence of Mind (April 11 to April 20)

No ordinary person, full imagination and originality, shy and reserved, ambitious, proud, self respect, hungers for new experiences, sometimes nervous, many complexes, good memory, learns easily, complicated love life, wants to impress.

Walnut Tree, the Passion (April 21 to April 30)

Unrelenting, strange and full of contrasts, often egoistic, aggressive, noble, broad horizon, unexpected reactions, spontaneous, unlimited ambition, no flexibility, difficult and uncommon partner, not always liked but often admired, ingenious strategist, very jealous and passionate, no compromises.

Poplar, the Uncertainty (May 1 to May 14)

Looks very decorative, no self-confident behaviour, only courageous if necessary, needs goodwill and pleasant surroundings, very choosy, often lonely, great animosity, artistic nature, good organiser, tends to philosophy, reliable in any situation, takes partnership serious.

Chestnut Tree, the Honesty (May 15 to May 24)

Of unusual beauty, does not want to impress, well-developed sense of justice, vivacious, interested, a born diplomat, but irritable and sensitive in company, often due to a lack of self-confidence, acts sometimes superior, feels not understood, loves only once, has difficulties in finding a partner.

Ash Tree, the Ambition (May 25 to June 3)

Uncommonly attractive, vivacious, impulsive, demanding, does not care for criticism, ambitious, intelligent, talented, likes to play with its fate, can be egoistic, very reliable and trustworthy, faithful and prudent lover, sometimes brains rule over heart, but takes partnership very serious.

Hornbeam, the good taste (June 4 to June 13)

Of cool beauty, cares for its looks and condition, good taste, tends to egoism, makes life as comfortable as possible, leads reasonable, disciplined life, looks for kindness, an emotional partner and acknowledgment, dreams of unusual lovers, is seldom happy with her feelings, mistrusts most people, is never sure of its decisions, very conscientious.

Fig Tree, the Sensibility (June 14 to June 23)

Very strong, a bit self-willed, independent, does not allow contradiction or arguments, loves life, its family, children and animals, a bit of a butterfly, good sense of humour, likes idleness and laziness, of practical talent and intelligence.

Birch, the Inspiration (June 24)

Vivacious, attractive, elegant, friendly, unpretentious,modest, does not like anything in excess, abhors the vulgar, loves life in nature and in calm, not very passionate, full of imagination, little ambition, creates a calm and content atmosphere.

Apple Tree, the Love (June 25 to July 4)

Of slight build, lots of charm, appeal and attraction, pleasant aura, flirtatious, adventurous, sensitive, always in love, wants to love and be loved, faithful and tender partner, very generous, scientific talents, lives for today, a carefree philosopher with imagination.

Fir Tree, the Mysterious (July 5 to July 14)

Extraordinary taste, dignity, cultivated airs, loves anything beautiful, moody, stubborn, tends to egoism but cares for those close to it,rather modest, very ambitious, talented, industrious uncontent lover, many friends, many foes, very reliable.

Elm Tree, the noble-mindedness (July 15 to July 25)

Pleasant shape, tasteful clothes, modest demands, tends not forgive mistakes, cheerful, likes to lead but not to obey, honest unfaithful partner, tends to a know-all-attitude and making decisions for others, noble-minded, generous, good sense of humour, practical.

Cypress, the Faithfulness (July 26 to August 4)

Strong, muscular, adaptable, takes what life has to give, happy,content,optimistic, needs enough money and acknowledgment, hates loneliness, passionate lover which cannot be satisfied, faithful, quick-tempered,unruly, pedantic and careless.

Poplar, the Uncertainty (August 5 to August 14)

Looks very decorative, no self-confident behaviour, only courageous if necessary, needs goodwill and pleasant surroundings, very choosy, often lonely, great animosity, artistic nature, good organiser, tends to philosophy, reliable in any situation, takes partnership serious.

Cedar, the Confidence (August 15 to August 23)

Of rare beauty, knows how to adapt, likes luxury, of good health not in the least shy, tends to look down on others, self-confident, determined, impatient, wants to impress others, many talents, industrious, healthy, optimism, waiting for the one true love, able to make quick decisions.

Pine Tree, the Particularity (August 24 to September 2)

Loves agreeable company, very robust, knows how to make life comfortable, very active, natural, good companion, but seldom friendly, falls easily in love but its passion burns out quickly, gives up easily, many disappointments till it finds its ideal, trustworthy, practical.

Weeping Willow, the Melancholy (September 3 to September 12)

Beautiful but full of melancholy, attractive, very empathic, loves anything beautiful and tasteful, loves to travel, dreamer, restless, capricious, honest, can be influenced but is not easy to live with, demanding, good intuition, suffers in love but finds sometimes an anchoring partner.

Lime Tree, the Doubt (September 13 to September 22)

Accepts what life dishes out in a composed way, hates fighting, stress and labour, tends to laziness and idleness, soft and relenting, makes sacrifices for friends, many talents but not tenacious enough to make them blossom, often wailing and complaining, very jealous, loyal.

Olive Tree, the Wisdom (September 23)

Loves sun, warmth and kind feelings, reasonable, balanced, avoids aggression and violence, tolerant, cheerful, calm, well-developed sense of justice, sensitive, empathic, free of jealousy, loves to read and the company of sophisticated people.

Hazelnut Tree, the Extraordinary (September 24 to October 3)

Charming, undemanding, very understanding, knows how to make an impression, active fighter for social cause, popular, moody and capricious lover, honest and tolerant partner, precise sense of judgement.

Rowan, the Sensitivity (October 4 to October 13)

Full of charm, cheerful, gifted, without egoism, likes to draw attention, loves life, motion, unrest and even complications, is both dependent and independent, good taste, artistic, passionate, emotional, good company, does not forgive.

Maple, Independence of Mind (October 14 to October 23)

No ordinary person, full imagination and originality, shy and reserved, ambitious, proud, self-respect, hungers for new experiences, sometimes nervous, many complexes, good memory, learns easily, complicated love life, wants to impress.

Walnut Tree, the Passion (October 24 to November 11)

Unrelenting, strange and full of contrasts, often egoistic, aggressive, noble, broad horizon, unexpected reactions, spontaneous, unlimited ambition, no flexibility, difficult and uncommon partner, not always liked but often admired, ingenious strategist, very jealous and passionate, no compromises.

Chestnut Tree, the Honesty (November 12 to November 21)

Of unusual beauty, does not want to impress, well-developed sense of justice, vivacious, interested, a born diplomat, but irritable and sensitive in company, often due to a lack of self-confidence, acts sometimes superior, feels not understood, loves only once, has difficulties in finding a partner.

Ash Tree, the Ambition (November 22 to December 1)

Uncommonly attractive, vivacious, impulsive, demanding, does not care for criticism, ambitious, intelligent, talented, likes to play with its fate, can be egoistic, very reliable and trustworthy, faithful and prudent lover, sometimes brains rule over heart, but takes partnership very serious.

Hornbeam, the good taste (December 2 to December 11)

Of cool beauty, cares for its looks and condition, good taste, tends to egoism, makes life as comfortable as possible, leads reasonable, disciplined life, looks for kindness, an emotional partner and acknowledgment, dreams of unusual lovers, is seldom happy with her feelings, mistrusts most people, is never sure of its decisions, very conscientious.

Fig Tree, the Sensibility (December 12 to December 21)

Very strong, a bit self-willed, independent, does not allow contradiction or arguments, loves life, its family, children and animals, a bit of a butterfly, good sense of humour, likes idleness and laziness, of practical talent and intelligence.

Beech, the Creative (December 22)

Has good taste, concerned about its looks, materialist, good organisation of life and career, economical, good leader, takes no unnecessary risks, reasonable, splendid lifetime companion, keen on keeping fit (diets, sports, etc.).

Another way to access database without using applicationContext.xml is as follows :

DriverManagerDataSource dataSource = new DriverManagerDataSource();
dataSource.setDriverClassName("oracle.jdbc.driver.OracleDriver");
dataSource.setUrl("jdbc:oracle:thin:@localhost:1521:XE");
dataSource.setUsername("username");
dataSource.setPassword("pwd");
JdbcTemplate jt = new JdbcTemplate(dataSource);

Just place it in your controller and you're done. ;)

Alright, now we'll move on to database connectivity. First create a table for our login, we only need 2 attributes, username and password, name the table as login or any name you like. In this example, i used Oracle. Basically its the same with any other database, MySQL..etc.. The difference is the class driver name and such. Here we'll simplify things by NOT using validator..and use javascript to validate fields. Much much easier..unless we're familiar with validators.

This example is done as per my understanding. You might approach this example in different way, which im sure there are lots. So if you think there's another way to do this, please feel free to comment. Share the knowledge :P

We're dropping off validator class, so you can dereference it from your bean by removing the <property name="validator"><ref bean="loginValidator"/></property> line from dispatcher-servlet.xml. Theres no further changes in that xml file. Create a simple jsp, name it as failure. jsp.

There's 2 ways to database connectivity, one is by normal JDBC, the other using Hibernate. This example uses JDBC (i'm too lazy to learn hibernate now, so i use JDBC :P) This connectivity using Springs is slightly different from Struts. So whatever you learnt in Struts u can forget it temporarily. Spring uses JDBC template in handling data access. This is not the only way. There are other ways, but so far ive found the template to be most used. Just remember to keep SpringSource website as your best friend.

One advantage of JdbcTemplate is it cleans-up the resources automatically, e.g. release the database connections. The template class of Spring is JdbcTemplate. A dataSource is provided inside JdbcTemplate.

We'll create 2 java classes, one interface and the other implementing it. We can also use just one class instead of 2. But i'll show that in the Part 4 series. So for now i'll stick to 2 classes.

Create a package called Connection. Create datacon.java in that package. (Actually this is not really the way to declare classes or packages. But for our understanding's sake we differentiate it this way) Add these lines :

public interface datacon {
public DataSource dbcon(); //don't forget to import javax.sql.DataSource
}

Create dataconimpl.java inside the same package. Add the following lines :

public class dataconimpl implements datacon{
private DataSource dataSource; //don't forget to import javax.sql.DataSource
public void setDataSource(DataSource ds) {
dataSource = ds;
}
public DataSource dbcon() {
return dataSource;
}
}

These 2 classes are referred from this page.

Now we'll see on applicationContext.xml. If you notice in that file, theres few lines of code commented. For some reason those codes are not working properly, so ive tried different way. That will be explained later once ive managed to run the application successfully. So in this file, add these lines,

<bean id="datacon" class="Connection.dataconimpl">
<property name="dataSource">
<ref local="dataSource"/>
</property>
</bean>

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
<property name="url" value="jdbc:oracle:thin:@localhost:1521:XE"/> <!-- XE - Oracle express edition -->
<property name="username" value="system"/> <!-- according to your local Oracle name, password -->
<property name="password" value="123456"/>
</bean>

Notice the highlighted dataSource? Both name are the same. We're goin to refer that datacon bean in our controller, and that datacon bean is referring to dataSource. Now let's update our LoginFormController.java. Remember we're not using validator in this example. Create your own javascript for field validation.

Now we'll see both database connectivity as well as linking failure page. Create a string variable to hold your jsp page name. .jsp extension has already resolved in the dispatcher-servlet.xml. (bean id="viewResolver") So you dont need to specify .jsp. The code will be short as we're just goin to check whether the record exists or not. If you have any other logic besides this, let me know :)

Comment out the previous codes. Then add the following codes :

String status = "success";
Resource res = new ClassPathResource("../applicationContext.xml");
BeanFactory factory = new XmlBeanFactory(res);
datacon bean1 = (datacon) factory.getBean("datacon");
DataSource ds = bean1.dbcon();
JdbcTemplate jt = new JdbcTemplate(ds);

status variable is to hold the name of the jsp page. success is the success.jsp. you can initialise it with any string. ClassPathResource reads the applicationContext.xml. It'll read the connections defined inside. Some codes online refers the xml file without the "../" before applicationContext.xml. So improvise to see which suits you best. datacon in the getBean() is the bean that you've defined in applicationContext.xml. JdbcTemplate will be used as our data access method.

Add these lines after the ones above :

LoginFormBean loginBean = (LoginFormBean) command;

int count = jt.queryForInt("select count(*) from login where username = ? and password=?", new Object[]{loginBean.getName(), loginBean.getPassword()});
if (count==0){
status = "failure";
}else{
status = "success";
}
return new ModelAndView(status);

count will keep the number of records according to that username and password. What this code does is merely checking if there's any record based on the username and password given. Like i said, you can use any logic to check for login details. I used counting records. The select statement is somewhat same as PreparedStatement. ? as the wildcard to get user input or values. new Object[]{} is like setXXX() (e.g setString) within those curly braces, you add as many parameters you want according to the number of question marks. failure is failure.jsp. So this onSubmit() function will return the view according to the status whether it's failure or success. Same like our execute() in Struts :P So you can remove the successView property from dispatcher-servlet.xml as we don't really need them.

Your imports for this LoginFormController.java is like below :

import Bean.LoginFormBean;
import Connection.datacon;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;
import org.springframework.beans.factory.BeanFactory;
import org.springframework.beans.factory.xml.XmlBeanFactory;
import org.springframework.core.io.ClassPathResource;
import org.springframework.core.io.Resource;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.validation.BindException;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.SimpleFormController;

No changes required for index.jsp page except adding on javascript validation if you want to. Run the application and see the results. :)

For those seeking for a FREE & EASY software to edit your images, seek no further! Here comes PhotoScape (I think it's only approx. 14 MB).

Features include:

• Viewer : Slideshow, Fullscreen, Wallpaper, Lossless Rotation, Exif
• Editor : Frames, Resize, Rotate, Brightness, Color, Contrast, Auto Level, Auto Contrast, Whitebalance, Curves, Sepia, Negative, Sharpen, Blur, Noise Reduction, Vignetting, Bloom, Gradient, Texture, Fisheye, Clipart, Balloon, Text, Figures, Crop, Red Eye Removal, Mosaic
• Batch Editor : Frames, Resize, Filters, Objects
• Page : Make one photo by merging multiple photos at the page frame
• Combine : Make one photo by attaching multiple photos vertically or horizontally
• Animated GIF: Make one animation photo with multiple photos
• Print: Print portrait shot, carte de visite, passport photo
• Screen Capture: Capture your screenshot and save it
• Splitter: Divide a photo into multiple parts
• Color Picker: Zoom in screen on images, search and pick the color
• Raw Converter : Convert RAW to JPG
• Rename: Change photo file names in batch mode