这篇文章主要讲解了“Android中ListView怎么使用”,文中的讲解内容简单清晰,易于学习与理解,下面请大家跟着小编的思路慢慢深入,一起来研究和学习“Android中ListView怎么使用”吧!
创建数据库
主方法调用数据库继承类且初始化数据库,写入数据
MyDatabaseHelper databaseHelper = new MyDatabaseHelper(this,"Co.db",null,1);
SQLiteDatabase db = databaseHelper.getWritableDatabase();
SQLiteDatabase db2 = databaseHelper.getReadableDatabase();
ContentValues values = new ContentValues();
values.put("Code","1");
values.put("Name","Admin");
values.put("Post","32");
values.put("Tel","123456789");
db.insert("employee",null,values);
values.clear();
values.put("Code","2");
values.put("Name","Admin1");
values.put("Post","22");
values.put("Tel","23342e");
db.insert("employee",null,values);
Cursor cursor = db2.query("Employee",null,null,null,null,null,null);
arrayList = new ArrayList<>();
if (cursor.moveToFirst()) {
do {
name = cursor.getString(cursor.getColumnIndex("Name"));
code = cursor.getString(cursor.getColumnIndex("Code"));
post = cursor.getString(cursor.getColumnIndex("Post"));
tel = cursor.getString(cursor.getColumnIndex("Tel"));
System.out.println("查找到的值:"+ name +"---"+ code +"---"+ post +"---"+ tel);
Employee employee=new Employee(name, tel, post, code);
arrayList.add(employee);
}while (cursor.moveToNext());
}
lv.setAdapter(new BaseAdapter() {
@Override
public int getCount() {
return arrayList.size();
}
@Override
public Object getItem(int position) {
return null;
}
@Override
public long getItemId(int position) {
return 0;
}
@Override
public View getView(int position, View convertView, ViewGroup parent) {
View view;
if (convertView==null){
view=View.inflate(getBaseContext(),R.layout.listitem,null);
}else{
view=convertView;
}
Employee ee=(Employee) arrayList.get(position);
TextView eename=view.findViewById(R.id.name);
TextView eedianhua=view.findViewById(R.id.dianhua);
TextView eezhiwei=view.findViewById(R.id.zhiwei);
TextView eekahao=view.findViewById(R.id.kahao);
eename.setText(ee.getName());
eedianhua.setText(ee.getTel());
eezhiwei.setText(ee.getPost());
eekahao.setText(ee.getCode());
return view;
}
});
public class MyDatabaseHelper extends SQLiteOpenHelper {
public static final String CREATE_Employees = "create table employee ("
+ "Code text, "
+ "Name text unique, "
+ "Post text, "
+ "Tel text)";
private Context mContext;
public MyDatabaseHelper(Context context, String name, SQLiteDatabase.CursorFactory
factory, int version) {
super(context, name, factory, version);
mContext = context;
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(CREATE_Employees);
Toast.makeText(mContext, "Create succeeded", Toast.LENGTH_SHORT).show();
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
package com.example.a4_7_1_lv;
public class Employee {
private String name;
private String tel;
private String post;
private String code;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getTel() {
return tel;
}
public void setTel(String tel) {
this.tel = tel;
}
public String getPost() {
return post;
}
public void setPost(String post) {
this.post = post;
}
public String getCode() {
return code;
}
public void setCode(String code) {
this.code = code;
}
public Employee(String name, String tel, String post, String code) {
this.name = name;
this.tel = tel;
this.post = post;
this.code = code;
}
public Employee() {
}
}
<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:app="http://schemas.android.com/apk/res-auto"
xmlns:tools="http://schemas.android.com/tools"
android:layout_width="match_parent"
android:layout_height="match_parent"
tools:context=".MainActivity">
<ListView
android:id="@+id/list"
android:layout_width="match_parent"
android:layout_height="match_parent"/>
</RelativeLayout>
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout
xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:orientation="vertical">
<LinearLayout
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:orientation="horizontal">
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="姓名"
android:textSize="30dp"/>
<TextView
android:layout_marginLeft="30dp"
android:id="@+id/name"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text=""
android:textSize="30dp"/>
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="电话"
android:layout_marginLeft="100dp"
android:textSize="30dp"/>
<TextView
android:layout_marginLeft="30dp"
android:id="@+id/dianhua"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text=""
android:textSize="30dp"/>
</LinearLayout>
<LinearLayout
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:orientation="horizontal">
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="职位"
android:textSize="30dp"/>
<TextView
android:layout_marginLeft="30dp"
android:id="@+id/zhiwei"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text=""
android:textSize="30dp"/>
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="卡号"
android:layout_marginLeft="100dp"
android:textSize="30dp"/>
<TextView
android:layout_marginLeft="30dp"
android:id="@+id/kahao"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text=""
android:textSize="30dp"/>
</LinearLayout>
</LinearLayout>
package com.example.a4_7_1_lv;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.widget.Toast;
public class MyDatabaseHelper extends SQLiteOpenHelper {
public static final String CREATE_Employees = "create table employee ("
+ "Code text, "
+ "Name text unique, "
+ "Post text, "
+ "Tel text)";
private Context mContext;
public MyDatabaseHelper(Context context, String name, SQLiteDatabase.CursorFactory
factory, int version) {
super(context, name, factory, version);
mContext = context;
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(CREATE_Employees);
Toast.makeText(mContext, "Create succeeded", Toast.LENGTH_SHORT).show();
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
package com.example.a4_7_1_lv;
import androidx.appcompat.app.AppCompatActivity;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.view.ViewGroup;
import android.widget.BaseAdapter;
import android.widget.ListView;
import android.widget.TextView;
import java.util.ArrayList;
public class MainActivity extends AppCompatActivity {
private ListView lv;
private MyDatabaseHelper databaseHelper;
private SQLiteDatabase db;
private SQLiteDatabase db2;
private ArrayList arrayList;
private String name;
private String code;
private String post;
private String tel;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
lv = findViewById(R.id.list);
}
@Override
protected void onStart() {
super.onStart();
MyDatabaseHelper databaseHelper = new MyDatabaseHelper(this,"Co.db",null,1);
db = databaseHelper.getWritableDatabase();
db2 = databaseHelper.getReadableDatabase();
DBInsert();
Cursor cursor = db2.query("Employee",null,null,null,null,null,null);
arrayList = new ArrayList<>();
if (cursor.moveToFirst()) {
do {
name = cursor.getString(cursor.getColumnIndex("Name"));
code = cursor.getString(cursor.getColumnIndex("Code"));
post = cursor.getString(cursor.getColumnIndex("Post"));
tel = cursor.getString(cursor.getColumnIndex("Tel"));
System.out.println("查找到的值:"+ name +"---"+ code +"---"+ post +"---"+ tel);
Employee employee=new Employee(name, tel, post, code);
arrayList.add(employee);
}while (cursor.moveToNext());
}
lv.setAdapter(new BaseAdapter() {
@Override
public int getCount() {
return arrayList.size();
}
@Override
public Object getItem(int position) {
return null;
}
@Override
public long getItemId(int position) {
return 0;
}
@Override
public View getView(int position, View convertView, ViewGroup parent) {
View view;
if (convertView==null){
view=View.inflate(getBaseContext(),R.layout.listitem,null);
}else{
view=convertView;
}
Employee ee=(Employee) arrayList.get(position);
TextView eename=view.findViewById(R.id.name);
TextView eedianhua=view.findViewById(R.id.dianhua);
TextView eezhiwei=view.findViewById(R.id.zhiwei);
TextView eekahao=view.findViewById(R.id.kahao);
eename.setText(ee.getName());
eedianhua.setText(ee.getTel());
eezhiwei.setText(ee.getPost());
eekahao.setText(ee.getCode());
return view;
}
});
}
private void DBInsert() {
ContentValues values = new ContentValues();
values.put("Code","1");
values.put("Name","Admin");
values.put("Post","32");
values.put("Tel","123456789");
db.insert("employee",null,values);
values.clear();
values.put("Code","2");
values.put("Name","Admin1");
values.put("Post","22");
values.put("Tel","23342e");
db.insert("employee",null,values);
values.clear();
values.put("Code","4");
values.put("Name","Admin13");
values.put("Post","2sda2");
values.put("Tel","233asd42e");
db.insert("employee",null,values);
values.clear();
values.put("Code","Code");
values.put("Name","Name");
values.put("Post","Post");
values.put("Tel","Tel");
db.insert("employee",null,values);
}
}
package com.example.a4_7_1_lv;
import androidx.appcompat.app.AppCompatActivity;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.view.ViewGroup;
import android.widget.BaseAdapter;
import android.widget.ListView;
import android.widget.TextView;
import java.util.ArrayList;
public class MainActivity extends AppCompatActivity {
private ListView lv;
private MyDatabaseHelper databaseHelper;
private SQLiteDatabase db;
private SQLiteDatabase db2;
private ArrayList arrayList;
private String name;
private String code;
private String post;
private String tel;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
lv = findViewById(R.id.list);
}
@Override
protected void onStart() {
super.onStart();
MyDatabaseHelper databaseHelper = new MyDatabaseHelper(this,"Co.db",null,1);
db = databaseHelper.getWritableDatabase();
db2 = databaseHelper.getReadableDatabase();
DBInsert();
Cursor cursor = db2.query("Employee",null,null,null,null,null,null);
arrayList = new ArrayList<>();
if (cursor.moveToFirst()) {
do {
name = cursor.getString(cursor.getColumnIndex("Name"));
code = cursor.getString(cursor.getColumnIndex("Code"));
post = cursor.getString(cursor.getColumnIndex("Post"));
tel = cursor.getString(cursor.getColumnIndex("Tel"));
System.out.println("查找到的值:"+ name +"---"+ code +"---"+ post +"---"+ tel);
Employee employee=new Employee(name, tel, post, code);
arrayList.add(employee);
}while (cursor.moveToNext());
}
lv.setAdapter(new BaseAdapter() {
@Override
public int getCount() {
return arrayList.size();
}
@Override
public Object getItem(int position) {
return null;
}
@Override
public long getItemId(int position) {
return 0;
}
@Override
public View getView(int position, View convertView, ViewGroup parent) {
View view;
if (convertView==null){
view=View.inflate(getBaseContext(),R.layout.listitem,null);
}else{
view=convertView;
}
Employee ee=(Employee) arrayList.get(position);
TextView eename=view.findViewById(R.id.name);
TextView eedianhua=view.findViewById(R.id.dianhua);
TextView eezhiwei=view.findViewById(R.id.zhiwei);
TextView eekahao=view.findViewById(R.id.kahao);
eename.setText(ee.getName());
eedianhua.setText(ee.getTel());
eezhiwei.setText(ee.getPost());
eekahao.setText(ee.getCode());
return view;
}
});
}
private void DBInsert() {
ContentValues values = new ContentValues();
values.put("Code","1");
values.put("Name","Admin");
values.put("Post","32");
values.put("Tel","123456789");
db.insert("employee",null,values);
values.clear();
values.put("Code","2");
values.put("Name","Admin1");
values.put("Post","22");
values.put("Tel","23342e");
db.insert("employee",null,values);
values.clear();
values.put("Code","4");
values.put("Name","Admin13");
values.put("Post","2sda2");
values.put("Tel","233asd42e");
db.insert("employee",null,values);
values.clear();
values.put("Code","Code");
values.put("Name","Name");
values.put("Post","Post");
values.put("Tel","Tel");
db.insert("employee",null,values);
}
}
感谢各位的阅读,以上就是“Android中ListView怎么使用”的内容了,经过本文的学习后,相信大家对Android中ListView怎么使用这一问题有了更深刻的体会,具体使用情况还需要大家实践验证。这里是亿速云,小编将为大家推送更多相关知识点的文章,欢迎关注!
亿速云「云服务器」,即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘,价格低至29元/月。点击查看>>
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。