How To - Create a Database Connection Class in Java (MySQL)

This was created when i was doing a project and was creating lot of database connections and i final spend my time to create a proper class to be used by other class of my projects. special attention was given to the variable creation. so that same could be used all over the project and to make standardized the code as possible. also to reduce the amount of memory used.

You can use the methods in this class to execute or get a resultset just insert the SQL query in a String format

Warning- this class returns a resultset this could lead to memory leak so better to close connection which are created.

Download Source Code



Comments

Post a Comment

Popular posts from this blog

Best Internet Connection In Sri Lanka For a Youth (2015 April)

Image
Definition of youth = downloading  movies, watch music video , TV shows , you tube and tonne of web browsing. (Minimum 100GB per month)  First internet connection i ever had was SLT prepaid dial up connection. Now in 2015 the internet has change, people has change(market) and also sri lankan ISP has change. * LankaBell 4G is connection fee of  7500, monthly rental of 1350 with out tax for 35GB @(speed 4Mbps downlaod & 1Mbps. Also you can get Unlimited connection but at very slow speed. *I Tested Mobitel,Etisalat,Airtel  but not include in the review because it was a waste of time and those packages does not make sense for any human or animal to use.  So here is what is the best for you... Dialog 4G SLT-ADSL Dialog Prepaid Time-base # CHEAPEST INTERNET CONNECTION PER GB (DOWNLOADING) WINNER = #Dialog prepaid I test all other isp but non of then were unlimited, they had rental (commitment) except Lankbell But the speed is 4Mbps in 2015 i
Read more

Homemade water pump

Image
It all started when i wanted to water-cool my PC, i search for a water- pumps on Sri-lankan market and  didn't find any good one but i manage to find a fish tank clening pump but it was expensive and noise. so i started to search on E-bay but they were expensive to ship to Sri lanka. so i did some research on the internet about home build water pumps and got some idea on centrifugal water pumps and how they work... when i was a small boy i saw a plumber repairing household water pump  and wondered how it work. Because at that time i couldn't understand how a spinning wheel could pump water. Wikipedia about Centrifugal pump http://en.wikipedia.org/wiki/Centrifugal_pump The challenge was to make a water pump, from what every i can get my hands on; around the house so that  i could keep my cost to minimum and have fun enjoying building it  .... Motor inside a coke bottle lid 
Read more