不会吧`~~for(int i =0;i<300;i++){ out.println("<tr>") out.println("<td>数据1.name</td>") out.println("<td>数据2.name</td>") out.println("</tr>") }
呵呵 out.println("<table>")for(int i =0;i<300;i++){ out.println("<tr>") out.println("<td>数据1.name</td>") out.println("<td>数据2.name</td>") out.println("</tr>") } out.println("</table>")
可能是我没说清楚,要是那么简单我就不问了!!! 我的所有数据存在一个adverItem的数组里面,AdverItem[] retm = new AdverItem[n]; public class AdverItem{ public String name; public String address; public String postNum; } 所以我要显示的是retm数组,要写两层循环 第一次数据表格结构为: retm[0].name retm[1].name retm[0].address retm[1].address retm[0].postNum retm[1].address 然后每次循环按这种结构显示;不知明白与否??
自己总算解决了!!为了达到这种显示效果 我在写bean的时候改了一下,代码如下(最下面是测试代码),请指教: package adver; import adver.DbConn; import java.sql.*; import adver.AdverItem; /** * * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2003</p> * <p>Company: </p> * @author unascribed * @version 1.0 */ public class AdverList { DbConn conn = new DbConn(); Connection con = conn.getConnection(); int n=0; public AdverItem[][] getList(String yearBegin,String monthBegin,String dayBegin,String yearEnd,String monthEnd,String dayEnd){ String[] timeSection = TimeFormat.getDate(yearBegin,yearEnd,monthBegin,monthEnd,dayBegin,dayEnd); String sql = "select name,address,post_num from adver where timeSection>='"+timeSection[0]+"' and timeSection<='"+timeSection[1]+"'"; AdverItem[][] retm=null; boolean result = true; try{ Statement stmt = con.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); ResultSet rs = stmt.executeQuery(sql); rs.last(); n = rs.getRow(); retm = new AdverItem[2][n]; rs.beforeFirst(); for(int i=0;i<n;){ for(int j=0;j<2;j++){ AdverItem item = new AdverItem(); result=rs.next(); if(result==false) break; item.name = rs.getString(1); item.address = rs.getString(2); item.postNum = rs.getString(3); retm[j][i] = item; i++; } if(result==false) break; } rs.close(); stmt.close(); con.close(); }catch(Exception e){ System.out.println(e.toString()); } return retm; } public int getNum(){ return n; } public static void main(String args[]){ AdverList test = new AdverList(); String yearBegin = "2003"; String yearEnd = "2003"; String monthBegin = "4"; String monthEnd = "4"; String dayBegin = "19"; String dayEnd = "19"; AdverItem[][] item = test.getList(yearBegin,monthBegin,dayBegin,yearEnd,monthEnd,dayEnd); int num = test.getNum(); //String name = item[0][260].name; //int n = item.length; //int n = item.length; //String address = item[0].name; //System.out.println(name); for(int i=0;i<num;i++){ String name1 = item[0][i].name; System.out.println(i+name1); i++; String name2 = item[1][i].name; System.out.println(i+name2); } } }
out.println("<tr>")
out.println("<td>数据1.name</td>")
out.println("<td>数据2.name</td>")
out.println("</tr>")
}
out.println("<table>")for(int i =0;i<300;i++){
out.println("<tr>")
out.println("<td>数据1.name</td>")
out.println("<td>数据2.name</td>")
out.println("</tr>")
}
out.println("</table>")
我的所有数据存在一个adverItem的数组里面,AdverItem[] retm = new AdverItem[n];
public class AdverItem{
public String name;
public String address;
public String postNum;
}
所以我要显示的是retm数组,要写两层循环
第一次数据表格结构为:
retm[0].name retm[1].name
retm[0].address retm[1].address
retm[0].postNum retm[1].address
然后每次循环按这种结构显示;不知明白与否??
我在写bean的时候改了一下,代码如下(最下面是测试代码),请指教:
package adver;
import adver.DbConn;
import java.sql.*;
import adver.AdverItem;
/**
*
* <p>Title: </p>
* <p>Description: </p>
* <p>Copyright: Copyright (c) 2003</p>
* <p>Company: </p>
* @author unascribed
* @version 1.0
*/
public class AdverList {
DbConn conn = new DbConn();
Connection con = conn.getConnection();
int n=0; public AdverItem[][] getList(String yearBegin,String monthBegin,String dayBegin,String yearEnd,String monthEnd,String dayEnd){
String[] timeSection = TimeFormat.getDate(yearBegin,yearEnd,monthBegin,monthEnd,dayBegin,dayEnd);
String sql = "select name,address,post_num from adver where timeSection>='"+timeSection[0]+"' and timeSection<='"+timeSection[1]+"'";
AdverItem[][] retm=null;
boolean result = true;
try{
Statement stmt = con.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery(sql);
rs.last();
n = rs.getRow();
retm = new AdverItem[2][n];
rs.beforeFirst();
for(int i=0;i<n;){
for(int j=0;j<2;j++){
AdverItem item = new AdverItem();
result=rs.next();
if(result==false)
break;
item.name = rs.getString(1);
item.address = rs.getString(2);
item.postNum = rs.getString(3);
retm[j][i] = item;
i++;
}
if(result==false)
break;
}
rs.close();
stmt.close();
con.close();
}catch(Exception e){
System.out.println(e.toString());
}
return retm;
} public int getNum(){
return n;
} public static void main(String args[]){
AdverList test = new AdverList();
String yearBegin = "2003";
String yearEnd = "2003";
String monthBegin = "4";
String monthEnd = "4";
String dayBegin = "19";
String dayEnd = "19";
AdverItem[][] item = test.getList(yearBegin,monthBegin,dayBegin,yearEnd,monthEnd,dayEnd);
int num = test.getNum();
//String name = item[0][260].name;
//int n = item.length;
//int n = item.length;
//String address = item[0].name;
//System.out.println(name);
for(int i=0;i<num;i++){
String name1 = item[0][i].name;
System.out.println(i+name1);
i++;
String name2 = item[1][i].name;
System.out.println(i+name2);
}
}
}