Android手机客户端通过JSP实现与Tomcat服务器端通信（Msql数据库，Json作为载体）--服务端代码
工程结构图：运行效果图：
浏览器输入：http://localhost:8080/test1/myJson.jsp
package com.json.servlet;
import java.util.ArrayList;
import java.util.List;
public class Person {
private String name;
private String address;
private Integer age;
private List<Student> list = new ArrayList<Student>();
public Person() {
super();
}
public Person(String name, String address, Integer age) {
super();
this.name = name;
this.address = address;
this.age = age;
}
public String getName() {
return name;
}
public void setName(String name) {
this.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;
}
public List<Student> getList() {
return list;
}
public void setList(List<Student> list) {
this.list = list;
}
}
package com.json.servlet;
public class Student {
private String name;
private int age;
private String school;
public Student(){
super();
}
public Student(String name,String school,int age){
this.name = name;
this.school = school;
this.age = age;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public String getSchool() {
return school;
}
public void setSchool(String school) {
this.school = school;
}
}
package com.json.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.google.gson.Gson;
public class JsonServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
secondMethod(request,response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
// ======第一种方法============
public void firstMethod(HttpServletRequest request,
HttpServletResponse response) {
response.setContentType("text/html");
response.setCharacterEncoding("UTF-8");
try {
PrintWriter out = response.getWriter();
// List<Person> persons = JsonService.getListPerson();//
// 返回JsonService的数据
List<Person> persons = new ArrayList<Person>();
for (int i = 0; i < 5; i++) {
Person p = new Person("张" + i + "号", "北京" + i + "号", i);
persons.add(p);
}
StringBuffer sb = new StringBuffer();// 数据缓存
sb.append('[');
for (Person person : persons) {// person.getName(),person.getAddress()获得姓名，地址，一些符号转换为char
// 锁定输出=> {"name":"姓名","address":"地址","age":年龄},
sb.append('{').append("\"name\":").append(
"\"" + person.getName() + "\"").append(",");
sb.append("\"address\":").append(
"\"" + person.getAddress() + "\"").append(",");
sb.append("\"age\":").append(person.getAge());
sb.append('}').append(",");
}
sb.deleteCharAt(sb.length() - 1);
sb.append(']');
out.write(new String(sb));
out.flush();
out.close();// 关闭
} catch (Exception e) {
System.out.println(e);
e.printStackTrace();
}
}
// ======第二种方法============
public void secondMethod(HttpServletRequest request,
HttpServletResponse response) {
// 设置编码格式
response.setContentType("application/json;charset=utf-8");
response.setHeader("pargma", "no-cache");
response.setHeader("cache-control", "no-cache");
PrintWriter out = null;
try {
out = response.getWriter();
List<Person> persons = new ArrayList<Person>();
for (int i = 0; i < 5; i++) {
Person p = new Person("张小胖" + i + "号", "北京昌平区" + i + "号", i);
List<Student> list = new ArrayList<Student>();
for(int j = 0;j<2;j++){
Student mStudent = new Student("无敌小和尚","清华大学",20);
list.add(mStudent);
}
p.setList(list);
persons.add(p);
}
Gson gson = new Gson();
String reslut = gson.toJson(persons);
System.out.println("reslut:" + reslut);
out.println(reslut);
out.flush();
out.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
注意：
<一>
导包： 记得在WebRoot/WEB-INF/lib里面 放入 gson-1.6.jar
<二>
整个工程要放在tomcat下：
我的是：E:\save\My_eclipse\apache-tomcat-5.5.20\conf\server.xml
打开这个server.xml 文件 添加：
<Context path="/test1" docBase="E:\MyEclipse8.6_workspace\test1\WebRoot" reloadable="true" />
看清楚位置：
<Context path="/test1" docBase="E:\MyEclipse8.6_workspace\test1\WebRoot" reloadable="true" />
</Host>
</Engine>
</Service>
</Server>
<三>
在WebRoot/WEB-INF/web.xml里面添加JsonServlet的声明，请看的我实例：
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5"
xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
<servlet>
<servlet-name>JsonServlet</servlet-name>
<servlet-class>com.json.servlet.JsonServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>JsonServlet</servlet-name>
<url-pattern>/myJson.jsp</url-pattern>
</servlet-mapping>
</web-app>
如果是从mysql数据库中读取数据然会的话，需要下面这个类：
package com.json.servlet;
import java.io.PrintWriter;
import java.sql.*;
import java.util.*;
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>();
// mLists.add(new Person("临风", "北京", 20));
System.out.println(mLists);
try {
Class.forName("com.mysql.jdbc.Driver");// 链接数据库
Connection conn = DriverManager.getConnection(
"jdbc:mysql://127.0.0.1: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();
List<Person> temp = con.getListPerson();
// System.out.println(temp.);
// str = temp.split(" ");
// for(int i = 0 ; i < str.length ; i++){
// System.out.println(str);
// }
// System.out.println(str.length);
}
}
页:
[1]