代码如下:
帮忙看看 <option value="" value2="0" selected>请选择所属栏目</option>
<%
ResultSet rs=stmt.executeQuery("select art_class_id,art_class_name from xf_art_class where art_class_class='0' ");
int i=0;
int j=1;
while(rs.next())
{
int art_class_id1;
art_class_id1 = rs.getInt("art_class_id");%>
<%
Statement stmt3=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs3=stmt3.executeQuery("select art_class_id,art_class_name,art_class_conts from xf_art_class where art_class_ow='1' and art_class_class="+art_class_id1+" ");
if(rs3.next()){
%>
<option value="" style="color:red" value2="<%=rs.getString("art_class_id")%>"><%=rs.getString("art_class_name")%></option>
<%
Statement stmt2=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs2=stmt2.executeQuery("select art_class_id,art_class_name,art_class_conts from xf_art_class where art_class_ow='1' and art_class_class="+art_class_id1+" order by art_class_id desc");
int k=0;
int l=1;
while(rs2.next())
{%>
<option value="<%=rs2.getString("art_class_id")%>" value2="<%=rs.getString("art_class_id")%>"> ├ <%=rs2.getString("art_class_name")%></option>
<%
k=k+1;
l=l+1;
}%>
<%}else{%>
<option value="<%=rs.getString("art_class_id")%>" style="color:blue" value2="<%=rs.getString("art_class_id")%>"><%=rs.getString("art_class_name")%></option>
<%}%>
<%
j=j+1;
i=i+1;
}%>
</select>
帮忙看看 <option value="" value2="0" selected>请选择所属栏目</option>
<%
ResultSet rs=stmt.executeQuery("select art_class_id,art_class_name from xf_art_class where art_class_class='0' ");
int i=0;
int j=1;
while(rs.next())
{
int art_class_id1;
art_class_id1 = rs.getInt("art_class_id");%>
<%
Statement stmt3=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs3=stmt3.executeQuery("select art_class_id,art_class_name,art_class_conts from xf_art_class where art_class_ow='1' and art_class_class="+art_class_id1+" ");
if(rs3.next()){
%>
<option value="" style="color:red" value2="<%=rs.getString("art_class_id")%>"><%=rs.getString("art_class_name")%></option>
<%
Statement stmt2=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs2=stmt2.executeQuery("select art_class_id,art_class_name,art_class_conts from xf_art_class where art_class_ow='1' and art_class_class="+art_class_id1+" order by art_class_id desc");
int k=0;
int l=1;
while(rs2.next())
{%>
<option value="<%=rs2.getString("art_class_id")%>" value2="<%=rs.getString("art_class_id")%>"> ├ <%=rs2.getString("art_class_name")%></option>
<%
k=k+1;
l=l+1;
}%>
<%}else{%>
<option value="<%=rs.getString("art_class_id")%>" style="color:blue" value2="<%=rs.getString("art_class_id")%>"><%=rs.getString("art_class_name")%></option>
<%}%>
<%
j=j+1;
i=i+1;
}%>
</select>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货