sqlite创建表成功，insert不报错，但没有数据插入

Question

sqlite创建的时候没问题，插入的时候没有反应，能运行，也不报错。
在DDMS里导出那个db文件查看，里面有创建的表，但是没有插入的数据。
建表语句

 public class MyDatabaseHelper extends SQLiteOpenHelper{
    public static final String CREAT_Msg = "creat table Msg (" +"id integer primary key autoincrement, "
            +"用户名 text, "+"密码 text)";
    public static final String CREAT_OTHER = "creat table Other (" +"id integer primary key autoincrement, "
            +"用户名 text, "+"密码 text)";
    public static final String CREAT_Info = "create table Info ("+"id integer primary key autoincrement, "
            +"用户名 text, "+"密码 text)";
    public MyDatabaseHelper(Context context, String name, CursorFactory factory, int version) {
        super(context, name, factory, version);
        // TODO Auto-generated constructor stub
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        // TODO Auto-generated method stub
        db.execSQL(CREAT_Info);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // TODO Auto-generated method stub
        /*
        switch (oldVersion) {
        case 2:
            db.execSQL(CREAT_Msg);
        case 3:
            db.execSQL(CREAT_OTHER);
        default:
        }
        */
    }
}

对数据库进行插入和查找操作

 public class MyDataBase {
    //public static final String DB_NAME = "MyDatabase.db";
    //public static final int VERSION = 1;
    private static MyDataBase myDataBase;
    private SQLiteDatabase database;
    private MyDataBase(Context context) {
        // TODO Auto-generated constructor stub
        MyDatabaseHelper databaseHelper = new MyDatabaseHelper(context,"MyDatabase.db",null,1);
        database=databaseHelper.getWritableDatabase();
    }
    public synchronized static MyDataBase getInstance(Context context){
        if(myDataBase == null){
            myDataBase=new MyDataBase(context);
        }
        return myDataBase;
    }
    public void saveUser(User user){
        if(user != null){
            Log.d("FromMyDatabase"+user.getUsername()+"saveUser",user.getPassword()+"saveUser");
            ContentValues contentValues = new ContentValues();
            contentValues.put("用户名",user.getUsername());
            contentValues.put("密码", user.getPassword());
            database.insert("Info",null,contentValues);
            //Log.d("保存数据了", user.getUsername()+user.getPassword());
        }
    }
    public List<User> loadUser(){
        List<User> lists = new ArrayList<User>();
        Cursor cursor = database.query("Info",null,null,null,null,null,null);
        //Log.d("开始下载数据",cursor.getCount()+"");

        if(cursor.moveToFirst()){
            do {
                User user= new User();
                user.setUsername(cursor.getString(cursor.getColumnIndex("用户名")));
                user.setPasword(cursor.getString(cursor.getColumnIndex("密码")));
                //Log.d("下载数据"+user.getUsername(),user.getPassword());
                lists.add(user);
            } while (cursor.moveToNext());
        }
        cursor.close();
        /*
        if(cursor != null){
            Log.d("要下数据了","下载");
            int i=1;
            User user=new User();
            while(cursor.moveToNext()){
                //User user= new User();
                user.setUsername(cursor.getString(cursor.getColumnIndex("用户名")));
                user.setPasword(cursor.getString(cursor.getColumnIndex("密码")));
                Log.d("下载数据",i+"");
                //Log.d("下载数据"+user.getUsername(),user.getPassword());
                i++;
                lists.add(user);    
            }
        }*/
        return lists;
    }
}

Answer 1

http://blog.csdn.net/mangobar/article/details/50977914