Jsp+Servlet+Echarts实现动态数据可视化

package com.zout.Servlet; import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.Statement; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.codehaus.jackson.map.ObjectMapper; import org.json.JSONArray; import org.json.JSONObject; import com.google.gson.Gson; /** * * @see 查询数据库数据 * @author zoutao * @time 2018/7/11 * */ public class FindServlet extends HttpServlet { private static final long serialVersionUID = 1L; protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response); } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub try { response.setCharacterEncoding("utf-8"); request.setCharacterEncoding("utf-8"); response.setContentType("text/html; charset=utf-8"); // 加载数据库驱动，注册到驱动管理器 Class.forName("com.mysql.jdbc.Driver"); // 数据库连接字符串 String url = "jdbc:mysql://localhost:3306/db_book?useUnicode=true&characterEncoding=utf-8"; // 数据库用户名 String username = "root"; // 数据库密码 String password = "root"; // 创建Connection连接 Connection conn = DriverManager.getConnection(url, username,password); // 添加信息的SQL语句 String sql = "select * from tb_books"; // 获取Statement Statement statement = conn.createStatement(); ResultSet resultSet = statement.executeQuery(sql); //array带回前台 List<Book> list = new ArrayList<Book>(); while(resultSet.next()){ Book book = new Book(); book.setId(resultSet.getInt("id")); book.setUsername(resultSet.getString("username")); book.setPassword(resultSet.getString("password")); list.add(book); } System.out.println("数据:"+list); ObjectMapper mapper = new ObjectMapper(); String json = mapper.writeValueAsString(list); System.out.println("转换的数据:"+json); // 将json字符串数据返回给前端 response.setContentType("text/html; charset=utf-8"); response.getWriter().write(json); /*request.setAttribute("list", list);*/ resultSet.close(); statement.close(); conn.close(); } catch (Exception e) { e.printStackTrace(); } request.getRequestDispatcher("list.jsp").forward(request,response); } }