Example usage for org.apache.commons.dbutils DbUtils closeQuietly

Introduction

In this page you can find the example usage for org.apache.commons.dbutils DbUtils closeQuietly.

Prototype

public static void closeQuietly(Connection conn, Statement stmt, ResultSet rs) 

Source Link

Document

Close a Connection, Statement and ResultSet.

Usage

From source file:com.mobiaware.auction.data.impl.MySqlDataServiceImpl.java

@Override
public List<User> getUsers(final int auctionUid, final int start, final int length, final String sort,
        final String dir) {
    List<User> objs = Lists.newArrayList();

    Connection conn = null;/*from  w ww . j  av  a  2 s .  c om*/
    CallableStatement stmt = null;
    ResultSet rs = null;

    try {
        conn = _dataSource.getConnection();

        stmt = conn.prepareCall("{call SP_GETUSERS (?,?,?,?,?)}");
        stmt.setInt(1, auctionUid);
        stmt.setInt(2, start);
        stmt.setInt(3, length);
        stmt.setString(4, sort);
        stmt.setString(5, dir);

        rs = stmt.executeQuery();

        while (rs.next()) {
            UserBuilder builder = User.newBuilder().setUid(rs.getInt("UID"))
                    .setAuctionUid(rs.getInt("AUCTIONUID")).setBidderNumber(rs.getString("BIDDERNUMBER"))
                    .setFirstName(rs.getString("FIRSTNAME")).setLastName(rs.getString("LASTNAME"))
                    .setRole(Roles.getId(rs.getInt("ROLE")));

            User obj = builder.build();
            obj.setPasswordHash(rs.getString("PASSWORDHASH"));

            objs.add(obj);
        }
    } catch (SQLException e) {
        LOG.error(Throwables.getStackTraceAsString(e));
    } finally {
        DbUtils.closeQuietly(conn, stmt, rs);
    }

    if (LOG.isDebugEnabled()) {
        LOG.debug("USER [method:{} result:{}]", new Object[] { "get", objs.size() });
    }

    return ImmutableList.copyOf(objs);
}

---

From source file:com.mobiaware.auction.data.impl.MySqlDataServiceImpl.java

@Override
public int getUserCount(final int auctionUid) {
    int count = 0;

    Connection conn = null;/*from  ww  w.  j a  v  a  2s  . co m*/
    CallableStatement stmt = null;
    ResultSet rs = null;

    try {
        conn = _dataSource.getConnection();

        stmt = conn.prepareCall("{call SP_GETUSERCOUNT (?)}");
        stmt.setInt(1, auctionUid);

        rs = stmt.executeQuery();

        if (rs.next()) {
            count = rs.getInt(1);
        }
    } catch (SQLException e) {
        LOG.error(Throwables.getStackTraceAsString(e));
    } finally {
        DbUtils.closeQuietly(conn, stmt, rs);
    }

    if (LOG.isDebugEnabled()) {
        LOG.debug("USER [method:{} result:{}]", new Object[] { "count", count });
    }

    return count;
}

---

From source file:com.mobiaware.auction.data.impl.MySqlDataServiceImpl.java

@Override
public int editUser(final User user) {
    int uid = -1;

    Connection conn = null;/*from w  w w  . j  a  v  a 2 s .  c  o m*/
    CallableStatement stmt = null;

    try {
        conn = _dataSource.getConnection();

        stmt = conn.prepareCall("{call SP_EDITUSER (?,?,?,?,?,?,?)}");
        stmt.registerOutParameter(1, Types.INTEGER);
        stmt.setInt(2, user.getAuctionUid());
        stmt.setString(3, user.getBidderNumber());
        stmt.setString(4, user.getFirstName());
        stmt.setString(5, user.getLastName());
        stmt.setString(6, user.getPasswordHash());
        stmt.setInt(7, user.getRole().getId());
        stmt.execute();

        uid = stmt.getInt(1);
    } catch (SQLException e) {
        LOG.error(Throwables.getStackTraceAsString(e));
        uid = -1;
    } finally {
        DbUtils.closeQuietly(conn, stmt, null);
    }

    if (LOG.isDebugEnabled()) {
        LOG.debug("USER [method:{} result:{}]", new Object[] { "add", uid });
    }

    return uid;
}

---

From source file:com.mobiaware.auction.data.impl.MySqlDataServiceImpl.java

@Override
public int deleteUser(final int uid) {
    int result = -1;

    Connection conn = null;//from   w  w  w .ja  v a 2  s  .co  m
    CallableStatement stmt = null;
    ResultSet rs = null;

    try {
        conn = _dataSource.getConnection();

        stmt = conn.prepareCall("{call SP_DELETEUSER (?)}");
        stmt.setInt(1, uid);

        rs = stmt.executeQuery();

        if (rs.next()) {
            result = rs.getInt(1);
        }
    } catch (SQLException e) {
        LOG.error(Throwables.getStackTraceAsString(e));
    } finally {
        DbUtils.closeQuietly(conn, stmt, rs);
    }

    if (LOG.isDebugEnabled()) {
        LOG.debug("USER [method:{} result:{}]", new Object[] { "delete", result });
    }

    return result;
}

---

From source file:com.mobiaware.auction.data.impl.MySqlDataServiceImpl.java

@Override
public User getUserByBidderNumber(final String biddernumber) {
    User obj = null;//  w w  w.  j  a  v  a2  s .c o m

    Connection conn = null;
    CallableStatement stmt = null;
    ResultSet rs = null;

    try {
        conn = _dataSource.getConnection();

        stmt = conn.prepareCall("{call SP_GETUSERBYBIDDERNUMBER (?)}");
        stmt.setString(1, biddernumber);

        rs = stmt.executeQuery();

        if (rs.next()) {
            UserBuilder builder = User.newBuilder().setUid(rs.getInt("UID"))
                    .setAuctionUid(rs.getInt("AUCTIONUID")).setBidderNumber(rs.getString("BIDDERNUMBER"))
                    .setFirstName(rs.getString("FIRSTNAME")).setLastName(rs.getString("LASTNAME"))
                    .setRole(Roles.getId(rs.getInt("ROLE")));

            obj = builder.build();
            obj.setPasswordHash(rs.getString("PASSWORDHASH"));
        }
    } catch (SQLException e) {
        LOG.error(Throwables.getStackTraceAsString(e));
    } finally {
        DbUtils.closeQuietly(conn, stmt, rs);
    }

    if (LOG.isDebugEnabled()) {
        LOG.debug("USER [method:{} result:{}]",
                new Object[] { "get", obj != null ? obj.toString() : "[error]" });
    }

    return obj;
}

---

From source file:com.mobiaware.auction.data.impl.MySqlDataServiceImpl.java

@Override
public List<Bid> getBidsByUser(final int userUid) {
    List<Bid> objs = Lists.newArrayList();

    Connection conn = null;//from  w w  w  .j av  a2  s .co  m
    CallableStatement stmt = null;
    ResultSet rs = null;

    try {
        conn = _dataSource.getConnection();

        stmt = conn.prepareCall("{call SP_GETBIDSBYUSER (?)}");
        stmt.setInt(1, userUid);

        rs = stmt.executeQuery();

        while (rs.next()) {
            BidBuilder builder = Bid.newBuilder().setUid(rs.getInt("UID")).setItemUid(rs.getInt("ITEMUID"))
                    .setUserUid(rs.getInt("USERUID")).setBidPrice(rs.getDouble("BIDPRICE"))
                    .setBidDate(rs.getDate("BIDDATE").getTime());

            objs.add(builder.build());
        }
    } catch (SQLException e) {
        LOG.error(Throwables.getStackTraceAsString(e));
    } finally {
        DbUtils.closeQuietly(conn, stmt, rs);
    }

    if (LOG.isDebugEnabled()) {
        LOG.debug("BID [method:{} result:{}]", new Object[] { "get", objs.size() });
    }

    return ImmutableList.copyOf(objs);
}

---

From source file:com.mobiaware.auction.data.impl.MySqlDataServiceImpl.java

@Override
public List<Watch> getWatchesByUser(final int userUid) {
    List<Watch> objs = Lists.newArrayList();

    Connection conn = null;/*  www.j a v  a 2  s .  c  om*/
    CallableStatement stmt = null;
    ResultSet rs = null;

    try {
        conn = _dataSource.getConnection();

        stmt = conn.prepareCall("{call SP_GETWATCHESBYUSER (?)}");
        stmt.setInt(1, userUid);

        rs = stmt.executeQuery();

        while (rs.next()) {
            WatchBuilder builder = Watch.newBuilder().setUid(rs.getInt("UID")).setUserUid(rs.getInt("USERUID"))
                    .setItemUid(rs.getInt("ITEMUID"));

            objs.add(builder.build());
        }
    } catch (SQLException e) {
        LOG.error(Throwables.getStackTraceAsString(e));
    } finally {
        DbUtils.closeQuietly(conn, stmt, rs);
    }

    if (LOG.isDebugEnabled()) {
        LOG.debug("WATCH [method:{} result:{}]", new Object[] { "get", objs.size() });
    }

    return ImmutableList.copyOf(objs);
}

---

From source file:com.mobiaware.auction.data.impl.MySqlDataServiceImpl.java

@Override
public List<Fund> getFundsByUser(final int userUid) {
    List<Fund> objs = Lists.newArrayList();

    Connection conn = null;/* ww  w  .j a  va 2s.  c  om*/
    CallableStatement stmt = null;
    ResultSet rs = null;

    try {
        conn = _dataSource.getConnection();

        stmt = conn.prepareCall("{call SP_GETFUNDSBYUSER (?)}");
        stmt.setInt(1, userUid);

        rs = stmt.executeQuery();

        while (rs.next()) {
            FundBuilder builder = Fund.newBuilder().setUid(rs.getInt("UID")).setUserUid(rs.getInt("USERUID"))
                    .setBidPrice(rs.getDouble("FUNDPRICE")).setBidDate(rs.getDate("FUNDDATE").getTime());

            objs.add(builder.build());
        }
    } catch (SQLException e) {
        LOG.error(Throwables.getStackTraceAsString(e));
    } finally {
        DbUtils.closeQuietly(conn, stmt, rs);
    }

    if (LOG.isDebugEnabled()) {
        LOG.debug("WATCH [method:{} result:{}]", new Object[] { "get", objs.size() });
    }

    return ImmutableList.copyOf(objs);
}

---

From source file:net.sourceforge.seqware.webservice.resources.tables.FileChildWorkflowRunsResource.java

/**
 * Use SQL to directly retrieve relevant workflows runs (defined as any workflow runs that 
 * include one or more files in the set we were given)
 * @param files//  w w  w  .  jav a  2  s.c o m
 * @param interestingWorkflows
 * @return
 * @throws SQLException 
 */
protected static WorkflowRunList2 directRetrieveWorkflowRuns(List<Integer> files,
        List<Integer> interestingWorkflows) throws SQLException {
    final Hibernate3DtoCopier copier = new Hibernate3DtoCopier();
    final WorkflowRunList2 runs = new WorkflowRunList2();
    runs.setList(new ArrayList());
    if (files.size() > 0) {

        ResultSet rs = null;
        MetadataDB mdb = null;
        try {
            WorkflowRunService ss = BeanFactory.getWorkflowRunServiceBean();
            StringBuilder query = new StringBuilder();
            query.append("select distinct r.sw_accession from workflow_run r, workflow w, ");
            query.append("workflow_run_input_files rf, file f WHERE r.workflow_run_id = rf.workflow_run_id "
                    + "AND rf.file_id = f.file_id " + "AND w.workflow_id = r.workflow_id " + "AND (");
            // handle file accessions
            for (int i = 0; i < files.size() - 1; i++) {
                Integer fInt = files.get(i);
                query.append(" f.sw_accession = ").append(fInt).append(" OR");
            }
            Integer fInt = files.get(files.size() - 1);
            query.append(" f.sw_accession = ").append(fInt).append(")");
            // handle interesting workflow accessions
            if (interestingWorkflows.size() > 0) {
                query.append(" AND (");
                for (int i = 0; i < interestingWorkflows.size() - 1; i++) {
                    Integer wInt = interestingWorkflows.get(i);
                    query.append(" w.sw_accession = ").append(wInt).append(" OR");
                }
                Integer wInt = interestingWorkflows.get(interestingWorkflows.size() - 1);
                query.append(" w.sw_accession = ").append(wInt).append(")");
            }

            query.append(" ORDER BY sw_accession");

            Log.info("Executing query: " + query);
            mdb = DBAccess.get();

            List<Integer> workflowSWIDs = mdb.executeQuery(query.toString(),
                    new ResultSetHandler<List<Integer>>() {
                        @Override
                        public List<Integer> handle(ResultSet rs) throws SQLException {
                            List<Integer> ids = new ArrayList<>();
                            while (rs.next()) {
                                ids.add(rs.getInt("sw_accession"));
                            }
                            return ids;
                        }
                    });

            for (int workflowSWID : workflowSWIDs) {
                WorkflowRun workflowRun = (WorkflowRun) testIfNull(ss.findBySWAccession(workflowSWID));
                CollectionPropertyName<WorkflowRun>[] createCollectionPropertyNames = CollectionPropertyName
                        .createCollectionPropertyNames(WorkflowRun.class,
                                new String[] { "inputFileAccessions" });
                WorkflowRun dto = copier.hibernate2dto(WorkflowRun.class, workflowRun,
                        ArrayUtils.EMPTY_CLASS_ARRAY, createCollectionPropertyNames);
                runs.add(dto);
            }
        } finally {
            if (mdb != null) {
                DbUtils.closeQuietly(mdb.getDb(), mdb.getSql(), rs);
            }
            DBAccess.close();
        }
    }
    return runs;
}

---

From source file:net.sourceforge.seqware.webservice.resources.tables.ProcessIDResource.java

private void closeConnectionStatementResultSet(MetadataDB mdb, ResultSet rs) {
    Log.debug("Closing connection  " + Integer.toHexString(mdb.getDb().hashCode()));
    Log.debug("Closing statement  " + Integer.toHexString(mdb.getSql().hashCode()));
    DbUtils.closeQuietly(mdb.getDb(), mdb.getSql(), rs);
    mdb.setDb(null);/*from w  ww .j  a v  a2  s  . c om*/
    mdb.setSql(null);
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• »