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