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.