📄 vote.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="myTools.DataBase" %>
<%@ page import="java.sql.*"%>
<%@ page import="org.jfree.data.general.DefaultPieDataset"%>
<%@ page import="org.jfree.chart.*"%>
<%@ page import="org.jfree.chart.plot.*"%>
<%@ page import="org.jfree.chart.servlet.ServletUtilities"%>
<%@ page import="org.jfree.chart.labels.StandardPieToolTipGenerator"%>
<%@ page import="org.jfree.chart.urls.StandardPieURLGenerator"%>
<%@ page import="org.jfree.chart.entity.StandardEntityCollection"%>
<%@ page import="java.io.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>投票</title>
</head>
<%
DataBase db = new DataBase();
ResultSet rs = null;
db.connectToDB();
String sql = "select * from topics where topic_id = 1000";
rs = db.executeQuery(sql);
String des = "";
int first = 0;
int second = 0;
int third = 0;
int forth = 0;
int fifth = 0;
String a = "";
String b = "";
String c = "";
String d = "";
String e = "";
if (rs.next()) {
des = rs.getString("topic_description");
a = rs.getString("a");
b = rs.getString("b");
c = rs.getString("c");
d = rs.getString("d");
e = rs.getString("e");
first = rs.getInt("first");
second = rs.getInt("second");
third = rs.getInt("third");
forth = rs.getInt("forth");
fifth = rs.getInt("fifth");
}
%>
<body>
<div style="float:left;">
<table>
<tr>
<td width="542" height="99"><table width="534" height="86">
<tr>
<td width="85" height="80">问题描述:</td>
<td width="437"><%=des%></td>
</tr>
</table></td>
</tr>
<tr>
<td height="178"><table width="537" height="126">
<tr>
<td width="86"> </td>
<td width="57">A</td>
<td width="378">
<input name="textfield1" type="text" size="55" value="<%=a%>" />
</td>
</tr>
<tr>
<td> </td>
<td>B</td>
<td>
<input name="textfield2" type="text" size="55" value="<%=b%>" />
</td>
</tr>
<tr>
<td>答案:</td>
<td>C</td>
<td>
<input name="textfield3" type="text" size="55" value="<%=c%>"/>
</td>
</tr>
<tr>
<td> </td>
<td>D</td>
<td>
<input name="textfield4" type="text" size="55" value="<%=d%>"/>
</td>
</tr>
<tr>
<td> </td>
<td>E</td>
<td>
<input name="textfield5" type="text" size="55" value="<%=e%>"/>
</table></td>
</tr>
<tr>
<form id="form1" name="form1" method="post" action="TopicServlet?operation=vote">
<td height="97"><table width="534" height="52">
<tr>
<td>你认为呢？</td>
</tr>
<tr>
<td height="26">
<p>
<label>
<input type="radio" name="RadioGroup1" value="first" />
A</label>
<label>
<input type="radio" name="RadioGroup1" value="second" />
B</label>
<label>
<input type="radio" name="RadioGroup1" value="third" />
C</label>
<label>
<input type="radio" name="RadioGroup1" value="forth" />
D</label>
<label>
<input type="radio" name="RadioGroup1" value="fifth" />
E</label>
</p>
</td>
</tr>
<tr>
<td height="26">
<input type="hidden" name="topic_id" value="1000"/>
<input type="submit" name="Submit" value="提交" />
</td>
</tr>
</table>
</td>
</form>
</tr>
</table>
</div>
<%
DefaultPieDataset data = new DefaultPieDataset();
//数据初始化
data.setValue(a + " " + String.valueOf(first), first);
data.setValue(b + " " + String.valueOf(second), second);
data.setValue(c + " " + String.valueOf(third), third);
data.setValue(d + " " + String.valueOf(forth), forth);
data.setValue(e + " " + String.valueOf(fifth), fifth);
//HttpSession session = request.getSession();
PiePlot3D plot = new PiePlot3D(data);//生成一个3D饼图
//plot.setURLGenerator(new StandardPieURLGenerator("DegreedView.jsp"));//设定图片链接
JFreeChart chart = new JFreeChart("", JFreeChart.DEFAULT_TITLE_FONT, plot, true);
chart.setBackgroundPaint(java.awt.Color.white);//可选，设置图片背景色
chart.setTitle(des);//可选，设置图片标题
plot.setToolTipGenerator(new StandardPieToolTipGenerator());
StandardEntityCollection sec = new StandardEntityCollection();
ChartRenderingInfo info = new ChartRenderingInfo(sec);
PrintWriter w = new PrintWriter(out);//输出MAP信息
//500是图片长度，300是图片高度
//String filename = ServletUtilities.saveChartAsPNG(chart,500,300,info,session);
String filename = ServletUtilities.saveChartAsJPEG(chart, 500, 300, info, session);
ChartUtilities.writeImageMap(w, "map0", info, false);
String graphURL = request.getContextPath() + "/servlet/DisplayChart?filename=" + filename;
%>
<div style="margin-top:20px;">
<div id="image"></div>
<div>
<P ALIGN="CENTER">
<img src="<%= graphURL%>" width=400 height=400 border=0 usemap="#map0">
</P>
</div>
<div></div>
</div>
<br>
<img src="<%= graphURL%>" width=800 height=600 border=0 usemap="#map0">
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -