目录

1 概述

2 数据库表

3 关键代码

4 效果演示

1 概述

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

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

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

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

2 数据库表

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数据库