Android：将sqlite数据库内容加载到webview [英] Android: load sqlite database content to webview

问题描述

我有一个 sqlite 数据库，其中我要在 webview ,,
中加载内容，因为我想 从数据库中选择并显示在网络视图中 ，有任何方法吗？

I have an sqlite database in which I have a content I want to load in webview ,, as I want to select from database and show in web view,, Is there any way to do so ?

public class TataworatYawmeeh extends Activity {
    WebView webView;
    String javascrips;

    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);   
        setContentView(R.layout.tataworat);

        webView = (WebView) findViewById(R.id.tatworatWebView);
        webView.setBackgroundColor(0x00000000);

        try {       
            DataBaseHelper myDbHelper = new DataBaseHelper(this);

            myDbHelper = new DataBaseHelper(this);

            try {
                myDbHelper.createDataBase();

                String selectQuery = "SELECT  * FROM 'nnn'";
                SQLiteDatabase db = myDbHelper.getReadableDatabase();
                db.execSQL(selectQuery);
            } catch (IOException ioe) {      
                throw new Error("Unable to create database");
            }

            try {
                myDbHelper.openDataBase();

            } catch (SQLException sqle) {
                throw sqle;
            }
        }   
    }
}

推荐答案

您必须使用Java类作为接口：

You have to use a Java Class as interface:

DataLoader dl = new DataLoader();

// For passing the data
webView.addJavascriptInterface(dl, "accessor");
webView.loadUrl("file:///android_asset/yourpage.html");

在您的活动中，您可以声明匿名类DataLoader，使用get方法检索数据并返回它使用JSON这样：

In your activity you can declare the anonymous class DataLoader, with a get method where you retrieve data and return it using JSON like this:

class ChartDataLoader {
    public String getData() {
        String selectQuery = "SELECT  * FROM 'nnn'";
        SQLiteDatabase db = myDbHelper.getReadableDatabase();
        result = db.execSQL(selectQuery);

        Gson gson = new Gson();
        data = gson.toJson(result, resultype.class);

        return data;
    }
}

最后，您可以在html ，using javascript：

And finally, you can use this data in your html, using javascript:

<script id="source" language="javascript" type="text/javascript">
     var obj = window.accessor;
     var data = JSON.parse(obj.getBalances());
     /* Loop */
</script>

这篇关于Android：将sqlite数据库内容加载到webview的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！