展开全部
java程序产生62616964757a686964616fe59b9ee7ad9431333337626234的图表可以用jfreechart来展示。
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html;charset=GBK");
DefaultCategoryDataset dataset = new DefaultCategoryDataset();
LinkDataBase linker=new LinkDataBase();
String sql="select sname,courseName,marks from course,marks,student where student.rollno=marks.rollno and marks.courseid=course.courseid ";
ResultSet rs=linker.executeQuery(sql);
try
{
while(rs.next())
{
dataset.addValue(Integer.parseInt(rs.getString("marks")),rs.getString("courseName"), rs.getString("sname"));
}
}
catch(Exception e)
{
e.printStackTrace();
}
JFreeChart chart = ChartFactory.createBarChart3D(
"学生成绩柱状图", "学生姓名", "成绩", dataset, PlotOrientation.VERTICAL, true, false, false);
try {
ChartUtilities.writeChartAsJPEG(response.getOutputStream(), 1.0f, chart, 400, 300, null);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
} finally {
linker.close();
}
}
jsp页面只需要执行这个servlet即可完成。
执行结果如下: