GDP 经济地图可视化展示

package com.qfedu.servlet; import com.alibaba.fastjson.JSON; 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 java.io.IOException; import java.math.BigDecimal; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; @WebServlet(value = "/updateServlet") public class updateServlet extends HttpServlet { @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { resp.setHeader("Content-type","text/html;charset=UTF-8");//设置响应内容类型 resp.setContentType("application/json;chatset=utf8");//设置字符集及响应类型 try { Class.forName("com.mysql.cj.jdbc.Driver"); Connection connection= DriverManager.getConnection("jdbc:mysql://localhost:3306/progdp","root","123456"); PreparedStatement pstmt=connection.prepareStatement("update city_gdp set gdp=? where city=? and year =?"); String gdp=req.getParameter("gdp"); String city_no=req.getParameter("city_no"); String year=req.getParameter("year"); String city=""; switch (city_no){ case "101": city="青岛市"; break; case "102": city="济南市"; break; case "103": city="烟台市"; break; case "104": city="潍坊市"; break; case "105": city="临沂市"; break; case "106": city="济宁市"; break; case "107": city="淄博市"; break; case "108": city="菏泽市"; break; case "109": city="德州市"; break; case "110": city="威海市"; break; case "111": city="东营市"; break; case "112": city="泰安市"; break; case "113": city="滨州市"; break; case "114": city="聊城市"; break; case "115": city="日照市"; break; case "116": city="枣庄市"; break; } System.out.println(city); System.out.println(year); System.out.println(gdp); System.out.println(city_no); pstmt.setString(1,gdp); pstmt.setString(2,city); pstmt.setString(3,year); pstmt.executeUpdate(); resp.sendRedirect("index.jsp"); } catch (Exception e) { e.printStackTrace(); } } }