android之获取远程数据.doc

Android之从mysql数据库中获取数据下面是整体结构图数据库端创建数据库CREATE DATABASE user /*!40100 DEFAULT CHARACTER SET utf8 */;创建用户表CREATE TABLE users ( name char(30) NOT NULL, password char(30) NOT NULL, PRIMARY KEY (name) ENGINE=InnoDB DEFAULT CHARSET=utf8;插入数据insert into users(name,password) values(zhangsan,123456);insert into users(name,password) values(lisi,123456);insert into users(name,password) values(wangwu,123456);insert into users(name,password) values(zhaoliu,123456);insert into users(name,password) values(sunqi,123456);服务器端package com.jackie.fz;import java.io.IOException;import java.io.PrintWriter;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;public class Conn_mysql extends HttpServlet/* * */private static final long serialVersionUID = 1L;Connection conn=null;PreparedStatement state=null;ResultSet res=null;Overrideprotected void doGet(HttpServletRequest req, HttpServletResponse resp)throws ServletException, IOException try /加载驱动程序Class.forName(com.mysql.jdbc.Driver);/连接数据库conn=DriverManager.getConnection(jdbc:mysql:/:3306/user,root,310911);String sql=select* from users;state=conn.prepareStatement(sql);/查询数据res=state.executeQuery();/将取得的数据串成一个Json格式的字符串StringBuilder result=new StringBuilder();result.append();while(res.next()result.append(+name:+res.getString(name)+,);result.append(password:+res.getString(password)+,);/删除最后一个逗号result.deleteCharAt(result.length()-1);result.append();/设置响应编码resp.setContentType(text/html;charset=utf-8);/打印PrintWriter out=resp.getWriter();out.print(result.toString(); catch (Exception e) e.printStackTrace();Overrideprotected void doPost(HttpServletRequest req, HttpServletResponse resp)throws ServletException, IOException this.doGet(req, resp);Android客户端package com.example.conn_mysql;import java.io.IOException;import java.util.ArrayList;import java.util.List;import org.apache.http.HttpResponse;import org.apache.http.NameValuePair;import org.apache.http.ParseException;import org.apache.http.client.entity.UrlEncodedFormEntity;import org.apache.http.client.methods.HttpPost;import org.apache.http.impl.client.DefaultHttpClient;import org.apache.http.message.BasicNameValuePair;import org.apache.http.util.EntityUtils;import org.json.JSONArray;import org.json.JSONObject;import android.app.Activity;import android.os.Bundle;import android.os.StrictMode;import android.widget.TextView;public class MainActivity extends Activity /初始化private TextView tv;Overrideprotected void onCreate(Bundle savedInstanceState) super.onCreate(savedInstanceState);setContentView(R.layout.item);StrictMode.setThreadPolicy(new StrictMode.ThreadPolicy.Builder() .detectDiskReads().detectDiskWrites().detectNetwork() .penaltyLog().build(); StrictMode.setVmPolicy(new StrictMode.VmPolicy.Builder() .detectLeakedSqlLiteObjects().detectLeakedClosableObjects() .penaltyLog().penaltyDeath().build(); tv=(TextView) this.findViewById(R.id.tv_item);String json=null;try json = connecting(); catch (Exception e) e.printStackTrace();String result=pull(json);tv.setText(result);/向服务器发出请求获取数据protected String connecting()throws ParseException,IOExceptionString result=;List params=new ArrayList();params.add(new BasicNameValuePair(st,fd);/建立连接HttpPost request=new HttpPost(02:8080/FZ/conn);/设置字符集request.setEntity(new UrlEncodedFormEntity(params);/执行请求，获取响应HttpResponse response=new DefaultHttpClient().execute(request);if(response.getStatusLine().getStatusCode()=200)result=EntityUtils.toString(response.getEntity();return result;/解析Json格式字符串protected String pull(String json)StringBuilder users=new StringBuilder();try JSONArray jsonArray = new JSONArray(json);for (int i = 0; i jsonArray.length()