SQLWrapper

[Duck Man]

I made this for two of my programs and wished I did for all my sql programs. Its just for mysql right now... but that could be changed pretty easy I think. So for my sql you will need MYSQL Connector/J for this to work. Get it HERE. Feel free to use this and modify it what ever way you want to. The cool thing is it automatically handles reconnecting to a db if get disconnected. It was funny, originally I had it in a loop so it just kept trying to reconnect until it succeeded. But if u fucked up the connect statement then it would just be stuck... lol. So only one try after a fail now.

[Duck Man]

I thot I should put an example of how to use it. I don't know if this would compile but it should...

Code: Select all

SQLWrapper = new SQLWrapper("jdbc:mysql://cookbookdm.piratehook.com/cookbookdm?user=duckmanis1&password=*******");
rs=sql.select("SELECT name FROM recipes");
rs.first();
System.out.println(rs.getString("name"));


I left out the Exception handling and crap. But this should connect to my cookbook db and get a list of all the names of the recipes and then print out the first name. That is not my password btw .