SQLite的CRUD
来源:互联网 发布:2014十大网络神曲 编辑:程序博客网 时间:2024/06/04 01:05
- package com.wansha;
- import android.app.Activity;
- import android.content.ContentValues;
- import android.database.Cursor;
- import android.database.sqlite.SQLiteDatabase;
- import android.database.sqlite.SQLiteOpenHelper;
- import android.os.Bundle;
- import android.view.View;
- import android.view.View.OnClickListener;
- import android.widget.Button;
- import com.wansha.db.DatabaseHelper;
- public class Activity12 extends Activity {
- private Button createDatabase;
- private Button updateDatabase;
- private Button insert;
- private Button update;
- private Button read;
- private Button delete;
- /** Called when the activity is first created. */
- @Override
- public void onCreate(Bundle savedInstanceState) {
- super.onCreate(savedInstanceState);
- setContentView(R.layout.main);
- this.createDatabase = (Button)this.findViewById(R.id.createDatabase);
- this.createDatabase.setOnClickListener(new CreateDatabaseListener());
- this.updateDatabase = (Button)this.findViewById(R.id.updateDatabase);
- this.updateDatabase.setOnClickListener(new UpdateDatabaseListener());
- this.insert = (Button)this.findViewById(R.id.insert);
- this.insert.setOnClickListener(new InsertListener());
- this.update = (Button)this.findViewById(R.id.update);
- this.update.setOnClickListener(new UpdateListener());
- this.read = (Button)this.findViewById(R.id.read);
- this.read.setOnClickListener(new ReadListener());
- this.delete = (Button)this.findViewById(R.id.delete);
- this.delete.setOnClickListener(new DeleteListener());
- }
- class CreateDatabaseListener implements OnClickListener{
- @Override
- public void onClick(View v) {
- SQLiteOpenHelper sqlite = new DatabaseHelper(Activity12.this,"sharp");
- sqlite.getReadableDatabase();
- }
- }
- class UpdateDatabaseListener implements OnClickListener{
- @Override
- public void onClick(View v) {
- System.out.println("UpdateDatabaseListener is invoked !!!");
- SQLiteOpenHelper sqlite = new DatabaseHelper(Activity12.this,"sharp",2);
- sqlite.getReadableDatabase();
- }
- }
- class InsertListener implements OnClickListener{
- @Override
- public void onClick(View v) {
- SQLiteOpenHelper sqlite = new DatabaseHelper(Activity12.this,"sharp");
- SQLiteDatabase database = sqlite.getWritableDatabase();
- ContentValues values = new ContentValues();
- values.put("username", "xiaopeng");
- database.insert("sharp", null, values);
- }
- }
- class UpdateListener implements OnClickListener{
- @Override
- public void onClick(View v) {
- SQLiteOpenHelper sqlite = new DatabaseHelper(Activity12.this,"sharp");
- SQLiteDatabase database = sqlite.getWritableDatabase();
- ContentValues values = new ContentValues();
- values.put("username", "pengpeng");
- database.update("sharp", values, "id=?", new String[]{"2"});
- }
- }
- class ReadListener implements OnClickListener{
- @Override
- public void onClick(View v) {
- SQLiteOpenHelper sqlite = new DatabaseHelper(Activity12.this,"sharp");
- SQLiteDatabase database = sqlite.getWritableDatabase();
- Cursor cursor = database.query("sharp", new String[]{"id","username"}, null, null, null, null, null);
- while(cursor.moveToNext()){
- String username = cursor.getString(cursor.getColumnIndex("username"));
- System.out.println("username---->" + username);
- }
- }
- }
- class DeleteListener implements OnClickListener{
- @Override
- public void onClick(View v) {
- SQLiteOpenHelper sqlite = new DatabaseHelper(Activity12.this,"sharp");
- SQLiteDatabase database = sqlite.getWritableDatabase();
- database.delete("sharp", "id=?", new String[]{"1"});
- }
- }
- }
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" >
- <Button android:id="@+id/createDatabase"
- android:layout_width="fill_parent"
- android:layout_height="wrap_content"
- android:text="创建数据库"
- />
- <Button android:id="@+id/updateDatabase"
- android:layout_width="fill_parent"
- android:layout_height="wrap_content"
- android:text="更新数据库"
- />
- <Button android:id="@+id/insert"
- android:layout_width="fill_parent"
- android:layout_height="wrap_content"
- android:text="插入数据"
- />
- <Button android:id="@+id/update"
- android:layout_width="fill_parent"
- android:layout_height="wrap_content"
- android:text="更新数据"
- />
- <Button android:id="@+id/read"
- android:layout_width="fill_parent"
- android:layout_height="wrap_content"
- android:text="读取数据"
- />
- <Button android:id="@+id/delete"
- android:layout_width="fill_parent"
- android:layout_height="wrap_content"
- android:text="删除数据"
- />
- </LinearLayout>
db.execSQL("create table sharp(id integer primary key autoincrement, username varchar(255))");
创建自增长ID
DatebaseHelper.java
- package com.wansha.db;
- import android.content.Context;
- import android.database.sqlite.SQLiteDatabase;
- import android.database.sqlite.SQLiteDatabase.CursorFactory;
- import android.database.sqlite.SQLiteOpenHelper;
- public class DatabaseHelper extends SQLiteOpenHelper{
- private static final int VERSION = 1;
- public DatabaseHelper(Context context, String name, CursorFactory factory,
- int version) {
- super(context, name, factory, version);
- }
- public DatabaseHelper(Context context, String name,int version) {
- this(context, name, null, version);
- }
- public DatabaseHelper(Context context, String name) {
- this(context, name, VERSION);
- }
- @Override
- public void onCreate(SQLiteDatabase db) {
- System.out.println("create table is invoked !!!");
- db.execSQL("create table sharp(id integer primary key autoincrement, username varchar(255))");
- }
- @Override
- public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
- System.out.println("update table is invoked !!!");
- }
- }
- android SQLite的CRUD
- SQLite的CRUD
- SQLite的CRUD
- Android-SQLite的CRUD
- SQLite CRUD
- Android中SQLite的简单crud操作
- android数据库sqlite的CRUD操作
- iOS-SQLite数据库(CRUD)
- 学习笔记:Android SQLite,并实现SQLite基本CRUD操作的Demo
- 学习笔记:Android SQLite,并实现SQLite基本CRUD操作的Demo
- iOS开发 - SQLite数据库(CRUD)
- Android Sqlite+反射 实现CRUD
- android sqlite CRUD 查询 事务
- Android中结合OrmLite for android组件对SQLite的CRUD(增删改查)操作实例
- Android中结合OrmLite for android组件对SQLite的CRUD(增删改查)操作实例
- 使用嵌入式关系型SQLite数据库存储数据经典的CRUD和分页
- Android中结合OrmLite for android组件对SQLite的CRUD(增删改查)操作实例
- Android中结合OrmLite for android组件对SQLite的CRUD(增删改查)操作实例
- Android APK反编译
- lua——string库函数的用法例子(包括string.dump的用法例子)
- 12306订票助手
- Lua——string库初级函数的用法举例
- SVN的安装与配置
- SQLite的CRUD
- unable to load selinux policy. machine is in enforcing
- Graphiti3
- smarty模板中获取页面session等
- AIX修改root # 号提示符
- 线程堆栈大小 pthread_attr_setstacksize 的使用
- errno.h头文件介绍
- AIX小机 RS/6000 液晶显示屏上显示代码(LED)的含义
- android 相对定位布局方向详解