auto.jsp

智能文档检索系统

<%@ page language="java" import="java.util.*" contentType="text/html; charset=UTF-8"import="java.sql.*" %>
<%@ page import="java.net.*"%>
<%@ page pageEncoding="UTF-8"%>


   

<%
        //设置输出信息的格式及字符集        

        response.setContentType( "text/xml" );
        response.setCharacterEncoding( "UTF-8" );
        String searchWhat="nihao";
        searchWhat=request.getParameter("search");
        searchWhat = java.net.URLDecoder.decode(searchWhat, "utf-8");
        
         Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
         String  url="jdbc:microsoft:sqlserver://localhost;DatabaseName=xy";
         String  user="sa";
         String  password="a";
         Connection  conn=  DriverManager.getConnection(url,user,password);
         
         Statement  stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
         if(!searchWhat.equals(""))
          {
             

                     String searchHot="select word from hotsearch where word like '%"+searchWhat+"%' ";//取出这个文章的地址
                    ResultSet rs_shishi=stmt.executeQuery(searchHot);
                    String hotWord=null;
                    String ww=",";
                    out.print("<responses>");
                    while(rs_shishi.next())
                     {          
                        hotWord=rs_shishi.getString("word");
                        ww=ww+hotWord+",";
                       // out.print("<response>");
                       // out.println(hotWord);	
                       // out.print("</response>");
                     }
                     out.print(ww);
                     out.print("</responses>");

                    out.close();
        }
        stmt.close();
        conn.close();
 %>