
I have created a servlet.In this,i have retrieved a record from MS Access database in an arraylist i.e. my arraylist contains only one object(rollno,name,marks1,marks2,marks3,marks4) from the database.now i have to pass this arraylist object to a jsp page and on that jsp page i have to display a graph between a student semester-marks .(semesters on x-axis and marks1,marks2,marks3,marks4 on y-axis) using JFREECHART.how can i do it.please reply soon.I am attaching my servlet and jsp page beneath. please reply asap.Its urgent.
Here is my code:
arraylist.java(servlet)
import java.util.ArrayList;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
*
* @author AARUSHI
*/
class database
{
int roll;
String name;
int marks1;
int marks2;
int marks3;
int marks4;
public database(int r,String nm,int m1,int m2,int m3,int m4)
{
roll=r;
name=nm;
marks1=m1;
marks2=m2;
marks3=m3;
marks4=m4;
}
@Override
public String toString()
{
return roll + ":" + name + ":" + marks1 + ":" + marks2 + ":" + marks3 + ":" + marks4;
}
}
public class arraylist extends HttpServlet {
/**
* Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
ArrayList<database> v = new ArrayList<database>();
database db;
try {
int rollno=Integer.parseInt(request.getParameter("txtroll"));
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:cdotdsn");
PreparedStatement ps=con.prepareStatement("select * from cdottable where rollno=?");
ps.setString(1,""+rollno);
ResultSet rs=ps.executeQuery();
out.println("hello1");
while(rs.next())
{
// out.println("1st "+rs.getString(1));
// out.println("2nd "+rs.getString(2));
//out.println("3rd "+rs.getString(3));
//out.println("4th "+rs.getString(4));
// out.println("5th "+rs.getString(5));
// out.println("6th "+rs.getString(6));
int r=Integer.parseInt(rs.getString(1));
String nm=rs.getString(2);
int m1=Integer.parseInt(rs.getString(3));
int m2=Integer.parseInt(rs.getString(4));
int m3=Integer.parseInt(rs.getString(5));
int m4=Integer.parseInt(rs.getString(6));
out.println(r+ nm + m1 + m2 + m3 + m4);
out.println("abc");
db=new database(r,nm,m1,m2,m3,m4);
v.add(db);
int m=v.size();
out.println(m);
out.println( v );
}
for (int i=0;i<v.size();i++)
{
//out.println("<tr><td><br>name======" + rowArray.get(i) + "</td></tr>");
request.getSession().setAttribute("myArrayList",v);
RequestDispatcher requestDispatcher=getServletContext().getRequestDispatcher("/myjsp.jsp");
requestDispatcher.forward(request,response);
}
con.close();
}
catch(Exception e)
{
out.println(e);
}
}
// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/**
* Handles the HTTP <code>GET</code> method.
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Handles the HTTP <code>POST</code> method.
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Returns a short description of the servlet.
* @return a String containing servlet description
*/
@Override
public String getServletInfo() {
return "Short description";
}// </editor-fold>
}
Jsp page(myjsp.jsp)
<%--
Document : myjsp
Created on : Oct 19, 2011, 8:22:50 PM
Author : AARUSHI
--%>
<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<%@page import="java.util.ArrayList"%>
<%@ page session="true"%>
<%@page import="java.io.*"%>
<%@page import="javax.servlet.*"%>
<%@page import="java.io.*"%>
<%@page import="p1.*"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<%
try
{
ArrayList pageArray = new ArrayList();
pageArray.add(request.getSession().getAttribute("myArrayList"));
//pageArray.add(request.getAttribute("myArrayList")) ;
for (int i=0;i<pageArray.size();i++)
{
out.println(pageArray.get(i));
}
out.println(pageArray.size());
}
catch(Exception e)
{
out.println(e);
e.printStackTrace();
}
%>
</body>
</html>
my access database contains the follwing fields(rollno,name,marks1,2,3,4). Please answer my query soon.

Please visit the following link:
http://www.roseindia.net/jsp/draw-statistical-chart-jsp.shtml

thankyou for the code.But this is not wat i m asking.tellme how can I generate the bar graph in my code attached i.e. myjsp.jsp.
I have sent the data from servlet to jsp already.
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.