StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
8606131
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-12-22T15:37:38.447
FavoriteCount
0
LastActivityDate
2011-12-22T15:44:11.433
LastEditDate
2011-12-22T15:44:11.433
LastEditorUserId
637853
OwnerUserId
637853
ParentId
8606070
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
First, you should define whether exact matches are necessary or if the parameters should be contained and there might be additional text in the description. Exact matches For exact matches, you can use the or-condition: <pre><code>if ( (car.getDescription().equals(description) | car.getDescription().equals(description2) ) && car.getHireDate().equals("") ) { ... } </code></pre> This means that if the description exactly matches <code>description</code> or <code>description2</code> you get a hit. Alternatively you could concatenate the parameters if you know the order: <pre><code>if ( car.getDescription().equals(description + " " + description2) && car.getHireDate().equals("") ) { ... } </code></pre> This would match "Blue Mustang" but not "Mustang Blue". Optionally you could make the concatenated string a regular expression in order to allow for arbitrary whitespace: <pre><code>if ( car.getDescription().matches("\\s*\\b" + description + "\\b\\s*\\b" + description2 + "\\b\\s*") && car.getHireDate().equals("") ) { ... } </code></pre> This would match "    Blue   Mustang    " etc. but not "BlueMustang" due to the word boundary requirements (<code>"\\b"</code>). Note that there are many more possibilities so you should define how you want to match first. Parameters contained If you want to get all descriptions that contain both parameters, use <code>contains(...)</code> instead: <pre><code>if ( car.getDescription().contains(description) && car.getDescription().contains(description2) && car.getHireDate().equals("") ) { ... } </code></pre> Note that this would match "Blue Ford Mustang", too ("Blue" and "Mustang" being the parameters).
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POSearching object arraylist confusion
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USThomas
UserOwnerUserId
1. USThomas
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.