Android手机客户端通过JSP实现与Tomcat服务器端通信（Msql数据库，Json作为载体）--服务端代码

android_zhang

浏览: 542822 次
性别:
来自: 北京

最近访客更多访客>>

ofbiz

lhy_0621

u011171464

水煮青蛙

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

博客分类：

jsp Ajax

工程结构图：
[img]

[/img]

运行效果图：
浏览器输入：http://localhost:8080/test1/myJson.jsp
[img]

[/img]

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[i]);
		// }
		// System.out.println(str.length);
	}

}