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); } }