<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="common.*" %>
<jsp:useBean id="record" scope="page" class="ElementInfoBean"/>
<jsp:useBean id="element" class="ElementInfo" scope="page"/>
<%
//浏览数据结果部分
//获取查询条件的sql语句
String sql = "SELECT * FROM ElementInfo";
System.out.println("sql is "+sql+"\n");
System.out.println("1111"+request.getParameter("PM")+"222");
String pm = request.getParameter("PM");
System.out.println("name is "+ pm +"\n");
if(pm!=null&&(!pm.equals("null")))
{
String[] pms = pm.trim().replaceAll("'","''").split(" ");
sql = sql + " WHERE 1<>1";
int i = 0;
for(i=0;i<pms.length;i++)
{
String field = pms[i];
sql = sql + " OR UPPER(Name) LIKE '%"+ field.toUpperCase()
+ "%' OR UPPER(ElementID) LIKE '%" + field.toUpperCase()
+ "%'";
} }//执行查询
java.util.Vector v = element.searchElement(sql);
System.out.println("search result is "+ v.get(0).toString()+"\n");//分页显示结果用参数
int EveryPage=10;//每页显示的记录数;
int OnPage=1; //当前显示的页数;
int Total=0;//记录的总数;
int TotalPage=0;//记录的总页数;
java.util.Vector result = (java.util.Vector)v.get(1);
System.out.println("v.get(1)"+result.toString()+"\n");
Total = result.size();
if(Total%EveryPage==0)
TotalPage=Total/EveryPage;
else
TotalPage=Total/EveryPage+1;
//取得文本框输入的值;
String Pages=request.getParameter("Pages");if(Pages!=null)
{
OnPage=Integer.parseInt(Pages);//把Pages转换为整型;
//根据输入的值,判断应显示的页;
if(OnPage>TotalPage)
{
OnPage=TotalPage;
}
else if(OnPage<=0)
{
OnPage=1;
}
}
System.out.println("nnd is over!");%>
<!-- define the title for the page -->
<% String titleStr="Welcome to MetaData Registry of SDB"; %>
<%@ include file="/comm/header.jsp"%><table width="95%" border="0" cellspacing="4" cellpadding="2" height="80%">
<tr valign="top" >
<td>
<!-- This table can be seperated into an independent part for easy reausable! -->
</td> <td align="center">
<table width="100%" cellpadding="1" cellspacing="2" bordercolor="#FFFFFF">
<tr>
<td colspan="4" height="20"><div align="center"><font size="+2"><strong><div>浏览元素</div></strong></font></div></td>
</tr>
<tr><td colspan="4" height="10"></td></tr> </tr>
<tr bgcolor="#363466">
<th bgcolor="#999999" width="41%"><div align="left"><font color="#FFFFFF">名称</font></div></th>
<th colspan="3" bgcolor="#999999"><div align="left"><font color="#FFFFFF">标识</font></div></th> </tr>
<!--分页列出查询结果-->
<%
for(int i=1;i<=EveryPage;i++)
{
int j = (OnPage-1)*EveryPage+(i-1);
ElementInfoBean mybean = new ElementInfoBean();
if(j < Total)
{
mybean = (ElementInfoBean)result.get(j);
}
else
{
break;
} %>
<tr bgcolor="#CCCCCC"> <td width="41%"><%=mybean.getName()%></td>
<td colspan="2"><%=mybean.getElementID()%></td>
<td width="7%"><a href=elementDetail.jsp?ElementID=<%=mybean.getElementID()%>>详细</a></td>
</tr>
<% } %>
<tr>
<form action="browsElement.jsp" method="POST">
<th colspan="2"><div align="left">元素查询
<input name="PM" type="text"size="18" height="20">
<input type="submit" name="query" value="查询" size="20" ></div></th>
</form> <th colspan="2">
<%
for(int i=1;i<=TotalPage;i++)
{
String p = String.valueOf(i);
%>
<a href=browsElement.jsp?PM=<%=pm%>&Pages=<%=p%>><%= p %></a>
<%
}%> </th>
</tr></table>
</td> </tr> <tr> <td colspan="2"> <hr noshade size="1"> </td>
</tr>
</table>
<%@ include file="/comm/footer.jsp"%>
<%@ page import="common.*" %>
<jsp:useBean id="record" scope="page" class="ElementInfoBean"/>
<jsp:useBean id="element" class="ElementInfo" scope="page"/>
<%
//浏览数据结果部分
//获取查询条件的sql语句
String sql = "SELECT * FROM ElementInfo";
System.out.println("sql is "+sql+"\n");
System.out.println("1111"+request.getParameter("PM")+"222");
String pm = request.getParameter("PM");
System.out.println("name is "+ pm +"\n");
if(pm!=null&&(!pm.equals("null")))
{
String[] pms = pm.trim().replaceAll("'","''").split(" ");
sql = sql + " WHERE 1<>1";
int i = 0;
for(i=0;i<pms.length;i++)
{
String field = pms[i];
sql = sql + " OR UPPER(Name) LIKE '%"+ field.toUpperCase()
+ "%' OR UPPER(ElementID) LIKE '%" + field.toUpperCase()
+ "%'";
} }//执行查询
java.util.Vector v = element.searchElement(sql);
System.out.println("search result is "+ v.get(0).toString()+"\n");//分页显示结果用参数
int EveryPage=10;//每页显示的记录数;
int OnPage=1; //当前显示的页数;
int Total=0;//记录的总数;
int TotalPage=0;//记录的总页数;
java.util.Vector result = (java.util.Vector)v.get(1);
System.out.println("v.get(1)"+result.toString()+"\n");
Total = result.size();
if(Total%EveryPage==0)
TotalPage=Total/EveryPage;
else
TotalPage=Total/EveryPage+1;
//取得文本框输入的值;
String Pages=request.getParameter("Pages");if(Pages!=null)
{
OnPage=Integer.parseInt(Pages);//把Pages转换为整型;
//根据输入的值,判断应显示的页;
if(OnPage>TotalPage)
{
OnPage=TotalPage;
}
else if(OnPage<=0)
{
OnPage=1;
}
}
System.out.println("nnd is over!");%>
<!-- define the title for the page -->
<% String titleStr="Welcome to MetaData Registry of SDB"; %>
<%@ include file="/comm/header.jsp"%><table width="95%" border="0" cellspacing="4" cellpadding="2" height="80%">
<tr valign="top" >
<td>
<!-- This table can be seperated into an independent part for easy reausable! -->
</td> <td align="center">
<table width="100%" cellpadding="1" cellspacing="2" bordercolor="#FFFFFF">
<tr>
<td colspan="4" height="20"><div align="center"><font size="+2"><strong><div>浏览元素</div></strong></font></div></td>
</tr>
<tr><td colspan="4" height="10"></td></tr> </tr>
<tr bgcolor="#363466">
<th bgcolor="#999999" width="41%"><div align="left"><font color="#FFFFFF">名称</font></div></th>
<th colspan="3" bgcolor="#999999"><div align="left"><font color="#FFFFFF">标识</font></div></th> </tr>
<!--分页列出查询结果-->
<%
for(int i=1;i<=EveryPage;i++)
{
int j = (OnPage-1)*EveryPage+(i-1);
ElementInfoBean mybean = new ElementInfoBean();
if(j < Total)
{
mybean = (ElementInfoBean)result.get(j);
}
else
{
break;
} %>
<tr bgcolor="#CCCCCC"> <td width="41%"><%=mybean.getName()%></td>
<td colspan="2"><%=mybean.getElementID()%></td>
<td width="7%"><a href=elementDetail.jsp?ElementID=<%=mybean.getElementID()%>>详细</a></td>
</tr>
<% } %>
<tr>
<form action="browsElement.jsp" method="POST">
<th colspan="2"><div align="left">元素查询
<input name="PM" type="text"size="18" height="20">
<input type="submit" name="query" value="查询" size="20" ></div></th>
</form> <th colspan="2">
<%
for(int i=1;i<=TotalPage;i++)
{
String p = String.valueOf(i);
%>
<a href=browsElement.jsp?PM=<%=pm%>&Pages=<%=p%>><%= p %></a>
<%
}%> </th>
</tr></table>
</td> </tr> <tr> <td colspan="2"> <hr noshade size="1"> </td>
</tr>
</table>
<%@ include file="/comm/footer.jsp"%>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货