SQLite 操作 and DoS
来源:互联网 发布:周大福网络旗舰店 编辑:程序博客网 时间:2024/05/09 21:28
Android SQLite 数据操作
(2010-12-06 10:27:49)转载
标签:
it
1.SQLiteHelper.java:创建数据库,表单
package com.android;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
public class SqLite extends SQLiteOpenHelper {
public SqLite(Context context, String name, CursorFactory factory,
int version) {
super(context, name, factory, version);
}
@Override
public void onCreate(SQLiteDatabase db) {
System.out.println("Create DB");
db.execSQL("create table user(id int,name varchar(15))"); //创建表单
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
}
}
2.SQLiteActivity.java:实现数据操作,增删改查
package com.android;
import android.app.Activity;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
public class SqlActivity extends Activity {
private Button buttCreate;
private Button buttSelect;
private Button buttInsert;
private Button buttUpdate;
private Button buttDelete;
public SQLiteDatabase db(){ //创建数据库
SqLite dbHelper = new SqLite(SqlActivity.this, "test_SQLite",
null, 1);
SQLiteDatabase db=dbHelper.getReadableDatabase();
return db;
}
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
//空间ID变量声明
buttCreate = (Button) this.findViewById(R.id.buttCreate);
buttSelect=(Button) this.findViewById(R.id.buttSelect);
buttInsert=(Button) this.findViewById(R.id.buttInsert);
buttUpdate=(Button) this.findViewById(R.id.buttUpdate);
buttDelete=(Button) this.findViewById(R.id.buttDelete);;
buttCreate.setOnClickListener(new View.OnClickListener() { //创建数据库
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
db();
System.out.println("创建数据库");
}
});
this.buttSelect.setOnClickListener(new View.OnClickListener() { //查询
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
SQLiteDatabase db=db();
Cursor cursor=db.query("user", new String[]{"id","name"},"id=?", new String[]{"1"}, null, null, null);
while(cursor.moveToNext()){
String name=cursor.getString(cursor.getColumnIndex("name"));
System.out.println("name="+name);
}
}
});
buttInsert.setOnClickListener(new View.OnClickListener() { //添加
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
ContentValues value=new ContentValues();
value.put("id",1);
value.put("name", "che");
SQLiteDatabase db=db();
db.insert("user", null,value);
System.out.println("insert ---");
}
});
this.buttUpdate.setOnClickListener(new View.OnClickListener() { //更新
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
SQLiteDatabase db=db();
ContentValues value=new ContentValues();
value.put("name","cheche");
db.update("user", value, "id=?", new String[]{"1"});
System.out.println("update ---");
}
});
this.buttDelete.setOnClickListener(new View.OnClickListener() { //删除
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
SQLiteDatabase db=db();
db.delete("user", "name=?",new String[]{"che"} );
System.out.println("delete ---");
}
});
}
}
3.进入DOS
>>adb shell
# cd data
# cd data
cd data
# ls
ls
com.android.google
com.android.fallback
com.android.gallery
com.android.htmlviewer
com.android.providers.userdictionary
com.android.cardock
com.android.development
com.android.defcontainer
com.android.server.vpn
com.android.soundrecorder
com.android.certinstaller
com.android.wallpaper.livepicker
com.android.netspeed
com.android.packageinstaller
android.tts
com.android.providers.applications
com.android.speechrecorder
com.android.inputmethod.latin
com.android.customlocale
com.android.inputmethod.pinyin
com.android.providers.subscribedfeeds
com.android.providers.drm
com.android.mms
com.android.providers.contacts
com.android.providers.media
com.svox.pico
com.android.sdksetup
com.android.term
com.android.providers.settings
com.android.phone
com.android.launcher
com.android.providers.telephony
com.android.providers.downloads
com.android.alarmclock
jp.co.omronsoft.openwnn
com.android.contacts
com.android.browser
com.pc
com.android.email
com.android.carhome
com.android.quicksearchbox
com.android.music
com.android.spare_parts
com.android.settings
com.android.camera
com.android.protips
com.android.calculator2
com.android
# cd com.android
cd com.android
# ls
ls
lib
databases
# cd da
cd da
cd: can't cd to da
# cd database
cd database
cd: can't cd to database
# cd databases
cd databases
# ls
ls
test_SQLite
# Sqlite3 test_SQLite
Sqlite3 test_SQLite
Sqlite3: not found
# SQLite3 test_SQLite
SQLite3 test_SQLite
SQLite3: not found
# sqlite3 test_SQLite
sqlite3 test_SQLite
SQLite version 3.6.22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .schema //查看当前计划
.schema
CREATE TABLE android_metadata (locale TEXT);
CREATE TABLE user(id int,name varchar(15));
sqlite> select * from user;
select * from user;
1|che
1|che
1|che
1|che
1|che
sqlite> select * from user;
select * from user;
1|che
1|che
1|che
1|che
1|che
1|che
sqlite> select * from user;
select * from user;
1|cheche
1|cheche
1|cheche
1|cheche
1|cheche
1|cheche
sqlite> select * from user;
select * from user;
sqlite> select * from user;
select * from user;
1|cheche
1|che
sqlite> select * from user;
select * from user;
sqlite> select * from user;
select * from user;
1|cheche
1|che
sqlite> select * from user;
select * from user;
1|cheche
1|che
sqlite> select * from user;
select * from user;
1|cheche
1|che
sqlite> select * from user;
select * from user;
1|cheche
sqlite> select * from user;
select * from user;
1|cheche
sqlite> select * from user;
select * from user;
1|cheche
1|che
sqlite> select * from user;
select * from user;
1|cheche
sqlite>
package com.android;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
public class SqLite extends SQLiteOpenHelper {
public SqLite(Context context, String name, CursorFactory factory,
int version) {
super(context, name, factory, version);
}
@Override
public void onCreate(SQLiteDatabase db) {
System.out.println("Create DB");
db.execSQL("create table user(id int,name varchar(15))"); //创建表单
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
}
}
2.SQLiteActivity.java:实现数据操作,增删改查
package com.android;
import android.app.Activity;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
public class SqlActivity extends Activity {
private Button buttCreate;
private Button buttSelect;
private Button buttInsert;
private Button buttUpdate;
private Button buttDelete;
public SQLiteDatabase db(){ //创建数据库
SqLite dbHelper = new SqLite(SqlActivity.this, "test_SQLite",
null, 1);
SQLiteDatabase db=dbHelper.getReadableDatabase();
return db;
}
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
//空间ID变量声明
buttCreate = (Button) this.findViewById(R.id.buttCreate);
buttSelect=(Button) this.findViewById(R.id.buttSelect);
buttInsert=(Button) this.findViewById(R.id.buttInsert);
buttUpdate=(Button) this.findViewById(R.id.buttUpdate);
buttDelete=(Button) this.findViewById(R.id.buttDelete);;
buttCreate.setOnClickListener(new View.OnClickListener() { //创建数据库
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
db();
System.out.println("创建数据库");
}
});
this.buttSelect.setOnClickListener(new View.OnClickListener() { //查询
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
SQLiteDatabase db=db();
Cursor cursor=db.query("user", new String[]{"id","name"},"id=?", new String[]{"1"}, null, null, null);
while(cursor.moveToNext()){
String name=cursor.getString(cursor.getColumnIndex("name"));
System.out.println("name="+name);
}
}
});
buttInsert.setOnClickListener(new View.OnClickListener() { //添加
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
ContentValues value=new ContentValues();
value.put("id",1);
value.put("name", "che");
SQLiteDatabase db=db();
db.insert("user", null,value);
System.out.println("insert ---");
}
});
this.buttUpdate.setOnClickListener(new View.OnClickListener() { //更新
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
SQLiteDatabase db=db();
ContentValues value=new ContentValues();
value.put("name","cheche");
db.update("user", value, "id=?", new String[]{"1"});
System.out.println("update ---");
}
});
this.buttDelete.setOnClickListener(new View.OnClickListener() { //删除
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
SQLiteDatabase db=db();
db.delete("user", "name=?",new String[]{"che"} );
System.out.println("delete ---");
}
});
}
}
3.进入DOS
>>adb shell
# cd data
# cd data
cd data
# ls
ls
com.android.google
com.android.fallback
com.android.gallery
com.android.htmlviewer
com.android.providers.userdictionary
com.android.cardock
com.android.development
com.android.defcontainer
com.android.server.vpn
com.android.soundrecorder
com.android.certinstaller
com.android.wallpaper.livepicker
com.android.netspeed
com.android.packageinstaller
android.tts
com.android.providers.applications
com.android.speechrecorder
com.android.inputmethod.latin
com.android.customlocale
com.android.inputmethod.pinyin
com.android.providers.subscribedfeeds
com.android.providers.drm
com.android.mms
com.android.providers.contacts
com.android.providers.media
com.svox.pico
com.android.sdksetup
com.android.term
com.android.providers.settings
com.android.phone
com.android.launcher
com.android.providers.telephony
com.android.providers.downloads
com.android.alarmclock
jp.co.omronsoft.openwnn
com.android.contacts
com.android.browser
com.pc
com.android.email
com.android.carhome
com.android.quicksearchbox
com.android.music
com.android.spare_parts
com.android.settings
com.android.camera
com.android.protips
com.android.calculator2
com.android
# cd com.android
cd com.android
# ls
ls
lib
databases
# cd da
cd da
cd: can't cd to da
# cd database
cd database
cd: can't cd to database
# cd databases
cd databases
# ls
ls
test_SQLite
# Sqlite3 test_SQLite
Sqlite3 test_SQLite
Sqlite3: not found
# SQLite3 test_SQLite
SQLite3 test_SQLite
SQLite3: not found
# sqlite3 test_SQLite
sqlite3 test_SQLite
SQLite version 3.6.22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .schema //查看当前计划
.schema
CREATE TABLE android_metadata (locale TEXT);
CREATE TABLE user(id int,name varchar(15));
sqlite> select * from user;
select * from user;
1|che
1|che
1|che
1|che
1|che
sqlite> select * from user;
select * from user;
1|che
1|che
1|che
1|che
1|che
1|che
sqlite> select * from user;
select * from user;
1|cheche
1|cheche
1|cheche
1|cheche
1|cheche
1|cheche
sqlite> select * from user;
select * from user;
sqlite> select * from user;
select * from user;
1|cheche
1|che
sqlite> select * from user;
select * from user;
sqlite> select * from user;
select * from user;
1|cheche
1|che
sqlite> select * from user;
select * from user;
1|cheche
1|che
sqlite> select * from user;
select * from user;
1|cheche
1|che
sqlite> select * from user;
select * from user;
1|cheche
sqlite> select * from user;
select * from user;
1|cheche
sqlite> select * from user;
select * from user;
1|cheche
1|che
sqlite> select * from user;
select * from user;
1|cheche
sqlite>
- SQLite 操作 and DoS
- sqlite 操作:rawQuery and execSQL
- C#连接操作SQLite and QT连接操作SQLite
- android sqlite 操作:rawQuery and execSQL
- dos操作
- 如何用dos窗口对Android内置的SQLite数据库进行操作
- SQLite:Java操作SQLite
- SQLite操作
- SQLite操作
- 操作sqlite
- sqlite 操作
- SQLite操作
- sqlite操作
- sqlite操作
- SQLite操作
- SQLite操作
- sqlite操作
- SQLite操作
- android开发环境搭建(for 驱动开发人员)
- JPCAP简介
- 展讯平台 mimi教程
- PHP mt_rand() 函数
- 摘抄 Android init.rc 翻译
- SQLite 操作 and DoS
- PHP PDO数据库抽象层
- win23串口编程总结
- awk
- C#常用排序算法大全
- js中的window.onload和jquery中的load区别的讲解
- JAVA ENUM
- Hudson setup
- 详解LMA(装载内存地址)与VMA(虚拟内存地址)