@Override public List<BlockStatus> findAllByBlockStatusExample( BlockStatusExample blockStatusExample, int offset, int limit) throws DaoException { try { Connection conn = DataSourceUtils.doGetConnection(dataSource); Statement stmt = conn.createStatement(); String clause = BlockStatusDaoImpl.buildClause(blockStatusExample) + " limit " + offset + "," + limit; logger.debug( "DB:FIND block_status[distinct=" + blockStatusExample.isDistinct() + ",clause=" + clause + "]"); ResultSet rs = stmt.executeQuery( "select" + (blockStatusExample.isDistinct() ? " distinct " : " ") + "`id`,`id2`,`shipment_id`,`declaration_no`,`status`,`remark`,`block_date_time`,`unblock_date_time`,`company_code`,`company_type`,`user_block`,`mawb`,`hawb`,`flight_no`,`flight_date`,`user_unblock`,`modified_date_time`,`auto_block_profile_id` from block_status" + clause); List<BlockStatus> list = new ArrayList<BlockStatus>(); while (rs.next()) { list.add(BlockStatusDaoImpl.createInstanceFromResultSet(rs)); } rs.close(); stmt.close(); return list; } catch (Exception e) { throw new DaoException(e); } }
@Override public BlockStatus findById(Integer id) throws DaoException { try { Connection conn = DataSourceUtils.doGetConnection(dataSource); PreparedStatement ps = conn.prepareStatement( "select `id`,`id2`,`shipment_id`,`declaration_no`,`status`,`remark`,`block_date_time`,`unblock_date_time`,`company_code`,`company_type`,`user_block`,`mawb`,`hawb`,`flight_no`,`flight_date`,`user_unblock`,`modified_date_time`,`auto_block_profile_id` from block_status where id=?"); ps.setInt(1, id); logger.debug("DB:FIND block_status[id=" + id + "]"); ResultSet rs = ps.executeQuery(); BlockStatus instance = null; if (rs.next()) { instance = BlockStatusDaoImpl.createInstanceFromResultSet(rs); } rs.close(); ps.close(); return instance; } catch (SQLException e) { throw new DaoException(e); } }