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

工程结构图:
[img]
[img]http://dl.iteye.com/upload/attachment/0077/0475/a5ec2ea4-cf53-3a5c-bc2b-70c691b1ee47.jpg[/img]
[/img]

运行效果图:
浏览器输入:http://localhost:8080/test1/myJson.jsp
[img]
[img]http://dl.iteye.com/upload/attachment/0077/0479/cefd694f-a8b2-359e-8900-0942aa1b39e6.jpg[/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);
}

}
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值