根据网上查找到的代码,连接了一下数据库
activity.java代码如下:
public class AaActivity extends Activity {
private String name;
private int id;
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
TextView Tv_name=(TextView)findViewById(R.id.name);
EditText Et_name=(EditText)findViewById(R.id.ename);
TextView Tv_phone=(TextView)findViewById(R.id.phone);
EditText Et_phone=(EditText)findViewById(R.id.ephone);
TextView Tv_address=(TextView)findViewById(R.id.address);
EditText Et_address=(EditText)findViewById(R.id.eaddress);
final Button button1=(Button)findViewById(R.id.button1);
final Button button2=(Button)findViewById(R.id.button2);
button1.setOnClickListener(new View.OnClickListener() {
public void onClick(View v) {
name = "liu"; id = 1; database temp = new database(AaActivity.this, "data_yeshu"); SQLiteDatabase db = temp.getWritableDatabase(); ContentValues value = new ContentValues(); value.put("id", id); value.put("name", name); db.insert("user", null, value);
System.out.println("insert OK");
}
});
======================================================================================
database.java代码如下:
package aa.test; import android.content.Context;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteDatabase.CursorFactory;import android.database.sqlite.SQLiteOpenHelper; public class database extends SQLiteOpenHelper {private static final int VERSION = 1;public database(Context context, String name, CursorFactory factory,int version) {super(context, name, factory, version);// TODO Auto-generated constructor stub}public database(Context context, String name, int version){this(context, name, null, version);}public database(Context context , String name){this(context, name, null, VERSION);}@Overridepublic void onCreate(SQLiteDatabase db) {// TODO Auto-generated method stubSystem.out.println("create a new database");db.execSQL("create table user(id int, name VERCHAR(20))");}@Overridepublic void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {// TODO Auto-generated method stubSystem.out.println("update a database");}
========================================================================
因为我是初学者,我想问一下各位高手,数据库data_yeshu存储在那个路径下阿我怎么没找到,能说一下详细路径么}
activity.java代码如下:
public class AaActivity extends Activity {
private String name;
private int id;
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
TextView Tv_name=(TextView)findViewById(R.id.name);
EditText Et_name=(EditText)findViewById(R.id.ename);
TextView Tv_phone=(TextView)findViewById(R.id.phone);
EditText Et_phone=(EditText)findViewById(R.id.ephone);
TextView Tv_address=(TextView)findViewById(R.id.address);
EditText Et_address=(EditText)findViewById(R.id.eaddress);
final Button button1=(Button)findViewById(R.id.button1);
final Button button2=(Button)findViewById(R.id.button2);
button1.setOnClickListener(new View.OnClickListener() {
public void onClick(View v) {
name = "liu"; id = 1; database temp = new database(AaActivity.this, "data_yeshu"); SQLiteDatabase db = temp.getWritableDatabase(); ContentValues value = new ContentValues(); value.put("id", id); value.put("name", name); db.insert("user", null, value);
System.out.println("insert OK");
}
});
======================================================================================
database.java代码如下:
package aa.test; import android.content.Context;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteDatabase.CursorFactory;import android.database.sqlite.SQLiteOpenHelper; public class database extends SQLiteOpenHelper {private static final int VERSION = 1;public database(Context context, String name, CursorFactory factory,int version) {super(context, name, factory, version);// TODO Auto-generated constructor stub}public database(Context context, String name, int version){this(context, name, null, version);}public database(Context context , String name){this(context, name, null, VERSION);}@Overridepublic void onCreate(SQLiteDatabase db) {// TODO Auto-generated method stubSystem.out.println("create a new database");db.execSQL("create table user(id int, name VERCHAR(20))");}@Overridepublic void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {// TODO Auto-generated method stubSystem.out.println("update a database");}
========================================================================
因为我是初学者,我想问一下各位高手,数据库data_yeshu存储在那个路径下阿我怎么没找到,能说一下详细路径么}
解决方案 »
- Android4.0 模拟器 视频播放
- !!! FAILED BINDER TRANSACTION !!!
- 那位高手能帮我申请一个googlemap apikey啊。非常感谢啦!
- Git如何查看某次提交某个文件的修改
- 高分请教:Android为什么我的Button点两下才起作用
- 第一家针对Android PC所设计的软件商店欢迎您来上传您所开发的Android程序
- android 调用本地VS中的webservice 与数据库交互 的问题
- 最新安卓换开发语言?
- 在线校验json串 报这种问题是什么错
- 使用mediacodec出现的问题
- onLocationChanged方法结束后自动关闭gps
- mars.Android视频教程里Activity03乘法计算的程序相关问题,求大神光顾
不用工具的。例如数据库名为test.db,包名为com.android.test
1、开始--》运行--》CMD--》adb shell--》cd data/com.android.test/data
2、sqlite3 test.db
这时候就进到了sqlite命令行了,查询库里面的所有表是.tables;查询表结构使用.schema 表名,其他的查询语句与SqlServer类似。使用方法很像MySql的,命令后面要加分号结束。
sqlite3 /data/data/com.android.providers.settings/databases/settings.db "INSERT INTO system VALUES(99,'http_proxy','114.30.47.10:80')"
sqlite3 /data/data/com.android.providers.settings/databases/settings.db "SELECT * FROM system"
sqlite3 /data/data/com.android.providers.settings/databases/settings.db "DELETE FROM system WHERE _id=99"查看APN所维护的数据,操作如下:
# adb shell
# cd /data/data/com.android.providers.telephony/databases
# sqlite3 telephony.db
sqlite> .dump carriers