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;
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
显示全部