android 操作sqlite数据库

1、

package com.exp.contentprividerstest.db;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DBUril extends SQLiteOpenHelper {

   public DBUril(Context context) {
       super(context, "user.db", null, 2);
        System.out.println("asdfasdfds");
   }

   @Override
   public void onCreate(SQLiteDatabase db) {
       String sql="create table user(id int,name varchar(32))";
       System.out.println(sql);
       db.execSQL(sql);
   }

   @Override
   public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {

   }

}

2、

package com.exp.contentprividerstest.test;

import com.exp.contentprividerstest.db.DBUril;

import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.test.AndroidTestCase;

public class DBTest extends AndroidTestCase{

   public void testinsert(){
       DBUril dbUril=new DBUril(getContext());
       SQLiteDatabase database=dbUril.getReadableDatabase();

       for(int i=0;i<10;i++){
           ContentValues values=new ContentValues();
           values.put("id", i);
           values.put("name", "name1:"+i);
           database.insert("user", null, values);
       }
   }

   public void insert1(){
       DBUril dbUril=new DBUril(getContext());
       SQLiteDatabase database=dbUril.getReadableDatabase();

       for(int i=0;i<10;i++){
           String []bindArgs={"1000"+i,"name1000"+i};
           database.execSQL("insert into user values(?,?)", bindArgs);
       }
   }

   public void delete(){
       DBUril dbUril=new DBUril(getContext());
       SQLiteDatabase database=dbUril.getReadableDatabase();
       database.delete("user", "id=?", new String[]{"4"});
   }

   public void delete1(){
       DBUril dbUril=new DBUril(getContext());
       SQLiteDatabase database=dbUril.getReadableDatabase();
       //database.delete("user", "id=?", new String[]{"4"});
       String sql="delete from user where id=?";
       String bindArgs[]={"10003"};
       database.execSQL(sql, bindArgs);
   }

   public void update(){
       DBUril dbUril=new DBUril(getContext());
       SQLiteDatabase database=dbUril.getReadableDatabase();
       ContentValues values=new ContentValues();
       values.put("name", "name3:333333333333333333");
       database.update("user", values, "id=?", new String[]{"3"});
   }

   public void update1(){
       DBUril dbUril=new DBUril(getContext());
       SQLiteDatabase database=dbUril.getReadableDatabase();
       String sql="update user set name=? where id=?";
       String bindArgs[]={"1000000000000","1003"};
       database.execSQL(sql, bindArgs);
   }

   public void query(){
       DBUril dbUril=new DBUril(getContext());
       SQLiteDatabase database=dbUril.getReadableDatabase();
       Cursor cursor=database.query("user", null, null, null, null, null, null);
       while(cursor.moveToNext()){
           int id=cursor.getInt(cursor.getColumnIndex("id"));
           String name=cursor.getString(cursor.getColumnIndex("name"));
           System.out.println(id+"="+name);
       }
   }

   public void query1(){
       DBUril dbUril=new DBUril(getContext());
       SQLiteDatabase database=dbUril.getReadableDatabase();
       String sql="select * from user where id=?";
       Cursor cursor=database.rawQuery(sql, new String[]{"10009"});
       while(cursor.moveToNext()){
           int id=cursor.getInt(cursor.getColumnIndex("id"));
           String name=cursor.getString(cursor.getColumnIndex("name"));
           System.out.println(id+"="+name);
       }
   }
}

更多相关文章

随机推荐