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);
}
}
}

更多相关文章

随机推荐