//首先创建实体类
package org.mobiletrain.www.aday32_demo04_dbutils;
/**
* Created by wanggang on 15/4/9.
*/
public class Student {
private int _id;
private String name;
private int age;
private int score;
private int clas;
private int numb;
public Student() {
}
public Student(String name, int age, int score, int clas, int numb) {
this.name = name;
this.age = age;
this.score = score;
this.clas = clas;
this.numb = numb;
}
@Override
public String toString() {
return "Student{" +
"name='" + name + '\'' +
", age=" + age +
", score=" + score +
", clas=" + clas +
", numb=" + numb +
'}';
}
public int get_id() {
return _id;
}
public void set_id(int _id) {
this._id = _id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public int getScore() {
return score;
}
public void setScore(int score) {
this.score = score;
}
public int getClas() {
return clas;
}
public void setClas(int clas) {
this.clas = clas;
}
public int getNumb() {
return numb;
}
public void setNumb(int numb) {
this.numb = numb;
}
}
//mainactivity中dbutils各种调用
package org.mobiletrain.www.aday32_demo04_dbutils;import android.support.v7.app.ActionBarActivity;
import android.os.Bundle;
import android.util.Log;
import android.view.Menu;
import android.view.MenuItem;
import com.lidroid.xutils.DbUtils;
import com.lidroid.xutils.db.sqlite.Selector;
import com.lidroid.xutils.db.sqlite.WhereBuilder;
import com.lidroid.xutils.exception.DbException;
import java.util.List;
public class MainActivity extends ActionBarActivity {
private static final String TAG = "DBUtils";
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
DbUtils dbUtils = DbUtils.create(this);
Student s = new Student("小王", 20, 99, 2, 123);
try {
dbUtils.save(s);
} catch (DbException e) {
e.printStackTrace();
}
try {
List<Student> students = dbUtils.findAll(Student.class);
for (int i = 0; i < students.size() ; i++) {
Log.i(TAG,students.get(i).toString());
}
} catch (DbException e) {
e.printStackTrace();
}
try {
List<Student> all = dbUtils.findAll(
Selector.from(Student.class)
.where("_id", "=", 1)
.and(WhereBuilder.b("name", "=", "小王"))
.orderBy("name")
.limit(10)
.offset(0)
);
Log.i(TAG,"==========条件查询============");
Log.i(TAG,all.get(0).toString());
} catch (DbException e) {
e.printStackTrace();
}
try {
dbUtils.delete(Student.class, WhereBuilder.b("_id", "=", 1));
// dbUtils.deleteAll(Student.class);
} catch (DbException e) {
e.printStackTrace();
}
Student s1 = new Student("大王", 200, 199, 1, 100000);
try {
dbUtils.update(s1, WhereBuilder.b("_id", "=", 2), "name", "age", "score", "clas", "numb");
} catch (DbException e) {
e.printStackTrace();
}
}
}