一个android读取sqlite数据库的数据并用listview显示demo
package kaoqin.xxf.com.kaoqin;
import android.database.sqlite.SQLiteDatabase;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.BaseAdapter;
import android.widget.ListView;
import android.database.Cursor;
import android.widget.TextView;
import org.w3c.dom.Text;
import java.util.ArrayList;
public class MainActivity extends AppCompatActivity {
//private SQLiteDatabase sd;
//private MyOpenHelper moh;
private ListView lv;
private ArrayList<Student> studentlist;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
studentlist = new ArrayList<>();
SQLdm s = new SQLdm();
SQLiteDatabase db = s.openDatabase(getApplicationContext());
Cursor cursor = db.rawQuery("select * from yidong",null);
while(cursor.moveToNext()){
String name = cursor.getString(cursor.getColumnIndex("name"));
String xuehao = cursor.getString(cursor.getColumnIndex("xuehao"));
String Class = cursor.getString(cursor.getColumnIndex("Class"));
Student st = new Student(name,Class,xuehao);
studentlist.add(st);
}
lv = (ListView)findViewById(R.id.student_lv);
lv.setAdapter(new BaseAdapter() {
/*
* 为ListView设置一个适配器
* getCount()返回数据个数
* getView()为每一行设置一个条目
* */
@Override
public int getCount() {
return studentlist.size();
}
@Override
public Object getItem(int position) {
// return studentlist.get(position);
return null;
}
@Override
public long getItemId(int position) {
// return position;
return 0;
}
@Override
public View getView(int position, View convertView, ViewGroup parent) {
View view ;
/**对ListView的优化，convertView为空时，创建一个新视图；
* convertView不为空时，代表它是滚出,
* 放入Recycler中的视图,若需要用到其他layout，
* 则用inflate(),同一视图，用fiindViewBy()
* **/
if(convertView == null )
{
LayoutInflater inflater = MainActivity.this.getLayoutInflater();
view = inflater.inflate(R.layout.item,null);
//view = View.inflate(getBaseContext(),R.layout.item,null);
}
else
{
view = convertView;
}
//从studentlist中取出一行数据，position相当于数组下标,可以实现逐行取数据
Student st = studentlist.get(position);
//TextView name = (TextView) LayoutInflater.from(MainActivity.this).inflate(R.layout.item, null).findViewById(R.id.stu_name);
//TextView xuehao = (TextView) LayoutInflater.from(MainActivity.this).inflate(R.layout.item, null).findViewById(R.id.stu_number);
//TextView Class = (TextView) LayoutInflater.from(MainActivity.this).inflate(R.layout.item, null).findViewById(R.id.stu_age);
TextView name = (TextView)view.findViewById(R.id.stu_name);
TextView xuehao = (TextView)view.findViewById(R.id.stu_number);
TextView Class = (TextView)view.findViewById(R.id.stu_age);
xuehao.setText(st.getXuehao());
name.setText(st.getName());
Class.setText(st.getclass());
return view;
}
});
}
}
资源文件列表
MyApplication2/.gitignore , 105
MyApplication2/.gradle/2.10/taskArtifacts/cache.properties , 31
MyApplication2/.gradle/2.10/taskArtifacts/cache.properties.lock , 17
MyApplication2/.gradle/2.10/taskArtifacts/fileHashes.bin , 142666
MyApplication2/.gradle/2.10/taskArtifacts/fileSnapshots.bin , 5242829
MyApplication2/.gradle/2.10/taskArtifacts/outputFileStates.bin , 20522
MyApplication2/.gradle/2.10/taskArtifacts/taskArtifacts.bin , 117115
MyApplication2/.idea/.name , 14
MyApplication2/.idea/compiler.xml , 686
MyApplication2/.idea/copyright/profiles_settings.xml , 76
MyApplication2/.idea/encodings.xml , 159
MyApplication2/.idea/gradle.xml , 833
MyApplication2/.idea/libraries/animated_vector_drawable_24_2_1.xml , 644
MyApplication2/.idea/libraries/appcompat_v7_24_2_1.xml , 760
MyApplication2/.idea/libraries/hamcrest_core_1_3.xml , 526
MyApplication2/.idea/libraries/junit_4_12.xml , 477
MyApplication2/.idea/libraries/multidex_1_0_1.xml , 411
MyApplication2/.idea/libraries/multidex_instrumentation_1_0_1.xml , 459
MyApplication2/.idea/libraries/support_annotations_24_2_1.xml , 493
MyApplication2/.idea/libraries/support_compat_24_2_1.xml , 930
MyApplication2/.idea/libraries/support_core_ui_24_2_1.xml , 937
MyApplication2/.idea/libraries/support_core_utils_24_2_1.xml , 776
MyApplication2/.idea/libraries/support_fragment_24_2_1.xml , 944
MyApplication2/.idea/libraries/support_media_compat_24_2_1.xml , 972
MyApplication2/.idea/libraries/support_v4_24_2_1.xml , 420
MyApplication2/.idea/libraries/support_vector_drawable_24_2_1.xml , 639
MyApplication2/.idea/misc.xml , 2226
MyApplication2/.idea/modules.xml , 365
MyApplication2/.idea/runConfigurations.xml , 564
MyApplication2/.idea/workspace.xml , 185451
MyApplication2/MyApplication2.iml , 945
MyApplication2/app/.gitignore , 8
MyApplication2/app/app.iml , 10925
MyApplication2/local.properties , 426
MyApplication2/gradlew.bat , 2404
MyApplication2/gradlew , 4971
MyApplication2/gradle.properties , 976
MyApplication2/app/build/generated/source/buildConfig/androidTest/debug/kaoqin/xxf/com/kaoqin/test/BuildConfig.java , 459
MyApplication2/app/build/generated/source/buildConfig/debug/kaoqin/xxf/com/kaoqin/BuildConfig.java , 449
MyApplication2/gradle/wrapper/gradle-wrapper.properties , 232
MyApplication2/app/build/generated/source/r/debug/android/support/v7/appcompat/R.java , 94657
MyApplication2/app/build/generated/source/r/debug/kaoqin/xxf/com/kaoqin/R.java , 420271
MyApplication2/gradle/wrapper/gradle-wrapper.jar , 53636
MyApplication2/app/build/intermediates/assets/debug/student1.db , 20480
MyApplication2/build.gradle , 521
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-af.json , 15977
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-am.json , 15971
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-ar.json , 15979
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-az-rAZ.json , 15389
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-b+sr+Latn.json , 16289
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-be-rBY.json , 16159
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-bg.json , 15983
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-bn-rBD.json , 16163
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-bs-rBA.json , 16159
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-ca.json , 15983
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-cs.json , 15979
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-da.json , 15975
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-de.json , 15979
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-el.json , 15985
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-en-rAU.json , 16151
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-en-rGB.json , 16151
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-en-rIN.json , 16151
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-es-rUS.json , 16161
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-es.json , 15981
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-et-rEE.json , 16161
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-eu-rES.json , 16157
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-fa.json , 15981
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-fi.json , 15975
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-fr-rCA.json , 16161
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-fr.json , 15985
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-gl-rES.json , 16159
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-gu-rIN.json , 16155
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-h720dp-v13.json , 951
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-hdpi-v4.json , 1011
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-hi.json , 15981
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-hr.json , 15979
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-hu.json , 15985
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-hy-rAM.json , 16153
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-in.json , 15981
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-is-rIS.json , 16149
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-it.json , 15977
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-iw.json , 15973
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-ja.json , 15967
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-ka-rGE.json , 16157
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-kk-rKZ.json , 16155
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-km-rKH.json , 16153
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-kn-rIN.json , 16159
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-ko.json , 15963
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-ky-rKG.json , 16155
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-land.json , 3183
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-large-v4.json , 7029
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-ldltr-v21.json , 949
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-lo-rLA.json , 16151
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-lt.json , 15985
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-lv.json , 15983
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-mk-rMK.json , 14629
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-ml-rIN.json , 16159
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-mn-rMN.json , 16153
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-mr-rIN.json , 16159
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-ms-rMY.json , 16157
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-my-rMM.json , 16161
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-nb.json , 15971
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-ne-rNP.json , 16163
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-night-v8.json , 5507
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-nl.json , 15985
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-pa-rIN.json , 16151
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-pl.json , 15981
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-port.json , 927
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-pt-rBR.json , 16161
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-pt-rPT.json , 16161
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-pt.json , 15985
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-ro.json , 15985
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-ru.json , 15983
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-si-rLK.json , 16157
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-sk.json , 15977
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-sl.json , 15981
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-sq-rAL.json , 16157
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-sr.json , 15981
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-sv.json , 15979
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-sw.json , 15977
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-sw600dp-v13.json , 6317
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-ta-rIN.json , 16159
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-te-rIN.json , 16161
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-th.json , 15977
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-tl.json , 15987
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-tr.json , 15977
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-uk.json , 15979
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-ur-rPK.json , 16155
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-uz-rUZ.json , 16159
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-v11.json , 15501
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-v12.json , 3319
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-v13.json , 923
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-v14.json , 8005
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-v17.json , 11761
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-v18.json , 921
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-v21.json , 69369
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-v22.json , 3319
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-v23.json , 8623
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-vi.json , 15983
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-w820dp-v13.json , 869
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-xlarge-v4.json , 4757
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-zh-rCN.json , 16137
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-zh-rHK.json , 16137
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-zh-rTW.json , 16137
MyApplication2/app/build/intermediates/blame/res/debug/multi/values-zu.json , 15983
MyApplication2/app/build/intermediates/blame/res/debug/multi/values.json , 399775
MyApplication2/app/build/intermediates/blame/res/debug/single/anim.json , 3188
MyApplication2/app/build/intermediates/blame/res/debug/single/color-v11.json , 780
MyApplication2/app/build/intermediates/blame/res/debug/single/color-v23.json , 3030
MyApplication2/app/build/intermediates/blame/res/debug/single/color.json , 5744
MyApplication2/app/build/intermediates/blame/res/debug/single/drawable-hdpi-v4.json , 17386
最多只能显示150条信息!