package com.storage.SQLiteDemo;
import android.app.Activity;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;
public class StorageActivity extends Activity {
/** Called when the activity is first created. */
private StoHelper dbAdepter ;
private EditText nameText;
private EditText ageText;
private EditText heightText;
private EditText idEntry;
private TextView labelView;
private TextView displayView;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
nameText = (EditText)findViewById(R.id.name);
ageText = (EditText)findViewById(R.id.age);
heightText = (EditText)findViewById(R.id.height);
idEntry = (EditText)findViewById(R.id.id_entry);
labelView = (TextView)findViewById(R.id.label);
displayView = (TextView)findViewById(R.id.display);
Button addButton = (Button)findViewById(R.id.add);
Button queryAllButton = (Button)findViewById(R.id.query_all);
Button clearButton = (Button)findViewById(R.id.clear);
Button deleteAllButton = (Button)findViewById(R.id.delete_all);
Button queryButton = (Button)findViewById(R.id.query);
Button deleteButton = (Button)findViewById(R.id.delete);
Button updateButton = (Button)findViewById(R.id.update);
addButton.setOnClickListener(addButtonListener);
queryAllButton.setOnClickListener(queryAllButtonListener);
clearButton.setOnClickListener(clearButtonListener);
deleteAllButton.setOnClickListener(deleteAllButtonListener);
queryButton.setOnClickListener(queryButtonListener);
deleteButton.setOnClickListener(deleteButtonListener);
updateButton.setOnClickListener(updateButtonListener);
dbAdepter = new StoHelper(this);
dbAdepter.open();
}
OnClickListener addButtonListener = new OnClickListener() {
@Override
public void onClick(View v) {
Storage people = new Storage();
people.Name = nameText.getText().toString();
people.Volume = Integer.parseInt(ageText.getText().toString());
people.Weight = Float.parseFloat(heightText.getText().toString());
long colunm = dbAdepter.insert(people);
if (colunm == -1 ){
labelView.setText("添加过程错误!");
} else {
labelView.setText("成功添加数据,ID:"+String.valueOf(colunm));
}
}
};
OnClickListener queryAllButtonListener = new OnClickListener() {
@Override
public void onClick(View v) {
Storage[] peoples = dbAdepter.queryAllData();
if (peoples == null){
labelView.setText("数据库中没有数据");
return;
}
labelView.setText("数据库:");
String msg = "";
for (int i = 0 ; i<peoples.length; i++){
msg += peoples[i].toString()+"\n";
}
displayView.setText(msg);
}
};
OnClickListener clearButtonListener = new OnClickListener() {
@Override
public void onClick(View v) {
displayView.setText("");
}
};
OnClickListener deleteAllButtonListener = new OnClickListener() {
@Override
public void onClick(View v) {
dbAdepter.deleteAllData();
String msg = "数据全部删除";
labelView.setText(msg);
}
};
OnClickListener queryButtonListener = new OnClickListener() {
@Override
public void onClick(View v) {
int id = Integer.parseInt(idEntry.getText().toString());
Storage[] peoples = dbAdepter.queryOneData(id);
if (peoples == null){
labelView.setText("数据库中没有ID为"+String.valueOf(id)+"的数据");
return;
}
labelView.setText("数据库:");
displayView.setText(peoples[0].toString());
}
};
OnClickListener deleteButtonListener = new OnClickListener() {
@Override
public void onClick(View v) {
long id = Integer.parseInt(idEntry.getText().toString());
long result = dbAdepter.deleteOneData(id);
String msg = "删除ID为"+idEntry.getText().toString()+"的数据" + (result>0?"成功":"失败");
labelView.setText(msg);
}
};
OnClickListener updateButtonListener = new OnClickListener() {
@Override
public void onClick(View v) {
Storage people = new Storage();
people.Name = nameText.getText().toString();
people.Volume = Integer.parseInt(ageText.getText().toString());
people.Weight = Float.parseFloat(heightText.getText().toString());
long id = Integer.parseInt(idEntry.getText().toString());
long count = dbAdepter.updateOneData(id, people);
if (count == -1 ){
labelView.setText("更新错误!");
} else {
labelView.setText("更新成功,更新数据"+String.valueOf(count)+"条");
}
}
};
}
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
Android当中内置SQLite数据库,那个SQLite有什么特点呢? SQLite 是一个开源的嵌入式关系数据库,实现自包容、零配置、支持事务的SQL数据库引擎。 其特点是高度便携、使用方便、结构紧凑、高效、可靠。 更多详细介绍请参考博客:http://blog.csdn.net/stoppig/article/details/39155937
资源推荐
资源详情
资源评论
收起资源包目录
StrorageDemo.zip (38个子文件)
StrorageDemo
.project 847B
project.properties 563B
src
com
storage
SQLiteDemo
Storage.java 407B
StoHelper.java 4KB
StorageActivity.java 5KB
AndroidManifest.xml 690B
res
drawable-ldpi
drawable-hdpi
drawable
icon.png 3KB
drawable-mdpi
layout
main.xml 5KB
drawable-xhdpi
values
strings.xml 173B
.settings
org.eclipse.jdt.core.prefs 177B
assets
gen
com
storage
SQLiteDemo
BuildConfig.java 164B
R.java 2KB
.classpath 475B
bin
resources.ap_ 7KB
classes
com
storage
SQLiteDemo
R$layout.class 406B
BuildConfig.class 353B
R$drawable.class 412B
StorageActivity$4.class 1KB
R$attr.class 352B
StorageActivity$1.class 2KB
StorageActivity.class 3KB
StorageActivity$6.class 2KB
StorageActivity$2.class 2KB
R$id.class 974B
R.class 559B
R$string.class 439B
StorageActivity$5.class 2KB
StorageActivity$7.class 2KB
Storage.class 1KB
StoHelper$DBOpenHelper.class 1KB
StoHelper.class 5KB
StorageActivity$3.class 958B
AndroidManifest.xml 690B
dexedLibs
annotations-cf3ff2926130a618b8d3867ed84c01bb.jar 943B
jarlist.cache 120B
res
drawable
icon.png 3KB
classes.dex 15KB
StorageDemo.apk 16KB
共 38 条
- 1
资源评论
- yljraul2015-05-27结合博客很详细
- 天冷好个秋2018-06-26很详细的小例子
- 飞翔的鸡翅中2014-10-16看完终于会用了~~~
停止的猪头
- 粉丝: 50
- 资源: 27
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功