optimize.jsp

论坛软件系统亦称电子公告板(BBS)系统

<%@ page language="java" pageEncoding="UTF-8"%>
<%@ taglib uri="/WEB-INF/c.tld" prefix="c"%>
<jsp:include page="../cp_header.jsp" />
<table width="100%" border="0" cellpadding="0" cellspacing="0" class="guide">
	<tr><td><a href="#" onclick="parent.menu.location='admincp.jsp?action=menu'; parent.main.location='admincp.jsp?action=home';return false;">系统设置首页</a>&nbsp;&raquo;&nbsp;数据表优化</td></tr>
</table>
<br />
<table width="100%" border="0" cellpadding="0" cellspacing="0" class="tableborder">
	<tr class="header"><td><div style="float:left; margin-left:0px; padding-top:8px"><a href="###" onclick="collapse_change('tip')">技巧提示</a></div><div style="float:right; margin-right:4px; padding-bottom:9px"><a href="###" onclick="collapse_change('tip')"><img id="menuimg_tip" src="images/admincp/menu_${collapsed ? 'add' : 'reduce'}.gif" border="0"/></a></div></td></tr>
	<tbody id="menu_tip" style="display: ${collapsed ? 'none' : ''}">
		<tr><td><ul><li>数据表优化可以去除数据文件中的碎片，使记录排列紧密，提高读写速度。</ul></td></tr>
	</tbody>
</table>
<br />
<form name="optimize" method="post" action="admincp.jsp?action=optimize">
	<table width="100%" border="0" cellpadding="0" cellspacing="0" class="tableborder">
		<tr class="header"><td><input class="checkbox" type="checkbox" name="chkall" class="header" onclick="checkall(this.form)" checked>优化?</td><td>数据表</td><td>类型</td><td>记录数</td><td>数据</td><td>索引</td><td>碎片</td></tr>
		<c:choose>
			<c:when test="${type=='optimize'}"><c:forEach items="${tableStatusVOs}" var="tableStatusVO"><tr><td class="altbg1" align="center">${tableStatusVO.data_free>0?"否":"是"}</td><td class="altbg2" align="center">${tableStatusVO.name}</td><td class="altbg1" align="center">${tableStatusVO.engine}</td><td class="altbg2" align="center">${tableStatusVO.rows}</td><td class="altbg1" align="center">${tableStatusVO.data_length}</td><td class="altbg2" align="center">${tableStatusVO.index_length}</td><td class="altbg1" align="center">${tableStatusVO.data_free}</td></tr></c:forEach></c:when>
			<c:otherwise><c:forEach items="${tableStatusVOs}" var="tableStatusVO"><c:if test="${tableStatusVO.data_free>0}"><tr><td class="altbg1" align="center"><input class="checkbox" type="checkbox" name="optimizetables" value="${tableStatusVO.name}" checked></td><td class="altbg2" align="center">${tableStatusVO.name}</td><td class="altbg1" align="center">${tableStatusVO.engine}</td><td class="altbg2" align="center">${tableStatusVO.rows}</td><td class="altbg1" align="center">${tableStatusVO.data_length}</td><td class="altbg2" align="center">${tableStatusVO.index_length}</td><td class="altbg1" align="center">${tableStatusVO.data_free}</td></tr></c:if></c:forEach></c:otherwise>
		</c:choose>
		<tr><td colspan="7" align="right"><c:choose><c:when test="${totalsize!=''}">尺寸 ${totalsize}</c:when><c:otherwise>数据表没有碎片，不需要再优化。</c:otherwise></c:choose></td></tr>
	</table>
	<c:if test="${type!='optimize'&&totalsize!=''}"><br /><center><input class="button" type="submit" name="optimizesubmit" value="提 交"></center></c:if>
</form>
<jsp:include page="../cp_footer.jsp" />