1200字范文 > 利用jsp和servlet MySQL实现简易报表

利用jsp和servlet MySQL实现简易报表

时间：2019-01-21 04:09:28

beans包和jdbc包代码不放了，麻烦

Service.java:

package service;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.ArrayList;

import java.util.List;

import beans.Profit;

import jdbc.JdbcConn;

public class Service {

private Connection dbconnection;

private Statement st,st1,st2;

private ResultSet rs,rs1,rs2;

private String sql,sql1,sql2;

private List list;

private Profit pf;

public List getProfit(){

list=new ArrayList();

dbconnection=JdbcConn.getCon();

try {

st=(Statement)dbconnection.createStatement();

st1=(Statement)dbconnection.createStatement();

st2=(Statement)dbconnection.createStatement();

sql="SELECT g.GOODS_NAME goodsName,g.SELLING_PRICE selling,g.COST_PRICE costPrice,g.GOODS_ID goodsId FROM t_goods g,t_trading t WHERE t.TRADING_GOODS_ID=g.GOODS_ID GROUP BY g.GOODS_NAME";

rs=st.executeQuery(sql);

int temp;

while(rs.next()){

pf=new Profit();

pf.setGoodsName(rs.getString("goodsName"));

pf.setSellingPrice(rs.getInt("selling"));

pf.setCostPrice(rs.getInt("costPrice"));

pf.setGoodsId(rs.getInt("goodsId"));

temp=0;

temp=pf.getSellingPrice()-pf.getCostPrice();

sql1="SELECT SUM(t.TRADING_NUMBER) sunNum FROM t_trading t WHERE t.TRADING_GOODS_ID="+pf.getGoodsId();

rs1=st1.executeQuery(sql1);

while(rs1.next()){

pf.setTradingNum(rs1.getInt("sunNum"));

}

pf.setProfit(temp*pf.getTradingNum());

sql2="SELECT COUNT(t.TRADING_GOODS_ID) times FROM t_trading t WHERE t.TRADING_GOODS_ID="+pf.getGoodsId();

rs2=st2.executeQuery(sql2);

while(rs2.next()){

pf.setTimes(rs2.getInt("times"));

}

list.add(pf);

}

} catch (SQLException e) {

e.printStackTrace();

}

return list;

}

ShowReport.java:

package servlet;

import java.io.IOException;

import java.io.PrintWriter;

import java.util.List;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import service.Service;

public class ShowReport extends HttpServlet {

public void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

List list;

Service service=new Service();

list=service.getProfit();

request.getSession().setAttribute("PROFIT",list);

response.sendRedirect("index.jsp");

}

@Override

protected void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

this.doPost(request, response);

}

index.jsp:

<%@ page language="java" import="java.util.*,beans.*" pageEncoding="utf-8"%>

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<title>原生态java报表生成</title>

table.hovertable{

font-size:13px;

color:#333333;

border-width:1px;

border-color:#999999;

border-collapse: collapse;

}

table.hovertable th{

background-color:#c3dde0;

border-width:1px;

padding:8px;

border-style:solid;

border-color:#a9c6c9;

}

table.hovertable tr{

background-color:#d4e3e5;

}

table.hovertable td{

border-width:1px;

padding:8px;

border-style:solid;

border-color:#a9c6c9;

}

</style>

</head>

<body>

</form>

<tr>

</tr>

List list=null;

if(session.getAttribute("PROFIT")!=null){

list=(List)session.getAttribute("PROFIT");

if(list.size()>0){

int temp=0;

int temp1=0;

int temp2=0;

int temp3=0;

Profit pf;

for(int i=0;i<list.size();i++){

pf=new Profit();

pf=(Profit)list.get(i);

temp1+=pf.getTradingNum();

temp2+=pf.getTimes();

temp3+=pf.getProfit();

<tr οnmοuseοver="this.style.backgroundColor='#ffff66';"

οnmοuseοut="this.style.backgroundColor='#d4e3e5';">

</tr>

}%>

<tr οnmοuseοver="this.style.backgroundColor='#ffff66';"

οnmοuseοut="this.style.backgroundColor='#d4e3e5';">

</tr>

}

</table>

</body>

</html>

本内容不代表本网观点和政治立场，如有侵犯你的权益请联系我们处理。

网友评论

网友评论仅供其表达个人看法，并不表明网站立场。