sqlite 删除表 java_SQLite实现基本的增删改查功能

public classDBManager {private DBHelper helper = null;privateSQLiteDatabase database ;publicDBManager(Context context) {this.helper = newDBHelper(context);//因为getWritableDatabase内部调用了mContext.openOrCreateDatabase(mName, 0, mFactory);//所以要确保context已初始化,我们可以把实例化DBManager的步骤放在Activity的onCreate里

database =helper.getWritableDatabase();

}/*** 插入操作

* 在添加student信息时，我们采用了事务处理，确保数据完整性；

*@paramstudent*/

public booleaninsert(Student student){boolean flag = false;//开启事务

database.beginTransaction();try{if(database.isOpen()){

database.execSQL("insert into student(name,age,info) values(?,?,?)",newObject[]{student.getName(),student.getAge(),student.getInfo()} );//标记事务成功，如果没执行这句话，则自动回滚

database.setTransactionSuccessful();

}

flag= true;

}catch(Exception e) {//TODO: handle exception

e.printStackTrace();

}finally{//关闭事务

database.endTransaction();

}returnflag;

}/*** 删除操作

*@paramstudentId*/

public boolean delete(intstudentId){boolean flag = false;try{if(database.isOpen()){

database.execSQL("delete from student where _id = ?",newObject[]{studentId});

}

flag= true;

}catch(Exception e) {//TODO: handle exception

e.printStackTrace();

}returnflag;

}/*** 更新操作

*@paramid

*@paramname

*@return

*/

public boolean update(intid,String name){boolean flag = false;try{if(database.isOpen()){

database.execSQL("update student set name = ? where _id = ?",newObject[]{name,id});

database.close();

}

flag= true;

}catch(Exception e) {//TODO: handle exception

e.printStackTrace();

}returnflag;

}/*** 根据id查询学生信息

*@paramid

*@return

*/

public Student queryById(intid){

Student student= null;try{if(database.isOpen()){

Cursor cursor= database.rawQuery("select _id,name,age,info from student where _id = ?", newString[]{String.valueOf(id)});if(cursor!=null && cursor.getCount()>0){if(cursor.moveToFirst()){int _id =cursor.getInt(0);

String name= cursor.getString(1);int age = cursor.getInt(2);

String info= cursor.getString(3);

student= newStudent(_id,name,age,info);

}

}

cursor.close();

}returnstudent;

}catch(Exception e) {//TODO: handle exception

e.printStackTrace();return null;

}

}/*** 查询所有的学生信息

*@return

*/

public ListqueryAllStudent(){

List studentList = null;try{if(database.isOpen()){

studentList= new ArrayList();

Cursor cursor= database.rawQuery("select _id,name,age,info from student",null);while(cursor.moveToNext()){int _id =cursor.getInt(cursor.getColumnIndex("_id"));

String name= cursor.getString(cursor.getColumnIndex("name"));int age = cursor.getInt(cursor.getColumnIndex("age"));

String info= cursor.getString(cursor.getColumnIndex("info"));

Student student= newStudent(_id,name,age,info);

studentList.add(student);

}

}

}catch(Exception e) {//TODO: handle exception

e.printStackTrace();

}returnstudentList;

}public voidcloseDB() {//释放数据库连接，否则容易出现SQLiteException

if(database.isOpen()){

database.close();

}

}

}