android通信 jsp(json mysql).doc

android 通信 JSP(json mysql) Android 手机客户端通过 JSP 实现与 Tomcat 服务器端通信( Msql 数据库, Json 作为载体) 服务器端主要代码: 1. 首先构建一个 Person 类,用来保存用户信息 public class Person private String name; private String address; private Integer age; public Person() { super(); } public Person(String name, String address, Integer age) { super(); = name; = address; = age; } public String getName() { return name; } public void setName(String name) { = name; } public String getAddress() { return address; } public void setAddress(String address) { = address; } public Integer getAge() { return age; } public void setAge(Integer age) { = age; }} 2. 服务器端的 service 类 import ; import .*; import .*; public class JsonService { public static List<Person> getListPerson(){ String a,b,allString = ""; int c= 0; List<Person> mLists = new ArrayList<Person>(); // List<Person> mLists = new ArrayList<Person>(); // (new Person(" 临风"," 北京", 20)); (mLists); try { ("");// 链接数据库 Connection conn = ( "jdbc:mysql://:3306/json", "root" , "123456"); Statement stmt = (); ResultSet rs= ("select * from people");// 遍历数据库 Person p= null; while(()) { ((1) + "\t" + (2) + "\t" + (3)); a= (1); b= (2); c= (3); (new Person(a, b, c));// 添加到 List 中} (mLists); }catch(Exception e){ (e); (); return mLists; } // finally{ // return mLists; //} (mLists); return mLists; } // 测试用主函数 public static void main(String[] args) throws Exception { String str[] = null; JsonService con = new JsonService(); List<Person> temp = (); // (temp.); // str = (" "); // for(int i=0;i< ; i++){ // (str[i]); /