Examples of org.apache.empire.db.DBDatabase.querySingleInt()

org.apache.empire.db.DBDatabase.querySingleInt()
Returns the value of the first row/column of a sql-query as an int. If the query does not return a result or if the query result is NULL, then the defaultValue is returned @param sqlCmd the SQL statement @param sqlParams list of query parameter values @param defaultValue the default value if no value was returned by the database @param conn a valid connection to the database. @return the value of the first column in the first row of the query

            if (cmd == null) {
                throw new AssertionError("The DBCommand object is null.");
            }
            DBTable t = db.getTables().get(0);
            cmd.select(t.count());
            return (db.querySingleInt(cmd, -1, conn) >= 0);
        } catch (Exception e) {
            return false;
        }
    }

View Full Code Here

            if (cmd == null) {
                throw new AssertionError("The DBCommand object is null.");
            }
            DBTable t = db.getTables().get(0);
            cmd.select(t.count());
            return (db.querySingleInt(cmd.getSelect(), -1, conn) >= 0);
        } catch (Exception e) {
            return false;
        }
    }

View Full Code Here

            if (cmd == null) {
                throw new AssertionError("The DBCommand object is null.");
            }
            DBTable t = db.getTables().get(0);
            cmd.select(t.count());
            return (db.querySingleInt(cmd.getSelect(), -1, conn) >= 0);
        } catch (Exception e) {
            return false;
        }
    }

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.