android json servlet mysql_用HTML设计android客户端连接远程服务器传递数据(JSON+SERVLET+MYSQL)...

Android客户端用HTML设计界面，用js给页面插入数据，客户端连接远程服务器上的servlet，通过json传递数据。

远程服务器上servlet：

package com.qider.servlet;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import net.sf.json.JSONArray;

import net.sf.json.JSONObject;

import com.qider.sql.MysqlUtil;

public class MyServlet extends HttpServlet {

private static final long serialVersionUID = 1L;

public MyServlet() {

super();

}

public void destroy() {

super.destroy();

}

public void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

this.doPost(request, response);

}

public void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

response.setContentType("text/html;charset=GBK");

PrintWriter out = response.getWriter();

//DataBean db=new DataBean();