SQL | TechieDan

Hibernate Error : exception setting property value

By techieDan Java December 17, 2009

Been playing around with Hibernate and mapping classes with Java. A reason why Hibernate is useful is so to facilitate users to stop writing pure SQL for queries and …

Tutorial

Java Why PreparedStament not Statement

By techieDan Tutorial March 17, 2009

a programmer uses PreparedStatement instead of Statement when doing SQL queries in my projects. I found out that I can indelibly hacked into the system when I use SQL …

Tutorial

Sample HQL Query

By techieDan Tutorial January 21, 2009

For those Java like programmers, they will be using pure SQL statements to get the whole of a table by typing the typical SQL query statement. String SQL = …

Tutorial

Writing SQL statement with Loop Objects

By techieDan Tutorial March 15, 2008

Coding have never been the same!!! Some bad habits when writing codes which are redundant String special = {"a1","a2","a3","a4"}; Connection con = null; PreparedStatement stmt = null; PreparedStatement stmt2 …

Tutorial

mySQL msSQL syntax

By techieDan Tutorial February 13, 2008

mySQL and msSQL has a similar SQL syntax but not the same. To have a grasp of what does this mean, let’s have an exercise to get 10 rows from a …

Tag: SQL