顶会热词统计5

Dao.java

package com.dao;

import com.DBUtil.Dbutil;
import com.bean.lunwenBean;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.*;
import java.util.stream.Collectors;

public class Dao {
    public List<lunwenBean> getsize() throws SQLException{
        List<lunwenBean> list=new ArrayList<>();
        lunwenBean bean=null;
        String sql="select * from cvpr limit 2";
        Connection conn = Dbutil.getConnection();
        Statement st=null;
        ResultSet rs=null;
        try {
            st=conn.createStatement();
            st.executeQuery(sql);
            rs=st.executeQuery(sql);
            while(rs.next()) {
                String title = rs.getString("title");
                String link = rs.getString("link");
                String zuozhe = rs.getString("zuozhe");
                String as = rs.getString("abstract");
                String keywords = rs.getString("keywords");
                String time = rs.getString("time");
                bean=new lunwenBean(title,link,zuozhe,as,keywords,time);
                list.add(bean);

            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        finally{
            Dbutil.close(st, conn);
        }
        return list;
    }
    public List<lunwenBean> getselectlunwen(String a, String b, String c) throws SQLException{
        List<lunwenBean> list=new ArrayList<>();
        lunwenBean bean=null;
        String sql="select * from cvpr where abstract like '%"+a+"%' and title like '%"+b+"%' and zuozhe like '%"+c+"%'";
        sql=sql+" order by time desc ";
        System.out.println("SQL="+sql);
        Connection conn = Dbutil.getConnection();
        Statement st=null;
        ResultSet rs=null;
        try {
            st=conn.createStatement();
            st.executeQuery(sql);
            rs=st.executeQuery(sql);
            while(rs.next()) {
                String title = rs.getString("title");
                String link = rs.getString("link");
                String zuozhe = rs.getString("zuozhe");
                String as = rs.getString("abstract");
                String keywords = rs.getString("keywords");
                String time = rs.getString("time");
                bean=new lunwenBean(title,link,zuozhe,as,keywords,time);
                list.add(bean);

            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        finally{
            Dbutil.close(st, conn);
        }
        return list;

    }
    public static Map<String,Integer> getrc()
    {
        int tnumi=0;
        String sql="select * from cvpr ";
        Map<String, Integer>map= new HashMap<String, Integer>();
        Map<String, Integer>results= new LinkedHashMap<String, Integer>();
        Connection conn = Dbutil.getConnection();
        Statement st=null;
        ResultSet rs=null;
        try {
            st=conn.createStatement();
            st.executeQuery(sql);
            rs=st.executeQuery(sql);
            while(rs.next())
            {
                String keywords=rs.getString("title");
                keywords=keywords.substring(1, keywords.length());
                String[] split = keywords.split(" ");
                for(int i=0;i<split.length;i++)
                {
                    if(map.get(split[i])==null)
                    {
                        map.put(split[i],1);
                    }
                    else
                    {
                        map.replace(split[i], map.get(split[i])+1);

                    }
                }

                tnumi++;
            }
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

        // System.out.println("of的个数为"+map.get("of")+"MAP个数"+map.size());
        Dbutil.close(rs, st, conn);
        map.entrySet()
                .stream()
                .sorted((p1, p2) -> p2.getValue().compareTo(p1.getValue()))
                .collect(Collectors.toList())
                .forEach(ele -> results.put(ele.getKey(), ele.getValue()));
        return results;
    }
}　　

servlet.java

package com.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.bean.lunwenBean;
import com.dao.Dao;

import net.sf.json.JSONArray;
import net.sf.json.JSONObject;

/**
 * Servlet implementation class servlet
 */
@WebServlet("/servlet")
public class servlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
	Dao dao=new Dao();
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public servlet() {
        super();
        // TODO Auto-generated constructor stub
    }
    public void findlunwen(HttpServletRequest req, HttpServletResponse response) throws ServletException, IOException, SQLException {
    	req.setCharacterEncoding("utf-8");
    	String as=req.getParameter("as");
        String title=req.getParameter("title");
        String zuozhe = req.getParameter("zuozhe");
        List<lunwenBean> list = dao.getselectlunwen(as,title,zuozhe);
        PrintWriter out = response.getWriter();
        JSONArray json=new JSONArray();
        for(int i=0;i<list.size();i++) {
        	JSONObject ob=new JSONObject();
        	ob.put("title", list.get(i).getTitle());
            ob.put("link", list.get(i).getLink());
        	ob.put("zuozhe", list.get(i).getZuozhe());
        	ob.put("as", list.get(i).getAs());
        	ob.put("keywords",list.get(i).getKeywords());
        	ob.put("time", list.get(i).getTime());
        	json.add(ob);
        }
        //System.out.println("JSON"+json.toString());
        System.out.println("zongshu"+list.size());
        out.write(json.toString());
    	
    }
    public void reci(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, SQLException {
    	request.setCharacterEncoding("utf-8");
    	int shuzi=Integer.parseInt(request.getParameter("shuzi"));
        Map<String, Integer>sortMap=Dao.getrc();
        JSONArray json =new JSONArray();
        int k=0;
        for (Map.Entry<String, Integer> entry : sortMap.entrySet()) 
        {
            JSONObject ob=new JSONObject();
            ob.put("name", entry.getKey());
            ob.put("value", entry.getValue());
            if(!(entry.getKey().equals("for")||entry.getKey().equals("and")||entry.getKey().equals("With")||entry.getKey().equals("of")||entry.getKey().equals("in")||entry.getKey().equals("From")||entry.getKey().equals("A")||entry.getKey().equals("to")||entry.getKey().equals("a")||entry.getKey().equals("the")||entry.getKey().equals("by")))
            {
                json.add(ob);
                k++;
            }
            if(k==shuzi)
                break;
        }
        System.out.println(json.toString());
        
        response.getWriter().write(json.toString());
    }
    public void cld(HttpServletRequest req, HttpServletResponse response) throws ServletException, IOException, SQLException{
		System.out.println("Rcservlet");
		response.setContentType("text/html;charset=UTF-8");
		req.setCharacterEncoding("UTF-8");
		int shuzi=Integer.parseInt(req.getParameter("shuzi"));
		System.out.println(shuzi);
		Map<String, Integer>sortMap=Dao.getrc();
		JSONArray json =new JSONArray();
		int k=0;
		for (Map.Entry<String, Integer> entry : sortMap.entrySet()) 
		{
				JSONObject ob=new JSONObject();
				ob.put("name", entry.getKey());
				ob.put("value", entry.getValue());
				if(!(entry.getKey().equals("for")||entry.getKey().equals("and")||entry.getKey().equals("With")||entry.getKey().equals("of")||entry.getKey().equals("in")||entry.getKey().equals("From")||entry.getKey().equals("A")||entry.getKey().equals("to")||entry.getKey().equals("a")||entry.getKey().equals("the")||entry.getKey().equals("by")))
				{
					json.add(ob);
					k++;
				}
				if(k==shuzi)
					break;
		}
		System.out.println(json.toString());
		response.getWriter().write(json.toString());
	}
    public void aja(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, SQLException {
    	 PrintWriter out = response.getWriter();
         String name = request.getParameter("name").trim();
         String type="-1";
         try {
             response.setCharacterEncoding("UTF-8");
             response.setContentType("application/json; charset=utf-8");
//             out.println("Success---llll");
             out.append(type);
             out.close();
         } catch (Exception e){
             e.printStackTrace();
         }
         
     
    }
	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		request.setCharacterEncoding("utf-8");
        String method=request.getParameter("method");
        if(method.equals("findlunwen")) {
        	 try {
                 findlunwen(request,response);
         } catch (ServletException e) {
                 e.printStackTrace();
         } catch (IOException e) {
                 e.printStackTrace();
         } catch (SQLException e) {
             e.printStackTrace();
     }
        	 
        }
        else if(method.equals("aja")) {
        	try {
                aja(request,response);
        } catch (ServletException e) {
                e.printStackTrace();
        } catch (IOException e) {
                e.printStackTrace();
        } catch (SQLException e) {
                e.printStackTrace();
        }
        }
        else if(method.equals("cld")) {
        	try {
                cld(request,response);
        } catch (ServletException e) {
                e.printStackTrace();
        } catch (IOException e) {
                e.printStackTrace();
        } catch (SQLException e) {
                e.printStackTrace();
        }
        }
        else if(method.equals("reci")) {
        	try {
                reci(request,response);
        } catch (ServletException e) {
                e.printStackTrace();
        } catch (IOException e) {
                e.printStackTrace();
        } catch (SQLException e) {
                e.printStackTrace();
        }
        }
        
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}