jsp
<s:iterator value="list" status="st">
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#336699" style="border-collapse:collapse;">
<tr height="25" height="25" style="font-size:12px" align="center" >
<td width="3%" align="center"><s:property value="#st.count" /></td>
<td width="6%" align="center"><s:property value="ip" /></td>
<td width="5%" align="center"><s:property value="jigui" /></td>
<td width="13%" align="center"><s:property value="zhuban" /></td>
<td width="9%" align="center"><s:property value="cpu" /></td>
<td width="9%" align="center"><s:property value="neicun" /></td>
<td width="9%" align="center"><s:property value="yingpan" /></td>
<s:set name="name" value="chanquan" />
<s:if test="#name == 1">
<td width="9%" align="center" background="black"><font color="red" >公司所有</font> </td>
</s:if>
<s:if test="#name == 0">
<td width="9%" align="center"><font color="green" >客户所有</font> </td>
</s:if>
<td width="9%" align="center"><s:property value="dianyuan" /></td>
<td width="9%" align="center"><s:property value="jixiang" /></td>
<td width="9%" align="center"><s:property value="beizhu" /></td>
<td width="5%" align="center">
<s:url id="update" action="companyUpdate">
<s:param name="ip">
<s:property value="ip" />
</s:param>
<s:param name="id">
<s:property value="id" />
</s:param>
<s:param name="jigui">
<s:property value="jigui" />
</s:param>
<s:param name="zhuban">
<s:property value="zhuban" />
</s:param>
<s:param name="cpu">
<s:property value="cpu" />
</s:param>
<s:param name="neicun">
<s:property value="neicun" />
</s:param>
<s:param name="yingpan">
<s:property value="yingpan" />
</s:param>
<s:param name="chanquan">
<s:property value="chanquan" />
</s:param>
<s:param name="dianyuan">
<s:property value="dianyuan" />
</s:param>
<s:param name="jixiang">
<s:property value="jixiang" />
</s:param>
<s:param name="beizhu">
<s:property value="beizhu" />
</s:param>
</s:url>
<s:a href="%{update}"><font color="red">修改</font></s:a>
</td>
<td width="13%" align="center">
<s:url id="delete" action="companyDelete">
<s:param name="id">
<s:property value="id" />
</s:param>
</s:url>
<s:a href="%{delete}">删除</s:a>
</td>
</tr>
</table>
</s:iterator>查询300条已经5秒钟了 为什么<s:iterator>循环加载速度那么慢
java
public List<IPBean> select() {
List<IPBean> list = null;
try {
list = super.queryForList("ip_show");
} catch (Exception e) {
e.printStackTrace();
}
return list;
}ibatis
<!-- 电脑信息查询 -->
<select id="ip_show" parameterClass="ip" resultClass="ip" >
SELECT *
FROM ip order by id desc
</select>
bean
/**
*
*/
package com.jinkun.youdebao.bean;/**
* @author
*
*/
public class IPBean {
private Integer id;
private String ip;
private String jigui;
private String zhuban;
private String cpu;
private String neicun;
private String yingpan;
private String chanquan;
private String beizhu;
private String dianyuan;
private String jixiang;
public String getJixiang() {
return jixiang;
} public void setJixiang(String jixiang) {
this.jixiang = jixiang;
} public String getIp() {
return ip;
} public void setIp(String ip) {
this.ip = ip;
} public String getJigui() {
return jigui;
} public void setJigui(String jigui) {
this.jigui = jigui;
} public String getZhuban() {
return zhuban;
} public void setZhuban(String zhuban) {
this.zhuban = zhuban;
} public String getCpu() {
return cpu;
} public void setCpu(String cpu) {
this.cpu = cpu;
} public String getNeicun() {
return neicun;
} public void setNeicun(String neicun) {
this.neicun = neicun;
} public String getYingpan() {
return yingpan;
} public void setYingpan(String yingpan) {
this.yingpan = yingpan;
} public String getChanquan() {
return chanquan;
} public void setChanquan(String chanquan) {
this.chanquan = chanquan;
} public String getBeizhu() {
return beizhu;
} public void setBeizhu(String beizhu) {
this.beizhu = beizhu;
} public String getDianyuan() {
return dianyuan;
} public void setDianyuan(String dianyuan) {
this.dianyuan = dianyuan;
} public Integer getId() {
return id;
} public void setId(Integer id) {
this.id = id;
}
}
<s:iterator value="list" status="st">
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#336699" style="border-collapse:collapse;">
<tr height="25" height="25" style="font-size:12px" align="center" >
<td width="3%" align="center"><s:property value="#st.count" /></td>
<td width="6%" align="center"><s:property value="ip" /></td>
<td width="5%" align="center"><s:property value="jigui" /></td>
<td width="13%" align="center"><s:property value="zhuban" /></td>
<td width="9%" align="center"><s:property value="cpu" /></td>
<td width="9%" align="center"><s:property value="neicun" /></td>
<td width="9%" align="center"><s:property value="yingpan" /></td>
<s:set name="name" value="chanquan" />
<s:if test="#name == 1">
<td width="9%" align="center" background="black"><font color="red" >公司所有</font> </td>
</s:if>
<s:if test="#name == 0">
<td width="9%" align="center"><font color="green" >客户所有</font> </td>
</s:if>
<td width="9%" align="center"><s:property value="dianyuan" /></td>
<td width="9%" align="center"><s:property value="jixiang" /></td>
<td width="9%" align="center"><s:property value="beizhu" /></td>
<td width="5%" align="center">
<s:url id="update" action="companyUpdate">
<s:param name="ip">
<s:property value="ip" />
</s:param>
<s:param name="id">
<s:property value="id" />
</s:param>
<s:param name="jigui">
<s:property value="jigui" />
</s:param>
<s:param name="zhuban">
<s:property value="zhuban" />
</s:param>
<s:param name="cpu">
<s:property value="cpu" />
</s:param>
<s:param name="neicun">
<s:property value="neicun" />
</s:param>
<s:param name="yingpan">
<s:property value="yingpan" />
</s:param>
<s:param name="chanquan">
<s:property value="chanquan" />
</s:param>
<s:param name="dianyuan">
<s:property value="dianyuan" />
</s:param>
<s:param name="jixiang">
<s:property value="jixiang" />
</s:param>
<s:param name="beizhu">
<s:property value="beizhu" />
</s:param>
</s:url>
<s:a href="%{update}"><font color="red">修改</font></s:a>
</td>
<td width="13%" align="center">
<s:url id="delete" action="companyDelete">
<s:param name="id">
<s:property value="id" />
</s:param>
</s:url>
<s:a href="%{delete}">删除</s:a>
</td>
</tr>
</table>
</s:iterator>查询300条已经5秒钟了 为什么<s:iterator>循环加载速度那么慢
java
public List<IPBean> select() {
List<IPBean> list = null;
try {
list = super.queryForList("ip_show");
} catch (Exception e) {
e.printStackTrace();
}
return list;
}ibatis
<!-- 电脑信息查询 -->
<select id="ip_show" parameterClass="ip" resultClass="ip" >
SELECT *
FROM ip order by id desc
</select>
bean
/**
*
*/
package com.jinkun.youdebao.bean;/**
* @author
*
*/
public class IPBean {
private Integer id;
private String ip;
private String jigui;
private String zhuban;
private String cpu;
private String neicun;
private String yingpan;
private String chanquan;
private String beizhu;
private String dianyuan;
private String jixiang;
public String getJixiang() {
return jixiang;
} public void setJixiang(String jixiang) {
this.jixiang = jixiang;
} public String getIp() {
return ip;
} public void setIp(String ip) {
this.ip = ip;
} public String getJigui() {
return jigui;
} public void setJigui(String jigui) {
this.jigui = jigui;
} public String getZhuban() {
return zhuban;
} public void setZhuban(String zhuban) {
this.zhuban = zhuban;
} public String getCpu() {
return cpu;
} public void setCpu(String cpu) {
this.cpu = cpu;
} public String getNeicun() {
return neicun;
} public void setNeicun(String neicun) {
this.neicun = neicun;
} public String getYingpan() {
return yingpan;
} public void setYingpan(String yingpan) {
this.yingpan = yingpan;
} public String getChanquan() {
return chanquan;
} public void setChanquan(String chanquan) {
this.chanquan = chanquan;
} public String getBeizhu() {
return beizhu;
} public void setBeizhu(String beizhu) {
this.beizhu = beizhu;
} public String getDianyuan() {
return dianyuan;
} public void setDianyuan(String dianyuan) {
this.dianyuan = dianyuan;
} public Integer getId() {
return id;
} public void setId(Integer id) {
this.id = id;
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货