Installation guide

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