Examples of lazyj.DBFunctions$DBConnection

• lazyj.DBFunctions
  the connection parameters
  ExtProperties dbProp = new ExtProperties(); dbProp.set("driver", "org.postgresql.Driver"); // mandatory dbProp.set("database", "somedb"); // mandatory dbProp.set("host", "127.0.0.1"); // defaults to 127.0.0.1 if missing dbProp.set("port", "5432"); // DB-dependend default if missing dbProp.set("user", "username"); // recommended dbProp.set("password", "*****"); // recommended // you can also set here various other configuration options that the JDBC driver will look at DBFunctions db = new DBFunctions(dbProp); DBFunctions.DBConnection conn = db.getConnection(); if (conn==null) return; Statement stat = null; ResultSet rs = null; try{ stat = conn.getConnection().createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); stat.execute(someQuery, Statement.NO_GENERATED_KEYS); rs = stat.getResultSet(); // .................. rs.close(); rs = null; stat.close(); stat = null; } catch (Exception e){ ... } finally{ if (rs!=null){ // close try{ rs.close(); } catch (Exception e){ } } if (stat!=null){ try{ stat.close(); } catch (Exception e){ } } conn.free(); } @author costing @since Jan 17, 2009 @see DBFunctions#DBFunctions(ExtProperties)

Related Classes of lazyj.DBFunctions$DBConnection