XListView+数据库

Main

package com.example.week_demo02;


import java.io.BufferedReader;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.net.HttpURLConnection;
import java.net.MalformedURLException;
import java.net.URL;
import java.util.List;


import com.example.week_demo02.DataBean.ResultBean;
import com.example.week_demo02.XListView.IXListViewListener;
import com.google.gson.Gson;


import android.os.AsyncTask;
import android.os.Bundle;
import android.app.Activity;
import android.content.ContentValues;
import android.database.sqlite.SQLiteDatabase;
import android.view.Menu;


public class MainActivity extends Activity {


XListView listView;
int page = 5;
int limit = 1;
String URL_HOST="http://gank.io/api/history/content/";
MyAdapter adapter;
boolean tag = true;
SQLiteDatabase db;

@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);

MyHelper helper = new MyHelper(MainActivity.this);
db = helper.getWritableDatabase();

listView = (XListView) findViewById(R.id.xlist);
listView.setPullLoadEnable(true);
listView.setPullRefreshEnable(true);
adapter = new MyAdapter(MainActivity.this);
listView.setAdapter(adapter);
listView.setXListViewListener(new IXListViewListener() {

@Override
public void onRefresh() {
// TODO Auto-generated method stub
page=1;
addTask();
}

@Override
public void onLoadMore() {
// TODO Auto-generated method stub
page++;
addTask();
}
});
addTask();
}

private void addTask(){
MyTask task = new MyTask();
task.execute("");
}

class MyTask extends AsyncTask<String, Integer, String>{


@Override
protected String doInBackground(String... params) {
// TODO Auto-generated method stub
return getNetData();
}


@Override
protected void onPostExecute(String result) {
// TODO Auto-generated method stub
super.onPostExecute(result);
if(result!=null){
Gson gson = new Gson();
DataBean bean = gson.fromJson(result, DataBean.class);
if(bean!=null){
List<ResultBean> resultBean = bean.results;
if(resultBean!=null&&resultBean.size()>0){
if(page>1){
adapter.addData(resultBean);
addDB(resultBean);
}else {
adapter.updateData(resultBean);
if(tag){
addDB(resultBean);
tag = false;
}
}
listView.stopLoadMore();
listView.stopRefresh();
}
}
}
}

}

private String getNetData(){
String path = URL_HOST + limit + "/" + page;
try {
URL url = new URL(path);
HttpURLConnection connection = (HttpURLConnection) url.openConnection();
int code = connection.getResponseCode();
if(code == 200){
InputStream is = connection.getInputStream();
BufferedReader reader = new BufferedReader(new InputStreamReader(is));
String str = "";
StringBuilder builder = new StringBuilder();
while((str=reader.readLine())!=null){
builder.append(str);
}
is.close();
reader.close();
return builder.toString();
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}

private void addDB(List<DataBean.ResultBean> list){
for (int i = 0; i < list.size(); i++) {
ContentValues values = new ContentValues();
values.put("title", list.get(i).title);
values.put("content", list.get(i).content);
db.insert("qwq", null, values);
}
}
}

MyAdapter  

package com.example.week_demo02;


import java.util.ArrayList;
import java.util.List;


import android.content.Context;
import android.view.View;
import android.view.ViewGroup;
import android.webkit.WebChromeClient;
import android.webkit.WebSettings;
import android.webkit.WebView;
import android.widget.BaseAdapter;
import android.widget.TextView;


public class MyAdapter extends BaseAdapter{


List<DataBean.ResultBean> list = new ArrayList<DataBean.ResultBean>();
Context context;
public MyAdapter(Context context) {
super();
this.context = context;
}
public void addData(List<DataBean.ResultBean> list){
this.list.addAll(list);
notifyDataSetChanged();
}
public void updateData(List<DataBean.ResultBean> list){
this.list.clear();
addData(list);
}
@Override
public int getCount() {
// TODO Auto-generated method stub
return list
.size();
}
@Override
public Object getItem(int position) {
// TODO Auto-generated method stub
return list.get(position);
}
@Override
public long getItemId(int position) {
// TODO Auto-generated method stub
return position;
}
@Override
public View getView(int position, View convertView, ViewGroup parent) {
ViewHolder holder;
if(convertView==null){
convertView = View.inflate(context, R.layout.item, null);
holder = new ViewHolder();
holder.textView = (TextView) convertView.findViewById(R.id.item_text);
holder.webView = (WebView) convertView.findViewById(R.id.item_web);
convertView.setTag(holder);
}else {
holder = (ViewHolder) convertView.getTag();
}
DataBean.ResultBean bean = list.get(position);
if(bean.title!=null){
holder.textView.setText(bean.title);
}
if(bean.content!=null){
holder.webView.loadDataWithBaseURL("", bean.content, "text/html", "utf-8", null);
WebSettings settings = holder.webView.getSettings();
settings.getJavaScriptCanOpenWindowsAutomatically();
settings.getJavaScriptEnabled();
holder.webView.setWebChromeClient(new WebChromeClient());
}
return convertView;
}

class ViewHolder{
TextView textView;
WebView webView;
}

}