Eclipse Mobile Mousw Guía de instalación descargar pdf (Pagina 38)

{

Location location = new Location();

location.getLocation(request, response);

}//end of if location

}

/**

* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

// TODO Auto-generated method stub

doGet(request, response);

}

Appendix-4

package com.demo.mobile;

import java.io.DataOutputStream;

import java.io.IOException;

import java.sql.ResultSet;

import java.sql.Statement;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

public class Location

{

private Connection connect = null;

public void getLocation(HttpServletRequest request, HttpServletResponse response) throws IOException

{

// get the username and password

String username = request.getParameter("username");

String password = request.getParameter("password");

String longitude = request.getParameter("lon");

String latitude = request.getParameter("lat");

double lon = Double.parseDouble(longitude);

double lat = Double.parseDouble(latitude);

// connect to database to update wetherOnService column and clear locations

ConnDB conndb = new ConnDB();

// NOTE: string -> varchar for posrgresql query by using ''

String updateSQL = "update userinfor set reportlat = " + lat + ", reportlon = " + lon +

" where username='" + username + "' and passwords='" + password + "'";

// give feedback on whether can login or not for Android mobile

1 2 ... 33 34 35 36 37 38 39 40 41 42 43 ... 58 59

Sin comentarios

Eclipse Mobile Mousw Guía de instalación Pagina 38