Sqlite数据库的创建与方法

//首先先创建一个数据库

public class MysqliteOpenHelper extends SQLiteOpenHelper {




public MysqliteOpenHelper(Context context) {
super(context,"school",null,1);
}


@Override
public void onCreate(SQLiteDatabase db) {

db.execSQL("create table student1(id varchar(5),student varchar(10))");
System.out.println("onCreate");



}


@Override
public void onUpgrade(SQLiteDatabase db,int oldVersion,int newVersion) {
System.out.println("onUpgrade");


}

//下面提供dao方法

public class Dao {


private MysqliteOpenHelper helper;
Context context;

public Dao(Context context) {
super();
this.context = context;
helper = new MysqliteOpenHelper(context);
}

//添加方法
public void add(String id,String student)
{
SQLiteDatabase db = helper.getWritableDatabase();

ContentValues values= new ContentValues();
values.put("id",id);
values.put("student",student);
db.insert("student1",values);
db.close();
}

//删除方法
public void delete(String id)
{
SQLiteDatabase db = helper.getWritableDatabase();
db.delete("student1","id=?",new String[]{id});
db.close();
}

//查询方法
public void select()
{
SQLiteDatabase db = helper.getWritableDatabase();
Cursor cursor = db.query("student1",null);
while(cursor.moveToNext())
{
String id = cursor.getString(cursor.getColumnIndex("id"));
String student = cursor.getString(cursor.getColumnIndex("student"));
System.out.println("id:"+id+"student:"+student);
}
db.close();
}

//修改方法

public void update(String id,String student) { SQLiteDatabase db = helper.getWritableDatabase(); ContentValues values = new ContentValues(); values.put("student",student); db.update("student1",values,new String[]{id}); db.close(); }

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!