Hello to all,
I have a problem about NumberFormatExc eption and i m very sad because i m not able to solve this.
So please help.
The code is----------
and error is ----
java.lang.Numbe rFormatExceptio n: For input string: "20100819000001 "
Thanks in advance.
I have a problem about NumberFormatExc eption and i m very sad because i m not able to solve this.
So please help.
The code is----------
Code:
<code>
<%@page import="Connection.Connect" %>
<%@page import="java.sql.*" %> <%-- for SQL Statements--%>
<%@page import="java.util.*" %>
<%@page import="java.math.BigInteger"%>
<%@page import="java.math.*" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>credit report</title>
</head>
<body>
<form action="Logout.jsp" name="Submit" method="POST">
<table border="0" cellspacing="0" width="100%">
<tbody>
<tr>
<td><font size="8"><b>Automatic tailer System</b></font></td>
<td align="right"><input type="submit" value="LOGOUT" name="LGB" /></td>
</tr>
</tbody>
</table>
</form>
<div align="center" style=" background-color: black ">
<font color="white"><b>Employee ID : </b><%= session.getAttribute("ID") %> </font>
<font color="white"><b>Branch : </b> <%= session.getAttribute("branch") %></font>
</div>
<%
String ID2=session.getAttribute("ID2").toString().trim();
String name=session.getAttribute("name").toString().trim();
String am=request.getParameter("amount").trim();
int amt=Integer.parseInt(am);
String cred=request.getParameter("credited").trim();
try
{
Connection con3=null;
String statement3="Select * from MASTER where ID = '" + ID2 + "'";
Connect newconn3 = new Connect();
ResultSet result3=null;
Statement command3 = null;
con3 = newconn3.create();
command3 = con3.createStatement();
result3 = command3.executeQuery(statement3);
result3.next();
String IDreq = result3.getString("ID").trim();
String acc_t= result3.getString("ACCOUNT_TYPE").trim();
int tb=result3.getInt("TOTAL_BAL");
tb=tb+amt;
String Cr;
Connection con=null;
String getreq="SELECT MAX(TRAN_ID) FROM CREDIT";
Connect newconn = new Connect();
ResultSet result=null;
Statement command = null;
con = newconn.create();
command = con.createStatement();
result = command.executeQuery(getreq);
result.next();
String find = String.valueOf(result.getBigDecimal(1));
String nextreqcom="";
int request_id;
java.util.Date curr = new java.util.Date();
int cyear = curr.getYear()+1900;
int cdate = curr.getDate();
int cmonth = curr.getMonth()+1;
if((find.length()==4)||(find.equals(null)))
{
find="000001";
if(cmonth<10)
{
nextreqcom = cyear+"0"+cmonth+""+cdate+""+find;
}
if(cdate<10)
{
nextreqcom = cyear+""+cmonth+"0"+cdate+""+find;
}
if((cmonth<10)&&(cdate<10))
{
nextreqcom = cyear+"0"+cmonth+"0"+cdate+""+find;
}
request_id =Integer.parseInt((nextreqcom).trim());
// request_id = new BigInteger(nextreqcom);
}
else
{
int maxreq = Integer.parseInt(find.substring(8));
int nextreq=maxreq+1;
String chk = String.valueOf(nextreq);
String valuereq="";
switch(chk.length())
{
case 1 : valuereq = "00000"+nextreq;
break;
case 2 : valuereq = "0000"+nextreq;
break;
case 3 : valuereq = "000"+nextreq;
break;
case 4 : valuereq = "00"+nextreq;
break;
case 5 : valuereq = "0"+nextreq;
break;
case 6 : valuereq = ""+nextreq;
break;
}
if(cmonth<10)
{
nextreqcom = cyear+"0"+cmonth+""+cdate+""+valuereq;
}
if(cdate<10)
{
nextreqcom = cyear+""+cmonth+"0"+cdate+""+valuereq;
}
if((cmonth<10)&&(cdate<10))
{
nextreqcom = cyear+"0"+cmonth+"0"+cdate+""+valuereq;
}
request_id =Integer.parseInt((nextreqcom).trim());
// request_id = new BigInteger(nextreqcom);
}
java.util.Date ff = new java.util.Date();
int mm = ff.getMonth()+1;
int dd = ff.getDate();
int yyyy = ff.getYear()+1900;
String today = yyyy+"-"+mm+"-"+dd;
Connection con2 = newconn.create();
Statement command2 = con2.createStatement();
String insert = "INSERT INTO CREDIT(TRAN_ID,ID,NAME,ACCOUNT_TYPE,AMOUNT,CREDITED_BY,TOTAL_BAL,CURT,TRAN_TYPE) values('"+request_id+"','"+IDreq+"','"+name+"','"+acc_t+"','"+amt+"','"+cred+"','"+tb+"','"+today+"','Cr')";
int set = command2.executeUpdate(insert);
String show = "REQV"+request_id;
Connection con1=null;
con1 = newconn.create();
Statement command1 = con1.createStatement();
String update = "UPDATE MASTER SET TOTAL_BAL='"+tb+"' WHERE ID='"+IDreq+"'";
int set1 = command1.executeUpdate(update);
%>
<BR>
<fieldset><legend><font face="Verdana" size="5">SYSTEM REPORT</font></legend>
<table border=0 width=100% height=100%><tr><td>
<table width=50%>
<tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr>
<tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr>
<tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr>
<tr><td align="center"><font face="Courier" size="3">The amount is credited in respective account.</font></td></tr>
<tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr>
<tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr>
<tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr>
<tr><td align="center"><font face="Courier" size="3">Transaction ID is: <b><%=show%></b></font></td></tr>
<tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr>
<tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr>
<tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr><tr><td></td></tr>
</table>
</td></tr></table>
</fieldset>
<BR>
<form name="Employee" action="Employee.jsp" method="POST">
<div style="width:100%">
<table style="width:100%">
<tr>
<td align="center" style="width:20%"><input style="width:20%" type="submit" value="OK" name="ID"></td>
</tr>
</table>
</div>
</form>
<%
}
catch(Exception e)
{ %> <%=e.toString() %>
<%
}
%>
</body>
</html>
</code>
java.lang.Numbe rFormatExceptio n: For input string: "20100819000001 "
Thanks in advance.
Comment