关于SQL 语句

===================【将表repurt 里score 列的数值+10，条件是 name = \'张三\'"】======================
SQLiteDatabase db=getWritableDatabase();
db.beginTransaction();
try {
db.execSQL("update repurt set score = score + 10 where name = \'张三\'");
db.setTransactionSuccessful();

}finally{
db.endTransaction();

}

=====================【创建表的语句】============================

String CREATE_TABLE="CREATE TABLE  repurt  (_id integer primary key autoincrement,name varchar(20),course varchar(10),score varchar(10))";

=======================【添加值】==========================

public void addRepurt(String name,String course,int score){
SQLiteDatabase db=getWritableDatabase();
db.execSQL("INSERT  INTO  repurt (name,course,score) VALUES (\'"+name+"\',\'"+course+"\',\'"+score+"\')");

// 关闭数据库
db.close();
}

========================【条件查询】==========================

//条件查询
public int select(String name,String course){
SQLiteDatabase db=getReadableDatabase();
String sql="SELECT*FROM  repurt  WHERE name  = \'"+name+"\' and course =\'"+course+"\'";
// select *  from repurt r where  r.name='wang'
// +" and course = "+course+
Cursor cursor = db.rawQuery(sql, null);
int data = 0;
while (cursor.moveToNext()) {
data=cursor.getInt(cursor.getColumnIndex("score"));
}
db.close();
return data;
}

===========================【查询Y条记录    sql似乎不支持top】===============================

sql="SELECT * FROM  " + tabname + "  order by _id desc limit 0,"+y;

========================【今天上传一条绝对是正确的写法，以后别再写错饿了   有多少项就打多少问号】======================

db.execSQL(
"INSERT INTO " + "b"+dbName
+ " (ex ,alert,sound,badge ,mc, mt ,tId ,tag,fId,belongUsername,ft,msgType,belongAvatar,status) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?);",
new String[] { bmobMsg.getEx(), bmobMsg.getAps().getAlert(), bmobMsg.getAps().getSound(),
bmobMsg.getAps().getBadge(), bmobMsg.getMc(), bmobMsg.getMt(), bmobMsg.gettId(),
bmobMsg.getTag(), bmobMsg.getfId(), bmobMsg.getBelongUsername(), bmobMsg.getFt(),
String.valueOf(bmobMsg.getMsgType()), bmobMsg.getBelongAvatar(),
String.valueOf(bmobMsg.getStatus()) });