Comment
shweta
plz help to resolve array out of bound exception,
September 1, 2009 at 9:55 PM
September 1, 2009 at 9:55 PM
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
public class order extends HttpServlet
{
public void doGet(HttpServletRequest req,HttpServletResponse res)throws IOException,ServletException
{
res.setContentType("text/html");
PrintWriter out=res.getWriter();
try{
HttpSession s=req.getSession(false);
out.println("<html><font Color=Red><h4>Client ID:"+s.getValue("SUID").toString()+"<br>Login Time:"+s.getValue("LoginTime").toString()+"</h4></font><br><a href=/servlet/logout>Logout</a><br>");
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection cn=DriverManager.getConnection("jdbc:odbc:eshop","admin","");
Statement smt=cn.createStatement();
String pid[]=req.getParameterValues("pid");
out.println("<html><form action=/servlet/invoice><center><table border=1><caption>List of Products Ordered</caption>");
out.println("<tr><th>PID</th><th>Name</th><th>Price</th><th>Qty.Order</th><th>Confirm</th></tr>");
ResultSet rs=null;
//the problem is with this loop. any1 how can resolve it.
for(int i=0;i<pid.length;i++)
{
rs=smt.executeQuery("Select * from product where pid='"+pid[i]+"'");
if(rs.next())
{
out.println("<tr><td>"+pid[i]+"</td><td>"+rs.getString(3)+"</td><td>"+rs.getString(4)+"</td><td><input type=text name=qo></td><td><input type=checkbox name=pid value="+pid[i]+"></td></tr>");
}
}
out.println("</table><input type=submit></center></form></html>");
cn.close();
out.flush();
}
catch(Exception e)
{out.println(e);}
}
catch(Exception r)
{
out.println("<h3>This Page Expire for Current Session Click Here For <a href=/servlet/login>Login</a>");
}
}}
View All Comments | View Tutorial
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
public class order extends HttpServlet
{
public void doGet(HttpServletRequest req,HttpServletResponse res)throws IOException,ServletException
{
res.setContentType("text/html");
PrintWriter out=res.getWriter();
try{
HttpSession s=req.getSession(false);
out.println("<html><font Color=Red><h4>Client ID:"+s.getValue("SUID").toString()+"<br>Login Time:"+s.getValue("LoginTime").toString()+"</h4></font><br><a href=/servlet/logout>Logout</a><br>");
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection cn=DriverManager.getConnection("jdbc:odbc:eshop","admin","");
Statement smt=cn.createStatement();
String pid[]=req.getParameterValues("pid");
out.println("<html><form action=/servlet/invoice><center><table border=1><caption>List of Products Ordered</caption>");
out.println("<tr><th>PID</th><th>Name</th><th>Price</th><th>Qty.Order</th><th>Confirm</th></tr>");
ResultSet rs=null;
//the problem is with this loop. any1 how can resolve it.
for(int i=0;i<pid.length;i++)
{
rs=smt.executeQuery("Select * from product where pid='"+pid[i]+"'");
if(rs.next())
{
out.println("<tr><td>"+pid[i]+"</td><td>"+rs.getString(3)+"</td><td>"+rs.getString(4)+"</td><td><input type=text name=qo></td><td><input type=checkbox name=pid value="+pid[i]+"></td></tr>");
}
}
out.println("</table><input type=submit></center></form></html>");
cn.close();
out.flush();
}
catch(Exception e)
{out.println(e);}
}
catch(Exception r)
{
out.println("<h3>This Page Expire for Current Session Click Here For <a href=/servlet/login>Login</a>");
}
}}
View All Comments | View Tutorial
Related Tutorial and Articles
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
