Java DbUtils.close方法代码示例

import nxt.util.DbUtils; //导入方法依赖的package包/类
public static DbIterator<? extends Transaction> getTransactionIterator(
    Long accountId, TransactionType[] recipientTypes,
    TransactionType[] senderTypes, int timestamp, Boolean orderAscending,
    Object referencedTransaction) {
  Connection con = null;
  try {
    con = Db.getConnection();
    PreparedStatement pstmt = createTransactionStatement(con, accountId,
        recipientTypes, senderTypes, timestamp, orderAscending,
        referencedTransaction, false);

    DbIterator<? extends Transaction> iterator = Nxt.getBlockchain()
        .getTransactions(con, pstmt);
    return iterator;
  }
  catch (SQLException e) {
    logger.error("SQL Error", e);
    if (con != null) {
      DbUtils.close(con);
    }
  }
  return null;
}
 

import nxt.util.DbUtils; //导入方法依赖的package包/类
public static List<Block> getGeneratedBlocks(Long accountId) {
  Connection con = null;
  try {
    con = Db.getConnection();
    PreparedStatement pstmt = con
        .prepareStatement("SELECT * FROM block WHERE generator_id = ? ORDER BY db_id ASC");
    pstmt.setLong(1, accountId);

    List<Block> result = new ArrayList<Block>();
    DbIterator<? extends Block> iterator = Nxt.getBlockchain().getBlocks(con,
        pstmt);
    while (iterator.hasNext()) {
      result.add(iterator.next());
    }
    return result;
  }
  catch (SQLException e) {
    DbUtils.close(con);
    throw new RuntimeException(e.toString(), e);
  }
}
 

import nxt.util.DbUtils; //导入方法依赖的package包/类
public DbIterator<BlockImpl> getAllBlocks()
{
  Connection localConnection = null;
  try
  {
    localConnection = Db.getConnection();
    PreparedStatement localPreparedStatement = localConnection.prepareStatement("SELECT * FROM block ORDER BY db_id ASC");
    new DbIterator(localConnection, localPreparedStatement, new DbIterator.ResultSetReader()
    {
      public BlockImpl get(Connection paramAnonymousConnection, ResultSet paramAnonymousResultSet)
        throws NxtException.ValidationException
      {
        return BlockDb.findBlock(paramAnonymousConnection, paramAnonymousResultSet);
      }
    });
  }
  catch (SQLException localSQLException)
  {
    DbUtils.close(new AutoCloseable[] { localConnection });
    throw new RuntimeException(localSQLException.toString(), localSQLException);
  }
}
 

import nxt.util.DbUtils; //导入方法依赖的package包/类
public DbIterator<TransactionImpl> getAllTransactions()
{
  Connection localConnection = null;
  try
  {
    localConnection = Db.getConnection();
    PreparedStatement localPreparedStatement = localConnection.prepareStatement("SELECT * FROM transaction ORDER BY db_id ASC");
    new DbIterator(localConnection, localPreparedStatement, new DbIterator.ResultSetReader()
    {
      public TransactionImpl get(Connection paramAnonymousConnection, ResultSet paramAnonymousResultSet)
        throws NxtException.ValidationException
      {
        return TransactionDb.findTransaction(paramAnonymousConnection, paramAnonymousResultSet);
      }
    });
  }
  catch (SQLException localSQLException)
  {
    DbUtils.close(new AutoCloseable[] { localConnection });
    throw new RuntimeException(localSQLException.toString(), localSQLException);
  }
}
 

import nxt.util.DbUtils; //导入方法依赖的package包/类
public static LazyList getTransactions(Boolean orderAscending, INxtService nxt) {
  Connection con = null;

  /* Count number of records */
  int available = Nxt.getBlockchain().getTransactionCount();

  /* Create the record iterator */
  try {
    con = Db.getConnection();
    StringBuilder buf = new StringBuilder();
    buf.append("SELECT * FROM transaction ");
    if (orderAscending != null) {
      if (Boolean.TRUE.equals(orderAscending)) {
        buf.append("ORDER BY db_id ASC");
      }
      else if (Boolean.FALSE.equals(orderAscending)) {
        buf.append("ORDER BY db_id DESC");
      }
    }
    PreparedStatement pstmt = con.prepareStatement(buf.toString());
    DbIterator<? extends Transaction> iterator = Nxt.getBlockchain()
        .getTransactions(con, pstmt);
    LazyList lazyList = new LazyList(iterator, available, nxt);
    return lazyList;
  }
  catch (SQLException e) {
    logger.error("SQL Error", e);
    if (con != null) {
      DbUtils.close(con);
    }
  }
  return null;
}
 

import nxt.util.DbUtils; //导入方法依赖的package包/类
public static LazyList getBlocks(Boolean orderAscending, INxtService nxt) {
  Connection con = null;

  /* Count number of records */
  // int available = nxt.getSmartBlockCount();
  int available = Nxt.getBlockchain().getBlockCount();

  /* Create the record iterator */
  try {
    con = Db.getConnection();
    StringBuilder buf = new StringBuilder();
    buf.append("SELECT * FROM block ");
    if (orderAscending != null) {
      if (Boolean.TRUE.equals(orderAscending)) {
        buf.append("ORDER BY db_id ASC");
      }
      else if (Boolean.FALSE.equals(orderAscending)) {
        buf.append("ORDER BY db_id DESC");
      }
    }
    PreparedStatement pstmt = con.prepareStatement(buf.toString());
    DbIterator<? extends Block> iterator = Nxt.getBlockchain().getBlocks(con,
        pstmt);
    LazyList lazyList = new LazyList(iterator, available);
    return lazyList;
  }
  catch (SQLException e) {
    logger.error("SQL Error", e);
    if (con != null) {
      DbUtils.close(con);
    }
  }
  return null;
}
 

import nxt.util.DbUtils; //导入方法依赖的package包/类
@Override
public DbIterator<BlockImpl> getAllBlocks() {
    Connection con = null;
    try {
        con = Db.getConnection();
        PreparedStatement pstmt = con.prepareStatement("SELECT * FROM block ORDER BY db_id ASC");
        return getBlocks(con, pstmt);
    } catch (SQLException e) {
        DbUtils.close(con);
        throw new RuntimeException(e.toString(), e);
    }
}
 

import nxt.util.DbUtils; //导入方法依赖的package包/类
@Override
public DbIterator<BlockImpl> getBlocks(Account account, int timestamp) {
    Connection con = null;
    try {
        con = Db.getConnection();
        PreparedStatement pstmt = con.prepareStatement("SELECT * FROM block WHERE timestamp >= ? AND generator_id = ? ORDER BY db_id ASC");
        pstmt.setInt(1, timestamp);
        pstmt.setLong(2, account.getId());
        return getBlocks(con, pstmt);
    } catch (SQLException e) {
        DbUtils.close(con);
        throw new RuntimeException(e.toString(), e);
    }
}
 

import nxt.util.DbUtils; //导入方法依赖的package包/类
@Override
public DbIterator<TransactionImpl> getAllTransactions() {
    Connection con = null;
    try {
        con = Db.getConnection();
        PreparedStatement pstmt = con.prepareStatement("SELECT * FROM transaction ORDER BY db_id ASC");
        return getTransactions(con, pstmt);
    } catch (SQLException e) {
        DbUtils.close(con);
        throw new RuntimeException(e.toString(), e);
    }
}
 

import nxt.util.DbUtils; //导入方法依赖的package包/类
@Override
public DbIterator<TransactionImpl> getTransactions(Account account, byte type, byte subtype, int timestamp, Boolean orderAscending) {
    Connection con = null;
    try {
        StringBuilder buf = new StringBuilder();
        if (orderAscending != null) {
            buf.append("SELECT * FROM (");
        }
        buf.append("SELECT * FROM transaction WHERE recipient_id = ? ");
        if (timestamp > 0) {
            buf.append("AND timestamp >= ? ");
        }
        if (type >= 0) {
            buf.append("AND type = ? ");
            if (subtype >= 0) {
                buf.append("AND subtype = ? ");
            }
        }
        buf.append("UNION SELECT * FROM transaction WHERE sender_id = ? ");
        if (timestamp > 0) {
            buf.append("AND timestamp >= ? ");
        }
        if (type >= 0) {
            buf.append("AND type = ? ");
            if (subtype >= 0) {
                buf.append("AND subtype = ? ");
            }
        }
        if (Boolean.TRUE.equals(orderAscending)) {
            buf.append(") ORDER BY timestamp ASC");
        } else if (Boolean.FALSE.equals(orderAscending)) {
            buf.append(") ORDER BY timestamp DESC");
        }
        con = Db.getConnection();
        PreparedStatement pstmt;
        int i = 0;
        pstmt = con.prepareStatement(buf.toString());
        pstmt.setLong(++i, account.getId());
        if (timestamp > 0) {
            pstmt.setInt(++i, timestamp);
        }
        if (type >= 0) {
            pstmt.setByte(++i, type);
            if (subtype >= 0) {
                pstmt.setByte(++i, subtype);
            }
        }
        pstmt.setLong(++i, account.getId());
        if (timestamp > 0) {
            pstmt.setInt(++i, timestamp);
        }
        if (type >= 0) {
            pstmt.setByte(++i, type);
            if (subtype >= 0) {
                pstmt.setByte(++i, subtype);
            }
        }
        return getTransactions(con, pstmt);
    } catch (SQLException e) {
        DbUtils.close(con);
        throw new RuntimeException(e.toString(), e);
    }
}