安卓页面
1.主页面
<RelativeLayout 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"
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" >
<Button android:id="@+id/btn_insert"
android:layout_height="wrap_content"
android:layout_width="wrap_content"
android:text="插入数据"
android:onClick="insert"/>
<Button android:id="@+id/bin_query"
android:layout_height="wrap_content"
android:layout_width="wrap_content"
android:onClick="query"
android:layout_toRightOf="@id/btn_insert"
android:text="查询数据"/>
<ListView
android:id="@+id/lv_list"
android:layout_below="@id/btn_insert"
android:layout_height="match_parent"
android:layout_width="match_parent">
</ListView>
</RelativeLayout>
2.显示数据页面
<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:orientation="vertical">
<ImageView
android:id="@+id/iv_icon"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:background="@drawable/ic_launcher"/>
<TextView android:id="@+id/txt_name"
android:layout_height="wrap_content"
android:layout_width="match_parent"
android:layout_toRightOf="@+id/iv_icon"
android:text="我是赵传奇"
android:textSize="20dp"
android:textColor="#000000"/>
<TextView android:id="@+id/txt_phone"
android:layout_height="wrap_content"
android:layout_width="match_parent"
android:layout_toRightOf="@+id/iv_icon"
android:layout_below="@id/txt_name"
android:text="我是赵传奇我是赵传奇我是赵传奇我是赵传奇我是赵传奇"
android:textSize="16dp"
android:textColor="#88000000"/>
</RelativeLayout>
3sqlite数据库的使用
package com.xuemeng.listview;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
public class MyOpenHelper extends SQLiteOpenHelper {
public MyOpenHelper(Context context, String name, CursorFactory factory,
int version) {
super(context, "test.db", null, 1);
// TODO Auto-generated constructor stub
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("create table info( _id integer primary key autoincrement,name varchar(20), phone varchar(20) )");
}
@Override
public void onUpgrade(SQLiteDatabase db, int arg1, int arg2) {
// TODO Auto-generated method stub
}
}
4创建javabean person获取数据
package com.xuemeng.listview;
public class Person {
String name;
String phone;
@Override
public String toString() {
return "Person [name=" + name + ", phone=" + phone + "]";
}
}
5关联数据并显示
package com.xuemeng.listview;
import java.util.ArrayList;
import android.os.Bundle;
import android.app.Activity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.view.Menu;
import android.view.View;
import android.view.ViewGroup;
import android.widget.BaseAdapter;
import android.widget.ListView;
import android.widget.TextView;
public class MainActivity extends Activity {
private ListView listview =null;
private MyOpenHelper openHelper;
private ArrayList<Person> persons=new ArrayList<Person>();
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
listview = (ListView) findViewById(R.id.lv_list);
openHelper=new MyOpenHelper(this, "test.db", null, 1);
}
public void insert(View v){
SQLiteDatabase database = openHelper.getReadableDatabase();
database.execSQL("insert into info(name,phone) values('张三1','133333333331')");
database.execSQL("insert into info(name,phone) values('张三2','133333333332')");
database.execSQL("insert into info(name,phone) values('张三3','133333333333')");
database.execSQL("insert into info(name,phone) values('张三4','133333333334')");
database.execSQL("insert into info(name,phone) values('张三5','133333333335')");
database.execSQL("insert into info(name,phone) values('张三6','133333333336')");
database.close();
}
public void query(View v){
SQLiteDatabase database = openHelper.getReadableDatabase();
Cursor rawQuery = database.rawQuery("select * from info", null);
while(rawQuery.moveToNext()){
Person person=new Person();
person.name=rawQuery.getString(1);
person.phone=rawQuery.getString(2);
persons.add(person);
}
rawQuery.close();
database.close();
for(Person person:persons){
System.out.println(person);
}
listview.setAdapter(new myAdapter());
}
class myAdapter extends BaseAdapter{
@Override
public int getCount() {
return persons.size();
}
@Override
public Object getItem(int pisition) {
return persons.get(pisition);
}
@Override
public long getItemId(int pisition) {
return pisition;
}
@Override
public View getView(int pisition, View cview, ViewGroup arg2) {
View view=null;
if(cview==null){
view=View.inflate(MainActivity.this, R.layout.list, null);
}else{
view=cview;
}
TextView tv_name=(TextView) view.findViewById(R.id.txt_name);
TextView tv_phone=(TextView) view.findViewById(R.id.txt_phone);
Person person=persons.get(pisition);
tv_name.setText(person.name);
tv_phone.setText(person.phone);
return view;
}
}
}
****自己项目目录*****