电力公司电费管理系统（以小区为例）Java语言 MYSQL数据库（数据库暂未打包，下载后留言留下邮箱即发送）

package com.docs.controller; //import java.awt.List;不支持泛型 import java.util.ArrayList; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.docs.dao.DianBiaoDao; import com.docs.dao.XiaoQuDao; import com.docs.dao.YeZhuDao; import com.docs.dao.YuanGongDao; import com.docs.javabean.*; public class Manage extends HttpServlet { private static final long serialVersionUID = 1L; public Manage() { super(); } protected void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { doPost(req, res); } protected void doPost(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { if (req.getSession().getAttribute("userName")!=null) { req.setCharacterEncoding("utf-8"); String url = null; // TODO Auto-generated method stub if (req.getParameter("manage").equals("XiaoQu")) { // 查看小区信息 if (req.getParameter("manageType").equals("query")) { url = "manager/XiaoQuManage.jsp"; } // 添加小区处理 else if (req.getParameter("manageType").equals("add")) { XiaoQu xq = new XiaoQu(); xq.setNum(Integer.valueOf(req.getParameter("Num"))); xq.setSName(req.getParameter("shortName")); xq.setName(req.getParameter("Name")); if (addXiaoQu(xq)) { url = "manager/XiaoQuManage.jsp"; } else { req.setAttribute("errorMessage","添加失败，请检查是否小区已存在或者小区编号已被占用!"); url = "add/AddXiaoQu.jsp"; } } // 删除小区处理 else if (req.getParameter("manageType").equals("delete")) { String xiaoqu_num = req.getParameter("xiaoqu_num"); String xiaoqu_sName = req.getParameter("xiaoqu_sName"); if (deleteXiaoQu(xiaoqu_num, xiaoqu_sName)) { url = "manager/XiaoQuManage.jsp"; } } /* * 从数据库中获取小区信息 */ setXiaoQu(req); req.getRequestDispatcher(url).forward(req, res); } // TODO Auto-generated method stub // 电表 else if (req.getParameter("manage").equals("DianBiao")) { String xiaoqu_short = req.getParameter("xiaoqu_short"); // 查看xiaoqu_short下的电表 if (req.getParameter("manageType").equals("query")) { url = "manager/DianBiaoManage.jsp"; } // 为xiaoqu_short添加电表 else if (req.getParameter("manageType").equals("add")) { DianBiao db = new DianBiao(); db.setDb_num(Integer.valueOf(req.getParameter("Num"))); db.setType(req.getParameter("Type")); db.setWork(req.getParameter("Work")); db.setUsed(req.getParameter("Used")); if (addDianBiao(db, xiaoqu_short)) { url = "manager/DianBiaoManage.jsp"; } else { req.setAttribute("errorMessage", "添加失败，请检查是否电表已存在或者电表编号已被占用!"); url = "add/AddDianBiao.jsp"; } } else if (req.getParameter("manageType").equals("delete")) { String db_num = req.getParameter("dianbiao_num"); if (deleteDianBiao(db_num, xiaoqu_short)) { url = "manager/DianBiaoManage.jsp"; } } // 小区信息 setXiaoQu(req); req.setAttribute("xiaoqu_short", xiaoqu_short); // 小区电表信息 DianBiaoDao dianbiao_dao = new DianBiaoDao(); ArrayList<DianBiao> dianbiao = dianbiao_dao.getDianBiaoList( xiaoqu_short, ""); req.setAttribute("dianbiaoList", dianbiao); req.getRequestDispatcher(url).forward(req, res);// } // TODO Auto-generated method stub // 员工 else if (req.getParameter("manage").equals("YuanGong")) { if (req.getParameter("manageType").equals("query")) { url = "manager/YuanGongManage.jsp"; } else if (req.getParameter("manageType").equals("add")) { YuanGong yg = new YuanGong(); yg.setNum(Integer.valueOf(req.getParameter("Num"))); yg.setName(req.getParameter("Name")); yg.setBumen(req.getParameter("Bumen")); yg.setTel(Long.valueOf(req.getParameter("Tel"))); yg.setPower(Integer.valueOf(req.getParameter("Power"))); yg.setPwd(req.getParameter("Pwd")); if (addYuanGong(yg)) { url = "manager/YuanGongManage.jsp"; } else { req.setAttribute("errorMessage", "添加失败，请检查是否员工已存在或者员工编号已被占用!"); url = "add/AddYuanGong.jsp"; } } else if (req.getParameter("manageType").equals("delete")) { String yg_num = req.getParameter("yuangong_num"); if (deleteYuanGong(yg_num)) { url = "manager/YuanGongManage.jsp"; } } YuanGongDao yuangong_dao = new YuanGongDao(); ArrayList<YuanGong> yuangong = yuangong_dao.getYuanGongList(); req.setAttribute("yuangongList", yuangong); req.getRequestDispatcher(url).forward(req, res); } // TODO Auto-generated method stub // 业主 else if (req.getParameter("manage").equals("YeZhu")) { String xiaoqu_short = req.getParameter("xiaoqu_short"); if (req.getParameter("manageType").equals("query")) { url = "manager/YeZhuManage.jsp"; } else if (req.getParameter("manageType").equals("add")) { YeZhu yz = new YeZhu(); yz.setYz_num(req.getParameter("Num")); yz.setYz_name(req.getParameter("Name")); yz.setID(req.getParameter("ID")); yz.setTel(Long.valueOf(req.getParameter("Tel"))); yz.setCompany(req.getParameter("Company")); yz.setDb_num(Integer.valueOf(req.getParameter("DianBiao"))); if (addYeZhu(yz, xiaoqu_short)) { url = "manager/YeZhuManage.jsp"; } else { req.setAttribute("errorMessage", "添加失败，请检查是否业主已存在或者业主编号已被占用!"); url = "add/AddYuanGong.jsp"; } } else if (req.getParameter("manageType").equals("delete")) { String yz_num = req.getParameter("yezhu_num"); String db_num = req.getParameter("dianbiao_num"); if (deleteYeZhu(yz_num, xiaoqu_short, db_num)) { url = "manager/YeZhuManage.jsp"; } } // 小区信息 setXiaoQu(req); req.setAttribute("xiaoqu_short", xiaoqu_short); // 小区业主信息 YeZhuDao yezhu_dao = new YeZhuDao(); ArrayList<YeZhu> yezhu = yezhu_dao.getYeZhuList(xiaoqu_short); req.setAttribute("yezhuList", yezhu); req.getRequestDispatcher(url).forward(req, res); } } else{ req.getRequestDispatcher("Login.jsp").forward(req, res); } } /* * 小区处理--从小区表删除记录，并删除其表-业主表与电表表 */ private boolean deleteXiaoQu(String xiaoqu_num, String xiaoqu_sName) { XiaoQuDao xiaoqu_dao = new XiaoQuDao(); return xiaoqu_dao.deleteXiaoQu(xiaoqu_num, xiaoqu_sName); } // 获取 private static void setXiaoQu(HttpServletRequest req) { XiaoQuDao xiaoqu_dao = new XiaoQuDao(); req.setAttribute("xiaoquList", xiaoqu_dao.getXiaoQuList()); } // 添加 private static boolean addXiaoQu(XiaoQu xq) { String sql = "insert into xiaoqu values(" + xq.getNum() + ",'" + xq.getSName() + "','" + xq.getName() + "');"; XiaoQuDao xiaoqu_dao = new XiaoQuDao(); return xiaoqu_dao.addXiaoQu(sql, xq.getSName()); } // TODO Auto-generated method stub /* * 电表处理 */ // 添加 private static boolean addDianBiao(DianBiao db, String xiaoqu_short) { String sql = "insert into " + xiaoqu_short + "_dianbiao values(" + db.getDb_num() + ",'" + db.getType() + "','" + db.getWork() + "','" + db.getUsed() + "');"; System.out.println(sql); DianBiaoDao dianbiao_dao = new DianBiaoDao(); return dianbiao_dao.addDianBiao(sql); } // 删除 private boolean deleteDianBiao(String db_num, String xiaoqu_short) { String sql = "delete from " + xiaoqu_short + "_dianbiao where db_num=" + db_num + " and used='未使用';"; System.out.println(sql); DianBiaoDao dianbiao_dao = new DianBia