Sql帮助类
public class Mysqlhelp extends SQLiteOpenHelper {
public Mysqlhelp(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
super(context, name, factory, version);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("create table users (id integer ,name varchar(10))");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
主类
public class MainActivity extends AppCompatActivity {
private SQLiteDatabase database;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
Mysqlhelp users = new Mysqlhelp(this, "users.db", null, 1);
database = users.getReadableDatabase();
database.beginTransaction();
for (int i = 0; i < 100; i++) {
database.execSQL("insert into users (id,name)values(1,'张雨东')");
}
database.setTransactionSuccessful();
database.endTransaction();
}
public void click(View view) {
switch (view.getId()){
case R.id.btn1:
add(view);
break;
case R.id.btn2:
delete(view);
break;
case R.id.btn3:
update(view);
break;
case R.id.btn4:
query(view);
break;
}
}
private void query(View view) {
String sql="select * from users";
Cursor query = database.rawQuery(sql, null);
if(query!=null){
while(query.moveToNext()){
String name = query.getString(query.getColumnIndex("name"));
int id = query.getInt(query.getColumnIndex("id"));
Toast.makeText(this, id+":"+name, Toast.LENGTH_SHORT).show();
}
}
query.close();
}
private void update(View view) {
ContentValues values = new ContentValues();
values.put("id",3);
database.update("users",values,"name=?",new String[]{"张雨东"});
}
private void delete(View view) {
database.delete("users","id=?",new String[]{"2"});
}
private void add(View view) {
String sql="insert into users(id,name) values(?,?)";
database.execSQL(sql,new Object[]{2,"刘桂通"});
}
}