SQLite的增删改查
来源:互联网 发布:速卖通复制软件 编辑:程序博客网 时间:2024/05/03 09:56
SQLiteActivity文件
PictureHelper文件:
DatabaseHelper文件:
Picture类文件:
package com.example.irscu;import com.example.database.Picture;import com.example.helper.Picturehelper;import android.os.Bundle;import android.app.Activity;import android.view.View;import android.view.View.OnClickListener;import android.widget.Button;import android.widget.EditText;import android.widget.ImageView;import android.widget.TextView;public class SQLiteActivity extends Activity { private Picturehelper pHelper; private Button add; private Button clear; private Button delete; private Button query; private Button queryAll; private Button update; private Button deleteAll; private EditText nameEdit; private EditText IdEdit; private TextView lableView,displayView; ImageView imageView1; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main); add=(Button) findViewById(R.id.btn_add); delete= (Button) findViewById(R.id.btn_delete); deleteAll=(Button) findViewById(R.id.btn_deleteAll); clear=(Button) findViewById(R.id.btn_clear); query=(Button) findViewById(R.id.btn_query); queryAll=(Button) findViewById(R.id.btn_queryAll); update=(Button) findViewById(R.id.btn_update); nameEdit=(EditText) findViewById(R.id.nameEdit); IdEdit=(EditText)findViewById(R.id.IdEdit); lableView=(TextView) findViewById(R.id.lable); displayView=(TextView) findViewById(R.id.display); pHelper=new Picturehelper(this); pHelper.open(); //添加新数据 add.setOnClickListener(new OnClickListener() { public void onClick(View v){ Picture.NAME=nameEdit.getText().toString(); Picture.ID=IdEdit.getText().toString(); long column=pHelper.insert(new Picture()); nameEdit.setText(""); IdEdit.setText(""); if(column== -1) { lableView.setText("添加错误"); } else{ lableView.setText("成功添加数据,ID"+String.valueOf( Picture.ID)); } } } ); //ID查询 query.setOnClickListener(new OnClickListener() { public void onClick(View v){ String id=IdEdit.getText().toString(); pHelper.queryOneData(id); } }); //查询全部 queryAll.setOnClickListener(new OnClickListener() { public void onClick(View v){ pHelper.query(); } } ); //清除显示 clear.setOnClickListener(new OnClickListener() { public void onClick(View v){ pHelper.deleteAll(); lableView.setText("数据全部清除"); displayView.setText(""); } }); //ID删除 delete.setOnClickListener(new OnClickListener() { public void onClick(View v){ String id=IdEdit.getText().toString(); pHelper.delete(id); //有问题 lableView.setText("删除ID为"+IdEdit.getText().toString()+"的数据"); } } ); //删除全部数据 deleteAll.setOnClickListener(new OnClickListener() { public void onClick(View v){ pHelper.deleteAll(); lableView.setText("数据全部删除"); displayView.setText(""); } } ); //更新数据 update.setOnClickListener(new OnClickListener() { public void onClick(View v){ String id=IdEdit.getText().toString(); Picture.NAME=nameEdit.getText().toString(); long count=pHelper.update(id); if(count==-1){ lableView.setText("更新错误"); displayView.setText(""); } else { lableView.setText("更新成功"+"更新数据第"+String.valueOf(id)+"条"); } } });}}
PictureHelper文件:
package com.example.irscu;import com.example.database.Picture;import com.example.helper.Picturehelper;import android.os.Bundle;import android.app.Activity;import android.view.View;import android.view.View.OnClickListener;import android.widget.Button;import android.widget.EditText;import android.widget.ImageView;import android.widget.TextView;public class SQLiteActivity extends Activity { private Picturehelper pHelper; private Button add; private Button clear; private Button delete; private Button query; private Button queryAll; private Button update; private Button deleteAll; private EditText nameEdit; private EditText IdEdit; private TextView lableView,displayView; ImageView imageView1; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main); add=(Button) findViewById(R.id.btn_add); delete= (Button) findViewById(R.id.btn_delete); deleteAll=(Button) findViewById(R.id.btn_deleteAll); clear=(Button) findViewById(R.id.btn_clear); query=(Button) findViewById(R.id.btn_query); queryAll=(Button) findViewById(R.id.btn_queryAll); update=(Button) findViewById(R.id.btn_update); nameEdit=(EditText) findViewById(R.id.nameEdit); IdEdit=(EditText)findViewById(R.id.IdEdit); lableView=(TextView) findViewById(R.id.lable); displayView=(TextView) findViewById(R.id.display); pHelper=new Picturehelper(this); pHelper.open(); //添加新数据 add.setOnClickListener(new OnClickListener() { public void onClick(View v){ Picture.NAME=nameEdit.getText().toString(); Picture.ID=IdEdit.getText().toString(); long column=pHelper.insert(new Picture()); nameEdit.setText(""); IdEdit.setText(""); if(column== -1) { lableView.setText("添加错误"); } else{ lableView.setText("成功添加数据,ID"+String.valueOf( Picture.ID)); } } } ); //ID查询 query.setOnClickListener(new OnClickListener() { public void onClick(View v){ String id=IdEdit.getText().toString(); pHelper.queryOneData(id); } }); //查询全部 queryAll.setOnClickListener(new OnClickListener() { public void onClick(View v){ pHelper.query(); } } ); //清除显示 clear.setOnClickListener(new OnClickListener() { public void onClick(View v){ pHelper.deleteAll(); lableView.setText("数据全部清除"); displayView.setText(""); } }); //ID删除 delete.setOnClickListener(new OnClickListener() { public void onClick(View v){ String id=IdEdit.getText().toString(); pHelper.delete(id); //有问题 lableView.setText("删除ID为"+IdEdit.getText().toString()+"的数据"); } } ); //删除全部数据 deleteAll.setOnClickListener(new OnClickListener() { public void onClick(View v){ pHelper.deleteAll(); lableView.setText("数据全部删除"); displayView.setText(""); } } ); //更新数据 update.setOnClickListener(new OnClickListener() { public void onClick(View v){ String id=IdEdit.getText().toString(); Picture.NAME=nameEdit.getText().toString(); long count=pHelper.update(id); if(count==-1){ lableView.setText("更新错误"); displayView.setText(""); } else { lableView.setText("更新成功"+"更新数据第"+String.valueOf(id)+"条"); } } });}}
DatabaseHelper文件:
<pre name="code" class="java">package com.example.database;import android.content.Context;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteOpenHelper;import android.database.sqlite.SQLiteDatabase.CursorFactory;public class DatabaseHelper extends SQLiteOpenHelper { public DatabaseHelper(Context context, String name, CursorFactory factory, int version) { super(context, name, factory, version); } //建立存储所在位置的数据库 /** static final String CREATE_DESTINATION_TABLE_SQL = "create table " + Destination.TABLE_NAME + "(" + Destination.ID + " integer primary key autoincrement," + Destination.LONGITUDE + " text," + Destination.LATITUDE+ " text," + ");"; **///建立存数拍摄的图片以及发表的心情的数据库 static final String CREATE_PICYURES_TABLE_SQL = "create table " + Picture.TABLE_NAME + " (" +Picture.ID +" text primary key ," +Picture.PIC +" text," +Picture.EMOTION + " text," +Picture.GPS +" text," +Picture.NAME+" text," +Picture.PATH+" text);"; @Override public void onCreate(SQLiteDatabase db) { //db.execSQL(CREATE_DESTINATION_TABLE_SQL) ; db.execSQL(CREATE_PICYURES_TABLE_SQL); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { String sql = "DROP TABLE IF EXISTS " + Picture.TABLE_NAME; db.execSQL(sql); onCreate(db); }}
Picture类文件:
package com.example.database;import android.content.Context;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteOpenHelper;import android.database.sqlite.SQLiteDatabase.CursorFactory;public class DatabaseHelper extends SQLiteOpenHelper { public DatabaseHelper(Context context, String name, CursorFactory factory, int version) { super(context, name, factory, version); } //建立存储所在位置的数据库 /** static final String CREATE_DESTINATION_TABLE_SQL = "create table " + Destination.TABLE_NAME + "(" + Destination.ID + " integer primary key autoincrement," + Destination.LONGITUDE + " text," + Destination.LATITUDE+ " text," + ");"; **///建立存数拍摄的图片以及发表的心情的数据库 static final String CREATE_PICYURES_TABLE_SQL = "create table " + Picture.TABLE_NAME + " (" +Picture.ID +" text primary key ," +Picture.PIC +" text," +Picture.EMOTION + " text," +Picture.GPS +" text," +Picture.NAME+" text," +Picture.PATH+" text);"; @Override public void onCreate(SQLiteDatabase db) { //db.execSQL(CREATE_DESTINATION_TABLE_SQL) ; db.execSQL(CREATE_PICYURES_TABLE_SQL); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { String sql = "DROP TABLE IF EXISTS " + Picture.TABLE_NAME; db.execSQL(sql); onCreate(db); }}
- SQLite的增删改查
- sqlite的增删改查
- SQLite的增删查改
- sqlite的增删改查
- sqlite增删查改
- SQLite增删改查
- SQLite增删改查
- Sqlite 增删改查
- SQLite增删改查
- SQLite增删改查
- sqlite增删查改
- SQlite增删改查
- SQLite数据库的增删改查代码
- 0.DB-SQLite的增删改查
- c++之SQLite的增删改查
- Android数据库的SQLite增删改查
- sqlite常用的命令-增删改查
- c++之SQLite的增删改查
- Java基础加强一JDK1.5新特性
- Unable to find a Java Virtual Machine.
- IOS之Property
- hadoop mapreduce
- Android多媒体分析(五)音乐播放器实例
- SQLite的增删改查
- Java学习笔记-----Java几个与运行环境交互类
- 对象
- ajax技术学习
- eclipse下启动resin项目
- Android 中文 API (100) —— ScrollView
- C language variable arguments
- Shell环境变量设置
- [android]WebView使用