English 中文(简体)
安康部队关闭 在执行ql声明时发生
原标题:Android Force Closed Error Occured when execute sql statement

我在打开我的安装机时大错,随函附上我的代码。

package my.package;

import android.app.Activity;
import android.content.Intent;
import android.os.Bundle;
import android.os.Handler;
import android.os.Message;
import android.widget.Toast;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import java.util.Locale;
import android.app.ProgressDialog;
import android.content.Context;

public class ContentLoader extends Activity{

    private ProgressDialog pDialog;
    private Context cntxt;
    private static String DBPATH="data/data/my.package/databases/";
    private static String DBNAME="mydb.db";

    public void onCreate(Bundle b){
        super.onCreate(b);
        setContentView(R.layout.content_loader);
        cntxt = this.getApplicationContext();

        //pBar = (ProgressBar) findViewById(R.id.loader);
        //pBar.showContextMenu();
        pDialog = ProgressDialog.show(this, null, "Loading Application Content", true);
        final Handler handler = new Handler(){
            public void handleMessage(Message msg){
                pDialog.dismiss();
                Intent rem = new Intent(getApplicationContext(), mynextativity.class);              
                startActivityForResult(rem,0);
            }
        };

        Thread thread = new Thread(){
            public void run(){
                createDBOnFirstInstance();
                //checkDB();                
                handler.sendEmptyMessage(0);
            }
        };
        thread.start();
    }

    private boolean checkDB(){
        boolean found=true;
        String path = DBPATH + DBNAME;
        SQLiteDatabase checkDB=null;
        try{
            checkDB = SQLiteDatabase.openDatabase(path, null, SQLiteDatabase.OPEN_READONLY);            

        }catch(Exception e){
            found = false;
        }
        if(checkDB != null){             
            checkDB.close();
        }       
        return found;
    }

    public void createDBOnFirstInstance() throws SQLException{
        SQLiteDatabase db;
        if(checkDB()!=true){
                db = openOrCreateDatabase("mydb.db", SQLiteDatabase.CREATE_IF_NECESSARY, null);
                db.setLocale(Locale.getDefault());
                db.setVersion(1);
                db.setLockingEnabled(true);

                final String CREATE_ERR_TABLE = "CREATE TABLE Error_Log("
                                                +"Err_Id INTEGER PRIMARY KEY,"
                                                +"Err_Trace TEXT,"
                                                +"Err_Action TEXT,"
                                                +"Err_Occ_Date TEXT,"
                                                +"Err_Occ_Time TEXT)";

                db.execSQL(CREATE_ERR_TABLE);
                db.close(); 
        }   
    }   
}

当我安装我的照片时,它将建立一个数据库和表格,介绍第一个事件,我打开了照片,从而造成严重错误。 如果我对以下守则发表评论的话,我会评论一下。

final String CREATE_ERR_TABLE = "CREATE TABLE Error_Log("
                                                +"Err_Id INTEGER PRIMARY KEY,"
                                                +"Err_Trace TEXT,"
                                                +"Err_Action TEXT,"
                                                +"Err_Occ_Date TEXT,"
                                                +"Err_Occ_Time TEXT)";

                db.execSQL(CREATE_ERR_TABLE);
                db.close();

没有发生重大错误,我有工作罚款。 请指导我。

最佳回答

你可以尝试这样做。

final String CREATE_ERR_TABLE = "CREATE TABLE **IF NOT EXISTS** Error_Log ("
                                                +"Err_Id INTEGER PRIMARY KEY **AUTOINCREMENT**,"
                                                +"Err_Trace TEXT,"
                                                +"Err_Action TEXT,"
                                                +"Err_Occ_Date TEXT,"
                                                +"Err_Occ_Time TEXT)**;**";
                db.execSQL(CREATE_ERR_TABLE);
                db.close();
问题回答




相关问题
what is wrong with this mysql code

$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...

Users asking for denormalized database

I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...

Easiest way to deal with sample data in Java web apps?

I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How can I know if such value exists in database? (ADO.NET)

For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...

热门标签