private static BlockStatus createInstanceFromResultSet(ResultSet rs) throws SQLException {
BlockStatus blockStatus = new BlockStatus();
Integer col1 = rs.getInt("id");
blockStatus.setId(rs.wasNull() ? null : col1);
Integer col2 = rs.getInt("id2");
blockStatus.setId2(rs.wasNull() ? null : col2);
Integer col3 = rs.getInt("shipment_id");
blockStatus.setShipmentId(rs.wasNull() ? null : col3);
String col4 = rs.getString("declaration_no");
blockStatus.setDeclarationNo(rs.wasNull() ? null : col4);
String col5 = rs.getString("status");
blockStatus.setStatus(rs.wasNull() ? null : col5);
String col6 = rs.getString("remark");
blockStatus.setRemark(rs.wasNull() ? null : col6);
java.sql.Timestamp col7 = rs.getTimestamp("block_date_time");
blockStatus.setBlockDateTime(rs.wasNull() ? null : new java.util.Date(col7.getTime()));
java.sql.Timestamp col8 = rs.getTimestamp("unblock_date_time");
blockStatus.setUnblockDateTime(rs.wasNull() ? null : new java.util.Date(col8.getTime()));
String col9 = rs.getString("company_code");
blockStatus.setCompanyCode(rs.wasNull() ? null : col9);
String col10 = rs.getString("company_type");
blockStatus.setCompanyType(rs.wasNull() ? null : col10);
String col11 = rs.getString("user_block");
blockStatus.setUserBlock(rs.wasNull() ? null : col11);
String col12 = rs.getString("mawb");
blockStatus.setMawb(rs.wasNull() ? null : col12);
String col13 = rs.getString("hawb");
blockStatus.setHawb(rs.wasNull() ? null : col13);
String col14 = rs.getString("flight_no");
blockStatus.setFlightNo(rs.wasNull() ? null : col14);
java.sql.Timestamp col15 = rs.getTimestamp("flight_date");
blockStatus.setFlightDate(rs.wasNull() ? null : new java.util.Date(col15.getTime()));
String col16 = rs.getString("user_unblock");
blockStatus.setUserUnblock(rs.wasNull() ? null : col16);
java.sql.Timestamp col17 = rs.getTimestamp("modified_date_time");
blockStatus.setModifiedDateTime(rs.wasNull() ? null : new java.util.Date(col17.getTime()));
Integer col18 = rs.getInt("auto_block_profile_id");
blockStatus.setAutoBlockProfileId(rs.wasNull() ? null : col18);
return blockStatus;
}
