通过tomcat配置上下文，通过jdbc链接数据源

tomcat中的配置

<Service name="ssd">      <Connector port="8080" maxHttpHeaderSize="8906"               maxThreads="150" minSpareThreads="25" maxSpareThreads="75"               enableLookups="false" redirectPort="8443" acceptCount="100"               connectionTimeout="20000" disableUploadTimeout="true"               URIEncoding="utf-8" useBodyEncodingForURI="true" />    <Engine name="ssd" defaultHost="localhost">      <Realm className="org.apache.catalina.realm.UserDatabaseRealm"             resourceName="UserDatabase" />      <Host name="localhost" appBase="">       <Context path="" docBase="c:\Microsoft\WorkPorject\WebProject\opinion\WebRoot"                 debug="5" reloadable="true" crossContext="true">            <Resource name="jdbc/union2" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000"                        username="root" password="root" driverClassName="com.mysql.jdbc.Driver"                       url="jdbc:mysql://xxx.xxx.xxx:xxxx/data_center?autoReconnect=true&amp;characterEncoding=utf-8"/>        </Context>      </Host>    </Engine></Service>

JDBC回忆

    /**     * 取得基础信息数据库链接     * 连接的数据库有public_zjgov     * @return     */    public static Connection getUnion2(){        try{            Connection con = null;            Context initCtx = new InitialContext();            Context envCtx = (Context)initCtx.lookup("java:comp/env");            DataSource connectionPool = (DataSource)envCtx.lookup("jdbc/union2");            con = connectionPool.getConnection();            return con;        }catch(Exception ex){            ex.printStackTrace();               return null;        }    }

jdbc查询

/**     * 从文章同一库查询文章列表     * @param sql     * @param values     * @return     */    public List<Map<String, Object>> queryForUnion2Map(String sql, Object[] values) {        List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();        Connection conn = null;        PreparedStatement pstmt = null;        ResultSet rs = null;        try {            conn = DBConnection.getUnion2();            pstmt = conn.prepareStatement(sql);            ParameterMetaData pmd = pstmt.getParameterMetaData();   //获取SQL语句的结构            int pmdCount = pmd.getParameterCount();     //获取SQL语句中?占位符的个数            //对SQL语句中的占位符进行赋值            if(null != values) {                for(int i = 0; i < pmdCount && i < values.length; ++i) {                    pstmt.setObject(i+1, values[i]);                }            }            rs = pstmt.executeQuery();            ResultSetMetaData rsmd = rs.getMetaData();      //获取查询结果的数据结构            int rsmdCount = rsmd.getColumnCount();            String[] columnName = new String[rsmdCount];            Map<String, String> columnType = new HashMap<String, String>();            for(int i = 0; i < rsmdCount; ++i) {                columnName[i] = rsmd.getColumnLabel(i+1);       //获取列的名字                columnType.put(rsmd.getColumnLabel(i+1), rsmd.getColumnClassName(i+1)); //获取列的JAVA数据类型名            }            Map<String, Object> map = null;            while(rs.next()) {                map = new LinkedHashMap<String, Object>();                for(int i = 0; i < rsmdCount; ++i) {                    map.put(columnName[i], tools.readRow(rs, columnType.get(columnName[i]), columnName[i]));                }                list.add(map);                map = null;            }        } catch(Exception e) {            e.printStackTrace();        } finally {            MySQLDBUtils.getInstance().free(rs, pstmt, conn);        }        return list;    }

传递拼接sql

@Override    public List<Map<String, Object>> getMonitorKeywordsList(String ids) {        StringBuffer sql = new StringBuffer();        sql.append("SELECT ai.artKeyword,ai.id FROM "+CommonPublic.ARTICLE_INFO +" ai WHERE 1=1 and ai.id in ("+ids+")");        List<Object> values = new ArrayList<Object>();        QueryResultMap query = new QueryResultMap();        List<Map<String, Object>> list = query.queryForMap(sql.toString(), values);        return list;    }

根据文章id查询关键字并排序统计截取

public  Map<String,Integer> queryRelationKeywordsStat(int monitorType,int sortType,int peopleId,String startDate,String endDate,String peopleName){        Page pg=new Page();        Map<String,Integer> countMap = new HashMap<String,Integer>();        for(int i=0;i<100;i++){            pg.setCurrentPage(i);            pg.setPageSize(100);            Page moniList=monitorpersonService.monitorAtricle(monitorType, sortType, peopleId, startDate, endDate, pg);            if(moniList.getTotalRow()==0||moniList.getTotalPage()<=i)break;                List<MymMonitorBean> dataList = moniList.getData();                String ids = "";                for(int j=0;j<dataList.size();j++){                    MymMonitorBean bean = dataList.get(j);                    if(dataList.size()-1!=j){                        ids+=bean.getId()+",";                    } else {                        ids+=bean.getId();                    }                }                 List<Map<String, Object>> monitorKeywordsMap = monitorpersonService.getMonitorKeywordsList(ids);                for(Map<String, Object> map : monitorKeywordsMap){                    String keyword = map.get("artKeyword").toString();                    // 分割关键词                    String[] wordAry = keyword.split(",");                    // 遍历关键词，并统计                    for(String word : wordAry){                        if(countMap.containsKey(word)){                            int newCount = countMap.get(word)+1;                            countMap.put(word, newCount);                        } else {                            if(word.equals(peopleName))continue;                            countMap.put(word, 1);                        }                    }                }        }        // 排序结果集，获取前二十个        Map<String,Integer> endCountMap = sortMap(countMap,20);        return endCountMap;    }    /**     * 根据map排序，并倒叙取前几个     * @param oldMap 需要排序的map     * @param many   取的个数     * @return     */    public static Map<String,Integer> sortMap(Map<String,Integer> oldMap,int many) {          ArrayList<Map.Entry<String, Integer>> list = new ArrayList<Map.Entry<String, Integer>>(oldMap.entrySet());          Collections.sort(list, new Comparator<Map.Entry<String, Integer>>() {              @Override              public int compare(Entry<java.lang.String, Integer> arg0,                      Entry<java.lang.String, Integer> arg1) {                  return arg0.getValue() - arg1.getValue();              }          });          Map<String,Integer> newMap = new LinkedHashMap<String,Integer>();        int count = list.size()>many?many:list.size();        for (int i = count; i > 0; i--) {            newMap.put(list.get(list.size()-i).getKey(), list.get(list.size()-i).getValue());          }          return newMap;    } 

将统计值放入名为echarts.java类中进行处理

    /**     * 封装力引导关系图的数据     * @param keywordsStatMap     * @return     */    public Map<String,Object> getRelationKeywords(Map<String, Integer> keywordsStatMap,String peopleName){                Map<String, Object> resultMap = new HashMap<String, Object>();//定义存放饼图信息的map集合                List<Map<String, Object>> nodeList = new ArrayList<Map<String, Object>>();                List<Map<String, Object>> edgeList = new ArrayList<Map<String, Object>>();                int total = 0;                Map<String, Object> firstNodeMap = new HashMap<String, Object>();                firstNodeMap.put("id", 0);                firstNodeMap.put("name", peopleName);                firstNodeMap.put("x", "-266.82776");                firstNodeMap.put("y", "299.6904");                int i = 1;                for(Map.Entry<String, Integer> statEntry : keywordsStatMap.entrySet()){                    String statKey = statEntry.getKey();                    Integer statValue = statEntry.getValue();                    total += statValue;                    Map<String, Object> nodeMap = new HashMap<String, Object>();                    nodeMap.put("id", i);                    nodeMap.put("name", statKey);                    nodeMap.put("x", coordinate("-266.82776", null,200,(i*15)));                    nodeMap.put("y", coordinate(null, "299.6904",200,(i*15)));                    nodeMap.put("num", statValue);                    nodeList.add(nodeMap);                    Map<String, Object> edgeMap = new HashMap<String, Object>();                    if(i <= keywordsStatMap.size()){                        edgeMap.put("id", i);                        edgeMap.put("sourceID", 0);                        edgeMap.put("targetID", i);                        edgeList.add(edgeMap);                    }                    i++;                }                firstNodeMap.put("num", total);                nodeList.add(firstNodeMap);            resultMap.put("nodes", nodeList);            resultMap.put("edges", edgeList);        return resultMap;    }

处理后的参数回传：

@RequestMapping("getRelationChartsData")    @ResponseBody    public String getRelationData(String startDate,String endDate,int peopleId,String peopleName){        int monitorType = NumberUtils.toInt(request.getParameter("monitorType"),0);//领导类型        int sortType = NumberUtils.toInt(request.getParameter("sortType"),1); // 排序方式        if(startDate == null || startDate.equals("")){            startDate = this.getDate(defBegin);        }        if(endDate == null || endDate.equals("")){            endDate = this.getDate(defEnd);        }        //查询关系词        Map<String, Integer> keywordsStatMap =queryRelationKeywordsStat( monitorType, sortType, peopleId, startDate, endDate,peopleName);        Map<String, Object> resultMap = new HashMap<String, Object>();        //封装查询的数据        if(null!=keywordsStatMap&&!keywordsStatMap.isEmpty()){            Echarts echarts = new Echarts();            resultMap =echarts.getRelationKeywords(keywordsStatMap, peopleName);        }           return JsonMapper.toJson(resultMap);    }

关系图前端js调用

    function getSimpleRelationCharts(){        $("#relationCharts").html(imgLoading);        var peopleId = $("#monitorList").find(".active").attr("monitor_id");        var peopleName = $("#monitorList").find(".active").attr("monitor_name");        $("#peopleId").val(peopleId);        $("#peopleName").val(peopleName);        var startDate = $("#startDate").val();        var endDate = $("#endDate").val();        var param = {            startDate : startDate,            endDate : endDate,            peopleId : peopleId,            peopleName:peopleName,            rnd : Math.random()        };        $.ajax({           type:"post",           url:"/opinion/monitorperson/getRelationChartsData",           dataType:"json",           async:false,           data:param,           success:function(data){                //console.log(data);                if(data){                    forceRelationChart("relationCharts", data);                }           }        });    }<script type="text/javascript" src="/opinion/plugins/echarts3.0/echarts.min.js"></script><script type="text/javascript">    function forceRelationChart(id,data){            var myChart = echarts.init(document.getElementById(id));            var nodes = [];            var edges = [];            if(data){                nodes = data["nodes"];                edges = data["edges"];            }            $.each(nodes, function(n, node){                //console.log(node.id+","+node.num);                node.id = ""+node.id+"";                node.value = node.num;                node.symbolSize = node.num*10;                node.symbolSize = 40;                node.category = 0;                node.draggable = true;                node.label = {                    normal: {                        //show: node.symbolSize > 30                        show: true                    }                };                node.itemStyle = {                    normal: {                        color: 'rgb(' +[                            106 | 0,                            176 | 0,                            184 | 0                        ].join(',') + ')'                    }                };                if(node.id == 0){                    node.symbolSize = 60;                    node.itemStyle = {                        normal: {                            color: 'rgb(' +[                                236 | 0,                                81 | 0,                                72 | 0                            ].join(',') + ')'                        }                    };                }            });            $.each(edges, function(n, edge){                console.log(edge.sourceID+","+edge.targetID);                edge.id = ""+edge.id+"";                edge.source = ""+edge.sourceID+"";                edge.target = ""+edge.targetID+"";                edge.lineStyle = {                    normal: {                        color: 'rgb(' +[                            106 | 0,                            176 | 0,                            184 | 0                        ].join(',') + ')'                    }                };            });                var categories = [];                categories = [                    {name: ''}                ];                console.log(nodes);                console.log(edges);                option = {                    title: {                        text: '关系图',                        //subtext: 'Default layout',                        top: 'bottom',                        left: 'right'                    },                    tooltip: {},                    legend: [{                        // selectedMode: 'single',                        data: categories.map(function (a) {                            return a.name;                        })                    }],                    animationDuration: 1500,                    animationEasingUpdate: 'quinticInOut',                    series : [                        {                            name: '关系',                            type: 'graph',                            //layout: 'none',                            layout: 'force',                            data: nodes,                            links: edges,                            categories: categories,                            roam: true,                            label: {                                normal: {                                    position: 'right',                                    formatter: '{b}'                                }                            },                            lineStyle: {                                normal: {                                    color: 'source',                                    //curveness: 0.3                                }                            },                            force: {                                repulsion: 700                            }                        }                    ]                };                myChart.setOption(option);    }</script>