/*
* 创建数据库
*/
public class DatabaseHelper extends SQLiteOpenHelper{
public static final String DB_NAME="com.john.db";
public static final String DB_TABLE="user";
public static final int VERSION=1;
public DatabaseHelper(Context context) {
super(context, DB_NAME,null, VERSION);
// TODO Auto-generated constructor stub
}
//数据库上创建一个表
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
String sql = "create table user(id int not null , name varchar(60) not null );";
db.execSQL(sql);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
}
}
package com.John.Data;
/*
* 处理数据库
*/
public class DataSqliteActivity extends Activity {
Button insert;
Button query;
Button update;
Button delete;
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
insert=(Button)findViewById(R.id.insertbutton);
insert.setOnClickListener(new insertListener());
}
class insertListener implements OnClickListener{
@Override
public void onClick(View v) {
ContentValues cv = new ContentValues();//实例化一个ContentValues用来装载待插入的数据
cv.put("id",1);
cv.put("name","xiao");
DatabaseHelper helper = new DatabaseHelper(DataSqliteActivity.this);
SQLiteDatabase db = helper.getWritableDatabase();
db.insert("user",null,cv);//执行插入操作
System.out.println("插入数据");
}
}
}