harshitha
jsp code compilation error
1 Answer(s)      5 years and 8 months ago
Posted in : JSP-Servlet
hai, iam doing online banking project.i created two database tables in mysql.Table1: user (username,password) Table2: myaccounts (accno,username,balance).

for funds transferring, i had written the following code.but it shows the following error.can you tell me where is the error and also what is the proper code for funds transfer.



<%@page import="java.sql.*"%>
<%
int acc1=Integer.parseInt(request.getParameter("no"));
int bal=Integer.parseInt(request.getParameter("amount"));
int acc2=Integer.parseInt(request.getParameter("to"));

try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/register";, "root", "root");
Statement st = con.createStatement();

ResultSet rs = st.executeQuery( "select balance from myaccounts where ano='"+acc1+"'");

int balance1=0;
while (rs.next()) {
balance1=rs.getInt("balance");
}
ResultSet rs1 = st.executeQuery( "select balance from myaccounts where ano='"+acc2+"'");

int balance2=0;
while (rs1.next()) {
balance2=rs1.getInt("balance");
}

int bal1=balance1-bal;
int bal2=balance2+bal;

st.addBatch("update myaccounts set balance="+bal1+" where ano='"+acc1+"'");
st.addBatch("update myaccounts set balance="+bal2+" where ano='"+acc2+"'");
st.executeBatch();
out.println("Transaction has been successfully done.");
}
catch(Exception e){}
%>





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: null
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
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)


root cause

java.lang.NumberFormatException: null
java.lang.Integer.parseInt(Integer.java:415)
java.lang.Integer.parseInt(Integer.java:497)
org.apache.jsp.xxxxxxxxxxxxxxx_jsp._jspService(xxxxxxxxxxxxxxx_jsp.java:62)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
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.
Advertisement
View Answers

January 5, 2010 at 10:49 AM


Hi Friend,

Try the following code:

<%@page import="java.sql.*"%>
<%
int acc1=Integer.parseInt(request.getParameter("no"));
int bal=Integer.parseInt(request.getParameter("amount"));
int acc2=Integer.parseInt(request.getParameter("to"));

try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/register";, "root", "root");
Statement st = con.createStatement();

ResultSet rs = st.executeQuery( "select balance from myaccounts where accno='"+acc1+"'");

int balance1=0;
while (rs.next()) {
balance1=rs.getInt("balance");

}
ResultSet rs1 = st.executeQuery( "select balance from myaccounts where accno='"+acc2+"'");

int balance2=0;
while (rs1.next()) {
balance2=rs1.getInt("balance");

}

int bal1=balance1-bal;
int bal2=balance2+bal;

st.addBatch("update myaccounts set balance="+bal1+" where accno='"+acc1+"'");
st.addBatch("update myaccounts set balance="+bal2+" where accno='"+acc2+"'");
st.executeBatch();
out.println("Transaction has been successfully done.");
}
catch(Exception e){}
%>

Thanks









Related Tutorials/Questions & Answers:
java Compilation error:jsp code - JSP-Servlet
java Compilation error:jsp code   I am getting an Generated Servlet error: String literal is not properly closed by a double-quote. here is my code: <% { Dbclass2 d= new Dbclass2
jsp code compilation error - JSP-Servlet
jsp code compilation error  hai, iam doing online banking project.i... is the error and also what is the proper code for funds transfer. HTTP... The server encountered an internal error () that prevented it from fulfilling
Advertisements
Compilation error. Hibernate code - Hibernate
Compilation error. Hibernate code   Exception in thread "main" java.lang.NoClassDefFoundError: org/slf4j/LoggerFactory...) how to rectify that error in hibernate  Hi Friend, You have
compilation error - JSP-Servlet
compilation error  Hi sir, i'm using following code to upload an image to the database.I'm facing the following problem. <% String...(longblob)) in the database and try the following code: <% String
Java compilation error - JSP-Servlet
*; ^ An error occurred at line: 18 in the jsp file: /employee_upload_profile...); ^ An error occurred at line: 18 in the jsp file...(); ^ An error occurred at line: 18 in the jsp file: /employee_upload
java compilation error - JSP-Servlet
java compilation error  hi, i have created a table in MYsql and connected it using JDBC, I have to now validate those fields using jsp, so please can you suggest me a way how to validate using jsp, my table has fields
java compilation error - JSP-Servlet
java compilation error  i have created an employee table in mysql and connected it using JDBC, now i have to do client side validations, can u please... code
java compilation error - JSP-Servlet
java compilation error  i want to do client side validations using JSP, so please can u suggest me a way out.thanq very much for the previous answers... validations.........u will find some js files download that and include i the jsp
java compilation error - JSP-Servlet
java compilation error  How to compile a java Program,If i am having jdk1.5 in webligic it support jdk1.4..When i put a .class file into WEB-INF/classes/Mybeans/Datacon.class it was given a error  Hi friend
Java Compilation error - JSP-Servlet
Java Compilation error  hi i m vipul chauhan , i having a problem with this package i download package from the location http://commons.apache.org...-fileupload-1.2.1.jar but still there is a problem and when i compile my file this error
srvlet compilation error - JSP-Servlet
srvlet compilation error  while compiling a servlet, httpservlet class not found errors & many such class not are generated.   Hi Friend, It seems that compiler haven't found the servlet-api.jar file.So put
java compilation error - JSP-Servlet
java compilation error  i have a field like name if name is not given then it should give an alert like name cannot be null, i want this type of validations.  Hi uma, I am sending you a link. This link will help
java compilation error - JSP-Servlet
java compilation error  sir ,i have jdk1.6.0_01 and textpad installed .I have also set classpath and path.But stil on compiling my servlet programs in textpad i get compile time errors like javax.servlet.* ,javax.servlet.http.
Java Compilation error. Hibernate code problem. Struts first example - Hibernate
Java Compilation error. Hibernate code problem. Struts first example  Java Compilation error. Hibernate code problem. Struts first example
compilation error
compilation error  Hi my program below is not compiling,when I try to compile it i'm getting the error message "tool completed with exit code 1... java.util.*; import java.text.*; class HardwareItems { String code
java compilation error - Applet
java compilation error  I am getting compilation error in the following code.: public void paint(Graphics g) { switch(screen...; } } Error is: Illegal start of expression Plz. find why am I getting this error
code error - JSP-Servlet
code error  hii this program is not working becoz when the mouse... is error in this progrm. ss function describe() { window.status... complaint   Hi friend, Do some changes in your code to solve
jdbc compilation error - JDBC
jdbc compilation error  java.lang.Exception: Problem in call_select when i am executing the program i am getting the above error. how can i resolve it?  Hi friend, plz specify in detail and send me code
jsp code error - JSP-Servlet
jsp code error  hello, is anyone here who can solve my problem. what happen experts where r u? or u r not able to do
jsp code error - JSP-Servlet
jsp code error  hello, is anyone here who can solve my problem. what happen experts where r u? r u not able to do
jsp code error - JSP-Servlet
jsp code error  I have a jsp page named "tMastDepartment".which has some table row containing text box like 'project code','Departmentcode','employee... there is the problem which i am facing.what will be the exact code
java compilation error - Applet
java compilation error  hi friends the following is the awt front design program error, give me the replay E:\ramesh>javac..., Plz give full details with source code and visit to : http
groovy compilation error - Framework
] [groovyc] 1 error Compilation error: Compilation Failed how we can resolve...groovy compilation error  while i am running the grails application , i got the error message like: [groovyc
java compilation error - Hibernate
java compilation error  hi i am getting org.hibernate.exception.GenericJDBCException: Cannot open connection exception when runnig the code why this exception is coming
Webshpere compilation error
Webshpere compilation error   I want clear result . Thank you WSWS3166E: Error: No client transport named 'http' found. faultActor: null faultDetail: [10/5/10 13:19:40:937 EDT] 00000043 SystemOut O WSWS3166E: Error
compilation error - Java Beginners
compilation error  i 'm not able to compile a program : prblem...; Post your code.  //this is person code!! public class Person...=dog; } public Dog getDog() { return dog; } } //this is Dog code
compilation error - Java Beginners
compilation error  class s { public static... this program it is giving an error as integer number is too large.why? and what... not in the Hexadecimal or Octal. Here is fraction of Java code example which will help you
compilation error - Java Beginners
compilation error   import java.awt.*; import java.awt.event.*; import javax.swing.*; class BLayout implements ActionListener { JFrame f...,BorderLayout.CENTER}; for(int i = 0 ; i  Hi Friend, Try the following code
Java compilation error - Java Beginners
Java compilation error  Method overridden problems in compile time error
Java Compilation error - SQL
Java Compilation error  ava.lang.NullPointerException at beanUtils.SaleHeaderUtility.getFullRemainPatientList(SaleHeaderUtility.java:754... post your code. Thanks
compilation error - Java Beginners
compilation error  sir what is the error inthis code after executing the below code i got java.lang.NoSuchMethodError: main Exception... org.array.Group Correct Code : package org.array; import java.io.