Android SQLite简单操作示例

Android SQLite数据库简单示例

解决

SqLiteActivity.java:

package com.cuit.edu.cn;  import com.cuit.edu.cn.db.DateBaseHelper;  import android.app.Activity; import android.content.ContentValues; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.os.Bundle; import android.view.View; import android.view.View.OnClickListener; import android.widget.Button;  public class SqLiteActivity extends Activity {     /** Called when the activity is first created. */          private Button createButton = null;     private Button updatebaseButton = null;     private Button insertButton = null;     private Button updateButton = null;     private Button queryButton = null;     @Override     public void onCreate(Bundle savedInstanceState) {         super.onCreate(savedInstanceState);         setContentView(R.layout.main);                  createButton = (Button)findViewById(R.id.createdatebase);         updatebaseButton = (Button)findViewById(R.id.updateDatebase);         insertButton = (Button)findViewById(R.id.insterButton);         updateButton = (Button)findViewById(R.id.updateButton);         queryButton = (Button)findViewById(R.id.queryButton);                           createButton.setText(R.string.create);         updatebaseButton.setText(R.string.updatebase);         insertButton.setText(R.string.insert);         updateButton.setText(R.string.update);         queryButton.setText(R.string.query);                  createButton.setOnClickListener(new createButtonListener());         updatebaseButton.setOnClickListener(new updatebaseButtonListener());         insertButton.setOnClickListener(new insertButtonListener());         updateButton.setOnClickListener(new updateButtonListener());         queryButton.setOnClickListener(new queryButtonListener());                                }          class createButtonListener implements OnClickListener     {          @Override         public void onClick(View v) {             // TODO Auto-generated method stub             DateBaseHelper dbHelper = new DateBaseHelper(SqLiteActivity.this, "user_Base");             SQLiteDatabase db = dbHelper.getReadableDatabase();         }              }          class updatebaseButtonListener implements OnClickListener     {          @Override         public void onClick(View v) {             // TODO Auto-generated method stub          System.out.println("b================");             DateBaseHelper dbHelper = new DateBaseHelper(SqLiteActivity.this, "user_Base",90);                          SQLiteDatabase db = dbHelper.getReadableDatabase();                          dbHelper.onUpgrade(db, 90, 91);                      }              }          class insertButtonListener implements OnClickListener     {          @Override         public void onClick(View v) {             // TODO Auto-generated method stub             ContentValues values = new ContentValues();             values.put("id", 1);             values.put("name", "rock");             DateBaseHelper dbHelper = new DateBaseHelper(SqLiteActivity.this,"user_Base");             SQLiteDatabase db = dbHelper.getWritableDatabase();             db.insert("user", null, values);         }              }          class updateButtonListener implements OnClickListener     {          @Override         public void onClick(View arg0) {             // TODO Auto-generated method stub             DateBaseHelper dbHelper = new DateBaseHelper(SqLiteActivity.this, "user_Base");             SQLiteDatabase db = dbHelper.getWritableDatabase();             ContentValues values = new ContentValues();             values.put("name", "cara");             db.update("user", values, "id=?", new String[]{"1"});         }              }     class queryButtonListener implements OnClickListener{          @Override         public void onClick(View v) {             // TODO Auto-generated method stub             DateBaseHelper dbHelper = new DateBaseHelper(SqLiteActivity.this, "user_Base");             SQLiteDatabase db = dbHelper.getReadableDatabase();             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("------"+name);             }                          }              } }

DateBaseHelper.java:

package com.cuit.edu.cn.db;  import android.content.Context; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteDatabase.CursorFactory; import android.database.sqlite.SQLiteOpenHelper;  public class DateBaseHelper extends SQLiteOpenHelper {      private static final int VERSION = 1;     public DateBaseHelper(Context context, String name, CursorFactory factory,             int version) {         super(context, name, factory, version);         // TODO Auto-generated constructor stub     }          public DateBaseHelper(Context context,String name)     {         this(context,name,VERSION);     }          public DateBaseHelper(Context context,String name,int version)     {         this(context,name,null,VERSION);     }      @Override     public void onCreate(SQLiteDatabase db) {         // TODO Auto-generated method stub         System.out.println("createdataBase");                  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("updataBase");     }  }

main.xml:

<?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"     android:layout_width="fill_parent"     android:layout_height="fill_parent"     android:orientation="vertical" >      <TextView         android:layout_width="fill_parent"         android:layout_height="wrap_content"         android:text="@string/hello" />     <Button         android:id="@+id/createdatebase"          android:layout_width="fill_parent"         android:layout_height="wrap_content"                  />          <Button         android:id="@+id/updateDatebase"          android:layout_width="fill_parent"         android:layout_height="wrap_content"         />          <Button         android:id="@+id/insterButton"          android:layout_width="fill_parent"         android:layout_height="wrap_content"         />         <Button         android:id="@+id/updateButton"          android:layout_width="fill_parent"         android:layout_height="wrap_content"                  />         <Button         android:id="@+id/queryButton"          android:layout_width="fill_parent"         android:layout_height="wrap_content"                  />           </LinearLayout>

string.xml:

<?xml version="1.0" encoding="utf-8"?> <resources>      <string name="hello">Hello World, SqLiteActivity!</string>     <string name="app_name">SqLite</string>     <string name="query">query</string>     <string name="updatebase">updatebase</string>     <string name="update">update</string>     <string name="create">create</string>     <string name="insert">insert</string>       </resources>