public class MainActivity extends Activity {
private SQLiteDatabase db;
private ListView lv;
private List<Person> list;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
//初始化listview控件
lv = (ListView) findViewById(R.id.lv);
DBHelper helper = new DBHelper(this, "persons.db", null, 1);
db = helper.getWritableDatabase();
}
public void insert(View v){
// db.execSQL(“insert into person (name)values(?)”, new String[]{“lisi”});
ContentValues values = new ContentValues();
Random r = new Random();
values.put(“name”, “zhangsan”+r.nextInt(100));
long rowId = db.insert(“person”, null, values);
System.out.println(“rowId=”+rowId);
Toast.makeText(this, “插入数据成功”, 0).show();
}
public void query(View v){
list = new ArrayList<Person>();
/**
* table 表名
* columns 查询的列
* selection 查询条件"id=1"
* selectionArgs 查询条件的值
* String groupBy
* String having
* String orderBy)
*
*/
Cursor cursor = db.query("person", new String[]{"id","name" }, null, null, null, null, null);
while(cursor.moveToNext()){
Person p = new Person();
int id = cursor.getInt(0);
p.setId(id);
String name = cursor.getString(1);
p.setName(name);
list.add(p);
System.out.println("id="+id+"; name="+name);
}
//把数据显示到列表
lv.setAdapter(new MyAdapter());
Toast.makeText(this, "查询数据成功", 0).show();
}
/**
*创建一个数据适配器,为listview填充数据
*/
private class MyAdapter extends BaseAdapter{
@Override
public int getCount() {
return list.size();
}
@Override
public View getView(int position, View convertView, ViewGroup parent) {
View view = null;
if(convertView != null){
view = convertView;
}
else{
view = View.inflate(MainActivity.this, R.layout.item, null);
}
TextView tv_id = (TextView) view.findViewById(R.id.tv_id);
TextView tv_name = (TextView) view.findViewById(R.id.tv_name);
Person p = list.get(position);
tv_id.setText(p.getId()+"");
tv_name.setText(p.getName());
return view;
}
@Override
public Object getItem(int position) {
// TODO Auto-generated method stub
return null;
}
@Override
public long getItemId(int position) {
// TODO Auto-generated method stub
return 0;
}
}
}