📄 xianshi.jsp
字号:
<td height="7"><div align="left"> <div align="center"></div></td> </tr> <tr><td bordercolor="8" bgcolor="#e6f2ff"> </td></tr> <TR> <td><table> <tr> <td width=100> <p align="center"><font size=4>相关搜索:</font></p> </td> <% int xgnum=0; String xgc[]=new String[100]; String sqlxg; Statement stmt3=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); for(int i=0;i<zuhe_mmm;i++) { sqlxg="select word from hotsearch where word like '%"+zuhe_nnn[i]+"%' and word<>'"+parameterValue+"'"; ResultSet rsxg=stmt3.executeQuery(sqlxg); while(rsxg.next()) { String xgw=rsxg.getString("word"); boolean flag=false; for(int m=0;m<xgnum;m++) { if(xgc[m].equalsIgnoreCase(xgw)) { flag=true;break; } // System.out.println(m); } if(flag)continue; else { xgc[xgnum]=xgw; xgnum++; } } } // System.out.println(xgnum); if(xgnum>0 && xgnum<5) { for(int i=0;i<xgnum;i++) { String xgw=xgc[i]; String xgww=java.net.URLEncoder.encode(xgw,"UTF-8"); System.out.println("sdf"); %> <td width=150> <p align="center"> <font size=4> <a href="xianshi.jsp?text2=<%=xgww%>"><%=xgw%></a></font> </td> <% } } if(xgnum>=5) { for(int i=0;i<5;i++) { String xgw=xgc[i]; String xgww=java.net.URLEncoder.encode(xgw,"UTF-8"); %> <TD> <p align="left"><a href="xianshi.jsp?text2=<%=xgww%>"><%=xgw%></a></p> </TD> <% } } %> </TR> </TABLE> </TD> </TR> </table><table width="33%" height="68%" border="0" align="left"> <tr> <td height="244"><p align="left"><font size=4>扩展搜索:</font></p> <% //zhuyiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii String kuozhanup[]=new String[100]; String up[][]=new String[3][20];String down[][]=new String[3][20];int up1,up2,up3;int down1,down2,down3;int upnum=0;int downnum=0;String kuozhandn[]=new String[50]; if(zuhe_mmmm==2){ up1=0;up2=0;down1=0;down2=0; up[0][up1]=zuhe_nnnn[0];up[1][up2]=zuhe_nnnn[1];up1++;up2++; for(int i=0;i<=1;i++) {String zuhe_eqsql="select up,down from tablex where word='"+zuhe_nnnn[i]+"'"; ResultSet zuhe_eqrs=stmt2.executeQuery(zuhe_eqsql); if(i==0) { if(zuhe_eqrs.next()) { String zup=zuhe_eqrs.getString("up"); if(zup!=null) {StringTokenizer zu_sTokenizer=new StringTokenizer(zup,"\\"); while(zu_sTokenizer.hasMoreTokens()) { String lisi=zu_sTokenizer.nextToken(); lisi=lisi.trim(); up[0][up1]=lisi;//分解的输入内容放到nnn[mmm]里 up1++; }} String zdown=zuhe_eqrs.getString("down"); if(zdown!=null) {StringTokenizer zu_sTokenizer=new StringTokenizer(zdown,"\\"); while(zu_sTokenizer.hasMoreTokens()) { String lisi=zu_sTokenizer.nextToken(); lisi=lisi.trim(); up[0][up1]=lisi;//分解的输入内容放到nnn[mmm]里 up1++; }} } } else { if(zuhe_eqrs.next()) { String zup=zuhe_eqrs.getString("up"); if(zup!=null) {StringTokenizer zu_sTokenizer=new StringTokenizer(zup,"\\"); while(zu_sTokenizer.hasMoreTokens()) { String lisi=zu_sTokenizer.nextToken(); lisi=lisi.trim(); up[1][up2]=lisi;//分解的输入内容放到nnn[mmm]里 up2++; }} String zdown=zuhe_eqrs.getString("down"); if(zdown!=null) {StringTokenizer zu_sTokenizer=new StringTokenizer(zdown,"\\"); while(zu_sTokenizer.hasMoreTokens()) { String lisi=zu_sTokenizer.nextToken(); lisi=lisi.trim(); up[1][up2]=lisi;//分解的输入内容放到nnn[mmm]里 up2++; }} } }//else }//for if(up1>0 && up2>0) { for(int i=0;i<up1;i++) { for(int j=0;j<up2;j++) {if(i==0 && j==0)continue; if(!up[0][i].equalsIgnoreCase(up[1][j])) {kuozhanup[upnum]=up[0][i]+" "+up[1][j]; upnum++;} } } } }//if2个 if(zuhe_mmmm==3){ up1=0;up2=0;up3=0; up[0][up1]=zuhe_nnnn[0];up1++; up[1][up2]=zuhe_nnnn[1];up2++; up[2][up3]=zuhe_nnnn[2];up3++; for(int i=0;i<=2;i++) {String zuhe_eqsql="select up,down from tablex where word='"+zuhe_nnnn[i]+"'"; ResultSet zuhe_eqrs=stmt2.executeQuery(zuhe_eqsql); if(i==0) { if(zuhe_eqrs.next()) { String zup=zuhe_eqrs.getString("up"); if(zup!=null) {StringTokenizer zu_sTokenizer=new StringTokenizer(zup,"\\"); while(zu_sTokenizer.hasMoreTokens()) { String lisi=zu_sTokenizer.nextToken(); lisi=lisi.trim(); up[0][up1]=lisi;//分解的输入内容放到nnn[mmm]里 up1++; }} String zdown=zuhe_eqrs.getString("down"); if(zdown!=null) {StringTokenizer zu_sTokenizer=new StringTokenizer(zdown,"\\"); while(zu_sTokenizer.hasMoreTokens()) { String lisi=zu_sTokenizer.nextToken(); lisi=lisi.trim(); up[0][up1]=lisi;//分解的输入内容放到nnn[mmm]里 up1++; }} } } if(i==1) { if(zuhe_eqrs.next()) { String zup=zuhe_eqrs.getString("up"); if(zup!=null) {StringTokenizer zu_sTokenizer=new StringTokenizer(zup,"\\"); while(zu_sTokenizer.hasMoreTokens()) { String lisi=zu_sTokenizer.nextToken(); lisi=lisi.trim(); up[1][up2]=lisi;//分解的输入内容放到nnn[mmm]里 up2++; }} String zdown=zuhe_eqrs.getString("down"); if(zdown!=null) {StringTokenizer zu_sTokenizer=new StringTokenizer(zdown,"\\"); while(zu_sTokenizer.hasMoreTokens()) { String lisi=zu_sTokenizer.nextToken(); lisi=lisi.trim(); up[1][up2]=lisi;//分解的输入内容放到nnn[mmm]里 up2++; }} } }//else if(i==2) { if(zuhe_eqrs.next()) { String zup=zuhe_eqrs.getString("up"); if(zup!=null) {StringTokenizer zu_sTokenizer=new StringTokenizer(zup,"\\"); while(zu_sTokenizer.hasMoreTokens()) { String lisi=zu_sTokenizer.nextToken(); lisi=lisi.trim(); up[2][up3]=lisi;//分解的输入内容放到nnn[mmm]里 up3++; }} String zdown=zuhe_eqrs.getString("down"); if(zdown!=null) {StringTokenizer zu_sTokenizer=new StringTokenizer(zdown,"\\"); while(zu_sTokenizer.hasMoreTokens()) { String lisi=zu_sTokenizer.nextToken(); lisi=lisi.trim(); up[2][up3]=lisi;//分解的输入内容放到nnn[mmm]里 up3++; }} } }//else }//for if(up1>0 && up2>0 && up3>0) { for(int i=0;i<up1;i++) {System.out.println("i:"+i); for(int j=0;j<up2;j++) {System.out.println("j:"+j); for(int r=0;r<up3;r++) {System.out.println("r:"+r); if(i==0 && j==0 && r==0)continue; if(!up[0][i].equalsIgnoreCase(up[1][j]) && !up[0][i].equalsIgnoreCase(up[2][r]) && !up[1][j].equalsIgnoreCase(up[2][r])) { kuozhanup[upnum]=up[0][i]+" "+up[1][j]+" "+up[2][r]; upnum++; }} } }} }//if3个 for(int i=0;i<zuhe_mmmm;i++) {String zuhe_upsql="select up,down from tablex where word='"+zuhe_nnnn[i]+"'";ResultSet zuhe_uprs=stmt2.executeQuery(zuhe_upsql); if(zuhe_uprs.next()) { String zup=zuhe_uprs.getString("up"); if(zup!=null) {StringTokenizer zu_sTokenizer=new StringTokenizer(zup,"\\"); while(zu_sTokenizer.hasMoreTokens()) { String lisi=zu_sTokenizer.nextToken(); lisi=lisi.trim(); kuozhandn[downnum]=lisi; downnum++; }} String zdown=zuhe_uprs.getString("down"); if(zdown!=null) {StringTokenizer zu_sTokenizer=new StringTokenizer(zdown,"\\"); while(zu_sTokenizer.hasMoreTokens()) { String lisi=zu_sTokenizer.nextToken(); lisi=lisi.trim(); kuozhandn[downnum]=lisi; downnum++; }} }} for(int i=0;i<downnum;i++) {boolean flag=false; for(int j=0;j<i;j++) {if(kuozhandn[i].equalsIgnoreCase(kuozhandn[j])) {flag=true;break;} } if(!flag){kuozhanup[upnum]=kuozhandn[i];upnum++;} } //zhuyiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii if(upnum>0) for(int i=0;i<upnum;i++) {String dn=kuozhanup[i]; dn=dn.trim(); String dn2=java.net.URLEncoder.encode(dn,"UTF-8"); %> <p align="left"> <font size=4><a href="xianshi.jsp?text2=<%=dn2%>"><%=dn%></a></font></p> <% }%> <div align="center"> </div></td> </tr> <tr> <td height="17"> </td> </tr></table><p> </p></font></body></html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -