jsp中如何用饼状图显示数据库中男女比例?急求

murder11 2014-11-14 01:20:02
这是我自己写的loginAction中的代码,现在还要加些什么代码?

<%@ page import="ch2.service.UserService" %>
<%@page import="java.sql.*"%>
<%@ page language="java" contentType="text/html;charset=GBK" pageEncoding="utf-8"%>
<%@ page import="org.jfree.chart.ChartFactory,
org.jfree.chart.JFreeChart,
org.jfree.chart.plot.PlotOrientation,
org.jfree.chart.servlet.ServletUtilities,
org.jfree.data.category.DefaultCategoryDataset,
org.jfree.data.general.DatasetUtilities,
org.jfree.chart.plot.*,
org.jfree.chart.labels.*,
org.jfree.chart.plot.PiePlot,
org.jfree.data.general.DefaultPieDataset,
org.jfree.chart.renderer.category.BarRenderer3D,
java.awt.*,
org.jfree.ui.*,
org.jfree.chart.axis.AxisLocation,org.jfree.chart.title.TextTitle,org.jfree.chart.axis.CategoryAxis,
org.jfree.chart.axis.NumberAxis"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>用户登录</title>
</head>
<body style="background-color:#D3D3D3">
<center>
<%
String uid=request.getParameter("uid");
String password=request.getParameter("password");
UserService userService=new UserService();
if(userService.login(uid,password)){
session.setAttribute("uid",uid);
%>
<font color="blue" size=6>登录成功!</font>
<%Class.forName("com.mysql.jdbc.Driver").newInstance();
String url="jdbc:mysql://localhost/userdb?user=root&password=123456&useUnicode=true&characterEncoding=gbk";
Connection conn=DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from user where uid like "+"'"+uid+"'";
ResultSet rs=stmt.executeQuery( sql);
while(rs.next()) {%><table width="40%" border="1" align="center" cellpadding="2" cellspacing="0">
<caption>
<font color="black" style="font-size: 20px"><FONT color=green size=5>个人的基本信息</FONT></font><br></caption>
<tr bgcolor="white">
<td width="50%" align="center">用户名</td>
<td width="50%" align="center" >
<%out.print (rs.getString(2));%></td>

</tr>
<tr bgcolor="white">
<td width="50%" align="center">姓名</td>
<td width="50%" align="center" >
<% out.print (rs.getString(4));%>
<tr bgcolor="white">
<td width="50%" align="center">性别</td>
<td width="50%" align="center" >
<%if(rs.getInt(5)==1)
out.print ("男");
else
out.print ("女");%></td>

</tr>
<tr bgcolor="white">
<td width="50%" align="center">职业</td>
<td width="50%" align="center" >
<%if(rs.getInt(6)==1)
out.print ("医生");
else
out.print ("病人");%></td>

</tr>
<tr bgcolor="white">
<td width="50%" align="center">电话</td>
<td width="50%" align="center" >
<% out.print (rs.getString(7));%>
<tr bgcolor="white">
<td width="50%" align="center">登陆次数</td>
<td width="50%" align="center" >
<%out.print (rs.getString(12));%></td>
</table><br>
<%}%>
<%rs.close();
stmt.close();
conn.close();
%>
<%
Connection honn= DriverManager.getConnection(url);
Statement htmt=honn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
Connection monn= DriverManager.getConnection(url);
Statement mtmt=monn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
String mql="select * from user where gender='"+0+"'";
ResultSet ms=htmt.executeQuery(mql);
ms.last();
int c=ms.getRow();
ms.beforeFirst();
Connection oonn= DriverManager.getConnection(url);
Statement otmt=oonn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
String oql="select * from user where gender='"+1+"'";
ResultSet os=otmt.executeQuery(oql);
os.last();
int d=os.getRow();
os.beforeFirst();
%>
<%

ms.close();
mtmt.close();
monn.close();
os.close();
otmt.close();
oonn.close();
%>

</html>
<a href="#" onclick="history.back();">退出</a>
<%}else{ %>
<font color="red">用户不存在或密码错误!</font>
<a href="#" onclick="history.back();">返回</a>
<%}%>

</center>
</body>
</html>
...全文
366 4 打赏 收藏 转发到动态 举报
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
静心事成 2014-11-15
  • 打赏
  • 举报
回复
最近做项目用的eChar,感觉还不错,推荐一下。
murder11 2014-11-14
  • 打赏
  • 举报
回复
能说详细点吗?新手不太懂?怎么加?
slwsss 2014-11-14
  • 打赏
  • 举报
回复
用控件http://raphaeljs.com/ http://raphaeljs.com/pie.html
murder11 2014-11-14
  • 打赏
  • 举报
回复
加些什么代码可以用饼状图显示数据库中男女比例情况

10,606

社区成员

发帖
与我相关
我的任务
社区描述
Web 开发 其他
社区管理员
  • 其他
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧