Sqlite 的小例子

第一步，搞一个数据库帮助类，继承sqliteOpenHelper类

package com.example.db; import android.content.Context; import android.database.<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite.<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDatabase; import android.database.<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite.<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteOpenHelper; import android.database.<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite.<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDatabase.CursorFactory; public class DatabaseHelper extends <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteOpenHelper { private static final String DATABASE_NAME = "test_user1"; private static final int DATABASE_VERSION= 1; private static final String DATABASE_TABLE = "users"; private static final String DATABASE_CREATE = "create table users(" +"id int," +"names varchar(20)" +")"; /* public DatabaseHelper(Context context){ super(context,DATABASE_NAME,null,DATABASE_VERSION); }*/ public DatabaseHelper(Context context,String name,CursorFactory factory,int version) { super(context,DATABASE_VERSION); } /// 该<a href="https://www.jb51.cc/tag/hanshu/" target="_blank" class="keywords">函数</a>在第一次创建 <a href="https://www.jb51.cc/tag/shujuku/" target="_blank" class="keywords">数据库</a>的时候执行 @Override public void onCreate(<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDatabase db) { // TODO Auto-generated method stub System.out.println("Create a database test_user and table users"); db.exec<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>(DATABASE_CREATE); } @Override public void onUpgrade(<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDatabase db,int oldVersion,int newVersion) { // TODO Auto-generated method stub db.exec<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>("Drop table if exists"+DATABASE_TABLE); onCreate(db); } }

第二步，写一个Activity,用来对数据库实现相关操作

package com.example.<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite_test; import com.example.db.DatabaseHelper; import android.app.Activity; import android.content.ContentValues; import android.database.Cursor; import android.database.<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite.<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDatabase; import android.os.Bundle; import android.view.View; import android.widget.Button; public class <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite_test extends Activity { // / 定义变量 private Button createDatabase; private Button updateDatabase; private Button insert; private Button update; private Button query; private Button delete; /** Called when the activity is first created. */ @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main); findViews(); setLisensers(); } // /给按钮绑定单击事件监听器 private void setLisensers() { // TODO Auto-generated method stub createDatabase.setOnClickListener(create_Database); updateDatabase.setOnClickListener(update_Database); insert.setOnClickListener(tab_Insert); update.setOnClickListener(tab_update); query.setOnClickListener(tab_query); delete.setOnClickListener(tab_delete); } // / 根据id得到控件对象 private void findViews() { // TODO Auto-generated method stub this.createDatabase = (Button) findViewById(R.id.createDatabase); this.updateDatabase = (Button) findViewById(R.id.updateDatabase); this.insert = (Button) findViewById(R.id.insert); this.update = (Button) findViewById(R.id.update); this.query = (Button) findViewById(R.id.query); this.delete = (Button) findViewById(R.id.delete); } private View.OnClickListener create_Database = new View.OnClickListener() { @Override public void onClick(View v) { // /<a href="https://www.jb51.cc/tag/shujuku/" target="_blank" class="keywords">数据库</a>存在返回true,不存在返回false if (<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite_test.this.deleteDatabase("test_user1")) System.out.println("数据已经存在！"); else System.out.println("数据<a href="https://www.jb51.cc/tag/wenjian/" target="_blank" class="keywords">文件</a>不存在！"); // / <a href="https://www.jb51.cc/tag/shengcheng/" target="_blank" class="keywords">生成</a>DatabaseHelper对象 DatabaseHelper databaseHelper = new DatabaseHelper( <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite_test.this,"test_user1",1); // / 只有<a href="https://www.jb51.cc/tag/diaoyong/" target="_blank" class="keywords">调用</a> 了getReadableDatabase<a href="https://www.jb51.cc/tag/fangfa/" target="_blank" class="keywords">方法</a>，或者getWritableDatabase // / <a href="https://www.jb51.cc/tag/fangfa/" target="_blank" class="keywords">方法</a>，才会创建<a href="https://www.jb51.cc/tag/shujuku/" target="_blank" class="keywords">数据库</a> databaseHelper.getReadableDatabase(); System.out.println("--------------------—create_Database"); } }; private View.OnClickListener update_Database = new View.OnClickListener() { @Override public void onClick(View v) { // / <a href="https://www.jb51.cc/tag/shengcheng/" target="_blank" class="keywords">生成</a>DatabaseHelper对象 DatabaseHelper databaseHelper = new DatabaseHelper( <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite_test.this,"test_user.db",2); // / 只有<a href="https://www.jb51.cc/tag/diaoyong/" target="_blank" class="keywords">调用</a> 了getReadableDatabase<a href="https://www.jb51.cc/tag/fangfa/" target="_blank" class="keywords">方法</a>，或者getWritableDatabase // / <a href="https://www.jb51.cc/tag/fangfa/" target="_blank" class="keywords">方法</a>，才会更新<a href="https://www.jb51.cc/tag/shujuku/" target="_blank" class="keywords">数据库</a> databaseHelper.getReadableDatabase(); System.out.println("--------------------—update_Database"); } }; private View.OnClickListener tab_Insert = new View.OnClickListener() { @Override public void onClick(View v) { // /创建ContentValue对象 ContentValues values = new ContentValues(); // /插入键值对，注意值的类型必须和<a href="https://www.jb51.cc/tag/shujuku/" target="_blank" class="keywords">数据库</a>表中字段类型一致 values.put("id",1); values.put("names","wangdan"); // /<a href="https://www.jb51.cc/tag/shengcheng/" target="_blank" class="keywords">生成</a><a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDatabase对象 DatabaseHelper dbHelp = new DatabaseHelper(<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite_test.this,1); // /<a href="https://www.jb51.cc/tag/diaoyong/" target="_blank" class="keywords">调用</a>DatabaseHelper的getWritableDatabase<a href="https://www.jb51.cc/tag/fangfa/" target="_blank" class="keywords">方法</a>，<a href="https://www.jb51.cc/tag/shengcheng/" target="_blank" class="keywords">生成</a> // /<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDatabase对象 <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDatabase db = dbHelp.getWritableDatabase(); // /执行插入 db.insert("users",values); System.out.println("----------------------insert"); } }; private View.OnClickListener tab_update = new View.OnClickListener() { @Override public void onClick(View v) { // /<a href="https://www.jb51.cc/tag/shengcheng/" target="_blank" class="keywords">生成</a>DatabaseHelper对象 DatabaseHelper databaseHelper = new DatabaseHelper( <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite_test.this,1); // /<a href="https://www.jb51.cc/tag/diaoyong/" target="_blank" class="keywords">调用</a> DatabaseHelper对象的getWritableDatabase<a href="https://www.jb51.cc/tag/fangfa/" target="_blank" class="keywords">方法</a>，<a href="https://www.jb51.cc/tag/shengcheng/" target="_blank" class="keywords">生成</a> // /<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDatabase对象 <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDatabase db = databaseHelper.getWritableDatabase(); // /<a href="https://www.jb51.cc/tag/shengcheng/" target="_blank" class="keywords">生成</a>ContentValues 对象，并设定键值对 ContentValues values = new ContentValues(); values.put("names","he shanshan"); // /更新表信息 update user set name='he shanshan' where // / id=1; db.update("users",values,"id=?",new String[] { "1" }); System.out.println("----------------------tab_update"); } }; private View.OnClickListener tab_query = new View.OnClickListener() { @Override public void onClick(View v) { // /<a href="https://www.jb51.cc/tag/shengcheng/" target="_blank" class="keywords">生成</a>DatabaseHelper对象 DatabaseHelper databaseHelper = new DatabaseHelper( <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite_test.this,1); // / <a href="https://www.jb51.cc/tag/diaoyong/" target="_blank" class="keywords">调用</a>databaseHelper的getReadableDatabase()<a href="https://www.jb51.cc/tag/fangfa/" target="_blank" class="keywords">方法</a> // / <a href="https://www.jb51.cc/tag/shengcheng/" target="_blank" class="keywords">生成</a><a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDatabase对象 <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDatabase db = databaseHelper.getReadableDatabase(); // 执行<a href="https://www.jb51.cc/tag/chaxun/" target="_blank" class="keywords">查询</a>，将<a href="https://www.jb51.cc/tag/chaxun/" target="_blank" class="keywords">查询</a>结果放入到Cursor中 Cursor cursor = db.query("users",new String[] { "id","names" },new String[] { "1" },null); // / 打印<a href="https://www.jb51.cc/tag/chaxun/" target="_blank" class="keywords">查询</a>结果 while (cursor.moveToNext()) { String name = cursor.getString(cursor.getColumnIndex("names")); System.out.println("query name ===>" + name); } } }; private View.OnClickListener tab_delete = new View.OnClickListener() { @Override public void onClick(View v) { // /<a href="https://www.jb51.cc/tag/shengcheng/" target="_blank" class="keywords">生成</a>DatabaseHelper对象 DatabaseHelper databaseHelper = new DatabaseHelper( <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>ite_test.this,1); // / <a href="https://www.jb51.cc/tag/diaoyong/" target="_blank" class="keywords">调用</a> DatabaseHelper对象的 getWritableDatabase()<a href="https://www.jb51.cc/tag/fangfa/" target="_blank" class="keywords">方法</a> // / <a href="https://www.jb51.cc/tag/shengcheng/" target="_blank" class="keywords">生成</a> <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDatabase 对象 <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>iteDatabase db = databaseHelper.getWritableDatabase(); db.delete("users",new String[] { "1" }); System.out.println("----------------------tab_delete"); } }; }

第三步，当然不可缺少布局文件，相当简单，就不再贴代码了

第四步，运行结果

05-10 03:43:50.959: INFO/System.out(15420): 数据已经存在！05-10 03:43:51.050: INFO/System.out(15420): Create a database test_user and table users05-10 03:43:51.089: INFO/System.out(15420): --------------------—create_Database05-10 03:44:03.409: INFO/System.out(15420): ----------------------insert05-10 03:44:07.500: INFO/System.out(15420): query name ===>wangdan05-10 03:44:12.690: INFO/System.out(15420): ----------------------tab_update05-10 03:44:13.990: INFO/System.out(15420): query name ===>he shanshan

原文链接：https://www.f2er.com/sqlite/202662.html

猜你在找的Sqlite相关文章