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); } }