Java Echarts通过数据库异步加载图表

最新推荐文章于 2023-11-17 17:48:34 发布

暖暖的味道

最新推荐文章于 2023-11-17 17:48:34 发布

阅读量316

点赞数

文章标签： echarts javascript

本文链接：https://blog.csdn.net/weixin_56853728/article/details/128153858

版权

1.入门练习

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
 <script src="js/echarts.min.js" ></script>
    </head>
    <body>
     <div id="main" style="width: 600px;height:400px;"></div>
    <script type="text/javascript">
        // 基于准备好的dom，初始化echarts实例
        var myChart = echarts.init(document.getElementById('main'));
        // 指定图表的配置项和数据
        var option1 = {
            title: {
                text: 'ECharts 入门示例'
            },
             xAxis: {
                data: ["衬衫","羊毛衫","雪纺衫","裤子","高跟鞋","袜子"]
            },
            yAxis: {},
            series: [{
                name: '销量',
                type: 'line',
                data: [5, 20, 36, 10, 10, 20]
            }]
        };
        // 使用刚指定的配置项和数据显示图表。
        myChart.setOption(option1);
    </script>
</body>
</html>

2.异步加载图表，在数据库中添加删除后，刷新界面会更改数据

echarts.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<!-- 引入 echarts.js -->
<script type="text/javascript" src="js/echarts.min.js"></script>
<!-- 引入jquery.js -->
<script type="text/javascript" src="js/jquery-1.12.3.js"></script>
</head>
<body>
<div id="main" style="width: 600px;height:400px;"></div>
<script type="text/javascript">
var myChart = echarts.init(document.getElementById('main'));
 // 显示标题，图例和空的坐标轴
 myChart.setOption({
     title: {
         text: '异步数据加载示例'
     },
         xAxis: {
         data: []
     },
     yAxis: {},
     series: [{
    	 name: '销量',
         type: 'bar',
         data: []
     }]
 });
 //myChart.showLoading();    //数据加载完之前先显示一段简单的loading动画
 var names=[];    //类别数组（实际用来盛放X轴坐标值）
 var nums=[];  //销量数组（实际用来盛放Y坐标值）
 $.ajax({
 type : "post",
 async : true,            //异步请求（同步请求将会锁住浏览器，用户其他操作必须等待请求完成才可以执行）
 url : "TestServlet",    //请求发送到TestServlet处
 data : {},
 dataType : "json",        //返回数据形式为json
 success : function(result) {
     //请求成功时执行该函数内容，result即为服务器返回的json对象
     if (result) {
            for(var i=0;i<result.length;i++){       
               names.push(result[i].name);    //挨个取出类别并填入类别数组
             }
            for(var i=0;i<result.length;i++){       
                nums.push(result[i].num);    //挨个取出销量并填入销量数组
              }
            myChart.hideLoading();    //隐藏加载动画
            myChart.setOption({        //加载数据图表
                xAxis: {
                    data: names
                },
                series: [{
                    data: nums
                }]
            });           
     }
},
 error : function(errorMsg) {
     //请求失败时执行该函数
 alert("图表请求数据失败!");
 //myChart.hideLoading();
 }
})
</script>
</body>
</html>

Product.java (注意包名，我是在com.cn下建立的类)

package com.cn;

public class Product {
	    private String name;    //类别名称
	    private int num;        //销量
	    public String getName() {
	        return name;
	    }
	    public void setName(String name) {
	        this.name = name;
	    }
	    public int getNum() {
	        return num;
	    }
	    public void setNum(int num) {
	        this.num = num;
	    }
	}

TestServlet.java

package com.cn;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import java.util.*;
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.fasterxml.jackson.databind.ObjectMapper;
/**
 * Servlet implementation class TestServlet
 */
@WebServlet("/TestServlet")
public class TestServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public TestServlet() {
        super();
        // TODO Auto-generated constructor stub
    }
	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		   response.setContentType("text/html; charset=utf-8");   
		   PrintWriter  out= response.getWriter();
		   List<Product> list = new ArrayList<Product>();
		   Connection con=null;
		   Statement stmt=null;
		   ResultSet rst=null;
		   try {
			 Class.forName("com.mysql.jdbc.Driver");
			 con=DriverManager.getConnection("jdbc:mysql://localhost:3306/sss","root","123456");
			 stmt=con.createStatement();
			 rst=stmt.executeQuery("select * from product");
			 while(rst.next())
			   {
				  Product pro=new Product();
			      pro.setName(rst.getString(2));
			      pro.setNum(rst.getInt(3));
			      list.add(pro);  
			   }
			    ObjectMapper mapper = new ObjectMapper();    //提供java-json相互转换功能的类  
		        String json = mapper.writeValueAsString(list);    //将list中的对象转换为Json格式的数组
		        
		        //将json数据返回给客户端
		        out.write(json);    
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			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);
	}
}

数据库中的数据，数据库名为sss,表名为product