Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- I have Problem Ask in StackOverflow, Please visit and Give Me solution.
- http://stackoverflow.com/questions/14416776/how-to-display-data-in-tablular-format-in-android-using-mysql-database
- PostExecute method:
- protected void onPostExecute(Integer result) {
- for (int i = 0; i < tableInfo.size(); i++) {
- row = new TableRow(LeagueTable.this);
- TextView t1, t2, t3, t4, t5;
- t1 = new TextView(LeagueTable.this);
- t2 = new TextView(LeagueTable.this);
- t3 = new TextView(LeagueTable.this);
- t4 = new TextView(LeagueTable.this);
- t5 = new TextView(LeagueTable.this);
- t1.setText(teamrank.get(i));
- t2.setText(teamName.get(i));
- t3.setText(teamMatchedPlayed.get(i));
- t4.setText(teamGoalDiff.get(i));
- t5.setText(teamPoint.get(i));
- t2.setPadding(170, 1, 1, 1);
- row.setPadding(70, 1, 1, 1);
- row.addView(t1);
- row.addView(t2);
- row.addView(t3);
- row.addView(t4);
- row.addView(t5);
- grade_matrix.addView(row, new TableLayout.LayoutParams(
- LayoutParams.WRAP_CONTENT,
- LayoutParams.WRAP_CONTENT));
- }
- Getting From web in Xml Format:
- **01-19 16:58:50.355: D/response is :**
- <Bpn_Request_Id></Bpn_Request_Id><Response_Code><Pcode>1</Pcode><Scode>Successful</Scode></Response_Code>
- <Data>
- <LeagueTable>
- <team>
- <rank><![CDATA[1]]></rank>
- <name><![CDATA[Manchester United]]></name>
- <mp><![CDATA[13]]></mp>
- <gd><![CDATA[+23]]></gd>
- <point><![CDATA[32]]></point>
- </team>
- <team>
- <rank><![CDATA[2]]></rank>
- <name><![CDATA[Manchester City]]></name>
- <mp><![CDATA[12]]></mp>
- <gd><![CDATA[+8]]></gd>
- <point><![CDATA[26]]></point>
- </team>
- <team>
- <rank><![CDATA[3]]></rank>
- <name><![CDATA[Chelsea]]></name>
- <mp><![CDATA[14]]></mp>
- <gd><![CDATA[+6]]></gd>
- <point><![CDATA[26]]></point>
- </team>
- <team>
- <rank><![CDATA[4]]></rank>
- <name><![CDATA[Tottenham Hotsput]></name>
- <mp><![CDATA[13]]></mp>
- <gd><![CDATA[+13]]></gd>
- <point><![CDATA[25]]></point>
- </team>
- <team>
- <rank><![CDATA[5]]></rank>
- <name><![CDATA[Everton]></name>
- <mp><![CDATA[11]]></mp>
- <gd><![CDATA[+12]]></gd>
- <point><![CDATA[25]]></point>
- </team>
- </LeagueTable>
- </Data>
- </Es_Response>!!!
- Xmlparser.java File
- public static EsResponse parseLeagueTable(String xml) {
- try {
- XMLReader xmlreader = initializeReader();
- TableHandlertandler= new TableHandler();
- // assign our handler
- xmlreader.setContentHandler(tandler);
- // perform the synchronous parse
- xmlreader.parse(new InputSource(new StringReader(xml)));
- return tandler.getEsResponse() ;
- } catch (Exception e) {
- e.printStackTrace();
- return null;
- }
- }
- TableHandler.java
- public class TableHandler extends DefaultHandler {
- private TableData tableData;
- private TableItems tableItems;
- private tableInfo tableInfo;
- private ResponseCode responseCode;
- private EsResponse esResponse;
- private StringBuilder content;
- publicTableHandler() {
- tableInfo = new TableInfo();
- content = new StringBuilder();
- }
- public TableData getTableData() {
- return tableData;
- }
- public TableItems getTableItems() {
- return tableItems;
- }
- public TableInfo getTableInfo() {
- return tableInfo;
- }
- public EsResponse getEsResponse() {
- return this.esResponse;
- }
- public void startElement(String uri, String localName, String qName,
- Attributes atts) throws SAXException {
- content = new StringBuilder();
- if (localName.equalsIgnoreCase("Es_Response")) {
- esResponse = new EsResponse();
- } else if (localName.equalsIgnoreCase("Response_Code")) {
- responseCode = new ResponseCode();
- } else if (localName.equalsIgnoreCase("Data")) {
- tableData = new TableData();
- } else if (localName.equalsIgnoreCase("LeagueTable")) {
- tableInfo = new TableInfo();
- } else if (localName.equalsIgnoreCase("Team")) {
- tableItems = new tableItems();
- }
- }
- public void endElement(String uri, String localName, String qName)
- throws SAXException {
- if (localName.equalsIgnoreCase("Pcode")) {
- responseCode.setpCode(content.toString());
- }
- else if (localName.equalsIgnoreCase("Response_Code")) {
- esResponse.setResponseCode(responseCode);
- } else if (localName.equalsIgnoreCase("Rank")) {
- tableItems.getTeamRank(content.toString());
- } else if (localName.equalsIgnoreCase("Name")) {
- tableItems.getTeamName(content.toString());
- } else if (localName.equalsIgnoreCase("MP")) {
- tableItems.getMatchPlayed(content.toString());
- } else if (localName.equalsIgnoreCase("GD")) {
- tableItems.getGoalDiff(content.toString());
- } else if (localName.equalsIgnoreCase("Point")) {
- tableItems.getPoint(content.toString());
- } else if (localName.equalsIgnoreCase("LeagueTable")) {
- tableInfo.add(tableItems);
- } else if (localName.equalsIgnoreCase("Data")) {
- tableData.setTableInfo(tableInfo);
- } else if (localName.equalsIgnoreCase("Es_Response")) {
- esResponse.setTableData(tableData);
- }
- }
- public void characters(char[] ch, int start, int length)
- throws SAXException {
- content.append(ch, start, length);
- }
- TableInfo.java
- public class TableInfo extends ArrayList<GradeItems>{
- /**
- *
- */
- private static final long serialVersionUID = -4485391163446089750L;
- public TableItems tableItems;
- public TableItems getTabletems() {
- return tableItems;
- }
- public void setTalbeItems(TableItems tableItems) {
- this.tableItems= tableItems;
- }
- TableItems.Java
- public class TableItems {
- private String rank, name, mp
- gd, point;
- public String getTeamRank() {
- return rank;
- }
- public void setTeamRank(String rank) {
- this.rank= rank;
- }
- Same as others
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement