I have a jsp page, which retrieves values from a html page, my problem is that
i can insert the values in database, but the problem is that it does not insert the flot type values...
like 21.21, 242.52. It shows only 21,242
it does not shows in float type.
html form:
<input type="text" name="code" size="5" maxlength="5">
<input type="text" name="Description" size="65">
<input type="text" name="DrAmount" size="12" >
<input type="text" name="CrAmount" size="12" >
<SELECT name="type">
<option value="" selected></option>
<option VALUE="C">C</option>
<option VALUE="O">O</option>
<option VALUE="OI">OI</option>
<option VALUE="OR">OR</option>
<option VALUE="S">S</option>
<option VALUE="SB">SB</option>
<option VALUE="SG">SG</option></select>
<input name="pct" type="text" size="6" maxlength="5" >
jsp page:
<html>
<head>
<%@ page
import = "java.io.*"
import = "java.lang.*"
import = "java.sql.*"
%>
<title></title>
</head>
<body>
<h1></h1>
<%
String Code,Description,Dr_Amount,Cr_Amount,Pct,Type, sql1 ;
ResultSet results;
PreparedStatement sql;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:pf","scott","ttlscott");
try
{
int gl_code;
Float db_amt,cr_amt,gl_pct;
String gl_descr, gl_type;
boolean doneheading = false;
Statement s=conn.createStatement();
Code = request.getParameter("code");
Description = request.getParameter("Description");
Dr_Amount=request.getParameter("DrAmount");
Cr_Amount=request.getParameter("CrAmount");
Type = request.getParameter("type");
Pct=request.getParameter("pct");
PreparedStatement pstmt = conn.prepareStatement(
("INSERT INTO gl_mast VALUES (?, ?, ?, ?, ?,?)"));
pstmt.setInt(1,Integer.parseInt(request.getParameter("Code")));
pstmt.setString(2, request.getParameter("Description"));
pstmt.setFloat(3,Float.parseFloat(request.getParameter("Dr_Amount")));
pstmt.setFloat(4,Float.parseFloat(request.getParameter("Cr_Amount")));
pstmt.setString(5, request.getParameter("Type"));
pstmt.setFloat(6,Float.parseFloat(request.getParameter("Pct")));
pstmt.executeUpdate();
sql = conn.prepareStatement("SELECT * FROM gl_mast WHERE gl_code = '" + Code + "'");
results = sql.executeQuery();
while(results.next())
{
if(! doneheading)
{
out.println("<table border=2>");
doneheading = true;
}
gl_code = results.getInt("gl_code");
gl_descr = results.getString("gl_descr");
db_amt = results.getFloat("db_amt");
cr_amt = results.getFloat("cr_amt");
gl_type = results.getString("gl_type");
gl_pct = results.getFloat("gl_pct");
out.println("<BODY bgColor=blanchedalmond text=#008000 topMargin=0>");
out.println("<P align=center><FONT face=Helvetica><FONT color=fuchsia > <BIG>GL MASTER INFORMATION</BIG></FONT></P>");
out.println("<P align=center>");
out.println("<TABLE align=center border=1 cellPadding=1 cellSpacing=1 width=\"75%\">");
out.println("<TR>");
out.println("<TD>Code No.</TD>");
out.println("<TD>Description</TD>");
out.println("<TD>Dr. Amount</TD>");
out.println("<TD>Cr. Amount</TD>");
out.println("<TD>Type</TD>");
out.println("<TD>Percentage</TD></TR>");
out.println("<tr><td>" + gl_code);
out.println("<td>" + gl_descr);
out.println("<td>" + db_amt);
out.println("<td>" + cr_amt);
out.println("<td>" + gl_type);
out.println("<td>" + gl_pct);
}
if(doneheading)
{
out.println("</table>");
}
else
{
out.println("No matches for " + Code);
}
}
catch (SQLException s)
{
out.println("Dupliacte Entry<br>");
}
}
catch (ClassNotFoundException err)
{
out.println("Class loading error");
}
%>
</body>
</html>
error:
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 13 in the jsp file: /gl_master/gl_save.jsp
Generated servlet error:
D:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\abhi\org\apache\jsp\gl_005fmaster\gl_005fsave_jsp.java:100: incompatible types
found : float
required: java.lang.Float
db_amt = results.getFloat("db_amt");
^
An error occurred at line: 13 in the jsp file: /gl_master/gl_save.jsp
Generated servlet error:
D:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\abhi\org\apache\jsp\gl_005fmaster\gl_005fsave_jsp.java:101: incompatible types
found : float
required: java.lang.Float
cr_amt = results.getFloat("cr_amt");
^
An error occurred at line: 13 in the jsp file: /gl_master/gl_save.jsp
Generated servlet error:
D:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\abhi\org\apache\jsp\gl_005fmaster\gl_005fsave_jsp.java:103: incompatible types
found : float
required: java.lang.Float
gl_pct = results.getFloat("gl_pct");
^
3 errors
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:332)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:437)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:497)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:476)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:464)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.30 logs.
--------------------------------------------------------------------------------
Apache Tomcat/5.0.30