shiju nair

Thanks to both of you .
I have solved my query using your code.

hi,
Please have a look at the code.

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:employee_details"); PreparedStatement p=null; p=con.prepareStatement("select * from emp_leave_application where approver='"+username+"'"); ResultSet r=p.executeQuery(); while(r.next()) { out.println("data found"); } Now here how should i use the else statement that if rows are not found then out.println("no data found");
this is the structure of my database i am using ms-access.

m_emp_no|from_date|to_date|approver|status| ________________________________________ 1002 | 22/9/2008 | 23/9/2008|1003 |pending 1004 | 29/9/2008 | 30/9/2008|1003 |pending 2044 | 15/9/2008 | 16/9/2008|3076 |pending
Please help me .
thanks in advance.

hi bear,
sorry i was just in a hurry to get things done.i will wait till the ranchers find a solution and by the mean time ,even i am trying from my side to get the solution.
thank you

hello everyone,
I am asking for help from when and no body is responding to me .
there is no one in this forum who could help me out.
atleast just guide me what has to be done.
its very urgent .there are hardly any days left out.
please guys help

Is there no one to help me out .
As amit stated that there is a problem with the update statement it might be true but unless and until we get the values how can we get the exact result using proper update statement also because as i said i am getting only one value from the code when i try to get values from the jsp page.
String approved=request.getParameter("approved"); String id=request.getParameter("id");
if any problem please refer the first coding and help me out with some suggestion as to how to get all the values.
please its very urgent.
thanks in advance.

hi amit,
but i dont understand one thing as i have stated above that when i retrieve the values from the database in the jsp page i get all the rows but when i retrieve the values from the page using
String approved=request.getParameter("approved");
why does it give me only one value or is it that i have not placed te list box properly .is there any other way to get all the values from the page.
please suggest me.
thanks in adavance.

hello,
please anyone help me out of this problem.I have to get this done as soon as possible.
thanks in advance.

hi sagar,
when i changed the code as you suggested it is updating the database related to its first entry i.e when i select approved for 1002 and cancelled for 1004 it is updating both as approved.
i think the values which i am retrieving is a single value ,used in the above code in update.jsp.
[B]approved=(String)request.getParameter("approved"); id=(String)request.getParameter("id");[/B]
because when i use System.out.println(approved+" "+id);
it gives me only one value else it should give me both the values.so there is problem with retrieving values but i am not able to find it, or else the coding is not proper in the first jsp above.
please find a solution
thanks in adavance.

hi sagar,
when i changed the code as you suggested it is updating the database related to its first entry i.e when i select approved for 1002 and cancelled for 1004 it is updating both as approved.
i think the values which i am retrieving is a single value ,used in the above code in update.jsp.
[B]approved=(String)request.getParameter("approved"); id=(String)request.getParameter("id");[/B]
because when i use System.out.println(approved+" "+id);
it gives me only one value else it should give me both the values.so there is problem with retrieving values but i am not able to find it, or else the coding is not proper in the first jsp above.
please find a solution
thanks in adavance.

hi,
I am badly stuck into this problem.Please look into it and find a solution.
I am using ms-access and jsp.
my database structure is as given below:

----------------------------------------------------------
m_emp_no|from_date|to_date|approver|status|
___________________________________________
1002 | 22/9/2008 | 23/9/2008|1003 |pending
1004 | 29/9/2008 | 30/9/2008|1003 |pending
2044 | 15/9/2008 | 16/9/2008|3076 |pending

------------------------------------------------------
now this is exactly a leave apply scenario where a page is displayed and the user has to fill in the details to apply leave.then the approver has to approve that leaves so even, he should get the details in his account.
for example here 1003 has to approve leaves for 1002 & 1004.i am able to fetch data from database for the particular approver here is the coding:
<html> <body> <form method="POST" name="f1" action="update.jsp"> <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:employee_details"); PreparedStatement p=null; p=con.prepareStatement("select * from emp_leave_application where approver='"+username+"'"); ResultSet r=p.executeQuery(); while(r.next()) { %> <table border="1" width="100%" bordercolor="#FFFFFF" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF"> <tr> <td width="100%" bgcolor="#999966"><b><u><%=r.getString(2)%></u></b></td> </tr> </table> <table border="1" width="100%" height="171" bordercolor="#FFFFFF" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF"> <tr> <td width="100%" height="165" valign="top"> <p align="left"><b>User ID</b>        : <input type="text" name="id" value="<%=r.getString(1)%>" size="4"></p> <p><b>from </b>: <%=r.getString(2)%></p> <p><b>to</b>: <%=r.getString(3)%></p> <p><b>status</b>: <%=r.getString(5)%>   <b>Approve</b> : <select size="1" name="approved"> <option value="Approved">Approved</option> <option value="Cancelled">Cancelled</option> </select></p> <% } con.close(); %> <table border="1" width="100%" bordercolor="#FFFFFF" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF"> <tr> <td width="100%" bgcolor="#999966"> <p align="center"><input type="reset" value="Clear" name="B1">  <input type="submit" value="Submit" name="B2"></td> </tr> </table> </td> </tr> </table> </form> </body> </html>
------------------------------------------------------------
but the problem is that how do i approve leaves individually because when i use the coding given below i am able to approve only the first row data.
i want to approve leaves for everyone but based on m_emp_no.
update.jsp:
<%@ page language="java"%> <%@ page import="java.sql.*"%> <html> String username=(String)session.getAttribute("user"); if(null==username) { response.sendRedirect("login.jsp"); return; } else { } %> <form method="post" name="f2"> <body bgcolor= "FFFFFF"> <%! String approved=""; String id=""; %> <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:employee_details"); PreparedStatement ps=null; PreparedStatement p=null; approved=(String)request.getParameter("approved"); id=(String)request.getParameter("id"); p=con.prepareStatement("select * from emp_leave_application where approver='"+username+"' and m_emp_no='"+id+"'"); ResultSet r=p.executeQuery(); while (r.next()) { if(username!=null) { ps=con.prepareStatement("update emp_leave_application set status='"+approved+"' where approver='"+username+"' and m_emp_no='"+id+"'"); ps.executeUpdate(); %> <script language="javascript"> alert("The leaves have been approved"); document.f2.action="process.jsp" document.f2.submit(); </script> <% } } con.close(); %> </form> </body> </html>

please help me out .
thanks in advance.

hi,
so you mean to say if it is not int then i need to convert both of them into int and then validate with the same condition.
please suggest.

when i am using
if(balance > day) { p=con.prepareStatement("INSERT into emp_leave_application values (?,?,?,?,?,?,?,?,?)"); } else{ alert("You do not have sufficient leave balance"); }
but it is giving me error such as
Error: 500 Internal Servlet Error: org.apache.jasper.JasperException: Unable to compile class for JSPC:\j2sdkee1.2.1\repository\itsoftwares\web\_0005csubmit_0002ejspsubmit_jsp_31.java:161: Incompatible type for <. Can't convert java.lang.String to int. if (bal < day) ^ 1 error at org.apache.jasper.compiler.Compiler.compile(Compiler.java:248) at org.apache.jasper.runtime.JspLoader$2.run(JspLoader.java:273) at java.security.AccessController.doPrivileged(Native Method) at org.apache.jasper.runtime.JspLoader.loadJSP(JspLoader.java:270) at org.apache.jasper.runtime.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:137) at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:148) at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:247) at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:352) at javax.servlet.http.HttpServlet.service(HttpServlet.java:865) at org.apache.tomcat.core.ServiceInvocationHandler.method(ServletWrapper.java:626) at org.apache.tomcat.core.ServletWrapper.handleInvocation(ServletWrapper.java:534) at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:378) at org.apache.tomcat.core.Context.handleRequest(Context.java:644) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:440) at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:144) at org.apache.tomcat.service.TcpConnectionThread.run(TcpEndpoint.java:310) at java.lang.Thread.run(Thread.java:484)

I am trying to do it but i am not getting it.

hi,
I am using ms-access as backend and jsp.
I am facing a problem in this scenario.I have a page which is displaying the leave balance such as pl=30,sl=7,cl=7 ok.there are two textboxes for dates.i have taken the difference of the two dates in days which is in string value.now what i want is when i click on submit button it should validate the leave balance with the days applied .when a leave is applied for the particular pl,sl,cl the figures goes on decreasing.so when it reaches pl=1,sl=1,cl=1 the person who is applying for leave more than the days in balance it should give him an alert box stating that "you do no have sufficient balance".
please help me .
thanks in advance.

Please tell me how to forward the arraylist to the jsp.
thanks

hi sreesnath,
Actually i am totally confused with this problem,so not able to think anything.can you please provide me with an example which will guide me to the solution.please help me
thanks in advance