StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
8481436
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-12-12T21:55:20.390
FavoriteCount
0
LastActivityDate
2011-12-12T22:18:02.093
LastEditDate
2011-12-12T22:18:02.093
LastEditorUserId
435706
OwnerUserId
435706
ParentId
8480130
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
<p>Here is how i would do it:</p> <pre><code> StringBuffer text = new StringBuffer(); HttpURLConnection conn = null; InputStreamReader in = null; BufferedReader buff = null; try { URL page = new URL( "http://example.com/"); // URLEncoder.encode(someparameter); use when passing params that may contain symbols or spaces use URLEncoder to encode it and conver space to %20...etc other wise you will get a 404 conn = (HttpURLConnection) page.openConnection(); conn.connect(); /* use this if you need to int responseCode = conn.getResponseCode(); if (responseCode == 401 || responseCode == 403) { // Authorization Error Log.e(tag, "Authorization Error"); throw new Exception("Authorization Error"); } if (responseCode >= 500 && responseCode <= 504) { // Server Error Log.e(tag, "Internal Server Error"); throw new Exception("Internal Server Error"); }*/ in = new InputStreamReader((InputStream) conn.getContent()); buff = new BufferedReader(in); String line = "anything"; while (line != null) { line = buff.readLine(); String found = interpretHtml(line); if(null != found) return found; // comment the previous 2 lines and this one if u need to load the whole html document. text.append(line + "\n"); } } catch (Exception e) { Log.e(Standards.tag, "Exception while getting html from website, exception: " + e.toString() + ", cause: " + e.getCause() + ", message: " + e.getMessage()); } finally { if (null != buff) { try { buff.close(); } catch (IOException e1) { } buff = null; } if (null != in) { try { in.close(); } catch (IOException e1) { } in = null; } if (null != conn) { conn.disconnect(); conn = null; } } if (text.toString().length() > 0) { return interpretHtml(text.toString()); // use this if you don't need to load the whole page. } else return null; } private String interpretHtml(String s){ if(s.startsWidth("<textTag class=\"text\"")){ return s.substring(22, s.length() - 10); } return null; } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POParsing html in java for an android app
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USShereef Marzouk
UserOwnerUserId
1. USShereef Marzouk
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POParsing html in java for an android app
  singulars
  PostTypePostTypeId
  PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTAcceptedByOriginator
2. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
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.