急。急。急。急。急。大家指点降序排列。
<%@ page contentType= "text/html;charset=GBK "%>
<%@page import= "java.sql.* "%>
<%@page import= "javax.naming.* "%>
<%@page import= "javax.sql.* "%>
<%@page import= "java.text.DecimalFormat "%>
<%@page import= "java.util.* "%>
<html>
<head>
<meta http-equiv= "Content-Type " content= "text/html; charset=gb2312 ">
<meta name= "GENERATOR " content= "Microsoft FrontPage 4.0 ">
<meta name= "ProgId " content= "FrontPage.Editor.Document ">
<STYLE type=text/css>
.style1 {
font-size: 18px;
font-weight: bold;
color: #FF9933;
}
td,th,body,input,select,textarea{font-size:12px;}
</STYLE>
<SCRIPT src= "sorttable.js " type= "text/javascript "> </SCRIPT>
</head>
<body>
<%
Connection conn=null;
try{
InitialContext ctx=new InitialContext();
DataSource ds=null;
ds=(javax.sql.DataSource)ctx.lookup( "oradb ");
conn=ds.getConnection();
ResultSet rs=null;
ResultSet rs1=null;
Statement stmt = conn.createStatement();
String sql= "select min(riqi) riqi from tablename ";
String minDate= " ";
rs=stmt.executeQuery(sql);
while(rs.next()){
minDate=rs.getString( "riqi ");
}
if(null==minDate)minDate= " ";
String sql1= "select max(riqi) riqi from tablename ";
String maxDate= " ";
rs=stmt.executeQuery(sql1);
while(rs.next()){
maxDate=rs.getString( "riqi ");
}
if(null==maxDate)maxDate= " ";
out.println( " <p align= 'center ' class= 'style1 '> 测试 </p> ");
out.println( " <table width=60% border= '1 ' bordercolor= '#FFFFFF ' bordercolorlight= '#999999 ' align= 'center ' cellspacing= '0 ' cellpadding= '5 ' bgcolor= 'f4f4f4 ' class= 'sortable ' id= 'mytable '> ");
out.println( " <tr align= 'center '> <td rowspan= '2 '> <b> 地市 </b> </td> <td colspan= '3 '> <b> M数 </b> </td> <td colspan= '3 '> <b> N数 </b> </td> </tr> ");
out.println( " <tr align= 'center '> ");
out.println( " <td> <b> A完成 </b> </td> ");
out.println( " <td> <b> 计划指标 </b> </td> ");
out.println( " <td> <b> 完成比例 </b> </td> ");
out.println( " <td> <b> B完成 </b> </td> ");
out.println( " <td> <b> 计划指标 </b> </td> ");
out.println( " <td> <b> 完成比例 </b> </td> ");
out.println( " </tr align= 'center '> ");
tablename where riqi = '20070331 ' or riqi = '20070430 ' or riqi = ' "+maxDate+ " ' ";
rs=stmt.executeQuery(strSql);
while(rs.next()){
String t2=rs.getString( "t2 ");
String t3=rs.getString( "t3 ");
int a;
a = Integer.parseInt(t2)+Integer.parseInt(t3);
String t1=rs.getString( "t1 ");
String strA=String.valueOf(a);
double aa,aa_1;
aa =Double.parseDouble(t1);
aa_1 =Double.parseDouble(strA);
double a1,b2;
a1= aa/2000;
b2=aa_1/120000;
a1*=100;
b2*=100;
DecimalFormat df=new DecimalFormat( "# ");
out.println( " <tr> ");
out.println( " <td align=center> 全省 </td> ");
out.println( " <td align=center> "+rs.getString( "t1 ")+ " </td> ");
out.println( " <td align=center> 2000 </td> ");
out.println( " <td align=center> "+df.format(a1)+ "% </td> ");
out.println( " <td align=center> "+a+ " </td> ");
out.println( " <td align=center> 120000 </td> ");
out.println( " <td align=center> "+df.format(b2)+ "% </td> ");
out.println( " </tr> ");
}
String AREADEF = " ";
String[][] cityArray=new String[13][3];
cityArray[0][0]= "哈 ";cityArray[0][1]= "6 ";cityArray[0][2]= "31 ";
cityArray[1][0]= "齐 ";cityArray[1][1]= "2 ";cityArray[1][2]= "14 ";
cityArray[2][0]= "佳 ";cityArray[2][1]= "1 ";cityArray[2][2]= "11 ";
cityArray[3][0]= "大 ";cityArray[3][1]= "2 ";cityArray[3][2]= "14 ";
cityArray[4][0]= "牡 ";cityArray[4][1]= "5 ";cityArray[4][2]= "11 ";
cityArray[5][0]= "绥 ";cityArray[5][1]= "1 ";cityArray[5][2]= "6 ";
cityArray[6][0]= "黑 ";cityArray[6][1]= "7 ";cityArray[6][2]= "5 ";
cityArray[7][0]= "鸡 ";cityArray[7][1]= "9 ";cityArray[7][2]= "7 ";
cityArray[8][0]= "七 ";cityArray[8][1]= "6 ";cityArray[8][2]= "4 ";
cityArray[9][0]= "鹤 ";cityArray[9][1]= "4 ";cityArray[9][2]= "4 ";
cityArray[10][0]= "双 ";cityArray[10][1]= "7 ";cityArray[10][2]= "6 ";
cityArray[11][0]= "大 ";cityArray[11][1]= "4 ";cityArray[11][2]= "1 ";
cityArray[12][0]= "伊 ";cityArray[12][1]= "6 ";cityArray[12][2]= "3 ";
for(int i=0;i <13;i++){
out.println( " <TR> ");
out.println( " <td align=center> "+cityArray[i][0]+ " </td> ");
String strSql1 = "select sum(NEW) t1,sum(CXZ) t2,sum(GXZ) t3 from tablename where riqi = '20070331 ' and AREADEF= ' "+cityArray[i][0]+ " ' or riqi = '20070430 ' and AREADEF= ' "+cityArray[i][0]+ " ' or riqi = ' "+maxDate+ " ' and AREADEF= ' "+cityArray[i][0]+ " ' ";
rs1=stmt.executeQuery(strSql1);
while(rs1.next()){
String t_1=rs1.getString( "t1 ");
String t4=rs1.getString( "t2 ");
String t5=rs1.getString( "t3 ");
int b;
b = Integer.parseInt(t4)+Integer.parseInt(t5);
double b1,b2;
double aa1;
aa1 = Double.parseDouble(t_1);
double aa_1 = Double.parseDouble(cityArray[i][1]);
double aa_2 = Double.parseDouble(cityArray[i][2]);
b1= aa1/aa_1;
b2=b/aa_2;
b1*=100;
b2*=100;
DecimalFormat df=new DecimalFormat( "# ");
out.println( " <td align=center> "+rs1.getString( "t1 ")+ " </td> ");
out.println( " <td align=center> "+cityArray[i][1]+ " </td> ");
out.println( " <td align=center> "+df.format(b1)+ "% </td> ");
out.println( " <td align=center> "+b+ " </td> ");
out.println( " <td align=center> "+cityArray[i][2]+ " </td> ");
out.println( " <td align=center> "+df.format(b2)+ "% </td> ");
}
out.println( " </TR> ");
}
out.println( " </table> ");
if(null!=conn)conn.close();conn=null;
}catch(Exception ex){
ex.printStackTrace();
if(null!=conn)conn.close();
}
if(null!=conn)conn.close();
%>
</html>
各位高手，帮帮小妹吧。我快疯了。
真是女人编程，对女人对程序都是一种折磨。
我想把这个表按照“df.format(b2)”的降序排列。谢谢了。
[解决办法]
加 Order by啊
[解决办法]
order by xx desc
[解决办法]
这代码写的!
用冒泡排序吧!这个不会,我就没办法了!
if (sortStrJ == null && sortStrI != null) {
return;
} else if (sortStrJ != null && sortStrI == null) {
isSwap = true;
} else if (sortStrJ.compareTo(sortStrI) > 0) {
isSwap = true;
}
[解决办法]
你这样写是实现不了的,你的数据是在循环里边检索的.要想排序的话,得再开一层循环来处理数据的.而且检索的数据得放在table的外边来处理.处理完了后再往页面上显示.
