October 30, 2017

Adding google map to Java Server Page to show the location of your business

Adding google map with markers in to website

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<head>
<title>Branch Details</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<link rel="stylesheet" type="text/css" href="../CSS/branchForm.css"/>
<link href="CSS/jquery-ui.css" rel="stylesheet">
<script type="text/javascript" src="JS/jquery.ui.datepicker.js"></script>
<script src="https://maps.googleapis.com/maps/api/js?callback=initMap" async defer></script>
<link href="CSS/style.css" rel="stylesheet">

<script>
$(function() {
$( "#datepicker" ).datepicker();
});
</script>

</head>
<body>
<form action="" class="register">

<fieldset class="row2">

<legend>Branch Details
</legend>

<p>
<label>Name
</label>
<input type="text"/>
</p>

<p>
<label>Firm Code
</label>
<input type="text"/>
</p>

<p>
<label>Category
</label>
<input type="text"/>
</p>

<p>
<label>Constituency
</label>
<input type="text"/>

</p>

<p>
<label>Address *
</label>
<input type="text" class="long"/>
</p>
<p>
<label>Location *
</label>
<input type="text" id="pac-Input" placeholder ="Enter your location" />
</p>

<p>
<label>City *
</label>
<input type="text" class="long" id="cityTxt"/>
</p>

<p>
<label>Inauguration Date *
</label>
<input type="text" maxlength="10" id="datepicker"/>
</p>
<p>
<label>Lat *
</label>
<input type="text" maxlength="2" id="latBox" />
</p>
<p>
<label>Lon *
</label>
<input type="text" maxlength="2" id="lngBox" />
</p>

<p>
<label class="optional">Website
</label>
<input class="long" type="text" value="http://"/>

</p>
</fieldset>
<fieldset class="row3">
<legend>Branch Location
</legend>


<div id="map"></div>
<script>
function initMap() {
var mapDiv = document.getElementById('map');

var map = new google.maps.Map(mapDiv, {
center: {lat: 11.253069, lng: 75.78281},
zoom: 12
});

var marker = new google.maps.Marker({
position: {lat: 11.253069, lng: 75.78281},
map: map,
title: 'Triveni location',
draggable: true
});

var locationInput = document.getElementById('pac-Input');

google.maps.event.addListener(marker, 'dragend', function (event) {
document.getElementById("latBox").value = this.getPosition().lat();
document.getElementById("lngBox").value = this.getPosition().lng();
//document.getElementById("cityTxt").value = locationInput;
});

var autocomplete = new google.maps.places.Autocomplete(locationInput);
autocomplete.bindTo('bounds', map);

var infowindow = new google.maps.InfoWindow();

autocomplete.addListener('place_changed', function() {
alert(" autocomplete add listener ");

infowindow.close();
//marker.setVisible(false);
var place = autocomplete.getPlace();
if (!place.geometry) {
window.alert("Autocomplete's returned place contains no geometry");
return;
}

var address = '';
if (place.address_components) {
address = [
(place.address_components[0] && place.address_components[0].short_name || ''),
(place.address_components[1] && place.address_components[1].short_name || ''),
(place.address_components[2] && place.address_components[2].short_name || '')
].join(' ');
}

infowindow.setContent('<div><strong>' + place.name + '</strong><br>' + address);
infowindow.open(map, marker);

});

//});
/*
var input = document.getElementById('pacInput');
var searchBox = new google.maps.places.SearchBox(input);
map.controls[google.maps.ControlPosition.TOP_LEFT].push(input);

searchBox.addListener('places_changed', function() {
var places = searchBox.getPlaces();

if (places.length == 0) {
return;
}
*/

}
</script>


</fieldset>
<fieldset class="row4">
<legend> blah blah blah...
</legend>
<p class="agreement">
<input type="checkbox" value=""/>
<label>* Is the <a href="#">unit currently working</a></label>
</p>

</fieldset>
<div><button class="button">Register »</button></div>
</form>
</body>
</html>

How to enable database cache in my java application

https://stackoverflow.com/questions/47004240/how-to-enable-database-cache-in-my-java-application

October 26, 2017

Sample Mysql Trigger on product inventory

Sample Mysql Trigger on product inventory

DELIMITER $$

DROP TRIGGER /*!50032 IF EXISTS */ `db_inventory_datacom`.`UpdateInventoryOnSalesReturn`$$

CREATE
/*!50017 DEFINER = 'root'@'localhost' */
TRIGGER `UpdateInventoryOnSalesReturn` AFTER INSERT ON `tbl_prdt_sales_returns`
FOR EACH ROW begin
update tbl_inventories set prod_quantity=(prod_quantity + new.prdt_quantity),prod_reorder_date=curdate() where prod_id=new.prod_id;
END;
$$

DELIMITER ;

The event triggers when ever a new row is inserted in the table `tbl_prdt_sales_returns`.

The trigger will update the table tbl_inventories product quantity .

October 22, 2017

Real Time Currency Converter in java - Webservice

Currency Converter API (xe.com)

Description

some time instead of keeping currency rate converter static data in your local database is not at all feasible for your project. Yahoo is providing a free web sevices for currency rate converter similar to google xe.com. The below code will return the currency converting ratio

import java.io.IOException;

import org.apache.commons.httpclient.DefaultHttpMethodRetryHandler;
import org.apache.commons.httpclient.HttpClient;
import org.apache.commons.httpclient.HttpException;
import org.apache.commons.httpclient.HttpMethod;
import org.apache.commons.httpclient.methods.GetMethod;
import org.apache.commons.httpclient.params.HttpMethodParams;

/**
*
*/

/**
* @author currency conversion
*
*/
public class DCSCurrencyConvertor {

/**
* @param args
* @throws IOException
* @throws HttpException
*/
public static void main(String[] args) {
// TODO Auto-generated method stub;

DCSCurrencyConvertor convertor = new DCSCurrencyConvertor();
try {
String rate = convertor.convert("USD","AED");
System.out.println("USD to AED :"+rate);
} catch (HttpException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}

private String convert(String currencyFrom, String currencyTo) throws HttpException, IOException {
String currentRate = null;
HttpClient client = new HttpClient();
HttpMethod method = new GetMethod("http://quote.yahoo.com/d/quotes.csv?s=" + currencyFrom + currencyTo + "=X&f=l1&e=.csv");
method.getParams().setParameter(HttpMethodParams.RETRY_HANDLER,
new DefaultHttpMethodRetryHandler(3, false));
int status = client.executeMethod(method);
System.out.println("status : "+status);

byte[] response = method.getResponseBody();
currentRate =new String(response);

return currentRate;
}

}

Jar files (Application Programming Interface)

commons-httpclient-3.1.jar
commons-codec-1.11.jar

Uri (Uniform Resource locator )

http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.xchange%20where%20pair%20in%20(%22USDEUR%22,%20%22USDJPY%22,%20%22USDBGN%22,%20%22USDCZK%22,%20%22USDDKK%22,%20%22USDGBP%22,%20%22USDHUF%22,%20%22USDLTL%22,%20%22USDLVL%22,%20%22USDPLN%22,%20%22USDRON%22,%20%22USDSEK%22,%20%22USDCHF%22,%20%22USDNOK%22,%20%22USDHRK%22,%20%22USDRUB%22,%20%22USDTRY%22,%20%22USDAUD%22,%20%22USDBRL%22,%20%22USDCAD%22,%20%22USDCNY%22,%20%22USDHKD%22,%20%22USDIDR%22,%20%22USDILS%22,%20%22USDINR%22,%20%22USDKRW%22,%20%22USDMXN%22,%20%22USDMYR%22,%20%22USDNZD%22,%20%22USDPHP%22,%20%22USDSGD%22,%20%22USDTHB%22,%20%22USDZAR%22,%20%22USDISK%22)&env=store://datatables.org/alltableswithkeys

Thanks to steffi for her support

October 19, 2017

Java Real Time currency convertor

import java.io.IOException;

/**
*
*/

/**
* @author belazy
*
*/
public class CurrencyConvertor {

public float convert(String currencyFrom, String currencyTo) throws IOException {
HttpClient httpclient = new DefaultHttpClient();
HttpGet httpGet = new HttpGet("http://quote.yahoo.com/d/quotes.csv?s=" + currencyFrom + currencyTo + "=X&f=l1&e=.csv");
ResponseHandler<String> responseHandler = new BasicResponseHandler();
String responseBody = httpclient.execute(httpGet, responseHandler);
httpclient.getConnectionManager().shutdown();
return Float.parseFloat(responseBody);
}

/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub

CurrencyConvertor cc = new CurrencyConvertor();
try {
float current = cc.convert("USD", "AED");
System.out.println(current);
}
catch (Exception e) {
e.printStackTrace();
}

}

}

October 17, 2017

Find Mean Mode and Median in Java : Introduction to Data Science

import java.util.Arrays;

/**
* Introduction to Data science
* Finding Mean Mode and Median
*/

/**
* @author belazy
* Consumerfed triveni supermarket kozhikode
*
*/
public class DataScienceLessonOne {

Integer[] arraySample = {4,5,3,3,5,6,7,3,1,5};

/**
* @param args
*/
public static void main(String[] args) {

DataScienceLessonOne dataScience = new DataScienceLessonOne();
System.out.println(dataScience.findMean());
System.out.println(dataScience.findMedian());
System.out.println(dataScience.findMode());

}

private char[] findMode() {
// TODO Auto-generated method stub
return null;
}

private float findMedian() {
// TODO Auto-generated method stub
float median = 0;
Arrays.sort(arraySample);

median = (arraySample.length % 2) == 0 ? (arraySample[arraySample.length/2]+arraySample[(arraySample.length/2)-1])/2 :arraySample[arraySample.length/2];

return median;
}

private float findMean() {
int sum = 0;
float mean = 0;
for(int a:arraySample){
sum = sum +a;
mean = sum/arraySample.length;
}
return mean;
}

}

October 09, 2017

Bithesh Information Manager K S C C F Ltd Kozhikode regional office

Consumerfed Regional office kozhikode Region IT Section

സീസണൽ റിപ്പോർട്

റിപ്പോർട് മൊബൈൽ ലഭിക്കുവാൻ സബ്സ്ക്രൈബ് ചെയുക

സീസണൽ റിപ്പോർട്

Thanks to +Consumerfed IT Division +Consumerfed +deepajayaprakash payyanakkal for their supports

Downloads

Regional Office Kozhikode

October 03, 2017

Collection list to simple Array convert in java

/**
* Sample java programs
*/
package com.belazy.misc;

import java.util.ArrayList;
import java.util.List;

/**
* @author belazy
*
*/
public class SampleArrays {

/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub

List<Integer> sampleList = new ArrayList<Integer>();

for(int i=0;i<=10;i++){
sampleList.add(i);
}

/**
* Arrays
*/
Integer[] a= new Integer[sampleList.size()];
a= sampleList.toArray(a);
System.out.println("5 th element in the array "+a[5]);

}

}

A small description

Arrays are treated as object in JVM
Type of array - The elementType has to specified (say Integer)
The size of the array should be on the stack before the operation is performed
Example :-
Int[] javaArraySample = new int [12];

Pages

October 30, 2017

Adding google map to Java Server Page to show the location of your business

Adding google map with markers in to website

October 26, 2017

Sample Mysql Trigger on product inventory

October 22, 2017

Real Time Currency Converter in java - Webservice

Currency Converter API (xe.com)

Description

Jar files (Application Programming Interface)

Uri (Uniform Resource locator )

October 19, 2017

Java Real Time currency convertor

October 17, 2017

Find Mean Mode and Median in Java : Introduction to Data Science

October 09, 2017

Bithesh Information Manager K S C C F Ltd Kozhikode regional office

Consumerfed Regional office kozhikode Region IT Section

സീസണൽ റിപ്പോർട്

സീസണൽ റിപ്പോർട്

Downloads

Regional Office Kozhikode

October 03, 2017

Collection list to simple Array convert in java

Facebook comments