HTML代码如下:<body leftMargin="30" topMargin="40" marginheight="0" marginwidth="0" bgcolor="#f2f8ff" text="#000000" >
<%
String type = ""; //属于某类专辑,歌手....
String columnname = "";
String id ="";
int size = 0;
String key = "";
StringBuffer strBuff = new StringBuffer();
String query = "";
if(request.getParameter("columnname")!= null)
columnname = request.getParameter("columnname").toString();
if(request.getParameter("id")!=null)
id = request.getParameter("id").toString();
if(request.getParameter("key")!= null)
key = request.getParameter("key").toString();
if(request.getParameter("type")!= null)
type = request.getParameter("type").toString();
if("1".equals(type)) {
strBuff.append("SELECT a.id,a.name,a.singertype FROM T_SINGER a,T_RELATION b where a.id=b.relationid and b.relationtypeid = 10 and b.srcid= ");
strBuff.append(id);
if (!"".equals(key)) {
strBuff.append(" and a.name like '%").append(Translate.TransGbToIso(key)).append("%' ");
}
}
else if("2".equals(type)) {
strBuff.append("SELECT a.id,a.subject,a.wind,a.local,a.lang FROM T_SONG a,T_RELATION b where a.id=b.relationid and b.relationtypeid = 10 and b.srcid= ");
strBuff.append(id);
if (!"".equals(key)) {
strBuff.append(" and a.subject like '%").append(Translate.TransGbToIso(key)).append("%' ");
}
}
else if("3".equals(type)) {
strBuff.append("SELECT a.id,a.subject,a.wind,a.local,a.lang FROM T_SPECIAL a,T_RELATION b where a.id=b.relationid and b.relationtypeid = 10 and b.srcid= ");
strBuff.append(id);
if (!"".equals(key)) {
strBuff.append(" and a.subject like '%").append(Translate.TransGbToIso(key)).append("%' ");
}
}
else if("4".equals(type)) {
strBuff.append("SELECT a.id,a.name FROM T_DISC_COM a,T_RELATION b where a.id=b.relationid and b.relationtypeid = 10 and b.srcid= ");
strBuff.append(id);
if (!"".equals(key)) {
strBuff.append(" and a.name like '%").append(Translate.TransGbToIso(key)).append("%' ");
}
}
else if("5".equals(type)) {
strBuff.append("SELECT a.id,a.subject,a.contenttype FROM T_CONTENT a,T_RELATION b where a.id=b.relationid and b.relationtypeid = 10 and b.srcid= ");
strBuff.append(id);
if (!"".equals(key)) {
strBuff.append(" and a.subject like '%").append(Translate.TransGbToIso(key)).append("%' ");
}
}
query = strBuff.toString();
session.setAttribute("sqlStr",query);
List list = pq.myQuery(query, request);
String bar = pq.PageLegendUp(); //读取分页提示栏
if(list!=null&&list.size()>0){
%>
<form action='./editdetail.jsp' name='form1' method='post'>
<input type="hidden" name="columnname" value="<%=columnname%>" >
<input type="hidden" name="id" value="<%=id%>" >
<input type="hidden" name="type" value="<%=type%>" >
<input type="hidden" name="key" value="<%=key%>" >
<input type="hidden" name="offset" >
</form>
<form name="EditData" method="post" action="EditData">
<input type="hidden" name="columnname" value="<%=columnname%>" >
<input type="hidden" name="id" value="<%=id%>" >
<input type="hidden" name="type" value="<%=type%>" >
<table border="0" cellpadding="0" cellspacing="10" width="100%" id="parentTable">
<TR vAlign="middle">
<TD align="center" width="100%">
你输入的栏目名:<font size="2" color="red"><%=columnname%></font>
<br>
<BR>
</TD>
</TR>
<TR vAlign="middle">
<TD align="center">
<%
for(int i=0;i<list.size();i++) {
List rsList = (ArrayList)list.get(i);
if (size == 0 ) size = rsList.size();
Iterator it =rsList.iterator();
%>
<table border=0 class="dragTable" cellspacing="0">
<tr align="Center" valign="Middle" style="color:#330099;">
<% if (it.hasNext()) {
String entry =(String) it.next();
%>
<td width=15%><input type="checkbox" name="checkbox<%=i%>" value ="<%=entry%>" > <%=entry%></td><td id="<%=entry%>"></td>
<% }
while (it.hasNext()) {
%>
<td width="20%">
<%String entry =(String) it.next();
out.println(entry);
%>
</td>
<% } %>
</tr></table>
<% } %>
</table><table>
<tr align="Center" valign="Middle" style="color:#330099;">
<td colspan =<%=size+1%>><%=bar%></td>
</tr>
</table></TD>
</TR>
</table>
<TABLE> <table>
<TR vAlign="middle">
<TD align="center" width="100%">
<br>
<BR>
全部选中 <input type="checkbox" name="check_all" size="6" onclick="javascript:CheckNone()" > <input type="button" style="BORDER-RIGHT: 1px ridge; BORDER-TOP: 1px ridge; FONT-SIZE: 10pt; BORDER-LEFT: 1px ridge; BORDER-BOTTOM: 1px ridge; FONT-FAMILY: 宋体; BACKGROUND-COLOR: #8ebae6" onclick="javascript:accessTrue()" value=" 删 除 " >
</TD>
</TR>
<TR vAlign="middle">
<TD align="center" width="100%">
<br>
<BR>
<input type="text" name="key" size="30" maxlength="30" Class="textbox" > <input type="button" style="BORDER-RIGHT: 1px ridge; BORDER-TOP: 1px ridge; FONT-SIZE: 10pt; BORDER-LEFT: 1px ridge; BORDER-BOTTOM: 1px ridge; FONT-FAMILY: 宋体; BACKGROUND-COLOR: #8ebae6" onclick="javascript:doClick1()" value=" 查 找 " >
</TD>
</TR>
</TABLE>
<%}
else{ %>
<table cellspacing="0" cellpadding="4" bordercolor="#009999" border="1" style="border-color:#009999;border-width:1px;border-style:solid;font-size:Smaller;width:70%;border-collapse:collapse;">
<tr align="Center" style="background-color:#EBF5F1;">
<td>没有你要选择的记录</td>
</tr>
<TR vAlign="middle">
<TD align="center" width="100%">
<input type="button" style="BORDER-RIGHT: 1px ridge; BORDER-TOP: 1px ridge; FONT-SIZE: 10pt; BORDER-LEFT: 1px ridge; BORDER-BOTTOM: 1px ridge; FONT-FAMILY: 宋体; BACKGROUND-COLOR: #8ebae6" onclick="javascript:transfer()" value=" 返回上一页 " >
<br>
<BR>
</TD>
</TR>
<table>
<% } %></form>
</body>
</html>
<%
String type = ""; //属于某类专辑,歌手....
String columnname = "";
String id ="";
int size = 0;
String key = "";
StringBuffer strBuff = new StringBuffer();
String query = "";
if(request.getParameter("columnname")!= null)
columnname = request.getParameter("columnname").toString();
if(request.getParameter("id")!=null)
id = request.getParameter("id").toString();
if(request.getParameter("key")!= null)
key = request.getParameter("key").toString();
if(request.getParameter("type")!= null)
type = request.getParameter("type").toString();
if("1".equals(type)) {
strBuff.append("SELECT a.id,a.name,a.singertype FROM T_SINGER a,T_RELATION b where a.id=b.relationid and b.relationtypeid = 10 and b.srcid= ");
strBuff.append(id);
if (!"".equals(key)) {
strBuff.append(" and a.name like '%").append(Translate.TransGbToIso(key)).append("%' ");
}
}
else if("2".equals(type)) {
strBuff.append("SELECT a.id,a.subject,a.wind,a.local,a.lang FROM T_SONG a,T_RELATION b where a.id=b.relationid and b.relationtypeid = 10 and b.srcid= ");
strBuff.append(id);
if (!"".equals(key)) {
strBuff.append(" and a.subject like '%").append(Translate.TransGbToIso(key)).append("%' ");
}
}
else if("3".equals(type)) {
strBuff.append("SELECT a.id,a.subject,a.wind,a.local,a.lang FROM T_SPECIAL a,T_RELATION b where a.id=b.relationid and b.relationtypeid = 10 and b.srcid= ");
strBuff.append(id);
if (!"".equals(key)) {
strBuff.append(" and a.subject like '%").append(Translate.TransGbToIso(key)).append("%' ");
}
}
else if("4".equals(type)) {
strBuff.append("SELECT a.id,a.name FROM T_DISC_COM a,T_RELATION b where a.id=b.relationid and b.relationtypeid = 10 and b.srcid= ");
strBuff.append(id);
if (!"".equals(key)) {
strBuff.append(" and a.name like '%").append(Translate.TransGbToIso(key)).append("%' ");
}
}
else if("5".equals(type)) {
strBuff.append("SELECT a.id,a.subject,a.contenttype FROM T_CONTENT a,T_RELATION b where a.id=b.relationid and b.relationtypeid = 10 and b.srcid= ");
strBuff.append(id);
if (!"".equals(key)) {
strBuff.append(" and a.subject like '%").append(Translate.TransGbToIso(key)).append("%' ");
}
}
query = strBuff.toString();
session.setAttribute("sqlStr",query);
List list = pq.myQuery(query, request);
String bar = pq.PageLegendUp(); //读取分页提示栏
if(list!=null&&list.size()>0){
%>
<form action='./editdetail.jsp' name='form1' method='post'>
<input type="hidden" name="columnname" value="<%=columnname%>" >
<input type="hidden" name="id" value="<%=id%>" >
<input type="hidden" name="type" value="<%=type%>" >
<input type="hidden" name="key" value="<%=key%>" >
<input type="hidden" name="offset" >
</form>
<form name="EditData" method="post" action="EditData">
<input type="hidden" name="columnname" value="<%=columnname%>" >
<input type="hidden" name="id" value="<%=id%>" >
<input type="hidden" name="type" value="<%=type%>" >
<table border="0" cellpadding="0" cellspacing="10" width="100%" id="parentTable">
<TR vAlign="middle">
<TD align="center" width="100%">
你输入的栏目名:<font size="2" color="red"><%=columnname%></font>
<br>
<BR>
</TD>
</TR>
<TR vAlign="middle">
<TD align="center">
<%
for(int i=0;i<list.size();i++) {
List rsList = (ArrayList)list.get(i);
if (size == 0 ) size = rsList.size();
Iterator it =rsList.iterator();
%>
<table border=0 class="dragTable" cellspacing="0">
<tr align="Center" valign="Middle" style="color:#330099;">
<% if (it.hasNext()) {
String entry =(String) it.next();
%>
<td width=15%><input type="checkbox" name="checkbox<%=i%>" value ="<%=entry%>" > <%=entry%></td><td id="<%=entry%>"></td>
<% }
while (it.hasNext()) {
%>
<td width="20%">
<%String entry =(String) it.next();
out.println(entry);
%>
</td>
<% } %>
</tr></table>
<% } %>
</table><table>
<tr align="Center" valign="Middle" style="color:#330099;">
<td colspan =<%=size+1%>><%=bar%></td>
</tr>
</table></TD>
</TR>
</table>
<TABLE> <table>
<TR vAlign="middle">
<TD align="center" width="100%">
<br>
<BR>
全部选中 <input type="checkbox" name="check_all" size="6" onclick="javascript:CheckNone()" > <input type="button" style="BORDER-RIGHT: 1px ridge; BORDER-TOP: 1px ridge; FONT-SIZE: 10pt; BORDER-LEFT: 1px ridge; BORDER-BOTTOM: 1px ridge; FONT-FAMILY: 宋体; BACKGROUND-COLOR: #8ebae6" onclick="javascript:accessTrue()" value=" 删 除 " >
</TD>
</TR>
<TR vAlign="middle">
<TD align="center" width="100%">
<br>
<BR>
<input type="text" name="key" size="30" maxlength="30" Class="textbox" > <input type="button" style="BORDER-RIGHT: 1px ridge; BORDER-TOP: 1px ridge; FONT-SIZE: 10pt; BORDER-LEFT: 1px ridge; BORDER-BOTTOM: 1px ridge; FONT-FAMILY: 宋体; BACKGROUND-COLOR: #8ebae6" onclick="javascript:doClick1()" value=" 查 找 " >
</TD>
</TR>
</TABLE>
<%}
else{ %>
<table cellspacing="0" cellpadding="4" bordercolor="#009999" border="1" style="border-color:#009999;border-width:1px;border-style:solid;font-size:Smaller;width:70%;border-collapse:collapse;">
<tr align="Center" style="background-color:#EBF5F1;">
<td>没有你要选择的记录</td>
</tr>
<TR vAlign="middle">
<TD align="center" width="100%">
<input type="button" style="BORDER-RIGHT: 1px ridge; BORDER-TOP: 1px ridge; FONT-SIZE: 10pt; BORDER-LEFT: 1px ridge; BORDER-BOTTOM: 1px ridge; FONT-FAMILY: 宋体; BACKGROUND-COLOR: #8ebae6" onclick="javascript:transfer()" value=" 返回上一页 " >
<br>
<BR>
</TD>
</TR>
<table>
<% } %></form>
</body>
</html>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货