SQLite及adb的简单使用

Love The Way You Lie 2024-02-17 22:13 41阅读 0赞

## 1 SQLite初识 ##

[SQLite][]:小型，关系型数据库  
安卓访问数据库：SQLiteOpenHelper 是一个抽象类，需要继承并复写其中的方法

public class SQLiteActivity extends Activity {
    
    	private static final String DB_NAME = "test_jiaozl_db";
    	Button createDB, updateDB, insertTable, updateTable, queryTable;
    
    	protected void onCreate(Bundle savedInstanceState) {
    		super.onCreate(savedInstanceState);
    
    		setContentView(R.layout.main);
    
    		createDB = (Button) findViewById(R.id.createdatabase);
    		createDB.setOnClickListener(new CreateListener());
    
    		updateDB = (Button) findViewById(R.id.updatedatabase);
    		updateDB.setOnClickListener(new UpdateListener());
    
    		insertTable = (Button) findViewById(R.id.inserttable);
    		insertTable.setOnClickListener(new InsertListener());
    
    		updateTable = (Button) findViewById(R.id.updatetable);
    		updateTable.setOnClickListener(new UpdateRecordListener());
    
    		queryTable = (Button) findViewById(R.id.querytable);
    		queryTable.setOnClickListener(new QueryListener());
    
    	}
    
    	class CreateListener implements OnClickListener {
    
    		@Override
    		public void onClick(View arg0) {
    			// 创建一个DatabaseHelper对象
    			DatabaseHelper dbHelper = new DatabaseHelper(SQLiteActivity.this,
    					DB_NAME);
    			// 只有调用了DatabaseHelper对象的getReadableDatabase等方法，才会真正创建数据库对象
    			SQLiteDatabase db = dbHelper.getReadableDatabase();
    		}
    	}
    
    	class UpdateListener implements OnClickListener {
    		@Override
    		public void onClick(View arg0) {
    			DatabaseHelper dbHelper = new DatabaseHelper(SQLiteActivity.this,
    					DB_NAME, 2);
    			SQLiteDatabase db = dbHelper.getReadableDatabase();
    		}
    	}
    
    	class InsertListener implements OnClickListener {
    
    		@Override
    		public void onClick(View arg0) {
    			// 生成ContentValues对象
    			ContentValues values = new ContentValues();
    			// 向该对象中插入键值对，其中键是列名，值是希望插入到这一列的值
    			values.put("id", 1);
    			values.put("name", "zhangsan");
    			DatabaseHelper dbHelper = new DatabaseHelper(SQLiteActivity.this,
    					DB_NAME, 2);
    			SQLiteDatabase db = dbHelper.getWritableDatabase();
    			// 调用insert方法
    			db.insert("user", null, values);
    		}
    	}
    
    	class UpdateRecordListener implements OnClickListener {
    
    		@Override
    		public void onClick(View arg0) {
    			DatabaseHelper dbHelper = new DatabaseHelper(SQLiteActivity.this,
    					DB_NAME, 2);
    			SQLiteDatabase db = dbHelper.getWritableDatabase();
    
    			ContentValues values = new ContentValues();
    			values.put("name", "zhangsanfeng");
    
    			db.update("user", values, "id=?", new String[] { "1" });
    		}
    	}
    
    	class QueryListener implements OnClickListener {
    
    		@Override
    		public void onClick(View arg0) {
    			DatabaseHelper dbHelper = new DatabaseHelper(SQLiteActivity.this,
    					DB_NAME, 2);
    			SQLiteDatabase db = dbHelper.getWritableDatabase();
    
    			// 获得游标
    			Cursor cursor = db.query("user", new String[] { "id", "name" },
    					"id=?", new String[] { "1" }, null, null, null);
    			while (cursor.moveToNext()) {
    				String name = cursor.getString(cursor.getColumnIndex("name"));
    				System.out.println("query---->" + name);
    			}
    
    		}
    	}
    
    }

public class DatabaseHelper extends SQLiteOpenHelper {
    
    	private static final int VERSION = 1;
    
    	// 当前对象，表名， ， 版本
    	public DatabaseHelper(Context context, String name, CursorFactory factory,
    			int version) {
    		super(context, name, factory, version);
    		// TODO Auto-generated constructor stub
    	}
    
    	public DatabaseHelper(Context context, String name, int version) {
    		this(context, name, null, version);
    	}
    
    	public DatabaseHelper(Context context, String name) {
    		this(context, name, VERSION);
    	}
    
    	// 第一次创建数据库的时候调用
    	@Override
    	public void onCreate(SQLiteDatabase db) {
    		// TODO Auto-generated method stub
    		System.out.println("create a database");
    		db.execSQL("create table user(id int, name varchar(20))");
    	}
    
    	@Override
    	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    		// TODO Auto-generated method stub
    		System.out.println("update a database");
    	}
    
    }

## 2 通过adb（Android Debug Bridge，起到调试桥的作用）调试安卓程序的步骤 ##

**注意：**首先要在dos下输入，adb看是否配置好环境变量；如果没有，将【 D:\\Program Files\\adt-bundle-windows-x86\\adt-bundle-windows-x86\\sdk\\platform-tools】加入path即可

*  dos下输入 【adb shell】 进入安卓模拟机或真机系统目录
 *  找到数据库所在位置后，输入：【sqlite3 数据库名 】： 即可进入数据库操作命令
 *  sqlite命令以.开头  
    .schema ： 查看数据库中有所有表
 *  其他命令与SQL一致  
    select \* from user;

[SQLite]: http://www.sqlite.org