Improve performance + refactoring

add conn.setAutoCommit();
add conn.commit();
add conn.rollback();
add conn.setAutoCommit(true);
for query for performance & multiple transaction protection

Refactoring: DAL + services function names in camel notation.
Refactoring

function casts
code cleanup