根据网上查找到的代码,连接了一下数据库
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存储在那个路径下阿我怎么没找到,能说一下详细路径么}
解决方案 »
- Notification中怎么传值给下一个Activity
- Android学习
- 目前为止google一共发布了多少次android 安全漏洞补丁?多谢了
- android 点击edittext 出现输入法 可是整体超出了屏幕上方
- 如何使自己的应用程序获得root权限..
- 求源码
- 怎么实现InputStream.read的超时功能
- mainactivity.java中声明TextView对象的问题
- adb经常offline
- Eclipse里面新建android工程出现的问题
- 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