文档详情

android通信 JSP(json mysql).doc

发布:2017-08-21约8.5千字共13页下载文档
文本预览下载声明
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; this.address = address; this.age = age; } public String getName() { return name; } public void setName(String name) { = name; } public String getAddress() { return address; } public void setAddress(String address) { this.address = address; } public Integer getAge() { return age; } public void setAge(Integer age) { this.age = age; } } 2.服务器端的service类 import java.io.PrintWriter; import java.sql.*; import java.util.*; public class JsonService { public static ListPerson getListPerson(){ String a,b,allString = ; int c = 0; ListPerson mLists = new ArrayListPerson(); // ListPerson mLists = new ArrayListPerson(); // mLists.add(new Person(临风, 北京, 20)); System.out.println(mLists); try { Class.forName(com.mysql.jdbc.Driver);//链接数据库 Connection conn = DriverManager.getConnection( jdbc:mysql://:3306/json, root , 123456); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(select * from people);//遍历数据库 Person p = null; while(rs.next()) { System.out.println(rs.getString(1) + \t + rs.getString(2) + \t + rs.getInt(3)); a = rs.getString(1); b = rs.getString(2); c = rs.getInt(3); mLists.add(new Person(a, b, c));//添加到List中 } System.out.println(mLists); }catch(Exception e){ System.out.println(e); e.printStackTrace(); return mLists; } // finally{ // return mLists; // } System.out.println(mLists); return mLists; } //测试用主函数 public static void main(String[] args) throws Exception { String str[] = null; JsonService con = new JsonService(); ListPerson temp
显示全部
相似文档