Software Testing the first time job

The most impressive error I've ever made in a recently completed project is when the Web big job connects to the database.

At first I just used to connect the database directly with JDBC, without making any try,catch errors thrown. The compilation can then pass smoothly but there is no return data. Looking for a long while do not know where the error, so the code to join the try and catch statements, divided into driver loading errors, database connection errors and data manipulation errors. Then, depending on the error thrown, it is possible to know that the sentence was not executed successfully.

The first is the database connection problem, because the database has not been set a password so the first password column string is empty. It's OK to set a password for the database.

Then the database operation error is thrown ...

The reason for this is that SQL statements because of the addition of a lot of read characters cause "" and the use of the + is particularly confusing. Adjust the format for each variable one line will be able to clearly find the error.

The data can then be returned successfully.

Software Testing the first time job