All Downloads are FREE. Search and download functionalities are using the official Maven repository.

top.wboost.common.boost.handler.HiveSqlBoostHandler Maven / Gradle / Ivy

Go to download

There is a newer version: 4.0.1
Show newest version
package top.wboost.common.boost.handler;

import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.springframework.web.servlet.ModelAndView;

import top.wboost.common.util.StringUtil;
import top.wboost.common.utils.web.utils.HtmlUtil;

//@AutoWebApplicationConfig("hiveSqlBoostHandler")
public class HiveSqlBoostHandler extends AbstractSqlBoostHandler {

    @Override
    @SuppressWarnings("unchecked")
    public ModelAndView handleInternal(HttpServletRequest request, HttpServletResponse response) {
        String sql = request.getParameter("sql");
        String split = request.getParameter("split");
        if (split == null)
            split = "\t";
        if (StringUtil.notEmpty(sql)) {
            List list = (List) executeSql(null, sql);
            StringBuilder sb = new StringBuilder();
            for (Object obj : list) {
                Object[] row = (Object[]) obj;
                int count = 0;
                for (Object one : row) {
                    //                    sb.append(one + "\t");
                    count++;
                    if (count != row.length) {
                        sb.append(one + split);
                    } else {
                        sb.append(one);
                    }
                }
                sb.append("\n");
            }
            HtmlUtil.writerJson(response, sb.toString());
        } else {
            HtmlUtil.writerJson(response, "no sql");
        }
        return null;
    }

    @Override
    public String getUrlMapping() {
        return "/boost/sql/hive";
    }

}
    

    

    

            

    

            



    
    






    
© 2015 - 2024 Weber Informatics LLC | Privacy Policy