一个关于求比率和总数的问题

时间:2008-06-12 10:10:34   来源:论坛整理  作者:  编辑:chinaitzhe
HTML code





Code highlighting produced by Actipro CodeHighlighter (freeware)

http://www.CodeHighlighter.com/





    <tr>

      <td align="center" valign="middle">区分</td>

      <td align="center" valign="middle">等级</td>

      <td>数量</td>

      <td>比率</td>

    </tr>   

 <s:iterator value="gradeList">

    <tr>

      <td align="center" valign="middle">&nbsp;<s:property value="pc_type"></s:property></td>

      <td align="center" valign="middle">&nbsp;<s:property value="grade"></s:property></td>

      <td>&nbsp;<s:property value="type_count"></s:property></td>

      <td>&nbsp;</td>

    </tr>

     </s:iterator>
\
得到的样式大概是这样：

区分 等级 数量 比率
PC A 3 60％
PC B 2 40％

现在不知道怎么能取得比率，我还要得到，一个区分的总数。不知道怎么得到。。。
我的sql语句是
SQL code





Code highlighting produced by Actipro CodeHighlighter (freeware)

http://www.CodeHighlighter.com/



select PC_TYPE,grade, count(*) as type_count from info GROUP BY pc_type,grade


网友回复:其实我专门用一条sql语句把各个区别的总数求出来了
SQL code





Code highlighting produced by Actipro CodeHighlighter (freeware)

http://www.CodeHighlighter.com/



select PC_TYPE,count(*) as total_count from info GROUP BY pc_type

得到结果
区分 总数
PC 5

HTML code





Code highlighting produced by Actipro CodeHighlighter (freeware)

http://www.CodeHighlighter.com/





    <tr>

      <td width="194" align="center" valign="middle">区分</td>

      <td width="213">总数</td>

    </tr>

    <s:iterator value="totalList">

    <tr>

      <td align="center" valign="middle">&nbsp;<s:property value="pc_type"></s:property></td>

      <td><s:property value="total_count"></s:property></td>

    </tr>

    </s:iterator>

网友回复:请问软件的架构，用了哪些框架？
网友回复:struts2还有itbatis


界面是jsp
网友回复:帮顶
网友回复:这么写SQL应该就可以吧
SQL code





Code highlighting produced by Actipro CodeHighlighter (freeware)

http://www.CodeHighlighter.com/





select PC_TYPE,grade, count(*),cout(*)/(select count(*)from info)*100 from as type_count from info GROUP BY pc_type,grade

网友回复:写错了，应该
SQL code





Code highlighting produced by Actipro CodeHighlighter (freeware)

http://www.CodeHighlighter.com/





select PC_TYPE,grade, count(*),count(*)/(select count(*)from info)*100 from as type_count from info GROUP BY pc_type,grade

网友回复:没用过itbatis，假如itbatis 也是把数据库和对象直接映射起来，查询后结果直接封装到对象中的话，推荐你在SQL查询时就把比率计算出来，然后封装到gradeList中对象的“比率”属性中，页面上直接标签取出来就可以了。


网友回复:select
PC_TYPE,
grade,
count(*) as type_count,
total_count,
(type_count/total_count*100) as percentage
from
info,
(select PC_TYPE,count(*) as total_count from info GROUP BY pc_type) aa
where
info.PC_TYPE = aa.PC_TYPE
GROUP BY
pc_type,grade
网友回复:晕，大哥好快！
关键字：一个,比率,总数,问题,

文章评论

共有 0 位网友发表了评论 此处只显示部分留言 点击查看完整评论页面

最新信息

最新代码下载