Retrieve data from sqlite database and display in assest folder's HTML page in android

Question

I want to make a dynamic webpage that can display my sqlite database's element in tabular format. How can I create a dynamic webpage in android? I make a static HTML page and put in assest folder. It works but now I want a dynamic webpage. Please help:

package com.Htmlview;
import java.io.IOException;
import java.io.InputStream;
import android.app.Activity;
import android.os.Bundle;
import android.webkit.WebView;

public class Htmlview extends Activity {
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        //setContentView(R.layout.main);
        WebView webview = new WebView(this);
        setContentView(webview);
        try {
            InputStream fin = getAssets().open("index3.html");
                byte[] buffer = new byte[fin.available()];
                fin.read(buffer);
                fin.close();
                webview.loadData(new String(buffer), "text/html", "UTF-8");
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}

This page works ... Help to make it dynamic through code.

gaurav gupta

P. Taylor Goetz · Accepted Answer · 2011-02-18 16:36:33Z

2

Use java.text.MessageFormat:

Put "{0}" markers in your html file.
Read your html file into a string
Create an arguments array from the database record
Call MessageFormat.format(htmlString, dbArgs)
Load the resulting string into the webview.

answered Feb 18, 2011 at 16:36

P. Taylor Goetz

1,1167 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Gaurav Gupta Over a year ago

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "w3.org/TR/html4/loose.dtd"> <html> <head> <title></title> </head> <body> <h1>It my page..testing!</h1> <table> <tr> <td>column</td> <td>column</td> <td>column1</td> <td>column1</td> </tr> <tr> <td>column11</td> <td>column11</td> <td>column11</td> <td>column11</td> </tr> </table> </body> </html> this is my html page

Gaurav Gupta Over a year ago

i want to set values in every column, but unable to do it,please help .thanks in advace

Vladimir Ivanov · Accepted Answer · 2011-02-18 13:18:53Z

0

You can't modify the asset folder in runtime as it compiled at build time. So, you have 2 variants:

You content from database as it is. Just read the bytes and pass them to the webview without storing to anywhere.
Store the content to the file in internal memory and do like you did it with assets. But there is no sence as you already have your data in db.

answered Feb 18, 2011 at 13:18

Vladimir Ivanov

43.2k19 gold badges80 silver badges103 bronze badges

Collectives™ on Stack Overflow

Retrieve data from sqlite database and display in assest folder's HTML page in android

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related