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;
}
}