
I have these 2 codes.
array.java----in which i retrieve the values from the database .
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 );
}
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>
}
and a jfreechart file to display the chart.this is a separate java file. graph.java
import org.jfree.chart.ChartFactory;
import org.jfree.chart.ChartFrame;
import org.jfree.chart.JFreeChart;
import org.jfree.chart.plot.PlotOrientation;
import org.jfree.data.category.DefaultCategoryDataset;
public class barchart {
public static void main(String[] args) {
DefaultCategoryDataset dataset = new DefaultCategoryDataset();
dataset.setValue(6, "Marks", "sem1");
dataset.setValue(7, "Marks", "sem2");
dataset.setValue(8, "Marks", "sem3");
dataset.setValue(5, "Marks", "sem4");
dataset.setValue(12, "Marks", "sem5");
JFreeChart chart = ChartFactory.createBarChart("MARKS INFORMATION OF THE ENTERED STUDENT",
"SEMESTER", "MARKS", dataset, PlotOrientation.VERTICAL,
false, true,false);
ChartFrame frame=new ChartFrame("student graph",chart);
frame.pack();
frame.setVisible(true);
}
}
NOW i want that these both things should be done in a single servlet and then the chart should be displayed on a jsp..how can i do it..pls reply..its urgent.
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.