JDBC Connection Wrapper Class

This project is no longer maintained
www.webprofusion.com

Welcome to the first opensource release of DBConnection.

com.webprofusion.utli.db.DBConnection is a simple wrapper object for JDBC database connections and currently supports MySQL & MS SQL Server. Also included in this package are the classes com.webprofusion.utils.StringUtils and com.webprofusion.SiteProperties - The dbconnection object currently uses this class to load settings for the DB Connection at runtime (this lets you define a properties file which specifies the dbengine and connection info.

Usage Examples

An Example usage of the DBConnection object would be:

String sql;
DBConnection conn=new DBConnection();
conn.open(); //do this before you use a new DBConnection..

sql="insert into DiscussionMessages values ("+StringUtils.inQuotes(myname)+","+StringUtils.inQuotes(message)+","+conn.getCurrentDateSQL()+")";
conn.executeUpdate(sql);

conn.close(); //always do this when finished using the DBConnection

Or :

DBConnection conn = new DBConnection();
conn.open();

String sql="select name from Users";

conn.openQueryRS(sql); //use this to open your query results

while(conn.rs.next()) //loop through results (if any)
{
System.out.println("hello "+conn.rs.getString("name"));
}

conn.closeQueryRS(); //always close result set
conn.close();

You can perform any number of DBConnection.executeUpdate("...") or DBConnection.openQueryRS("...")
as long as you don't nest another operation inside an openQueryRS/closeQueryRS, if you need to nest a query, create a new DBConnection to handle it.

Webprofusion Ltd  2000