安卓访问mysql的源码_【原创源码】安卓数据库简单操作demo

[Java] 纯文本查看 复制代码public Long updateSql(String text) {

ContentValues contentValues = new ContentValues();

db = mySql.getWritableDatabase();

contentValues.put("name", text);

Long id = db.insert(MySql.TABLE_NAME, null, contentValues);

db.close();

return id;

}

public void editSql(String s, int id) {

db = mySql.getWritableDatabase();

ContentValues cv = new ContentValues();

cv.put("name", s);

Cursor c = db.query(MySql.TABLE_NAME, null, null, null, null, null, null);//查询并获得游标

c.moveToPosition(id);

String id2 = c.getString(c.getColumnIndex("_id"));

String[] args = {String.valueOf(id2)};

//执行SQL语句

int result = db.update(MySql.TABLE_NAME, cv, "_id=?", args);

//关闭数据库

c.close();

db.close();

}

public void deleteSqlValue(int id) {

db = mySql.getWritableDatabase();

Cursor c = db.query(MySql.TABLE_NAME, null, null, null, null, null, null);//查询并获得游标

c.moveToPosition(id);

String id2 = c.getString(c.getColumnIndex("_id"));

String[] args = {String.valueOf(id2)};

//执行SQL语句

db.delete(MySql.TABLE_NAME, "_id=?", args);

db.close();

}

public void querySql() {

db = mySql.getReadableDatabase();

Cursor c = db.query(MySql.TABLE_NAME, null, null, null, null, null, null);//查询并获得游标

if (c.moveToFirst()) {//判断游标是否为空

for (int i = 0; i < c.getCount(); i++) {

c.moveToPosition(i);

;//移动到指定记录

String username = c.getString(c.getColumnIndex("name"));

mData.add(username);

}

}

c.close();

db.close();

}