📄 res.jsp

📁 JSP工程应用与实践
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="conn" scope="session" class="project3.Link_db"></jsp:useBean>
<jsp:useBean id="qus" scope="session" class="project3.fordb"></jsp:useBean>
<!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=gb2312">
<title>统计信息</title>
<style type="text/css">
<!--
.style1 {
	font-size: 24px;
	font-weight: bold;
	font-family: "黑体";
	color: #6666FF;
}
-->
</style>
</head>

<body>
<table width="629" height="29" border="0" align="center">
  <tr>
    <td><div align="center"><span class="style1">统计结果</span>
      <hr>
    </div></td>
  </tr>
</table>

<%
String Color[]={"yellow","deepink","darkcyan","deepskyblue","orange","lightslategray"};
String Opt1[]={"很满意","很不满意","不满意","满意","尚可"};
String Opt[]={"您满意本网站的内容吗？","您满意本网站的版面设计吗？","您满意本网站的风格吗？"};
for(int i=1;i<4;i++)
{
String sql="select * from stat";
Connection con=conn.getCon();
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(sql);
//ResultSet rs=qus.executeQuery(sql);
float a=0.00f;
float b=0.00f;
float c=0.00f;
float d=0.00f;
float num=0.00f;
float senter=100.00f;
float e=0;
while(rs.next())
{
num=num+1;
String tt=rs.getString(i+1);
if(tt.equals("很不满意")){
	a=a+1;
}
if(tt.equals("满意")){
	b=b+1;
}
if(tt.equals("很满意")){
	d=d+1;
}
if(tt.equals("尚可")){
	e=e+1;
}
if(tt.equals("不满意")){
	c=c+1;
}
}
rs.close();
stmt.close();
con.close();
float rad[]={d*senter/num,a*senter/num,c*senter/num,b*senter/num,e*senter/num};
/*
float rad1=a*senter/num);
float rad2=(c*senter/num);
float rad3=(b*senter/num);
float rad4=(e*senter/num);
*/
out.print(Opt[i-1]+"<br>");
/*
out.println("很满意");
out.println(rad+"%");
out.println("<br>");
out.println("满意");
out.println(rad3+"%");
out.println("<br>");
out.print("尚可");
out.print(rad4+"%");
out.println("<br>");
out.print("不满意");
out.print(rad2+"%");
out.println("<br>");
out.print("很不满意");
out.println(rad1+"%");
out.print("<br>");
*/
%>
<%
for(int j=0;j<5;j++)
{
out.print("&nbsp;&nbsp;"+Opt1[j]);
out.println(rad[j]+"%"+"<br>");
%>
<!--乘4是为了让颜色条更显示的更清晰也可以不用-->

 <table width="<%=rad[j]*4%>" border="0" height="20">
<tr>
<!--取得数组中色彩的颜色值-->
<td width="31" bgcolor="<%=Color[j]%>"></td>
</tr>
</table>
<%	
}
}
%>
<%
/*
/*
int TotalRec=qus.RecNum(con.getCon(),"");
int Count=0,prad=0;
for(int i=0;i<3;i++)
{
%>
<%=qus.getQus(i)%>
<%
for(int j=0;j<5;j++)
{
%>
<%=qus.getOpt(j)%>
<%
Count=qus.RecNum(con.getCon(),
"Qus"+(i+1)+"="+(j+1));
prad=Count*100/TotalRec;
%>
<td width="<%=prad%>" bgcolor="<%=qus.getColor(j)%>"></td>
<td><font size=4 color="#FF0000"><b>(<%=prad%>%)</b></font></td>
<%
}
}
out.println(Count);
*/
%>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -