SQLite数据库

//数据库
public class SQLHelp extends SQLiteOpenHelper {

public SQLHelp(Context context) {
    super(context, "bw.db", null, 1);
}

@Override
public void onCreate(SQLiteDatabase db) {
    db.execSQL("CREATE TABLE person(id INTEGER PRIMARY KEY AUTOINCREMENT,title TEXT)");
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

}

}

//ListViewAdapter页面
public class ListAdapter extends BaseAdapter {
private Context context;
private List list;

public ListAdapter(Context context, List<One> list) {
    this.context = context;
    this.list = list;
}

@Override
public int getCount() {
    return list.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) {
    ViewHolder holder=null;
    if(convertView==null){
        convertView=View.inflate(context, R.layout.list_item,null);
        holder=new ViewHolder();
        holder.imageView=convertView.findViewById(R.id.imageview);
        holder.textView=convertView.findViewById(R.id.text_name);
        holder.textView1=convertView.findViewById(R.id.text_pric);
        convertView.setTag(holder);
    }else{
        holder = (ViewHolder) convertView.getTag();
    }
    One da = list.get(position);
    Glide.with(context).load(da.getMasterPic()).into(holder.imageView);
    holder.textView.setText(da.getCommodityName());
    holder.textView1.setText(da.getPrice()+"");
    return convertView;
}

class ViewHolder{
    private ImageView imageView;
    private TextView textView;
    private TextView textView1;
}

}