@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 int countByBlockStatusExample(BlockStatusExample blockStatusExample) throws DaoException {
try {
Connection conn = DataSourceUtils.doGetConnection(dataSource);
Statement stmt = conn.createStatement();
String clause = BlockStatusDaoImpl.buildClause(blockStatusExample);
ResultSet rs =
stmt.executeQuery(
"select"
+ (blockStatusExample.isDistinct() ? " distinct " : " ")
+ "count(*) from block_status"
+ clause);
int count = -1;
if (rs.next()) {
count = rs.getInt(1);
}
rs.close();
stmt.close();
logger.debug(
"DB:COUNT block_status[distinct="
+ blockStatusExample.isDistinct()
+ ",clause="
+ clause
+ "] => "
+ count);
return count;
} catch (Exception e) {
throw new DaoException(e);
}
}
@Override
public int insert(BlockStatus blockStatus) throws DaoException {
if (blockStatus == null) {
throw new DaoException("Cannot insert block_status with null value.");
}
try {
Connection conn = DataSourceUtils.doGetConnection(dataSource);
PreparedStatement ps =
conn.prepareStatement(
"insert into block_status(`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`) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)",
Statement.RETURN_GENERATED_KEYS);
BlockStatusDaoImpl.setPreparedStatementValues(ps, blockStatus);
ps.setNull(1, java.sql.Types.INTEGER);
ps.execute();
int id = -1;
ResultSet rs = ps.getGeneratedKeys();
if (rs.next()) {
id = rs.getInt(1);
}
rs.close();
ps.close();
logger.info("DB:INSERT block_status[id=" + id + "]");
return id;
} catch (SQLException e) {
throw new DaoException(e);
}
}
@Override
public int update(BlockStatus blockStatus) throws DaoException {
if (blockStatus == null) {
throw new DaoException("Cannot insert block_status with null value.");
}
try {
Connection conn = DataSourceUtils.doGetConnection(dataSource);
PreparedStatement ps =
conn.prepareStatement(
"update block_status set `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`=? where id=?");
BlockStatusDaoImpl.setPreparedStatementValues(ps, blockStatus);
ps.setInt(19, blockStatus.getId());
int count = ps.executeUpdate();
ps.close();
logger.info("DB:UPDATE block_status[id=" + blockStatus.getId() + "] => " + count);
return count;
} catch (SQLException 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);
}
}
