1.布局文件
采用scrollView布局
<ScrollView
xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:tools="http://schemas.android.com/tools"
android:layout_width="match_parent"
android:layout_height="match_parent"
>
<LinearLayout
android:id="@+id/ll"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:paddingBottom="@dimen/activity_vertical_margin"
android:paddingLeft="@dimen/activity_horizontal_margin"
android:paddingRight="@dimen/activity_horizontal_margin"
android:paddingTop="@dimen/activity_vertical_margin"
tools:context=".MainActivity" >
</LinearLayout>
</ScrollView>
根据布局显示数据库中的内容
public class MainActivity extends Activity {
List<Person> personList;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
personList = new ArrayList<Person>();
//把数据库的数据查询出来
MyOpenHelper oh = new MyOpenHelper(this, "person.db", null, 1);
SQLiteDatabase db = oh.getWritableDatabase();
Cursor cursor = db.query("person", null, null, null, null, null, null, null);
while(cursor.moveToNext()){
String _id = cursor.getString(0);
String name = cursor.getString(1);
String phone = cursor.getString(2);
String salary = cursor.getString(3);
Person p = new Person(_id, name, phone, salary);
personList.add(p);
}
LinearLayout ll = (LinearLayout) findViewById(R.id.ll);
//把数据显示到界面
//1.结合中每一条数据,就new一个TextView
for(Person p : personList){
TextView tv = new TextView(this);
//2.把信息显示到文本框
tv.setText(p.toString());
//3.把TextView设置成线性布局的子节点
ll.addView(tv);
}
}