jsp网页显示乱码,字符设置没有问题,其它显示正常。
sql语句:select convert(char(10),a.statime,120)as date,a.cnum,a.income,b.payout,(a.income-b.payout)as benifit,substring(convert(char(20),round(((a.income-b.payout)/a.income)*100,2)),1,4)+'%' as rate from (select statime,sum(cnum)as cnum,cast(sum(cnum*fee)as dec(11,2))as income from sms_sp_sta group by statime)a left join
(select statime,cast(sum(adfee*cnum)as dec(11,2))as payout from sms_cp_sta group by statime)b
on a.statime=b.statime union select '合计',sum(t.cnum),sum(t.income),sum(t.payout),sum(t.income)-sum(t.payout),''from (select convert(char(10),a.statime,120)as date,a.cnum,a.income,b.payout,substring(convert(char(20),round(((a.income-b.payout)/a.income)*100,2)),1,4)+'%' as rate from (select statime,sum(cnum)as cnum,cast(sum(cnum*fee)as dec(11,2))as income from sms_sp_sta group by statime)a left join
(select statime,cast(sum(adfee*cnum)as dec(11,2))as payout from sms_cp_sta group by statime)b
on a.statime=b.statime)t order by date desc"
其中‘合计‘在网页中显示不出来,request.setCharacterEncoding();已经试过,不行,怎么样才能让'合计'显示出来
sql语句:select convert(char(10),a.statime,120)as date,a.cnum,a.income,b.payout,(a.income-b.payout)as benifit,substring(convert(char(20),round(((a.income-b.payout)/a.income)*100,2)),1,4)+'%' as rate from (select statime,sum(cnum)as cnum,cast(sum(cnum*fee)as dec(11,2))as income from sms_sp_sta group by statime)a left join
(select statime,cast(sum(adfee*cnum)as dec(11,2))as payout from sms_cp_sta group by statime)b
on a.statime=b.statime union select '合计',sum(t.cnum),sum(t.income),sum(t.payout),sum(t.income)-sum(t.payout),''from (select convert(char(10),a.statime,120)as date,a.cnum,a.income,b.payout,substring(convert(char(20),round(((a.income-b.payout)/a.income)*100,2)),1,4)+'%' as rate from (select statime,sum(cnum)as cnum,cast(sum(cnum*fee)as dec(11,2))as income from sms_sp_sta group by statime)a left join
(select statime,cast(sum(adfee*cnum)as dec(11,2))as payout from sms_cp_sta group by statime)b
on a.statime=b.statime)t order by date desc"
其中‘合计‘在网页中显示不出来,request.setCharacterEncoding();已经试过,不行,怎么样才能让'合计'显示出来
解决方案 »
- GWT 报错,会的请进: com.google.gwt.event.shared.UmbrellaException: Exception caught: Se
- 263通信 明天面试有以前面过的同学吗?分享一下经验啊!!!
- jsp可以用include指令吗?
- hibernate插入数据的问题
- Struts2 问题,在线等结果!!
- jasperreports 报表问题
- xp下weblogic中文版-sturts本地化资源文件乱码问题
- 请问这两段代码的区别
- 如何限制同一个帐号的多个登录?
- 商品购物车怎么实现每种商品总价都随商品数量变化而变化
- html下拉框选值问题
- 新晋程序员求助,关于首页一块地方显示滚动新闻
那肯定是JSP内中文代码问题。
这里面有几种解决乱码的方法!我试过了挺管用的!