创建是数据库
public class SqliteHelper extends SQLiteOpenHelper {
/**
* @param context 上下文
* @param name 数据库的名字
* @param factory 工程游标
* @param version 版本号
*/
public SqliteHelper(Context context) {
super(context, "Person.db", null, 1);
// TODO Auto-generated constructor stub
}
//创建 执行成功 只执行一次 SQLiteDatabase操作数据库
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
//创建表 create table 创建 一个表为 person primary key 主键 autoincrement 自增长
db.execSQL("create table person(id integer primary key autoincrement," +
"name text," +
"sex text)");
}
//升级数据库的方法
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
}
}
(对数据库进行操作)
public class PersonDao {
private SqliteHelper sqliteHelper;
private SQLiteDatabase db;
public PersonDao(Context context){
sqliteHelper = new SqliteHelper(context);
db = sqliteHelper.getReadableDatabase();
}
//增加的方法
public void add(String name, String sex){
//? 占位
db.execSQL("insert into person (name,sex) values (?,?)",new Object[]{name,sex});
}
//查询
public String select(){
//1.sql语句 2.条件的值 Cursor 游标
Cursor rawQuery = db.rawQuery("select *from person", null);
StringBuffer buffer = new StringBuffer();
//rawQuery.moveToNext() 移动到下一行读取
while (rawQuery.moveToNext()) {
//得到查询出来的值
String name = rawQuery.getString(rawQuery.getColumnIndex("name"));
String sex = rawQuery.getString(rawQuery.getColumnIndex("sex"));
buffer.append("姓名:"+name+"----"+"性别:"+sex);
}
return buffer.toString();
}
//删除
public void delete(String name){
db.execSQL("delete from person where name = ?",new Object[]{name});
}
//修改
public void update(String tj,String name,String sex){
//要去修改person中的name, sex,根据name 为 ? 的 条件去修改
db.execSQL("update person set name =?,sex = ? where name = ?",new Object[]{name,sex,tj});
}
}
调用操作方法
public class MainActivity extends Activity {
private PersonDao dao;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
dao = new PersonDao(this);
}
//点击添加
public void add(View v){
dao.add("one1", "不详");
}
//查询
public void select(View v){
//接受查询出来的值
String name = dao.select();
Toast.makeText(MainActivity.this, name, 1).show();
}
//删除
public void delete(View v){
dao.delete("two");
}
//修改
public void update(View v){
dao.update("one1", "baby奇", "不详");
}
}