<%@ page contentType="text/html; charset=UTF-8" language="java"%> <%@ page import="java.util.*"%> <%@ page import="com.sysmodel.datamodel.xmlmodel.ModelFactory, com.sysmodel.datamodel.xmlmodel.able.MdpConstant, com.sysmodel.datamodel.xmlmodel.able.SysModel, com.persistence.DBdll.SysOperator, com.sysmodel.datamodel.xmlmodel.able.MdpClass"%> <% String sourcecode = request.getParameter("sourcecode"); SysModel sysmodel = ModelFactory.getSysmodel(); if(sourcecode == null) return; SysOperator SysOperator = new SysOperator(); ArrayList xmltablelist = sysmodel.getMdpClassByDataSource(Integer.parseInt(sourcecode)); ArrayList xmlMdpConstantlist = sysmodel.getMdpConstantByDataSource(Integer.parseInt(sourcecode)); %> <%! SysModel sysmodel = ModelFactory.getSysmodel(); public String getClassIds(int number){ StringBuffer sb = new StringBuffer(); //提供的推荐编码个数 int getNum = 5; int iToNumber = number + 100; sb.append("{"+number + "～" + iToNumber + "推荐编号 : "); int iget = 0; for(int i = number; i < iToNumber; i ++){ if(iget > getNum) break; if(sysmodel.getMdpClassByClassID(i) == null){ sb.append(" "+ i +" "); iget ++; } } sb.append("}"); return sb.toString(); } public boolean isTableExist(String tableName , ArrayList xmltablelist,ArrayList MdpConstantlist){ boolean flag = true; int iFalg = 0; for (int i = 0 ; i < xmltablelist.size() ; i++){ MdpClass mdpClass = (MdpClass)xmltablelist.get(i); if(mdpClass.getName().toUpperCase().equals(tableName.toUpperCase())){ iFalg ++; } } for (int i = 0 ; i < MdpConstantlist.size() ; i++){ MdpConstant mdpConstant = (MdpConstant)MdpConstantlist.get(i); if(mdpConstant.getCodeName().toUpperCase().equals(tableName.toUpperCase())){ iFalg ++; } } if (iFalg > 0){ flag = false; } return flag; } %>
1
数据库中表的管理—（列出配置文件没有管理到的表）