问题解决:在html页面显示销量等数据库信息
通过这样的算法来实现在html里显示数据库的信息,现在已经可以动态显示在网页里。
效果截图:
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/231c14880990eb0f01a9ca93c5858ad4.png)
<%
int sales=0;
for(Goods goods : list){
int i = list.indexOf(goods);
for(int j=0;j<i;j++){
if(j-1>=0){
sales = list.get(j).getGoods_sell_quantity()+list.get(j-1).getGoods_sell_quantity();
}
else {
sales = list.get(j).getGoods_sell_quantity();
}
}
%>
<%
}
%>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page import="com.etc.dao.GoodsDao" %>
<%@ page import="com.etc.entity.Goods" %>
<%@ page import="com.sun.org.apache.xpath.internal.operations.Variable" %>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="keywords" content="">
<meta name="description" content="">
<meta name="author" content="">
<link rel="icon" href="assets/images/favicon.png" type="image/png">
<title>财务</title>
<link href="assets/plugins/morris-chart/morris.css" rel="stylesheet">
<link href="assets/plugins/jquery-ui/jquery-ui.min.css" rel="stylesheet"/>
<link href="assets/css/icons.css" rel="stylesheet">
<link href="assets/css/bootstrap.min.css" rel="stylesheet">
<link href="assets/css/style.css" rel="stylesheet">
<link href="assets/css/responsive.css" rel="stylesheet">
<!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="js/html5shiv.min.js"></script>
<script src="js/respond.min.js"></script>
<![endif]-->
</head>
<body class="sticky-header">
<%
GoodsDao goodsDao = new GoodsDao();
List<Goods> list = goodsDao.quertAllGoods();
%>
<!--body wrapper start-->
<div class="wrapper">
<!--Start Page Title-->
<div class="page-title-box">
<h4 class="page-title" style="color:orange">华华购物商城欢迎您</h4>
<ol class="breadcrumb">
<li>
<a href="login.jsp">注销</a>
</li>
<li class="active">
我的财务
</li>
</ol>
<div class="clearfix"></div>
</div>
<!--End Page Title-->
<!--Start row-->
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-3">
<div class="analytics-box white-box">
<h3>总利润</h3>
<div class="analytics-info">
<%
double total=0;
for(Goods goods : list){
int i = list.indexOf(goods);
for(int j=0;j<i;j++){
if(j-1>=0){
total = list.get(j).getGoods_cost()+list.get(j-1).getGoods_cost();
}
else {
total = list.get(j).getGoods_cost();
}
}
%>
<%
}
%>
<div class="analytics-stats">
<%=total%>
</div>
<span id="sparklinestats1"></span>
</div>
</div>
</div> <!-- /analytics-box-->
<div class="col-md-3">
<div class="analytics-box white-box">
<h3>销售总额</h3>
<div class="analytics-info">
<%
int sales=0;
for(Goods goods : list){
int i = list.indexOf(goods);
for(int j=0;j<i;j++){
if(j-1>=0){
sales = list.get(j).getGoods_sell_quantity()+list.get(j-1).getGoods_sell_quantity();
}
else {
sales = list.get(j).getGoods_sell_quantity();
}
}
%>
<%
}
%>
<div class="analytics-stats">
<%=sales%>
</div>
<span id="sparklinestats2"></span>
</div>
</div>
</div> <!-- /analytics-box-->
<div class="col-md-3">
<div class="analytics-box white-box">
<h3>总访问量</h3>
<div class="analytics-info">
<div class="analytics-stats">
<%
int number = 0; //定义保存访问次数的变量
//用户第一次访问时
if(application.getAttribute("number")==null){
number = 1;
}else{
//获取application中number值并转化为int数据类型
number=Integer.parseInt(application.getAttribute("number").toString());
number++;
}
application.setAttribute("number",number);
%>
<%=number%>
</div>
<span id="sparklinestats3"></span>
</div>
</div>
</div> <!-- /analytics-box-->
<div class="col-md-3">
<div class="analytics-box white-box">
<h3>推送次数</h3>
<div class="analytics-info">
<div class="analytics-stats">
<%=number%>
</div>
<span id="sparklinestats4"></span>
</div>
</div>
</div> <!-- /analytics-box-->
</div>
</div>
</div>
<!--End row-->
<!--Start row-->
<div class="row">
<div class="col-md-12">
<div class="white-box">
<h2 class="header-title">销售图</h2>
<!--Start chart-->
<div class="col-md-9">
<canvas id="sharpLinechart" height="140"></canvas>
</div>
<!--End chart-->
<div class="col-md-3" align="center">
<div class="progress-main">
<span class="progress-text">总订单</span>
<span class="progress-stats">48%</span>
<div class="progress progress-sm">
<div style="width: 48%;" class="progress-bar"></div>
</div>
</div>
<div class="progress-main">
<span class="progress-text">过去一个月的订单</span>
<span class="progress-stats">60%</span>
<div class="progress progress-sm">
<div style="width: 60%;" class="progress-bar progress-bar-success"></div>
</div>
</div>
<div class="progress-main">
<span class="progress-text">月收入</span>
<span class="progress-stats">22%</span>
<div class="progress progress-sm">
<div style="width: 22%;" class="progress-bar progress-bar-danger"></div>
</div>
</div>
</div>
</div>
</div>
</div>
<!--End row-->
<!-- Start To Do List-->
<!--Begin core plugin -->
<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/bootstrap.min.js"></script>
<script src="assets/plugins/moment/moment.js"></script>
<script src="assets/js/jquery.slimscroll.js "></script>
<script src="assets/js/jquery.nicescroll.js"></script>
<script src="assets/js/functions.js"></script>
<!-- End core plugin -->
<!--Begin Page Level Plugin-->
<script src="assets/plugins/morris-chart/morris.js"></script>
<script src="assets/plugins/morris-chart/raphael-min.js"></script>
<script src="assets/plugins/jquery-sparkline/jquery.charts-sparkline.js"></script>
<script src="assets/pages/dashboard2.js"></script>
<script src="assets/plugins/chart-js/Chart.js"></script>
</div>
</body>
</html>