Counter servlet
$30-100 USD
Pagado a la entrega
A simple counter servlet
Technology : Implemented in Java/Tomcat (V5)
Result : a war file
A simple servlet which use a pool of connection (parameters defined in servlet initialization context)
Read parameters :
String id = [url removed, login to view]("i");
String oper = [url removed, login to view]("o");
String host = [url removed, login to view]("h");
String res = [url removed, login to view]("r");
redirect the url (trace log in logger [specific logger by oper]):
if ([url removed, login to view]("http://")) url = res;
else url = "http://" + host + "/res/" + res;
[url removed, login to view]("redirect id: " + id + " oper " + oper + " url " + url);
[url removed, login to view](url); // when here no error return
then add a counter
String values = "'', '" + id + "', '" + res + "', '" + new Date() + "'"; // first value is auto-incremented ky
String sql = "INSERT INTO `" + oper + "` VALUES(" + values + ")";
log error et create database if not already existing (1 database per oper)
CREATE TABLE [url removed, login to view] (
`key` int( 4 ) NOT NULL AUTO_INCREMENT ,
`id` varchar( 20 ) NOT NULL default '',
`res` varchar( 50 ) NOT NULL default '',
`date` date NOT NULL default '0000-00-00',
PRIMARY KEY ( `key` )
) TYPE = MYISAM ;
Where project name is defined from another table form the oper value.
All catching exception and alert should be taken in account.
Nº del proyecto: #32252