android学习笔记——SQLite

先看事例代码：

先看SQLiteTestActivity.java

  1 package crazyblz.SQLiteTest;
  2 import crazyblz.SQLite.db.DatabaseHelper;
  3 import android.app.Activity;
  4 import android.content.ContentValues;
  5 import android.database.Cursor;
  6 import android.database.sqlite.SQLiteDatabase;
  7 import android.os.Bundle;
  8 import android.view.View;
  9 import android.view.View.OnClickListener;
 10 import android.widget.Button;
 11 
 12 public class SQLiteTestActivity extends Activity {
 13     /** Called when the activity is first created. */
 14     private Button creatButton = null;
 15     private Button updateDatabaseButton = null;
 16     private Button insertButton = null;
 17     private Button updateButton = null;
 18     private Button queryButton = null;
 19     
 20     @Override
 21     public void onCreate(Bundle savedInstanceState) {
 22         super.onCreate(savedInstanceState);
 23         setContentView(R.layout.main);
 24         creatButton = (Button)findViewById(R.id.creatButton);
 25         creatButton.setOnClickListener(new creatListener());
 26         updateDatabaseButton = (Button)findViewById(R.id.updateDatabaseButton);
 27         updateDatabaseButton.setOnClickListener(new updateDatabaseListener());
 28         insertButton = (Button)findViewById(R.id.insertButton);
 29         insertButton.setOnClickListener(new insertButtonListener());
 30         updateButton = (Button)findViewById(R.id.updateButton);
 31         updateButton.setOnClickListener(new updateButtonListener());
 32         queryButton = (Button)findViewById(R.id.queryButton);
 33         queryButton.setOnClickListener(new queryButtonListener());
 34         
 35     }
 36     
 37     class creatListener implements OnClickListener{
 38 
 39         public void onClick(View v) {
 40             // TODO Auto-generated method stub
 41 //DatabaseHelper dbHelper = null;
 42             DatabaseHelper dbHelper = new DatabaseHelper(SQLiteTestActivity.this,"crazyblz_SQLite_db");
 43             SQLiteDatabase db = dbHelper.getReadableDatabase();
 44         }    
 45     }
 46    class updateDatabaseListener implements OnClickListener{
 47 
 48     public void onClick(View v) {
 49         // TODO Auto-generated method stub
 50         DatabaseHelper dbHelper = new DatabaseHelper(SQLiteTestActivity.this,"crazyblz_SQLite_db",2);
 51         SQLiteDatabase db = dbHelper.getReadableDatabase();
 52         }
 53         
 54         }
 55    
 56    class insertButtonListener implements OnClickListener{
 57 
 58         public void onClick(View v) {
 59             // TODO Auto-generated method stub
 60             ContentValues values = new ContentValues();
 61             values.put("id",1);
 62             values.put("name","zhangsan");
 63             DatabaseHelper dbHelper = new DatabaseHelper(SQLiteTestActivity.this,"crazyblz_SQLite_db");
 64             SQLiteDatabase db = dbHelper.getWritableDatabase();
 65             db.insert("user", null, values);
 66             
 67             }
 68             
 69             }
 70    class updateButtonListener implements OnClickListener{
 71 
 72         public void onClick(View v) {
 73             // TODO Auto-generated method stub
 74             ContentValues values = new ContentValues();
 75             DatabaseHelper dbHelper = new DatabaseHelper(SQLiteTestActivity.this,"crazyblz_SQLite_db");
 76             SQLiteDatabase db = dbHelper.getWritableDatabase();
 77             values.put("name","zhangsanfeng");
 78             db.update("user",values,"id=?",new String[]{"1"});
 79             
 80             }
 81             
 82             }
 83    class queryButtonListener implements OnClickListener{
 84 
 85         public void onClick(View v) {
 86             // TODO Auto-generated method stub
 87             DatabaseHelper dbHelper = new DatabaseHelper(SQLiteTestActivity.this,"crazyblz_SQLite_db",2);
 88             SQLiteDatabase db = dbHelper.getReadableDatabase();
 89             Cursor cursor = db.query("user", new String[]{"id","name"}, "id=?", new String[]{"1"}, null, null, null);
 90             while(cursor.moveToNext()) {
 91             String name = cursor.getString(cursor.getColumnIndex("name"));
 92             System.out.println("query---->" + name);
 93                 
 94             }
 95             }
 96             
 97             }
 98 
 99 
100 
101 
102 }
103     

再看：DatabaseHelper.java

 1 package crazyblz.SQLite.db;
 2 import android.content.Context;
 3 import android.database.sqlite.SQLiteDatabase;
 4 import android.database.sqlite.SQLiteDatabase.CursorFactory;
 5 import android.database.sqlite.SQLiteOpenHelper;
 6 public class DatabaseHelper extends SQLiteOpenHelper {
 7     /** Called when the activity is first created. */
 8    private static final int VERSION  = 1;
 9     public DatabaseHelper(Context context,String name,CursorFactory Factory,int version) {
10         super(context,name,Factory,version);
11         //setContentView();
12     }
13     public DatabaseHelper(Context context,String name){
14         this(context,name,VERSION);
15     }
16     public DatabaseHelper(Context context,String name,int version){
17         this(context,name,null,version);
18     }
19     @Override
20     public void onCreate(SQLiteDatabase db) {
21         // TODO Auto-generated method stub
22         System.out.println("create a database!");
23         db.execSQL("create table user(id int,name varchar(20))");
24     }
25     @Override
26     public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
27         // TODO Auto-generated method stub
28         System.out.println("updata a record!");
29     }
30     
31 }

最后main.xml

 1 <?xml version="1.0" encoding="utf-8"?>
 2 <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
 3     android:layout_width="fill_parent"
 4     android:layout_height="fill_parent"
 5     android:orientation="vertical" >
 6     <Button 
 7 android:id="@+id/creatButton"
 8         android:layout_width="fill_parent"
 9         android:layout_height="wrap_content"
10         android:text="@string/createButton"
11 />
12     <Button 
13 android:id="@+id/updateDatabaseButton"
14         android:layout_width="fill_parent"
15         android:layout_height="wrap_content"
16         android:text="@string/updateDatabaseButton"
17 />
18     <Button 
19 android:id="@+id/insertButton"
20         android:layout_width="fill_parent"
21         android:layout_height="wrap_content"
22         android:text="@string/insertButton"
23         
24 />
25     <Button 
26 android:id="@+id/updateButton"
27         android:layout_width="fill_parent"
28         android:layout_height="wrap_content"
29         android:text="@string/updateButton"
30         
31 />
32     <Button 
33 android:id="@+id/queryButton"
34         android:layout_width="fill_parent"
35         android:layout_height="wrap_content"
36         android:text="@string/queryButton"
37         
38 />
39 
40 </LinearLayout>

string文件：

 1 <?xml version="1.0" encoding="utf-8"?>
 2 <resources>
 3 
 4     <string name="hello">Hello World, SQLiteTestActivity!</string>
 5     <string name="app_name">SQLiteTest</string>
 6     <string name="createButton">create</string>
 7     <string name="updateDatabaseButton">updetaDatabase</string>
 8     <string name="insertButton">insert</string>
 9     <string name="updateButton">update</string>
10     <string name="queryButton">query</string>
11     
12     
13     
14 
15 </resources>

转载于:https://www.cnblogs.com/crazyblz/archive/2012/03/19/2406124.html