SSM框架60018高校快递收发网站 (idea开发javaweb-php-asp.netC#-j2ee-springboot)收件人-投递信息-到达状态-存放位置-收货人-签收退货-已收快件管理

1 概述

该系统实现了前台用户登录、注册、网站公告、留言板、会员中心、管理员登录；后台实现的功能有管理员管理、公告管理、网点管理、投递管理、收件人管理、留言板。

2 数据库表

表5 t_shoujianren收件人

表6 t_toudi  快递投递

3 关键代码

package com.action;import java.io.IOException;
import java.sql.ResultSet;
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 com.dao.DB;
import com.orm.TAdmin;
import com.orm.Tshoujianren;public class shoujianren_servlet extends HttpServlet {public void service(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {String type = req.getParameter("type");if (type.equals("edit")) {edit(req, res);}if (type.endsWith("editsave")) {editsave(req, res);}if (type.endsWith("shoujianrenMana")) {shoujianrenMana(req, res);}if (type.endsWith("shoujianrenAdd")) {shoujianrenAdd(req, res);}if (type.endsWith("shoujianrenDel")) {shoujianrenDel(req, res);}if (type.equals("reg")) {reg(req, res);}if (type.equals("edit_q")) {edit_q(req, res);}if (type.equals("editsave_q")) {editsave_q(req, res);}}// 前台注册public void reg(HttpServletRequest req, HttpServletResponse res) {String name = req.getParameter("name");String sex = req.getParameter("sex");int age = Integer.parseInt(req.getParameter("age"));String dianhua = req.getParameter("dianhua");String dizhi = req.getParameter("dizhi");String loginpw = req.getParameter("loginpw");String del = "no";String sql = "insert into t_shoujianren values(?,?,?,?,?,?,?,?)";Object[] params = { null, name, sex, age, dianhua, dizhi,  del, loginpw };DB mydb = new DB();mydb.doPstm(sql, params);mydb.closed();req.setAttribute("message", "操作成功");req.setAttribute("path", "index");String targetURL = "/common/success.jsp";dispatch(targetURL, req, res);}// 前台修改信息public void edit_q(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {HttpSession session = req.getSession();Tshoujianren shoujianren = (Tshoujianren) session.getAttribute("shoujianren");int id = shoujianren.getId();// 当前登录的用户的IDString sql = "select * from t_shoujianren where id=" + id;Object[] params = {};DB mydb = new DB();try {mydb.doPstm(sql, params);ResultSet rs = mydb.getRs();rs.next();shoujianren.setId(rs.getInt("id"));shoujianren.setName(rs.getString("name"));shoujianren.setSex(rs.getString("sex"));shoujianren.setAge(rs.getString("age"));shoujianren.setDianhua(rs.getString("dianhua"));shoujianren.setDizhi(rs.getString("dizhi"));shoujianren.setLoginpw(rs.getString("loginpw"));rs.close();} catch (Exception e) {e.printStackTrace();}mydb.closed();req.setAttribute("shoujianren", shoujianren);req.getRequestDispatcher("qiantai/userinfo/edit.jsp").forward(req, res);}// 前台用户修改信息保存public void editsave_q(HttpServletRequest req, HttpServletResponse res) {String name = req.getParameter("name");String sex = req.getParameter("sex");int age = Integer.parseInt(req.getParameter("age"));String dianhua = req.getParameter("dianhua");String dizhi = req.getParameter("dizhi");String loginpw = req.getParameter("loginpw");String sql = "";if (loginpw.equals(""))sql = "update t_shoujianren set name='" + name + "',sex='" + sex + "',age='" + age + "' ,dianhua='"+ dianhua + "',dizhi='" + dizhi + "' where id=" + Integer.parseInt(req.getParameter("id"));// 密码为空则不修改密码if (!loginpw.equals("")) {sql = "update t_shoujianren set name='" + name + "',sex='" + sex + "',age='" + age + "' ,dianhua='"+ dianhua + "',dizhi='" + dizhi + "',loginpw='" + loginpw + "'  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", "shoujianren?type=edit_q");String targetURL = "/common/success.jsp";dispatch(targetURL, req, res);}// 后台添加public void shoujianrenAdd(HttpServletRequest req, HttpServletResponse res) {String name = req.getParameter("name");String sex = req.getParameter("sex");int age = Integer.parseInt(req.getParameter("age"));String dianhua = req.getParameter("dianhua");String dizhi = req.getParameter("dizhi");String loginpw = req.getParameter("loginpw");String del = "no";String sql = "insert into t_shoujianren values(?,?,?,?,?,?,?,?)";Object[] params = { null, name, sex, age, dianhua, dizhi, del, loginpw };DB mydb = new DB();mydb.doPstm(sql, params);mydb.closed();req.setAttribute("message", "操作成功");req.setAttribute("path", "shoujianren?type=shoujianrenMana");String targetURL = "/common/success.jsp";dispatch(targetURL, req, res);}// 后台删除public void shoujianrenDel(HttpServletRequest req, HttpServletResponse res) {String sql = "delete from  t_shoujianren   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", "shoujianren?type=shoujianrenMana");String targetURL = "/common/success.jsp";dispatch(targetURL, req, res);}// 后台修改信息public void edit(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {Tshoujianren shoujianren = new Tshoujianren();String sql = "select * from t_shoujianren where id=" + Integer.parseInt(req.getParameter("id"));Object[] params = {};DB mydb = new DB();try {mydb.doPstm(sql, params);ResultSet rs = mydb.getRs();rs.next();shoujianren.setId(rs.getInt("id"));shoujianren.setName(rs.getString("name"));shoujianren.setSex(rs.getString("sex"));shoujianren.setAge(rs.getString("age"));shoujianren.setDianhua(rs.getString("dianhua"));shoujianren.setDizhi(rs.getString("dizhi"));shoujianren.setLoginpw(rs.getString("loginpw"));rs.close();} catch (Exception e) {e.printStackTrace();}mydb.closed();req.setAttribute("shoujianren", shoujianren);req.getRequestDispatcher("admin/shoujianren/edit.jsp").forward(req, res);}// 后台用户修改信息保存public void editsave(HttpServletRequest req, HttpServletResponse res) {String name = req.getParameter("name");String sex = req.getParameter("sex");int age = Integer.parseInt(req.getParameter("age"));String dianhua = req.getParameter("dianhua");String dizhi = req.getParameter("dizhi");String loginpw = req.getParameter("loginpw");String sql = "";if (loginpw.equals(""))sql = "update t_shoujianren set name='" + name + "',sex='" + sex + "',age='" + age + "' ,dianhua='"+ dianhua + "',dizhi='" + dizhi + "' where id=" + Integer.parseInt(req.getParameter("id"));// 密码为空则不修改密码if (!loginpw.equals("")) {sql = "update t_shoujianren set name='" + name + "',sex='" + sex + "',age='" + age + "' ,dianhua='"+ dianhua + "',dizhi='" + dizhi + "',loginpw='" + loginpw + "'  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", "shoujianren?type=shoujianrenMana");String targetURL = "/common/success.jsp";dispatch(targetURL, req, res);}public void shoujianrenMana(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {List shoujianrenList = new ArrayList();String sql = "select * from t_shoujianren where del='no'";Object[] params = {};DB mydb = new DB();try {mydb.doPstm(sql, params);ResultSet rs = mydb.getRs();while (rs.next()) {Tshoujianren shoujianren = new Tshoujianren();shoujianren.setId(rs.getInt("id"));shoujianren.setName(rs.getString("name"));shoujianren.setSex(rs.getString("sex"));shoujianren.setAge(rs.getString("age"));shoujianren.setDianhua(rs.getString("dianhua"));shoujianren.setDizhi(rs.getString("dizhi"));shoujianrenList.add(shoujianren);}rs.close();} catch (Exception e) {e.printStackTrace();}mydb.closed();req.setAttribute("shoujianrenList", shoujianrenList);req.getRequestDispatcher("admin/shoujianren/shoujianrenMana.jsp").forward(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数据库