android中sqlite的使用

 

1.在adb中查询android中的数据：

adb shell  ---->data---->data------------->应用的名称--------->sqlite3 数据库名称---------->.databases

 

 

    .databases    :显示数据库

    .tables :显示数据库中的数据表

     .schema  表的结构信息

 

public class MySqliteOpenHelper extends SQLiteOpenHelper{
	
	   private static final String TAG = "MySqliteOpenHelper";
	    
	    private static final int DEFAULTVERSION = 1;
	    private static final String DATABASENAME = "woyo_test";
		
	    public MySqliteOpenHelper(Context context) {
			super(context, DATABASENAME, null, DEFAULTVERSION);
		}
	    
	    public MySqliteOpenHelper(Context context, int version) {
			super(context, DATABASENAME, null, version);
		}
	    

		@Override
		public void onCreate(SQLiteDatabase db) {
			Log.i(TAG, "=========oncreate  database==========");
			db.execSQL("create table user(id int,name varchar(20));");
		}

		@Override
		public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
			Log.i(TAG, "=========onUpgrade  database==========");
			db.execSQL("create table user2(id int,name varchar(20));");
		}
}

 

 

 

public class SqliteActivity extends Activity {

	private static final String TAG = "SqliteActivity";

	private Button btn_create;
	private Button btn_update;
	private Button btn_insert;
	private Button btn_get;

	private SQLiteDatabase db;

	/** Called when the activity is first created. */
	@Override
	public void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.main);
		btn_create = (Button) findViewById(R.id.btn_create);
		btn_update = (Button) findViewById(R.id.btn_update);
		btn_insert = (Button) findViewById(R.id.btn_insert);
		btn_get = (Button) findViewById(R.id.btn_get);
		db = new MySqliteOpenHelper(SqliteActivity.this).getWritableDatabase();

		btn_create.setOnClickListener(new OnClickListener() {

			@Override
			public void onClick(View v) {
				Log.i(TAG, "=====btn_create=====");
				new MySqliteOpenHelper(SqliteActivity.this);
			}
		});

		btn_update.setOnClickListener(new OnClickListener() {

			@Override
			public void onClick(View v) {
				new MySqliteOpenHelper(SqliteActivity.this, 2);
			}
		});

		btn_insert.setOnClickListener(new OnClickListener() {

			@Override
			public void onClick(View v) {
				ContentValues values = new ContentValues();
				values.put("id", 1);
				values.put("name", "antty");
				long id = db.insert("user", null, values);
				Log.i(TAG, "===" + id);
			}
		});

		btn_get.setOnClickListener(new OnClickListener() {

			@Override
			public void onClick(View v) {
				Log.i(TAG, "=======btn_get=======");
				Cursor cursor = db.query("user", new String[] { "id", "name" }, null, null, null, null, null);
				int size = cursor.getCount();
				Log.i(TAG, "=======size:" + size);
				while (cursor.moveToNext()) {
					if (cursor.isLast()) {
						break;
					}
					String id = cursor.getString(cursor.getColumnIndex("id"));
					String name = cursor.getString(cursor.getColumnIndex("name"));
					Log.i(TAG, cursor.getPosition() + "========id:" + id + "==========name:" + name);

				}
			}
		});
	}
}