查

public class Main4Activity extends AppCompatActivity {

    private static  SQLiteDatabase db;
    public static  List<Dao> list=new ArrayList<>();
    private ListView listView;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main4);
        listView = (ListView) findViewById(R.id.lv);
        Utils u=new Utils(Main4Activity.this);
         db = u.getWritableDatabase();
        quaey();
       // MyAdapter2 adapter2=new MyAdapter2(list,Main4Activity.this);
        //List<Bean.ResultBean.DataBean> list = Select();
       // Fragment1.insert();
       // adapter2.addList(list);
        listView.setAdapter(new My());
    }
    class  My extends BaseAdapter{

public static void insert(){
    ContentValues values=new ContentValues();
    for (int i=0;i<list.size();i++){
        values.put("author_name",list.get(i).getAuthor_name());
        values.put("title",list.get(i).getTitle());
        values.put("date",list.get(i).getDate());
        db.insert("wang",null,values);
    }

        @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) {
            convertView=View.inflate(Main4Activity.this,R.layout.item6,null);
            TextView tv= (TextView) convertView.findViewById(R.id.tv);
            tv.setText(list.get(position).getTitle());
            return convertView;
        }
    }
    public void quaey(){
            Cursor cursor = db.query("wang", null, null, null, null, null, null);

            while (cursor.moveToNext()){
                Dao d=new Dao();
                // d.title = cursor.getString(cursor.getColumnIndex("author_name"));
                d.title = cursor.getString(cursor.getColumnIndex("title"));
                //String date = cursor.getString(cursor.getColumnIndex("date"));
                 
                list.add(d);
        }

    }