Financial Year Table

Im trying to design a financial year table...wherein the user enters the data in the table and the same is updated in backend.i have successfully desinged the page but i have certain doubts in jsp code.the table is as follows:

MS_target HSD_Target ALPG_Target Lubes_target
april
May
June
July
August
September
october
november
december
january
february
march

The HTML code is fine but im confused on to the JSP part as using an array is not possible.
I have tried using the hastable by creating a hashmap for all the months.

is it fine to use hashmap...or else kindly suggest me to some alternative.I have given names for all fields separately(eg:aprMS,aprHSD,mayMS,mayHSD).also suugest me a code on how to iterate through all the fields.

HashMap april= new HashMap();
april.put("aprMS",new Integer(1));
april.put("aprHSD",new Integer(2));
april.put("aprALPG",new Integer(3));
april.put("aprLubes",new Integer(4));

Like wise i have created hashmap for all months.but i have doubts on how to read the hashmap data and insert the same in database. Kindly help

The HTML code is fine but im confused on to the JSP part as using an array is not possible.
I have tried using the hastable by creating a hashmap for all the months.

is it fine to use hashmap...or else kindly suggest me to some alternative.I have given names for all fields separately(eg:aprMS,aprHSD,mayMS,mayHSD).also suugest me a code on how to iterate through all the fields.

You can use any of the collection and set them in request scope through Servlet and then dispatch the request to JSP page. You can then access/iterate these collections through JSTL tags.

hashmap for all months.but i have doubts on how to read the hashmap data and insert the same in database. Kindly help

You can submit the form to a Servlet and get the values submitted through request.getParameter(" ") .

Can you give me an example for the former part.....i got the later part.....im a new bie...kindly help....thnanks in advance

There are plenty of previous examples of iterating through a collection in a JSP in the forum. Search for <c:forEach>

Thanks for your help(piyush and Bear).As i am a new bie to jsp i understand what you explain but i am finding it difficult to put on code.To get a better picture i would like to explain my project..My project is to design a financial year table where the months are placed on Y axis and The targets are placed on X axis.now the user enters the target details.eg MS_target for the month of april.like wise the target for every field is entered.If suppose the user enters the data for april and clicks on submit the same is updated in table.If after a month the user logs in to enter the details for remaining months the previous data entered should reflect in my page and user can continue entering data for remaining months.

try{
straprMS = request.getParameter("aprMS");
straprHSD = request.getParameter("aprHSD");
straprAlpg = request.getParameter("aprAlpg");
straprLubes = request.getParameter("aprLubes");

strmayMS = request.getParameter("mayMS");
strmayHSD = request.getParameter("mayHSD");
strmayAlpg = request.getParameter("mayAlpg");
strmayLubes = request.getParameter("mayLubes");

HashMap <String,Integer> april= new HashMap <String,Integer>();
		
	april.put("aprMS",new Integer(1));
	april.put("aprHSD",new Integer(2));
	april.put("aprAlpg",new Integer(3));
	may.put("mayLubes",new Integer(4));

HashMap <String, Integer> may= new HashMap <String, Integer>();
	
	may.put("mayMS",new Integer(1));
	may.put("mayHSD",new Integer(2));
	may.put("mayAlpg",new Integer(3));
	may.put("mayLubes",new Integer(4));

catch( BatchUpdateException be)
{

int[] counts = be.getUpdateCounts();
	for(int i=0; i<counts.length;i++)
{
	System.out.println("Statement["+i+"]:"+counts[i]);
}

strUpdateFlag= "false";
conn.rollback();
be.printStackTrace();

}

catch(Exception ex)
{
	strUpdateFlag = "false";
	conn.rollback();
	ex.printStackTrace();
}

finally
{
if(pstmt!= null)pstmt.close();
}
}

<html>
<head>
<Title>Enter Target details</Title>
<style type="text/css">
td{font-family: sans-serif;font-size:12px}
th{font-family: sans-serif;color:white;font-size:12px}

function validateText(param)

{
var a=(event.keyCode);	//String.fromCharCode
	//alert(a);

if(param==1)
	{
		if( ((a>=65)&&(a<=90))||((a>=97)&&(a<=122))||(a==46)||(a==32))
		{
		return true;
		}

else
		{
			alert("Only alphabets and space allowed.");
			return false;
		}
	}

else if(param==2)
		{

if((a>=48)&&(a<=57)||(a==46))
			{
				return true;

}

else
			{
				alert("Only numbers allowed in this field.");

return false;

}
		}
	}

function submitData()
{
var flag;
		var frm = eval(document.manualTargetEntryForm);
if(flag == true)
	{
		document.manualTargetEntryForm.actionP.value="u";
		document.manualTargetEntryForm.method="POST";
		document.manualTargetEntryForm.action="TargetSales.jsp";
		document.manualTargetEntryForm.submit();
	}

}

</script>

</head>

<tr>

<label for="financial year" class="required"><B>Financial Year</B></label>
												<select id="financial year" name="financial year" size="1" >
													<option value="1">2011-2012</option>
													<option value="2">2012-2013</option>
													<option value="3">2013-2014</option>
													<option value="4">2014-2015</option>
													<option value="5">2015-2016</option>
												</select>

</tr>
</table>

<thead>

<% String strMsg="";
	if(!strUpdateFlag.equals(""))
{
	if(strUpdateFlag.equals("true"))
	strMsg="Data Updated Successfully.";
	else if(strUpdateFlag.equals("false"))
	strMsg="Error: Data not Updated.";

%>

</tr>

<%

}
%>

<tr bgcolor="#CCCCFF">
<td class="bAppTableColSubhead" colspan="15" rowspan="2">
<font size="+1"><b>TARGET DETAILS</b></font>

</td>

<tr bgcolor="#8B8989" class="colsubtitle">
<th align ="center" rowspan="2">Month</th>

<th align ="center" rowspan="2">MS<BR>Target</th>
<th align ="center" rowspan="2">HSD<BR>Target</th>
<th align ="center" rowspan="2">ALPG<BR>Target</th>
<th align ="center" rowspan="2">Lubes<BR>Target</th>

<tr><td>April</td><td><input type="text" name="aprMS" value="<%=straprMS%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="aprHSD" value="<%=straprHSD%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="aprAlpg" value="<%=straprAlpg%>" maxlength="6"  onKeyPress="return validateText(2);"/></td><td><input type="text" name="aprLubes" value="<%=straprLubes%>" maxlength="6" onKeyPress="return validateText(2);"/></td> 
<tr><td>May</td><td><input type="text" name="mayMS" value="<%=strmayMS%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="mayHSD" value="<%=strmayHSD%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="mayAlpg" value="<%=strmayAlpg%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="mayLubes" value="<%=strmayLubes%>" maxlength="6" onKeyPress="return validateText(2);"/></td>
<tr><td>June</td><td><input type="text" name="junMS" value="<%=strjunMS%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="junHSD" value="<%=strjunHSD%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="junAlpg" value="<%=strjunAlpg%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="junLubes" value="<%=strjunLubes%>" maxlength="6" onKeyPress="return validateText(2);"/></td>
<tr><td>July</td><td><input type="text" name="julMS" value="<%=strjulMS%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="julHSD" value="<%=strjulHSD%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="julAlpg" value="<%=strjulAlpg%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="julLubes" value="<%=strjulLubes%>" maxlength="6" onKeyPress="return validateText(2);"/></td>
<tr><td>August</td><td><input type="text" name="augMS" value="<%=straugMS%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="augHSD" value="<%=straugHSD%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="augAlpg" value="<%=straugAlpg%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="augLubes" value="<%=straugLubes%>" maxlength="6" onKeyPress="return validateText(2);"/></td>
<tr><td>September</td><td><input type="text" name="sepMS" value="<%=strsepMS%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="sepHSD" value="<%=strsepHSD%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="sepAlpg" value="<%=strsepAlpg%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="sepLubes" value="<%=strsepLubes%>" maxlength="6" onKeyPress="return validateText(2);"/></td>
<tr><td>October</td><td><input type="text" name="octMS" value="<%=stroctMS%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="octHSD" value="<%=stroctHSD%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="octAlpg" value="<%=stroctAlpg%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="octLubes" value="<%=stroctLubes%>" maxlength="6" onKeyPress="return validateText(2);"/></td>
<tr><td>November</td><td><input type="text" name="novMS" value="<%=strnovMS%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="novHSD" value="<%=strnovHSD%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="novAlpg" value="<%=strnovAlpg%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="novLubes" value="<%=strnovLubes%>" maxlength="6" onKeyPress="return validateText(2);"/></td>
<tr><td>December</td><td><input type="text" name="decMS" value="<%=strdecMS%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="decHSD" value="<%=strdecHSD%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="decAlpg" value="<%=strdecAlpg%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="decLubes" value="<%=strdecLubes%>" maxlength="6" onKeyPress="return validateText(2);"/></td>
<td>January</td><td><input type="text" name="janMS" value="<%=strjanMS%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="janHSD" value="<%=strjanHSD%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="janAlpg" value="<%=strjanAlpg%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="janLubes" maxlength="6" value="<%=strjanLubes%>" onKeyPress="return validateText(2);"/></td><td>
<tr><td>February</td><td><input type="text" name="febMS" value="<%=strfebMS%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="febHSD"  value="<%=strfebHSD%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="febAlpg" value="<%=strfebAlpg%>" maxlength="6"  onKeyPress="return validateText(2);"/></td><td><input type="text" name="febLubes" value="<%=strfebLubes%>" maxlength="6" onKeyPress="return validateText(2);"/></td>
<tr><td>March</td><td><input type="text" name="marMS" value="<%=strmarMS%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="marHSD" value="<%=strmarHSD%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="marAlpg" value="<%=strmarAlpg%>" maxlength="6" onKeyPress="return validateText(2);"/></td><td><input type="text" name="marLubes" value="<%=strmarLubes%>" maxlength="6" onKeyPress="return validateText(2);"/></td>

<%

}
catch(Exception ce)
{
System.out.println("Error:" +ce);
}
finally
{
	try
	{
	if(rs!=null)rs.close();
	//if(stmt!=null)stmt.close();
	if(conn!=null)conn.close();
	//out.println("conn.close()");

}
	catch(Exception e)
	{
	out.println("Exception -New:"+e);
	}

}

%>
		</TBODY>
		</table>
	</form>
	</body>

</html>

I have managed to put in the code.....kindly help in editing the same.

i am srry....i do understand that i jst had to zero in on the code which is not proper....but what i meant was to show you the entrie code so as to what changes could be made to the entire code

How do i go ahead to iterate the data and insert the same in the database?

Database? I thought you were asking about how to display the data via a JSP?

My primary concern is to store the details in the database entered by the user in my jsp....please help me with an example on how to do the same.....

If you're looking for an example of how to insert data into a database, then choosing to ask that question in the JSP forum was a bad choice. You shouldn't even have code in a JSP which works with a database, that's a job for the servlet which acts as its controller.

But anyway, an example of inserting data into a database: I'm sure you should find an example in Oracle's JDBC tutorial.