存储数据库展示存储数据库展示

public classOneextendsFragmentimplementsXListView.IXListViewListener {

privateListbeanList;
privateXListViewxListView;
private intstartNum=0;
privateMyAdapteradapter;
privateSQLiteDatabasedb;
privateXnewsDBxnewsDB;
privateListlist;
privateAadapteraadapter;
privateHandlerxhandler=newHandler() {
@Override
public voidhandleMessage(Message msg) {
String s = msg.obj.toString();
Gson gson =newGson();
if(isNetworkConnected(getActivity())){
Xnews xnews = gson.fromJson(s,Xnews.class);
beanList.addAll(xnews.getData());
adapter.notifyDataSetChanged();
}else{
Neww neww = gson.fromJson(s,Neww.class);
list.add(neww);
aadapter.notifyDataSetChanged();
}
stopXlist();
insert();
}
private voidstopXlist() {
xListView.stopRefresh();
xListView.stopLoadMore();
xListView.setRefreshTime("刚刚");
}
};
private voidinsert() {
for(Xnews.DataBean bean :beanList) {
ContentValues values =newContentValues();
values.put("id",bean.getID());
values.put("title",bean.getTITLE());
values.put("froname",bean.getFROMNAME());
values.put("image",bean.getIMAGEURL());
longaNew =db.insert("new", null,values);
if(aNew >0) {
Toast.makeText(getActivity(),"添加成功",Toast.LENGTH_SHORT).show();
}
}
}
@Nullable
@Override
publicViewonCreateView(LayoutInflater inflater,@NullableViewGroup container,@NullableBundle savedInstanceState) {
View view = View.inflate(getActivity(),R.layout.activity_one, null);
if(isNetworkConnected(getActivity())) {
xnewsDB=newXnewsDB(getActivity());
db=xnewsDB.getReadableDatabase();
xListView= (XListView) view.findViewById(R.id.xlist);
beanList=newArrayList<>();
xListView.setPullLoadEnable(true);
xListView.setXListViewListener(this);
adapter=newMyAdapter();
loaDate();
xListView.setAdapter(adapter);
Toast.makeText(getActivity(),"网络可用",Toast.LENGTH_LONG).show();
}else{
xnewsDB=newXnewsDB(getActivity());
db=xnewsDB.getReadableDatabase();
xListView= (XListView) view.findViewById(R.id.xlist);
xListView.setPullLoadEnable(true);
xListView.setXListViewListener(this);
show();
aadapter=newAadapter();
xListView.setAdapter(aadapter);
Toast.makeText(getActivity(),"网络不可用",Toast.LENGTH_LONG).show();
}
returnview;
}
private voidshow() {
list=newArrayList<>();
Cursor cursor =db.rawQuery("select * from new", null);
while(cursor.moveToNext()) {
【存储数据库展示】String id = cursor.getString(cursor.getColumnIndex("id"));
String title = cursor.getString(cursor.getColumnIndex("title"));
String froname = cursor.getString(cursor.getColumnIndex("froname"));
String image = cursor.getString(cursor.getColumnIndex("image"));
Neww neww =newNeww(id,title,froname,image);
list.add(neww);
}
}
public booleanisNetworkConnected(Context context) {
if(context !=null) {
ConnectivityManager mConnectivityManager = (ConnectivityManager) context
.getSystemService(Context.CONNECTIVITY_SERVICE);
NetworkInfo mNetworkInfo = mConnectivityManager.getActiveNetworkInfo();
if(mNetworkInfo !=null) {
returnmNetworkInfo.isAvailable();
}
}
return false;
}
private voidloaDate() {
newThread() {
@Override
public voidrun() {
String urlConnect = Net.getUrlConnect("http://www.93.gov.cn/93app/data.do?channelId=0&startNum="+startNum);
Message message = Message.obtain();
message.obj= urlConnect;
xhandler.sendMessage(message);
}
}.start();
}
@Override
public voidonRefresh() {
startNum++;
if(isNetworkConnected(getActivity())) {
beanList.clear();
}else{
list.clear();
}
loaDate();
}
@Override
public voidonLoadMore() {
startNum++;
loaDate();
}
classMyAdapterextendsBaseAdapter {
@Override
public intgetCount() {
returnbeanList.size();
}
@Override
publicObjectgetItem(inti) {
returnbeanList.get(i);
}
@Override
public longgetItemId(inti) {
returni;
}
@Override
publicViewgetView(inti,View view,ViewGroup viewGroup) {
ViewHolder holder;
if(view ==null) {
holder =newViewHolder();
view = View.inflate(getActivity(),R.layout.item, null);
holder.imageView= (ImageView) view.findViewById(R.id.i1);
holder.textView= (TextView) view.findViewById(R.id.t1);
holder.textView2= (TextView) view.findViewById(R.id.t2);
view.setTag(holder);
}else{
holder = (ViewHolder) view.getTag();
}
holder.textView.setText(beanList.get(i).getTITLE());
holder.textView2.setText(beanList.get(i).getFROMNAME());
Glide.with(getActivity()).load(beanList.get(i).getIMAGEURL()).into(holder.imageView);
returnview;
}
}
classViewHolder {
ImageViewimageView;
TextViewtextView,textView2;
}
classAadapterextendsBaseAdapter {
@Override
public intgetCount() {
returnlist.size();
}
@Override
publicObjectgetItem(inti) {
returnlist.get(i);
}
@Override
public longgetItemId(inti) {
returni;
}
@Override
publicViewgetView(inti,View view,ViewGroup viewGroup) {
ViewHolder2 holder;
if(view ==null) {
holder =newViewHolder2();
view = View.inflate(getActivity(),R.layout.item, null);
holder.imageView= (ImageView) view.findViewById(R.id.i1);
holder.textView= (TextView) view.findViewById(R.id.t1);
holder.textView2= (TextView) view.findViewById(R.id.t2);
view.setTag(holder);
}else{
holder = (ViewHolder2) view.getTag();
}
holder.textView.setText(list.get(i).getTitle());
holder.textView2.setText(list.get(i).getFroname());
Glide.with(getActivity()).load(list.get(i).getImage()).into(holder.imageView);
returnview;
}
}
classViewHolder2 {
ImageViewimageView;
TextViewtextView,textView2;
}
}

存储数据库展示

推荐阅读

构成职务侵占罪会如何追究责任?

红梅树修剪时间和方法刚买的红梅盆栽养殖方法

佳能单反p档操作佳能p档怎么使用

给我查一下一月份哪天日子好查一下日子

孤独就像烧开的水壶孤独水壶是什么意思

美的随风行美的随风行移动空调不制冷

出远门核酸检测提前几天做

单反相机与数码相机的区别有哪些？数码相机和单反相机的区别

济宁什么情况能带押过户？

《暗黑破坏神3：夺魂之镰》圣教军FARM练级实用心得

新冠疫苗|普通人还有多久能接种新冠疫苗？最新回应来了

春笋怎么保存一周春笋保存方法家庭

专家解读：个人医保账户里的钱为何少了？

上古卷轴5天际怎么玩_玩法大全分享

慢跑可以练出腹肌吗

idea是用来干什么的，idea后面加是什么意思

土豆粉一包多少钱纯土豆粉条多少钱一斤

韭菜与鸡肉相克吗

投稿|营收增长难掩资本市场落寞：腾讯音乐“押宝”元宇宙？

小耳朵奶茶获得教程小耳朵奶茶活动什么时候结束