疫情图表

package bean;

public class Data {
private int id;
private String Date;
private String Province;
private String City;
private String Confirmed_num;
private String Yisi_num;
private String Cured_num;
private String Dead_num;
private String Code;

public int getId() {
return id;
}
public void SetId(int id)
{
this.id=id;
}
public String getDate() {
return Date;
}
public void SetDate(String Date) {
this.Date = Date;
}
public String getProvince() {
return Province;
}
public void SetProvince(String Province) {
this.Province = Province;
}
public String getCity() {
return City;
}
public void SetCity(String City) {
this.City = City;
}
public String getConfirmed_num() {
return Confirmed_num;
}
public void SetConfirmed_num(String Confirmed_num) {
this.Confirmed_num = Confirmed_num;
}
public String getYisi_num() {
return Yisi_num;
}
public void SetYisi_num(String Yisi_num) {
this.Yisi_num = Yisi_num;
}
public String getCured_num() {
return Cured_num;
}
public void SetCured_num(String Cured_num) {
this.Cured_num = Cured_num;
}
public String getDead_num() {
return Dead_num;
}
public void SetDead_num(String Dead_num) {
this.Dead_num = Dead_num;
}
public String getCode() {
return Code;
}
public void SetCode(String Code) {
this.Code = Code;
}

public Data(int id,String Date,String Province,String City,String Confirmed_num,String Yisi_num,String Cured_num,String Dead_num,String Code) {
this.id=id;
this.Date = Date;
this.Province = Province;
this.City = City;
this.Confirmed_num = Confirmed_num;
this.Yisi_num = Yisi_num;
this.Cured_num = Cured_num;
this.Dead_num = Dead_num;
this.Code = Code;
}
public Data(int id,String Province,String City,String Confirmed_num,String Yisi_num,String Cured_num,String Dead_num,String Code) {
this.id=id;
this.Province = Province;
this.City = City;
this.Confirmed_num = Confirmed_num;
this.Yisi_num = Yisi_num;
this.Cured_num = Cured_num;
this.Dead_num = Dead_num;
this.Code = Code;
}
public Data(int id,String Date,String Province,String Confirmed_num,String Cured_num,String Dead_num,String Code) {
this.id=id;
this.Date = Date;
this.Province = Province;
this.Confirmed_num = Confirmed_num;
this.Cured_num = Cured_num;
this.Dead_num = Dead_num;
this.Code = Code;
}
public Data(String Date,String Province,String Confirmed_num,String Cured_num,String Dead_num,String Code) {
this.Date = Date;
this.Province = Province;
this.Confirmed_num = Confirmed_num;
this.Cured_num = Cured_num;
this.Dead_num = Dead_num;
this.Code = Code;
}
public Data(int id ,String Date,String Province,String Code) {
this.id=id;
this.Date = Date;
this.Province = Province;
this.Code = Code;
}

}

package dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import bean.*;
import jdbc.Util;

public class Dao {

public List<Data> dlist(String sDate,String eDate) { // 查询所有信息

String begin="";
String []s=sDate.split("-");
for(int i=0;i<s.length;i++)
begin+=s[i].toString();

String end="";
String []e=eDate.split("-");
for(int i=0;i<e.length;i++)
end+=e[i].toString();

int bg=Integer.valueOf(begin);
int ed=Integer.valueOf(end);

List<Data> list = new ArrayList<Data>(); // 创建集合
Connection conn = Util.getConn();
String sql = "select * from info "; // SQL查询语句

try {

PreparedStatement pst = conn.prepareStatement(sql);

ResultSet rs = pst.executeQuery();

Data data = null;

while (rs.next()) {

int id= rs.getInt("id");;

String Province = rs.getString("Province");

String Confirmed_num = rs.getString("Confirmed_num");

String Yisi_num = rs.getString("Yisi_num");

String Cured_num = rs.getString("Cured_num");

String Dead_num = rs.getString("Dead_num");

String Code = rs.getString("Code");

String City = rs.getString("City");

String Date=rs.getString("Date");

String num="";
String date=Date.substring(0, 10);
String []d=date.split("-");
for(int i=0;i<d.length;i++)
{
num+=d[i].toString();
}
int k=Integer.valueOf(num);

if(k>=bg&&k<=ed) {
data = new Data(id,Province,City,Confirmed_num,Yisi_num,Cured_num,Dead_num,Code);
}
list.add(data);

}

rs.close(); // 关闭

pst.close(); // 关闭

} catch (SQLException e1) {

e1.printStackTrace(); // 抛出异常

}

return list; // 返回一个集合

}
public List<Data> pres() { // 查询所有信息

List<Data> list = new ArrayList<Data>();
Connection conn = Util.getConn();
String sql = "select * from info"; // SQL查询语句

try {

PreparedStatement pst = conn.prepareStatement(sql);

ResultSet rs = pst.executeQuery();

Data data = null;

int index=0;
while (rs.next()) {

index++;

int id= rs.getInt("id");;

String Province = rs.getString("Province");

String Confirmed_num = rs.getString("Confirmed_num");

String Yisi_num = rs.getString("Yisi_num");

String Cured_num = rs.getString("Cured_num");

String Dead_num = rs.getString("Dead_num");

String Code = rs.getString("Code");

String City = rs.getString("City");

String Date=rs.getString("Date");

if(index<=32) {
data = new Data(id,Date,Province,City,Confirmed_num,Yisi_num,Cured_num,Dead_num,Code);
list.add(data);
}

}

rs.close(); // 关闭

pst.close(); // 关闭

} catch (SQLException e1) {

e1.printStackTrace(); // 抛出异常

}

return list; // 返回一个集合

}

public Data SelectAll() { // 根据ID进行查询
String sql = "select * from info ";
Connection conn = Util.getConn();
Statement state = null;
ResultSet rs = null;
Data data = null;
try {
state = conn.createStatement();
rs = state.executeQuery(sql);
while (rs.next()) {

int id= rs.getInt("id");;

String Province = rs.getString("Province");

String Confirmed_num = rs.getString("Confirmed_num");

String Yisi_num = rs.getString("Yisi_num");

String Cured_num = rs.getString("Cured_num");

String Dead_num = rs.getString("Dead_num");

String Code = rs.getString("Code");

String City = rs.getString("City");

String Date=rs.getString("Date");

data = new Data(id,Date,Province,City,Confirmed_num,Yisi_num,Cured_num,Dead_num,Code);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
Util.close(rs, state, conn);
}
return data;
}

}

package jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
* 数据库连接工具
* @author YP
*/
public class Util {
public static String db_url = "jdbc:mysql://localhost:3306/test?serverTimezone=UTC";
public static String db_user = "root";
public static String db_pass = "root";
public static Connection getConn () {
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");//加载驱动
conn = DriverManager.getConnection(db_url, db_user, db_pass);
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
/**
* 关闭连接
* @param state
* @param conn
*/
public static void close (Statement state, Connection conn) {
if (state != null) {
try {
state.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static void close (ResultSet rs, Statement state, Connection conn) {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (state != null) {
try {
state.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}

package servlet;

import java.io.IOException;

import java.util.List;

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 javax.servlet.http.HttpSession;

import bean.Data;
import dao.Dao;

@WebServlet("/AllDataServlet")
public class AllDataServlet extends HttpServlet { // 显示全部数据

private static final long serialVersionUID = 1L;

protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

this.doPost(req, resp);

}

protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

req.setCharacterEncoding("utf-8");

Dao dao = new Dao();
List<Data> pres=null;
pres=dao.pres();
req.setAttribute("pres",pres);

req.getRequestDispatcher("ShowData.jsp").forward(req, resp);

}

package servlet;

import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

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 javax.servlet.http.HttpSession;

import bean.*;
import dao.Dao;

@WebServlet("/ShowDataServlet")
public class ShowDataServlet extends HttpServlet { // 显示全部数据

private static final long serialVersionUID = 1L;

protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

this.doPost(req, resp);

}

protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

req.setCharacterEncoding("utf-8");
String sDate=req.getParameter("stime");
String eDate=req.getParameter("etime");
Dao dao = new Dao();
List<Data> list=null;
list=dao.dlist(sDate, eDate);
req.setAttribute("list",list);
req.getRequestDispatcher("AllDataServlet").forward(req, resp);

}

<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@page import="com.bean.Data" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<meta charset="UTF-8">

</head>

<body >
<br>
<h1>疫情统计表</h1>
<div id="main" style="height:400px"></div>
<div id="main2" style="height:600px;"></div>
<div>
开始日期：<input type="date" id="btime" name="btime">(日期格式xxxx-xx-xx)<br />
截止日期：<input type="date" id="etime" name="etime">
<button type="button" class="btn btn-info" onclick="checkfind()">查询</button>    
<br><br>
<table >

<tr>

<c:forEach items="${list}" var="item">

<tr>

<td>${item.province }</td>

<td>${item.city }</td>

<td>${item.confirmed_num }</td>

<td>${item.yisi_num }</td>

<td>${item.cured_num}</td>

<td>${item.dead_num }</td>

<td>${item.code }</td>

</tr>

</c:forEach>

</table>
</div>
<script type="text/javascript">
// 基于准备好的dom，初始化echarts实例
var myChart = echarts.init(document.getElementById('main'));

var arr = new Array();
var index = 0;
<c:forEach items="${pres}" var="goods">
arr[index++] = ${goods.confirmed_num};

</c:forEach>

// 指定图表的配置项和数据
var option = {
title: {
text: '全国疫情统计(柱状图)'
},
tooltip: {
show: true
},
legend: {
data:['患者数']
},
xAxis : [
{
type : 'category',

axisLabel:{
interval:0,
rotate:40,
},
data : [
<c:forEach items="${pres}" var="g">
["${g.province}"],
</c:forEach>
]
}
],
yAxis : [
{
type : 'value'
}
],
series : [
{
name:'患者数',
type:'bar',
data: arr
}
]
};

// 使用刚指定的配置项和数据显示图表
myChart.setOption(option);

var myChart2=echarts.init(document.getElementById("main2"));

var option={

title:{
text:'全国疫情统计(折线图)'
},

toolbox:{
show:true,
feature:{
saveAsImage:{
show:true
}
}
},

legend:{
data:['患者数']
},

xAxis : [
{
type : 'category',
axisLabel:{
interval:0,
rotate:40,
},
data : [
<c:forEach items="${pres}" var="g">
["${g.province}"],
</c:forEach>
]
}
],

yAxis : [
{
type : 'value'
}
],

series:[{
name:'患者数',
type:'line',
data:arr,
itemStyle:{
normal:{
label : {
show: true
},
borderColor:'blue',
lineStyle:{
width:5,
type:'solid'
}
}
}
}]
};

//使用前面指定的配置项和数据项显示图表
myChart2.setOption(option);

</script>
<script type="text/javascript">
function checkfind()
{
var stime=document.getElementById("btime").value;
var etime=document.getElementById("etime").value;
if(btime==""&&etime=="")
{
alert("请输入时间！");
return ;
}
else
{
window.location.href = "ShowDataServlet?name="+name+"&stime="+stime+"&etime="+etime;
}
}
</script>

</body>
</html>

posted @ 2020-03-08 23:10 明月照我还阅读(224) 评论(0) 编辑收藏举报

刷新页面返回顶部

明月照我还

疫情图表

公告