<%@ page contentType="text/html; charset=UTF-8" language="java"%> <%@ page import ="com.sysmodel.datamodel.xmlmodel.ModelFactory, com.sysmodel.datamodel.xmlmodel.able.SysModel, com.sysmodel.datamodel.xmlmodel.impl.MdpDataSourceImpl, com.sysmodel.datamodel.xmlmodel.able.MdpDataSource, com.persistence.DBdll.adapter.DatabaseAdapter, com.persistence.DBdll.DatabaseFactory, com.persistence.DBdll.adapter.assitant.index.IndexInfo, java.util.ArrayList" %> <% SysModel sysmodel = ModelFactory.getSysmodel(); MdpDataSource datasource = sysmodel.getDataSourceByCode(1); DatabaseAdapter Dbadapter = DatabaseFactory.getInstance(datasource); ArrayList indlis = Dbadapter.getTableIndexInfo(); String title = sysmodel.getUnitname()+"("+sysmodel.getUnitCode()+")数据库字段索引创建情况一览"; %>

<%=title %>

<%for(int i = 0; i < indlis.size(); i ++){ IndexInfo IndexInfo = indlis.get(i); %> <% } %>

<%=title %>
序号	表名	索引名称	类型	字段
<%=i+1%>	<%=IndexInfo.getTabName()%>	<%=IndexInfo.getIndexName()%>	<%=IndexInfo.getIndexType()%>	<%=IndexInfo.getColumNames()%>