private static void setPreparedStatementValues(PreparedStatement ps, BlockStatus blockStatus)
throws SQLException {
if (blockStatus.getId() != null) {
ps.setInt(1, blockStatus.getId());
} else {
ps.setNull(1, java.sql.Types.INTEGER);
}
if (blockStatus.getId2() != null) {
ps.setInt(2, blockStatus.getId2());
} else {
ps.setNull(2, java.sql.Types.INTEGER);
}
if (blockStatus.getShipmentId() != null) {
ps.setInt(3, blockStatus.getShipmentId());
} else {
ps.setNull(3, java.sql.Types.INTEGER);
}
if (blockStatus.getDeclarationNo() != null) {
ps.setString(4, blockStatus.getDeclarationNo());
} else {
ps.setNull(4, java.sql.Types.VARCHAR);
}
if (blockStatus.getStatus() != null) {
ps.setString(5, blockStatus.getStatus());
} else {
ps.setNull(5, java.sql.Types.VARCHAR);
}
if (blockStatus.getRemark() != null) {
ps.setString(6, blockStatus.getRemark());
} else {
ps.setNull(6, java.sql.Types.VARCHAR);
}
if (blockStatus.getBlockDateTime() != null) {
ps.setTimestamp(7, new java.sql.Timestamp(blockStatus.getBlockDateTime().getTime()));
} else {
ps.setNull(7, java.sql.Types.TIMESTAMP);
}
if (blockStatus.getUnblockDateTime() != null) {
ps.setTimestamp(8, new java.sql.Timestamp(blockStatus.getUnblockDateTime().getTime()));
} else {
ps.setNull(8, java.sql.Types.TIMESTAMP);
}
if (blockStatus.getCompanyCode() != null) {
ps.setString(9, blockStatus.getCompanyCode());
} else {
ps.setNull(9, java.sql.Types.VARCHAR);
}
if (blockStatus.getCompanyType() != null) {
ps.setString(10, blockStatus.getCompanyType());
} else {
ps.setNull(10, java.sql.Types.VARCHAR);
}
if (blockStatus.getUserBlock() != null) {
ps.setString(11, blockStatus.getUserBlock());
} else {
ps.setNull(11, java.sql.Types.VARCHAR);
}
if (blockStatus.getMawb() != null) {
ps.setString(12, blockStatus.getMawb());
} else {
ps.setNull(12, java.sql.Types.VARCHAR);
}
if (blockStatus.getHawb() != null) {
ps.setString(13, blockStatus.getHawb());
} else {
ps.setNull(13, java.sql.Types.VARCHAR);
}
if (blockStatus.getFlightNo() != null) {
ps.setString(14, blockStatus.getFlightNo());
} else {
ps.setNull(14, java.sql.Types.VARCHAR);
}
if (blockStatus.getFlightDate() != null) {
ps.setTimestamp(15, new java.sql.Timestamp(blockStatus.getFlightDate().getTime()));
} else {
ps.setNull(15, java.sql.Types.DATE);
}
if (blockStatus.getUserUnblock() != null) {
ps.setString(16, blockStatus.getUserUnblock());
} else {
ps.setNull(16, java.sql.Types.VARCHAR);
}
if (blockStatus.getModifiedDateTime() != null) {
ps.setTimestamp(17, new java.sql.Timestamp(blockStatus.getModifiedDateTime().getTime()));
} else {
ps.setTimestamp(17, new java.sql.Timestamp(System.currentTimeMillis()));
}
if (blockStatus.getAutoBlockProfileId() != null) {
ps.setInt(18, blockStatus.getAutoBlockProfileId());
} else {
ps.setNull(18, java.sql.Types.INTEGER);
}
}
