求大神给点代码如何用javabean+jsp循环取出mysql数据库里的数据
求大神给点代码怎么用javabean+jsp循环取出mysql数据库里的数据
我现在数据库里表里有40组数据吧,每组数据包含4个数据(A1,A2,A3,A4),现在我能取出全部数据显示在jsp网页上,我需要怎么样能把数据循环取出来看,比如每次取20组数据,1到20取完显示出来,接下来从2开始取2到21........以此类推,最好能把20组数据取出来赋值给一个二维数组C[][],求大神帮忙给点指导,万分感谢,问题解决立马给分。
------解决思路----------------------
例如:
if (catattrList != null && catattrList.size() > 0) {%>
<%Hashtable aMap = new Hashtable();
for (int i = 0; i < catattrList.size(); i++) {
aMap = (Hashtable) catattrList.get(i);
String attr_name = "", default_value = "", attr_id = "", en_name = "";
if (aMap.get("attr_id") != null)
attr_id = aMap.get("attr_id").toString();
if (aMap.get("attr_name") != null)
attr_name = aMap.get("attr_name").toString();
if (aMap.get("default_value") != null)
default_value = aMap.get("default_value").toString();
if (aMap.get("en_name") != null)
en_name = aMap.get("en_name").toString();%>
<dl class="lastline">
<dt><%=attr_name %>:</dt>
<dd id="sizeArea" class="sizeArea"> <em class="selecteall"><a style="color:#ffffff;" href="javascript:dealCatattr('attr_desc_para','')">全部</a></em>
<ul class="size" id="size">
<%if (!default_value.equals("")&& default_value.indexOf("
------解决思路----------------------
") > -1) {
String deStr[] = default_value.split("\\
------解决思路----------------------
");
if (deStr.length > 0) {
for (int j = 0; j < deStr.length; j++) {
String deStr_name = deStr[j];
String attr_str = attr_id + "
------解决思路----------------------
" + deStr_name
+ ",";%>
<li>
<%
if(attr_str.equals(cat_desc)){%>
<a style="<%=a_class %>" href="javascript:dealCatattr('attr_desc_para','<%=attr_str%>')"><%=deStr_name %></a>
<%}else{%>
<a href="javascript:dealCatattr('attr_desc_para','<%=attr_str%>')"><%=deStr_name %></a>
<%}
%>
</li>
<%}
}
}%>
</ul>
<a style="display: none;" class="selectemore" href="#">更多</a> </dd>
<dd class="clear"></dd>
</dl>
<%}}
我现在数据库里表里有40组数据吧,每组数据包含4个数据(A1,A2,A3,A4),现在我能取出全部数据显示在jsp网页上,我需要怎么样能把数据循环取出来看,比如每次取20组数据,1到20取完显示出来,接下来从2开始取2到21........以此类推,最好能把20组数据取出来赋值给一个二维数组C[][],求大神帮忙给点指导,万分感谢,问题解决立马给分。
------解决思路----------------------
例如:
if (catattrList != null && catattrList.size() > 0) {%>
<%Hashtable aMap = new Hashtable();
for (int i = 0; i < catattrList.size(); i++) {
aMap = (Hashtable) catattrList.get(i);
String attr_name = "", default_value = "", attr_id = "", en_name = "";
if (aMap.get("attr_id") != null)
attr_id = aMap.get("attr_id").toString();
if (aMap.get("attr_name") != null)
attr_name = aMap.get("attr_name").toString();
if (aMap.get("default_value") != null)
default_value = aMap.get("default_value").toString();
if (aMap.get("en_name") != null)
en_name = aMap.get("en_name").toString();%>
<dl class="lastline">
<dt><%=attr_name %>:</dt>
<dd id="sizeArea" class="sizeArea"> <em class="selecteall"><a style="color:#ffffff;" href="javascript:dealCatattr('attr_desc_para','')">全部</a></em>
<ul class="size" id="size">
<%if (!default_value.equals("")&& default_value.indexOf("
------解决思路----------------------
") > -1) {
String deStr[] = default_value.split("\\
------解决思路----------------------
");
if (deStr.length > 0) {
for (int j = 0; j < deStr.length; j++) {
String deStr_name = deStr[j];
String attr_str = attr_id + "
------解决思路----------------------
" + deStr_name
+ ",";%>
<li>
<%
if(attr_str.equals(cat_desc)){%>
<a style="<%=a_class %>" href="javascript:dealCatattr('attr_desc_para','<%=attr_str%>')"><%=deStr_name %></a>
<%}else{%>
<a href="javascript:dealCatattr('attr_desc_para','<%=attr_str%>')"><%=deStr_name %></a>
<%}
%>
</li>
<%}
}
}%>
</ul>
<a style="display: none;" class="selectemore" href="#">更多</a> </dd>
<dd class="clear"></dd>
</dl>
<%}}