StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHaving trouble saving node input to a string
primarykey
Id
19053885
data
AcceptedAnswerId
0
AnswerCount
3
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-09-27T14:56:17.367
FavoriteCount
0
LastActivityDate
2013-09-27T15:20:49.330
LastEditDate
2013-09-27T15:12:49.940
LastEditorUserId
1853785
OwnerUserId
2820236
ParentId
0
PostTypeId
1
Score
0
ViewCount
70
LastEditorDisplayName
text
Body
<p>Below is a class I have for a 2 class project. Basically I want to parse the title of the wiki page, and save it to the string title or something I can call from another class using something like <code>retrieveTitle.setText(WikiSearcherExtension.title);</code> In eclipse its telling me the local variable title isnt being used at all to store the node information.</p> <p>It wouldnt let me paste the xml as a block of code so here is the url I have been using <a href="http://en.wikipedia.org/w/api.php?action=query&prop=revisions&format=xml&rvprop=timestamp&rvlimit=1&rvtoken=rollback&titles=test&redirects=" rel="nofollow">http://en.wikipedia.org/w/api.php?action=query&prop=revisions&format=xml&rvprop=timestamp&rvlimit=1&rvtoken=rollback&titles=test&redirects=</a></p> <pre><code>public class WikiParserTrials { private String wikiInformation; private String wikiUrl; String title; public void urlRefactor(String url) throws IOException { String wikiPageName = url.replaceAll(" ", "_"); wikiUrl = "http://en.wikipedia.org/w/api.php?action=query&prop=revisions&format=xml&rvprop=timestamp&rvlimit=1&rvtoken=rollback&titles=test&redirects="; setUrlInformation(); } private void setUrlInformation() throws IOException { URL url = new URL(wikiUrl); URLConnection connection = url.openConnection(); BufferedReader reader = new BufferedReader(new InputStreamReader(connection.getInputStream())); wikiInformation = ""; for (String line = reader.readLine(); line != null; line = reader.readLine()) { wikiInformation += line; } } public class ReadAndPrintXMLFile { public void main(String argv[]) { try { DocumentBuilderFactory dbf = DocumentBuilderFactory.newInstance(); DocumentBuilder db = dbf.newDocumentBuilder(); InputSource is = new InputSource(); is.setCharacterStream(new StringReader(wikiInformation)); Document doc = db.parse(is); NodeList nodes = doc.getElementsByTagName("normalized"); for (int i = 0; i < nodes.getLength(); i++) { Element element = (Element) nodes.item(i); NodeList name = element.getElementsByTagName("to"); Element line = (Element) name.item(0); String title = (getCharacterDataFromElement(line)); } } catch (Throwable t) { t.printStackTrace(); } } } } </code></pre>
Tags
<java><xml><parsing><nodes><getter-setter>
Title
Having trouble saving node input to a string
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USomainegra
UserOwnerUserId
1. USSam Haito
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. PO
  singulars
  PostTypePostTypeId
  PTAnswer
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
3. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POHaving trouble saving node input to a string
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTApproveEditSuggestion
CommentsPostId
1. COWhat eclipse is tellin you that title is no being used, which is true, you need to store it in a property of the class. Note that you are re-declaring title locally. So the property title never gets it value.
  singulars
  PostPostId
  POHaving trouble saving node input to a string
  UserUserId
  USluiso1979

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.