首页
学习
活动
专区
圈层
工具
发布
首页
学习
活动
专区
圈层
工具
MCP广场
社区首页 >问答首页 >正在将数据插入SQLite数据库,数据类型不匹配

正在将数据插入SQLite数据库,数据类型不匹配
EN

Stack Overflow用户
提问于 2015-03-16 15:35:13
回答 1查看 6.3K关注 0票数 0

我想使用SQLite将数据插入到数据库中,但是我做不到。我按下了我创建的输入按钮,但数据无法发送到数据库中。我通读了一下LogCat,它显示的内容类似于数据类型不匹配,我不知道它指的是哪种数据类型。

下面是我的代码:

database.java

代码语言:javascript
运行
复制
public class database {

    public static final String MOVIE_NAME = "mName";

    private static final String DATABASE_NAME = "Movie";
    private static final String DATABASE_TABLE = "mList";
    private static final int DATABASE_VERSION = 1;

    private Database db;
    private final Context cont;
    private SQLiteDatabase moviedatabase;

    public static class Database extends SQLiteOpenHelper{

        public Database(Context context) {
            super(context, DATABASE_NAME, null, DATABASE_VERSION);
            // TODO Auto-generated constructor stub
        }

        @Override
        public void onCreate(SQLiteDatabase db) {
            // TODO Auto-generated method stub
            db.execSQL("CREATE TABLE " + DATABASE_TABLE + " (" +
                    MOVIE_NAME + " TEXT NOT NULL);"
            );
        }

        @Override
        public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
            // TODO Auto-generated method stub
            db.execSQL("DROP TABLE IF EXISTS " + DATABASE_NAME);
        }

    }

    public database(Context con){
        cont = con;
    }

    public database open() throws Exception{
        db = new Database(cont);
        moviedatabase = db.getWritableDatabase();
        return this;
    }
    public void close(){
        db.close();
    }

    public void createEntry(String input) {
        // TODO Auto-generated method stub
        ContentValues content = new ContentValues();
        content.put(MOVIE_NAME, input);
        moviedatabase.insert(DATABASE_TABLE, null, content);
    }

    public String getData() {
        // TODO Auto-generated method stub


        String[] col = new String[]{MOVIE_NAME};
        Cursor curs = moviedatabase.query(DATABASE_TABLE, col, null, null, null, null, null);
        String res = "";
        int rowNum = curs.getColumnIndex(MOVIE_NAME);

        for(curs.moveToFirst(); !curs.isAfterLast(); curs.moveToNext()){
            res = res + curs.getString(rowNum) + "\n";
        }

        return res;
    }

insert.java

代码语言:javascript
运行
复制
public class insert extends Activity{

    Button insBtn;
    EditText insET;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        // TODO Auto-generated method stub
        super.onCreate(savedInstanceState);
        setContentView(R.layout.insert);

        insET = (EditText) findViewById(R.id.insertET);
        insBtn = (Button) findViewById(R.id.insertBtn);

        insBtn.setOnClickListener(new View.OnClickListener() {

            @Override
            public void onClick(View v) {
                // TODO Auto-generated method stub

                try{
                    String input = insET.getText().toString();

                    database newEntry = new database(insert.this);
                    newEntry.open();
                    newEntry.createEntry(input);
                    newEntry.close();
                }catch(Exception e){
                    e.printStackTrace();
                }
            }
        });
    }

list.java

代码语言:javascript
运行
复制
public class list extends Activity{
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        // TODO Auto-generated method stub
        super.onCreate(savedInstanceState);
        setContentView(R.layout.list);

        TextView d = (TextView) findViewById(R.id.movieName);
        database movies = new database(this);

        try{
            movies.open();
            String data = movies.getData();
            movies.close();
            d.setText(data);
        }catch(Exception e){
            e.printStackTrace();
        }
    }

}

LogCat:

代码语言:javascript
运行
复制
03-16 07:28:17.617: E/SQLiteLog(3194): (20) statement aborts at 6: [INSERT INTO mList(mName) VALUES (?)] datatype mismatch
03-16 07:28:17.635: E/SQLiteDatabase(3194): Error inserting mName=dfsefsd
03-16 07:28:17.635: E/SQLiteDatabase(3194): android.database.sqlite.SQLiteDatatypeMismatchException: datatype mismatch (code 20)
03-16 07:28:17.635: E/SQLiteDatabase(3194):     at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method)
03-16 07:28:17.635: E/SQLiteDatabase(3194):     at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:775)
03-16 07:28:17.635: E/SQLiteDatabase(3194):     at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788)
03-16 07:28:17.635: E/SQLiteDatabase(3194):     at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86)
03-16 07:28:17.635: E/SQLiteDatabase(3194):     at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469)
03-16 07:28:17.635: E/SQLiteDatabase(3194):     at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339)
03-16 07:28:17.635: E/SQLiteDatabase(3194):     at com.example.project.database.createEntry(database.java:63)
03-16 07:28:17.635: E/SQLiteDatabase(3194):     at com.example.project.insert$1.onClick(insert.java:34)
03-16 07:28:17.635: E/SQLiteDatabase(3194):     at android.view.View.performClick(View.java:4204)
03-16 07:28:17.635: E/SQLiteDatabase(3194):     at android.view.View$PerformClick.run(View.java:17355)
03-16 07:28:17.635: E/SQLiteDatabase(3194):     at android.os.Handler.handleCallback(Handler.java:725)
03-16 07:28:17.635: E/SQLiteDatabase(3194):     at android.os.Handler.dispatchMessage(Handler.java:92)
03-16 07:28:17.635: E/SQLiteDatabase(3194):     at android.os.Looper.loop(Looper.java:137)
03-16 07:28:17.635: E/SQLiteDatabase(3194):     at android.app.ActivityThread.main(ActivityThread.java:5041)
03-16 07:28:17.635: E/SQLiteDatabase(3194):     at java.lang.reflect.Method.invokeNative(Native Method)
03-16 07:28:17.635: E/SQLiteDatabase(3194):     at java.lang.reflect.Method.invoke(Method.java:511)
03-16 07:28:17.635: E/SQLiteDatabase(3194):     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793)
03-16 07:28:17.635: E/SQLiteDatabase(3194):     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560)
03-16 07:28:17.635: E/SQLiteDatabase(3194):     at dalvik.system.NativeStart.main(Native Method)
03-16 07:28:26.418: I/Choreographer(3194): Skipped 33 frames!  The application may be doing too much work on its main thread.
EN

Stack Overflow用户

发布于 2015-03-16 16:19:21

首先开始修改你的代码

代码语言:javascript
运行
复制
db.execSQL("DROP TABLE IF EXISTS " + DATABASE_NAME);

代码语言:javascript
运行
复制
db.execSQL("DROP TABLE IF EXISTS " + DATABASE_TABLE);

这很有可能解释了数据类型错误。

票数 1
EN
查看全部 1 条回答
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/29071692

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档