基于idea-SSM的智能电网用电量收费缴费显示模拟分析系统-javaweb-php-asp.netC#-j2ee-springboot

 

目录

 

 

1 概述

 

2 数据库表

 

3 关键代码

4 效果演示

 

---

 

1 概述

 

系统管理：该模块实现的功能有系统属性、管理员维护、修改密码。主要是对系统的维护信息的分析；

电网管理：该模块实现的功能有电网产品分类、添加分类、电网产品管理、添加产品。产品分类主要是对分类管理的添加、删除修改；产品管理主要是对产品信息进行添加、删除、修改等，如类别、名称、等；

客户管理：该模块实现的功能有客户管理、添加客户。主要是对客户信息的添加、删除、修改，如姓名、性别、年龄、联系电话、住址；

电量管理：该模块主要实现的功能有用电量登记、用户量统计。

2 数据库表

 

5	t_dianliangmingxi	电量明细
字段名称	自动增长		字段类型	说明
id	-		int	-
dianliang_id	-		int	编号
goods_id	-		int	电编号
shuliang	-		int	数量
beizhu	-		varchar	备注
b_numb	-		int	上次数量
e_numb	-		int	本次数量

 

3 关键代码

 

 

package com.action;

import java.io.IOException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.directwebremoting.WebContext;
import org.directwebremoting.WebContextFactory;

import com.dao.DB;
import com.orm.TAdmin;
import com.orm.Tgoods;
import com.orm.Tdianliang;
import com.orm.TdianliangMingxi;

import com.service.liuService;

public class dianliang_servlet extends HttpServlet
{ 
	public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException 
	{
		String type=req.getParameter("type");
		
		if(type.endsWith("dianliangAdd"))
		{
			dianliangAdd(req, res);
		}
		if(type.endsWith("dianliangEdit"))
		{
			dianliangEdit(req, res);
		}
		if(type.endsWith("dianliangMana"))
		{
			dianliangMana(req, res);
		}
		if(type.endsWith("dianliangDel"))
		{
			dianliangDel(req, res);
		}
		
		if(type.endsWith("dianliangMingxiAdd"))
		{
			dianliangMingxiAdd(req, res);
		}
		if(type.endsWith("dianliangMingxiMana"))
		{
			dianliangMingxiMana(req, res);
		}
		if(type.endsWith("dianliangMingxiDel"))
		{
			dianliangMingxiDel(req, res);
		}
	}
	
	
	
	
	public void dianliangAdd(HttpServletRequest req,HttpServletResponse res)
	{
		String danjuhao=req.getParameter("danjuhao");
		String shijian=req.getParameter("shijian");
		int zongjiage=Integer.parseInt(req.getParameter("zongjiage"));
		String jingshouren=req.getParameter("jingshouren");
		String beizhu=req.getParameter("beizhu");
		String del="no";
		
		String sql="insert into t_dianliang (`danjuhao`, `shijian`, `zongjiage`, `jingshouren`, `beizhu`, `del`)  values(?,?,?,?,?,?)";
		Object[] params={danjuhao,shijian,zongjiage,jingshouren,beizhu,del};
		DB mydb=new DB();
		mydb.doPstm(sql, params);
		mydb.closed();
		
		req.setAttribute("message", "操作成功");
		req.setAttribute("path", "dianliang?type=dianliangMana");
		
        String targetURL = "/common/success.jsp";
		dispatch(targetURL, req, res);
	}
	
	public void dianliangEdit(HttpServletRequest req,HttpServletResponse res)
	{
		String danjuhao=req.getParameter("danjuhao");
		String shijian=req.getParameter("shijian");
		int zongjiage=Integer.parseInt(req.getParameter("zongjiage"));
		String jingshouren=req.getParameter("jingshouren");
		String beizhu=req.getParameter("beizhu");
		String del="no";
		
		String sql="update t_dianliang set danjuhao='"+danjuhao+"',shijian='"+shijian+"',zongjiage='"+zongjiage+"',jingshouren='"+jingshouren+"',beizhu='"+beizhu+"' where id="+Integer.parseInt(req.getParameter("id"));
		Object[] params={};
		DB mydb=new DB();
		mydb.doPstm(sql, params);
		mydb.closed();
		
		req.setAttribute("message", "操作成功");
		req.setAttribute("path", "dianliang?type=dianliangMana");
		
        String targetURL = "/common/success.jsp";
		dispatch(targetURL, req, res);
	}
	
	public void dianliangDel(HttpServletRequest req,HttpServletResponse res)
	{
		int id=Integer.parseInt(req.getParameter("id"));
		
		String sql="update t_dianliang set del='yes' where id=?";
		Object[] params={id};
		DB mydb=new DB();
		mydb.doPstm(sql, params);
		mydb.closed();
		
		req.setAttribute("message", "操作成功");
		req.setAttribute("path", "dianliang?type=dianliangMana");
		
        String targetURL = "/common/success.jsp";
		dispatch(targetURL, req, res);
	}
	
	public void dianliangMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
	{
		String page1=req.getParameter("page");
		if(page1==null){
			page1="1";
		}
		//分页设置
		int EVERYPAGENUM=10;//每页条数
		int page=Integer.parseInt(page1);   //传递过来的当前页
		int cou = 1;//得到信息总数	
		int pagecount=1;  //总页数
		String sql1="select count(*) as cou from t_dianliang where del='no'";
		Object[] params1={};
		DB mydb1=new DB();
		try
		{
			mydb1.doPstm(sql1, params1);
			ResultSet rs=mydb1.getRs();
			while(rs.next())
			{
			cou= rs.getInt("cou");
			}
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb1.closed();
		
		
		
		if (cou % EVERYPAGENUM == 0) {
			pagecount= cou / EVERYPAGENUM;
        } else {
        	pagecount=cou / EVERYPAGENUM + 1;
        }	
		
		
		
		
		
		
		req.setAttribute("EVERYPAGENUM", EVERYPAGENUM);	
		req.setAttribute("page", page);
		req.setAttribute("cou", cou);
		req.setAttribute("pagecount", pagecount);
		
		
		
		List dianliangList=new ArrayList();
		String sql="select * from t_dianliang where del='no'";
		Object[] params={};
		DB mydb=new DB();
		try
		{
			mydb.doPstm(sql, params);
			ResultSet rs=mydb.getRs();
			 for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) {
	                rs.next();
	            }
	            for (int t = 0; t < EVERYPAGENUM; t++) {
	                if (rs.next()) {
				Tdianliang dianliang=new Tdianliang();
				dianliang.setId(rs.getInt("id"));
				dianliang.setDanjuhao(rs.getString("danjuhao"));
				dianliang.setShijian(rs.getDate("shijian"));
				dianliang.setZongjiage(rs.getInt("zongjiage"));
				dianliang.setJingshouren(rs.getString("jingshouren"));
				dianliang.setBeizhu(rs.getString("beizhu"));
				dianliangList.add(dianliang);
	                } else {
	                    break; //减少空循环的时间
	                }
	            }
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb.closed();
		
		req.setAttribute("dianliangList", dianliangList);
		req.getRequestDispatcher("admin/dianliang/dianliangMana.jsp").forward(req, res);
	}
	
	
	
	public void dianliangMingxiAdd(HttpServletRequest req,HttpServletResponse res)
	{
		
		int dianliang_id=Integer.parseInt(req.getParameter("dianliang_id"));
		int goods_id=Integer.parseInt(req.getParameter("goods_id"));
		int shuliang=Integer.parseInt(req.getParameter("shuliang"));
		int b_numb=Integer.parseInt(req.getParameter("b_numb"));
		int e_numb=Integer.parseInt(req.getParameter("e_numb"));
		String beizhu=req.getParameter("beizhu");
		
		String sql="insert into t_dianliangMingxi (`dianliang_id`, `goods_id`, `shuliang`, `beizhu`, `b_numb`, `e_numb`)  values(?,?,?,?,?,?)";
		Object[] params={dianliang_id,goods_id,shuliang,beizhu,b_numb,e_numb};
		DB mydb=new DB();
		mydb.doPstm(sql, params);
		mydb.closed();
		
		req.setAttribute("msg", "操作成功");
        String targetURL = "/common/msg.jsp";
		dispatch(targetURL, req, res);
	}
	
	
	public void dianliangMingxiMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
	{
		int dianliang_id=Integer.parseInt(req.getParameter("dianliang_id"));
		
		List dianliangMingxiList=new ArrayList();
		String sql="select * from t_dianliangMingxi where dianliang_id="+dianliang_id;
		Object[] params={};
		DB mydb=new DB();
		try
		{
			mydb.doPstm(sql, params);
			ResultSet rs=mydb.getRs();
			while(rs.next())
			{
				TdianliangMingxi dianliangMingxi=new TdianliangMingxi();
				
				dianliangMingxi.setId(rs.getInt("id"));
				dianliangMingxi.setDianliang_id(rs.getInt("dianliang_id"));
				dianliangMingxi.setGoods_id(rs.getInt("goods_id"));
				dianliangMingxi.setShuliang(rs.getInt("shuliang"));
				dianliangMingxi.setBeizhu(rs.getString("beizhu"));
				dianliangMingxi.setB_numb(rs.getInt("b_numb"));
				dianliangMingxi.setE_numb(rs.getInt("e_numb"));
				
				dianliangMingxi.setGoods_name(liuService.getGoodsName(rs.getInt("goods_id")));
				
				dianliangMingxiList.add(dianliangMingxi);
		    }
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		mydb.closed();
		System.out.println(dianliangMingxiList.size());
		req.setAttribute("dianliangMingxiList", dianliangMingxiList);
		req.setAttribute("dianliang_id", dianliang_id);
		req.getRequestDispatcher("admin/dianliang/dianliangMingxiMana.jsp").forward(req, res);
	}
	
	public void dianliangMingxiDel(HttpServletRequest req,HttpServletResponse res)
	{
		
		int id=Integer.parseInt(req.getParameter("id"));
		
		String sql="delete from t_dianliangMingxi where id="+id;
		Object[] params={};
		DB mydb=new DB();
		mydb.doPstm(sql, params);
		mydb.closed();
		
		req.setAttribute("msg", "操作成功");
        String targetURL = "/common/msg.jsp";
		dispatch(targetURL, req, res);
	}
	
	public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response) 
	{
		RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
		try 
		{
		    dispatch.forward(request, response);
		    return;
		} 
		catch (ServletException e) 
		{
                    e.printStackTrace();
		} 
		catch (IOException e) 
		{
			
		    e.printStackTrace();
		}
	}
	public void init(ServletConfig config) throws ServletException 
	{
		super.init(config);
	}
	
	public void destroy() 
	{
		
	}
}

4 效果演示

 

 

idea或eclipse开发,mysql数据库