xianshi.jsp

智能文档检索系统

                      }
                    }
                }


                if(f!=0&&d==0)//关键子不是空，作者是空
                  {
                    for(int i=0;i<f;i++)
                    {
                        n[l]=e[i];
                        everyn[everyl]=e[i];
                        l++;
                        everyl++; 
                    }
                    //l=f;n=e;
                  }

                if(f==0&&d!=0)////关键子是空，作者不是空
                    {
                      for(int i=0;i<d;i++)
                        {
                           n[l]=c[i];
                          everyn[everyl]=c[i];
                           l++;
                           everyl++; 
                       }
                      //l=d;n=c;
                    }

                
                if(k==0&&j==0&&f==0&&d==0)//关键字和作者都是空
                {   mhflag=true;
                   // String sql555_title="select ID from discourse where title like '%"+nnn[0]+"%' ";
                    String sql555="select ID from discourse where abstract like '%"+nnn[0]+"%' ";
                    String sql666="select did from author where name like '%"+nnn[0]+"%'";
                    String sql777="select did from keyword where word like '%"+nnn[0]+"%'";
                    for(int i=1;i<mmm;i++)
                    { 
                      //sql555_title=sql555_title+"or title like '%"+nnn[i]+"%'"; 
                      sql555=sql555+"or abstract like '%"+nnn[i]+"%'";
                      sql666=sql666+"or name like '%"+nnn[i]+"%'";
                      sql777=sql777+"or word like '%"+nnn[i]+"%'";
                    }

                   // ResultSet rs555_title=stmt1.executeQuery(sql555_title);
                   // while(rs555_title.next())
                    //  {
                     //    n[l]=Integer.parseInt(rs555_title.getString("ID"));
                     //    l++;
                    //  }
                     ResultSet rs555=stmt1.executeQuery(sql555);
                     while(rs555.next())
                      {
                         n[l]=Integer.parseInt(rs555.getString("ID"));
                         l++;
                         everyn[everyl]=Integer.parseInt(rs555.getString("ID"));
                         everyl++;
                      }
                      ResultSet rs666=stmt1.executeQuery(sql666);
                      int nowl=l;
                      while(rs666.next())
                          {    boolean flag=false;
                               int did=rs666.getInt("did");

                               for(int i=0;i<nowl;i++)
                               {
                                  if(did==n[i]){flag=true;break;}  
                               }
                               if(!flag)
                                 {
                                   n[l]=did;l++;
                                   everyn[everyl]=did;everyl++;
                                 }
                          }
                      ResultSet rs777=stmt1.executeQuery(sql777);
                      nowl=l;
                      while(rs777.next())
                          {    boolean flag=false;
                               int did=rs777.getInt("did");

                               for(int i=0;i<nowl;i++)
                               {
                               if(did==n[i]){flag=true;break;}  
                               }
                               if(!flag)
                               {
                                   n[l]=did;l++;
                                   everyn[everyl]=did;everyl++;
                               }
                          }
                      rs555.close();
                      rs666.close();
                      rs777.close();
                 }
                
                
                
                
                
             if(everyl>0)//往热表里加没有热表里没有的输入内容   不能使用n[],n[]是全局变量
                {
                     String searchdid=String.valueOf(everyn[0]);

                     for(int y=1;y<everyl;y++)
                       {
                         searchdid=searchdid+"\\"+String.valueOf(everyn[y]);


                       }
                         String insql="insert into hotsearch(ID,word,did,times) values("+Maxid+",'"+zuhe_parameterValue+"','"+searchdid+"',1)" ;  
                         Maxid++;
                         stmt2.execute(insql);
                }
                
                
               

  }//hot---else     end  else//热表里没有相应的词，则从search表开始查找，并加入

}//for(int zuhe_i=0;zuhe_i<zuhe_mmmmm;zuhe_i++)//大循环
 
     
l=onlySort.onlySort(n,l);//应用usebean//使n[]中的论文号唯一

int times[]=new int[1000];//存放文章的浏览次数
times[0]=0;

for(int i=0;i<l;i++)//取得文章的浏览次数
{
   String wenzhang_times="select times from discourse where id='"+n[i]+"'" ; //sql语句 ; 
   ResultSet wenzhang_times_rs=stmt.executeQuery(wenzhang_times);
   if(wenzhang_times_rs.next())
    {
       times[i+1]=wenzhang_times_rs.getInt("times");
    }
}

lotSort.lotSort(n,l,times);//应用usebean//把浏览次数多的文章放到前面

  
int ll=0;
int pp5=1;
intPageCount555=(l+3)/4;
if(intPage==0)intPage=1;
if(intPage!=1)ll=(intPage-1)*4;


Object usID=session.getAttribute("userID");
if(usID!=null)//插入用户搜索过的内容，当表中有时，次数加一
{
    String userID=usID.toString();
    System.out.println("1userID:"+userID);
    String usersql="select love from userlove where userID="+userID+" and love='"+parameterValue+"'";
    ResultSet users=stmt.executeQuery(usersql);
    if(users.next())
    {
    usersql="update userlove set times=times+1 where userID="+userID+" and love='"+parameterValue+"'";
    stmt.executeUpdate(usersql);
    }
    else
        {
        usersql="insert into userlove(userID,love,times,type) values("+userID+",'"+parameterValue+"',1,0)" ;  
        stmt.execute(usersql);
        }
}// end  if(usID!=null)//插入用户搜索过的内容，当表中有时，次数加一


for(int i=ll;i<l&&i<ll+4;i++)//分页显示
{ 
   String sql3="select ID,title,address,abstract from discourse where id='"+n[i]+"'" ; //sql语句 ; 
   ResultSet rs3=stmt.executeQuery(sql3);
   if(rs3.next())
   { int ppk=rs3.getInt("ID");
     String sppk=Integer.toString(ppk);
     String title=rs3.getString("title");
String s_title[]=title.split(zuhe_nnn[0]);
     
%>　
<p><a href="lunwen.jsp?lunwen_ID=<%=sppk%>"><%
int num_t=s_title.length;
String sto_t=s_title[0];
sto_t=sto_t.trim();
out.print(sto_t);for(int sm=1;sm<num_t;sm++){sto_t=s_title[sm];sto_t=sto_t.trim();%><span class="STYLE8"><%out.print(zuhe_nnn[0]);%></span><%out.print(sto_t);}%></a>      
      </p> <p align="left"> </p>
         <div><table cellpadding="0" cellspacing="0"><tr><td>作　者：</td>
<% 
     
      String abs=rs3.getString("abstract");
      String sss[]=abs.split(zuhe_nnn[0]);
      String zuozhe="select name from author where did='"+rs3.getInt("ID")+"'"; //找作者 
      ResultSet rszuozhe=stmt.executeQuery(zuozhe);
      while(rszuozhe.next())
           {
              boolean flag=false; 
              String zzz=rszuozhe.getString("name");                                                                                                                                                                      
              if(mhflag)
              {  
                  String xg=zuhe_nnn[0];
                  String sss_zuozhe[]=zzz.split(xg);
                  int xgi=1;
                  int num1_zuozhe=sss_zuozhe.length;
                  while(num1_zuozhe<=1 && xgi<zuhe_mmm)
                  {
                      xg=zuhe_nnn[xgi];
                      sss_zuozhe=zzz.split(xg);
                      num1_zuozhe=sss_zuozhe.length;
                      xgi++;
                  }
                  String sto=sss_zuozhe[0];
                  sto=sto.trim();%>
                                  
             <td> <%out.print(sto); 
              for(int sm=1;sm<num1_zuozhe;sm++)
              {
              %>
          </td><td><span class="STYLE8"><%out.print(xg);%></span></td>
          <% sto=sss_zuozhe[sm];sto=sto.trim();%>

          <td><%out.print(sto);%>

          <%}%></td>
          <td>&nbsp;</td><td>&nbsp;</td>

          <% }                                                          
          else
          {
                  zzz=zzz.trim();
                  for(int jjj=0;jjj<zuhe_mmm;jjj++)
                  {
                      if(zzz.equalsIgnoreCase(zuhe_nnn[jjj]))
                      {
                        flag=true;
                      }
                     if(flag)break;
                  }
                  if(flag)
                  {%>
                  <td> <span class="STYLE8">
                          <%
                          out.print(zzz+" ");
                          %>
                  </span></td><td>&nbsp;</td><td>&nbsp;</td>
                  <%}
                  else
                  {%>
                  <td><%out.print(zzz+" ");%></td><td>&nbsp;</td><td>&nbsp;</td>
                <%}
          }
      }
                              %>
              </tr></table></div>
    <%rszuozhe.close();
%>
</p>
<div><table cellpadding="0" cellspacing="0"><tr><td>关键词：</td>
            <% String guanjianzi="select word from keyword where did='"+ppk+"'"; 
            ResultSet rsguanjianzi=stmt.executeQuery(guanjianzi);
            while(rsguanjianzi.next())
            {
            boolean flag=false;
            String keyword=null;
            
            keyword=rsguanjianzi.getString("word");
            
            
            
            
            if(mhflag)
            {    String xg=zuhe_nnn[0];
            String sss_gjz[]=keyword.split(zuhe_nnn[0]);
            int num1_gjz=sss_gjz.length;
            int xgi=1;
            
            while(num1_gjz<=1 && xgi<zuhe_mmm)
            {xg=zuhe_nnn[xgi];
            sss_gjz=keyword.split(xg);
            num1_gjz=sss_gjz.length;
            xgi++;
            }
            String sto=sss_gjz[0];
            sto=sto.trim();
            %>
            <td><%out.print(sto+" ");%>
                <%for(int sm=1;sm<num1_gjz;sm++)
                {
                %>
            </td><td><span class="STYLE8">
                    <%out.print(xg);%>    
            </span></td>
            <%                  sto=sss_gjz[sm];
            sto=sto.trim();%>
            <td><%out.print(sto);
            }%></td><td>&nbsp;</td><td>&nbsp;</td>
            <%}
            
            else
            { keyword=keyword.trim();
            //
            for(int iii=0;iii<zuhe_mmm;iii++) 
            {
            
            
            if(keyword.equalsIgnoreCase(zuhe_nnn[iii]))
            {
            flag=true;
            }
            
            if(flag)break;
            
            } 
            
            if(flag)
            {%>
            <td><span class="STYLE8">
                    <%
                    out.print(keyword);
                    %>
            </span></td><td>&nbsp;</td><td>&nbsp;</td>
            <%}
            else
            {%>
            <td><%out.print(keyword);%></td><td>&nbsp;</td><td>&nbsp;</td>
            <% }
            }
            }
            rsguanjianzi.close();
           //  
            
            %>
</tr></table></div>
<br>&nbsp;
<table border="0" align="left">
<tr>
<td height="10">摘　要：</td>
<td rowspan="2">
    <%
int num1=sss.length;
String sto=sss[0];
sto=sto.trim();
out.print(sto);for(int sm=1;sm<num1;sm++){sto=sss[sm];sto=sto.trim();%><span class="STYLE8"><%out.print(zuhe_nnn[0]);%></span><%out.print(sto);}%>
    
</td>
</tr>
<tr>
<td height="26">&nbsp;</td>
</tr>
</table>
<p>&nbsp;  </p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;  </p>
  <%
   }
  rs3.close(); 
}//end   for(int i=ll;i<l&&i<ll+4;i++)分页显示
%>

<p>&nbsp;</p>
<p>第<%=intPage%>页 共<%=intPageCount555%>页</p>
<p>
  <%
  if(intPage<intPageCount555){%> 
  <a href="xianshi.jsp?page=<%=intPage+1%>">下一页</a> 
  <%}
if(intPage>1){

%> 
  <a href="xianshi.jsp?page=<%=intPage-1%>">上一页</a></p>
<p>
  <%
}  
   
   
   
%>	
</p></td>
  </tr>
  <tr>