package com.example.ex_day00;

讓客戶滿意是我們工作的目標(biāo)，不斷超越客戶的期望值來自于我們對這個行業(yè)的熱愛。我們立志把好的技術(shù)通過有效、簡單的方式提供給客戶，將通過不懈努力成為客戶在信息化領(lǐng)域值得信任、有價值的長期合作伙伴，公司提供的服務(wù)項目有：域名與空間、網(wǎng)絡(luò)空間、營銷軟件、網(wǎng)站建設(shè)、云龍網(wǎng)站維護(hù)、網(wǎng)站推廣。

import java.io.File;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.FileOutputStream;

import java.io.IOException;

import java.io.InputStream;

import java.net.MalformedURLException;

import java.net.URL;

import java.net.URLConnection;

import java.nio.ByteBuffer;

import java.util.ArrayList;

import java.util.HashMap;

import org.apache.http.util.ByteArrayBuffer;

import org.apache.http.util.EncodingUtils;

import org.json.JSONArray;

import org.json.JSONException;

import org.json.JSONObject;

import android.os.AsyncTask;

import android.os.Bundle;

import android.os.Environment;

import android.app.Activity;

import android.content.ContentValues;

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.graphics.Bitmap;

import android.graphics.BitmapFactory;

import android.transition.Visibility;

import android.util.Log;

import android.view.LayoutInflater;

import android.view.Menu;

import android.view.View;

import android.view.View.OnClickListener;

import android.view.ViewGroup;

import android.widget.BaseAdapter;

import android.widget.Button;

import android.widget.EditText;

import android.widget.ImageView;

import android.widget.ListView;

import android.widget.ProgressBar;

public class MainActivity extends Activity implements OnClickListener {

String path = "http://10.0.2.2:8080/abc.txt";

ArrayList ruanjian = new ArrayList();

MyAsyncTask myAsyncTask;

ListView listview;

  HashMap hashBit = new HashMap();

  HashMap myasync = new HashMap();

  EditText chongshi;

  ProgressBar progressbar;

  Button button;

private MyAdaper myAdaper;

private SQLiteDatabase mdb;

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.activity_main);

listview = (ListView) findViewById(R.id.listView1);

progressbar = (ProgressBar)findViewById(R.id.progressBar1);

chongshi = (EditText)findViewById(R.id.chongshi);

  button = (Button)findViewById(R.id.button1);

  button.setOnClickListener(this);

  download();

  selectSQL();

}

private void selectSQL() {

ruanjian.clear();

    Cursor query = mdb.query("student", null, null, null, null, null, null);

    boolean toFirst = query.moveToFirst();

    while (toFirst) {

      int name_index = query.getColumnIndex("name");

      int desc_index = query.getColumnIndex("desc");

      int p_w_picpathpath_index = query.getColumnIndex("p_w_picpathpath");

      String name = query.getString(name_index);

      String desc = query.getString(desc_index);

      String p_w_picpathpath = query.getString(p_w_picpathpath_index);

      ruanjian.add(new RuanJian(name, desc, p_w_picpathpath));

      toFirst = query.moveToNext();

}

    myAdaper.notifyDataSetChanged();

}

private void LianJieSQL() {

   MyData myData = new MyData(this);

   mdb = myData.getReadableDatabase();

}

private void download() {

MyAsyncTask myAsyncTask = new MyAsyncTask();

myAsyncTask.execute(path);

LianJieSQL();

myAdaper = new MyAdaper();

listview.setAdapter(myAdaper);

}

class MyAsyncTask extends AsyncTask {

@Override

protected String doInBackground(String... params) {

         ByteArrayBuffer arrayBuffer = new ByteArrayBuffer(50);

try {

URL url = new URL(params[0]);

URLConnection openConnection = url.openConnection();

openConnection.setConnectTimeout(3000);

openConnection.setReadTimeout(3000);

        InputStream inputStream = openConnection.getInputStream();

byte[] buffer = new byte[1024];

int len = 0;

while((len = inputStream.read(buffer)) !=-1)

{

  arrayBuffer.append(buffer, 0, len);

}

}  catch (MalformedURLException e) {

runOnUiThread(new Runnable() {

@Override

public void run() {

          chongshi.setText("讀取失敗1");

             button.setVisibility(Button.VISIBLE);

             progressbar.setVisibility(View.INVISIBLE);

}

});

e.printStackTrace();

} catch (IOException e) {

runOnUiThread(new Runnable() {

@Override

public void run() {

          chongshi.setText("網(wǎng)絡(luò)連接異常1");

          button.setVisibility(Button.VISIBLE);

          progressbar.setVisibility(View.INVISIBLE);

}

});

e.printStackTrace();

}

return new String(arrayBuffer.toByteArray());

}

    @Override

  protected void onPostExecute(String result) {

   super.onPostExecute(result);

   new MyAsyncTask3().execute(result);

  }

}

  class MyAsyncTask3 extends AsyncTask

  {

@Override

protected Void doInBackground(String... params) {

try {

JSONArray array = new JSONArray(params[0]);

SQldelete();

  //刪除數(shù)據(jù)庫所有數(shù)據(jù)delete

for (int i = 0; i < array.length(); i++) {

JSONObject jsonObject = array.getJSONObject(i);

String name = jsonObject.getString("name");

String desc = jsonObject.getString("desc");

String p_w_picpathpath = jsonObject.getString("p_w_picpathpath");

RuanJian ruanJian = new RuanJian(name, desc, p_w_picpathpath);

SQLinsert(ruanJian);

ruanjian.add(ruanJian);

}

} catch (JSONException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

runOnUiThread(new  Runnable() {

public void run() {

myAdaper.notifyDataSetChanged();

}

}); return null;

}

private void SQldelete() {

       mdb.delete("student", null, null);

}

private void SQLinsert(RuanJian ruanjian) {

ContentValues values = new ContentValues();

values.put("name", ruanjian.name);

values.put("desc", ruanjian.desc);

values.put("p_w_picpathpath", ruanjian.p_w_picpathpath);

mdb.insert("student", null, values);

}

  

  }

class MyAsyncTask2 extends AsyncTask {

private ImageView p_w_picpathview;

    int position;

    String name;

public MyAsyncTask2(ImageView p_w_picpathview,int position,String name) {

this.p_w_picpathview = p_w_picpathview;

      this.position = position;

  this.name = name;

}

@Override

protected Bitmap doInBackground(String... params) {

Cursor cursor = mdb.query("student", null, "name = ?",new String[]{name}, null, null, null);

if (cursor.moveToFirst()) {

String p_w_picpath_path = cursor.getString(cursor.getColumnIndex("p_w_picpathpath"));

File file = new File(p_w_picpath_path);

try {

FileInputStream is = new FileInputStream(file);

Bitmap bitmap = BitmapFactory.decodeStream(is);

hashBit.put(params[0], bitmap);

return bitmap;

} catch (FileNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

Bitmap bitmap = null;

try {

URL url = new URL(params[0]);

URLConnection openConnection = url.openConnection();

openConnection.setConnectTimeout(3000);

openConnection.setReadTimeout(3000);

InputStream is = openConnection.getInputStream();

bitmap = BitmapFactory.decodeStream(is);

hashBit.put(params[0], bitmap);

//實現(xiàn)把圖片保存到sdcard中

//判斷sdcard是否可用

//得到保存圖片的上一級目錄,file.getparentFile

//bitmap.compress

int p_w_picpath_index = params[0].lastIndexOf("/");

String p_w_picpath_path = params[0].substring(p_w_picpath_index);

        if (bitmap!=null) {

         if (Environment.MEDIA_MOUNTED.equals(Environment.getExternalStorageState())) {

         String path = Environment.getExternalStorageDirectory().getPath() + "/p_w_picpaths/"+p_w_picpath_path;

         update(path,name);

         File file = new File(path);

         File file2 = file.getParentFile();

         if(!file2.exists())

         {

         file2.mkdirs();

         }

         FileOutputStream fos = new FileOutputStream(file);

         bitmap.compress(Bitmap.CompressFormat.PNG, 100, fos);

         }

}

} catch (MalformedURLException e) {

runOnUiThread(new Runnable() {

@Override

public void run() {

          chongshi.setText("讀取失敗2");

}

});

e.printStackTrace();

} catch (Exception e) {

          runOnUiThread(new Runnable() {

@Override

public void run() {

          chongshi.setText("網(wǎng)絡(luò)連接異常2");

}

});

e.printStackTrace();

}

return bitmap;

}

private void update(String path,String name) {

Log.e("========name========", name+","+path);

ContentValues values = new ContentValues();

values.put("p_w_picpathpath", path);

mdb.update("student", values , "name =?", new String[]{name});

}

@Override

protected void onPostExecute(Bitmap result) {

if (listview.getFirstVisiblePosition()<=position &&listview.getLastVisiblePosition()>=position)

{

p_w_picpathview.setImageBitmap(result);

}

progressbar.setVisibility(ProgressBar.GONE);

chongshi.setVisibility(EditText.GONE);

super.onPostExecute(result);

}

}

class MyAdaper extends BaseAdapter {

@Override

public int getCount() {

// TODO Auto-generated method stub

return ruanjian.size();

}

@Override

public Object getItem(int position) {

// TODO Auto-generated method stub

return null;

}

@Override

public long getItemId(int position) {

// TODO Auto-generated method stub

return 0;

}

@Override

public View getView(int position, View convertView, ViewGroup parent) {

RuanJian ruanJian2 = ruanjian.get(position);

LayoutInflater layoutInflater = getLayoutInflater();

View inflate = null;

User user = new User();

if (convertView==null) {

inflate = layoutInflater.inflate(R.layout.itemp, null);

user.p_w_picpathview = (ImageView) inflate.findViewById(R.id.p_w_picpathView1);

user.et1 = (EditText) inflate.findViewById(R.id.editText1);

user.et2 = (EditText) inflate.findViewById(R.id.editText2);

inflate.setTag(user);

}else

{

inflate = convertView;

user = (User)inflate.getTag();

}

user.et1.setText(ruanJian2.name);

user.et2.setText(ruanJian2.desc);

user.p_w_picpathview.setImageResource(R.drawable.ic_launcher);

Bitmap bitmap = hashBit.get(ruanJian2.p_w_picpathpath);

if (bitmap == null) {

MyAsyncTask2 task2 = myasync.get(ruanJian2.p_w_picpathpath);

if(task2==null)

{

task2 = new MyAsyncTask2(user.p_w_picpathview,position,ruanJian2.name);

  myasync.put(ruanJian2.p_w_picpathpath, task2);

  task2.execute(ruanJian2.p_w_picpathpath);

}

}else

{

user.p_w_picpathview.setImageBitmap(bitmap);

}

return inflate;

}

}

  class User

  {

   ImageView p_w_picpathview;

   EditText et1;

   EditText et2;

  }

@Override

public boolean onCreateOptionsMenu(Menu menu) {

getMenuInflater().inflate(R.menu.main, menu);

return true;

}

@Override

public void onClick(View v) {

switch (v.getId()) {

case R.id.button1:

btn_01();

break;

default:

break;

}

}

private void btn_01() {

      download();

      button.setVisibility(Button.INVISIBLE);

      progressbar.setVisibility(ProgressBar.VISIBLE);

      chongshi.setText("正在加載");

}

}

另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)scvps.cn，海內(nèi)外云服務(wù)器15元起步，三天無理由+7*72小時售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡單易用、服務(wù)可用性高、性價比高”等特點與優(yōu)勢，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應(yīng)用場景需求。

文章標(biāo)題：JSON_SQLite_Listview06-17-創(chuàng)新互聯(lián)
分享地址：http://weahome.cn/article/csieie.html