android - Android:我们可以在运行UI Thread时将数据插入sqlite吗？

我发现同样的问题，但没有答案。这就是为什么我想在这里再次询问：

这是我的主线程上的类：

private class DownloadTask extends AsyncTask<String, Void, String>
    {
        @Override
        protected String doInBackground(String... urls)
        {
            // TODO Auto-generated method stub
            XMLParser parser1 = new XMLParser();//System.out.println("XML before catching");
            String result = parser1.getXmlFromUrl("http://exampl1.com/arrival.XML");
            xml=result;
            Document doc = parser1.getDomElement(xml);
            NodeList nl = doc.getElementsByTagName(DOM_KEY_CONTENT);
            arrayList = new ArrayList<HashMap<String,String>>();
            databaseAirport myDbHelper ;
            myDbHelper = new databaseAirport(ctx);
            myDbHelper.open();
            for (int i = 0; i < nl.getLength(); i++)
            {
                // creating new HashMap
                HashMap<String, String> mapData= new HashMap<String, String>();
                Element e = (Element) nl.item(i);
                // adding each child node to HashMap key => value
                mapData.put(DOM_KEY_ID, parser1.getValue(e, DOM_KEY_ID));
                mapData.put(DOM_KEY_PRI_ID,parser1.getValue(e,DOM_KEY_PRI_ID));
                mapData.put(DOM_KEY_FDATE, parser1.getValue(e, DOM_KEY_FDATE));
                mapData.put(DOM_KEY_ORDER, parser1.getValue(e, DOM_KEY_ORDER));

                arrayList.add(mapData);

字符串a1，b1，c1，d1为var global;

                a1 = parser1.getValue(e,  DOM_KEY_ID);
                b1 = parser1.getValue(e,  DOM_KEY_PRI_ID);
                c1 = parser1.getValue(e,  DOM_KEY_FDATE);
                d1 = parser1.getValue(e,  DOM_KEY_ORDER);

                System.out.println(a1+b1+c1+d1);
                myDbHelper.insertArrival(Integer.parseInt(a1), c1, Integer.parseInt(d1));

            }
            long size = arrayList.size();
            System.out.println("Size of arrayList "+size);
            return result;
        }
    }

正常打印a1，b1，c1和d1

这是错误：

java.lang.RuntimeException: An error occured while executing doInBackground()
at android.os.AsyncTask$3.done(AsyncTask.java:299)
at java.util.concurrent.FutureTask$Sync.innerSetException(FutureTask.java:273)
at java.util.concurrent.FutureTask.setException(FutureTask.java:124)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:307)
at java.util.concurrent.FutureTask.run(FutureTask.java:137)
at android.os.AsyncTask$SerialExecutor$1.run(AsyncTask.java:230)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1076)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:569)
at java.lang.Thread.run(Thread.java:856)

**Caused by: java.lang.NullPointerException**


at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:224)
    at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:164)
    at com.airport.serverside.databaseAirport.open(databaseAirport.java:76)
    at com.airport.serverside.AirportActivity$DownloadWebPageTask.doInBackground(AirportActivity.java:133)
    at com.airport.serverside.AirportActivity$DownloadWebPageTask.doInBackground(AirportActivity.java:1)
    at android.os.AsyncTask$2.call(AsyncTask.java:287)
    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:305)

已编辑

74  public databaseAirport open() throws SQLException
75    {
76       db = DBHelper.getWritableDatabase();
77        return this;
78    }

谁能帮我吗 ？
提前致谢 ...

最佳答案

我还面临数据库被锁定的问题。我使用内容提供程序摆脱了这一点。可能对您也有帮助。

我提到了Google IO应用http://code.google.com/p/iosched/。

关于android - Android:我们可以在运行UI Thread时将数据插入sqlite吗？，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/13107650/