Android使用SQLite数据库,insert没有报错但是数据也没有插入

 String PeopleName;
        PeopleName = nameEditText.getText().toString();/
        SQLiteDatabase DB = dbHelper.getWritableDatabase();
ContentValues values = new ContentValues();
        //values.put("id","1");
        //values.put("number","NumArray[i]");
        values.put("name","PeopleName");
        values.put("score","ScoreArray");
        values.put("mdate","DateArray");
        values.put("evaluate","EvaluateArray");
        DB.insert("score2",null,values);
        values.clear();//清空

public static String ShootScore2 = "create table score2("
            +"id integer primary key autoincrement,"
            +"number int,"
            +"name text,"
            +"score text,"
            +"date text,"
            +"evaluate text)";

 

好了,mdate改回date就好了,表创建的时候用的date,然后因为冲突换了一下名字出问题了

这么关闭这个问题啊,我秀我自己。。。。

values.put("mdate","DateArray");去掉这一行就能正常写入
public static String ShootScore2 = "create table score2("
            +"id integer primary key autoincrement,"
            +"number int,"
            +"name text,"
            +"score text,"
            +"mdate text,"
            +"evaluate text)";

这里也改了,加上这一行还是写入失败,这一行怕是有毒