• Java项目：JSP药店药品商城管理系统

    作者主页：源码空间站2022

     简介：Java领域优质创作者、Java项目、学习资料、技术互助

    文末获取源码

    项目介绍

    本项目分为前后台，分为管理员与普通用户两种角色，管理员登录后台，普通用户登录前台；

    管理员角色包含以下功能：

    管理员登录,订单管理,客户管理,药品管理,类目管理等功能。

    用户角色包含以下功能：
    用户首页,查看药品详情,用户登录,查看购物车,提交订单付款,我的订单管理,用户个人中心等功能。

    环境需要

    1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。
    2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA;
    3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可
    4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS； 

    5.数据库：MySql 5.7版本；

    6.是否Maven项目：否；

    技术栈

    JSP+CSS+jQuery+bootstrap+mysql+servlet

    使用说明

    1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；

    2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;

    若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行；

    3. 将项目中src/utils/DBUtil.java配置文件中的数据库配置改为自己的配置;
    4. 运行项目，输入localhost:8080/jsp_medi/ 登录 注：tomcat中配置项目路径必须为jsp_medi，否则会有异常；
    用户账号/密码：user/123456

    管理员账号/密码：admin/admin

    运行截图

    前台界面

    后台界面

    相关代码 

    ApplicationListener

    1. package listener;
    2.  
    3. import service.TypeService;
    4.  
    5. import javax.servlet.ServletContextEvent;
    6. import javax.servlet.ServletContextListener;
    7. import javax.servlet.annotation.WebListener;
    8. import javax.servlet.http.HttpSessionAttributeListener;
    9. import javax.servlet.http.HttpSessionEvent;
    10. import javax.servlet.http.HttpSessionListener;
    11. import javax.servlet.http.HttpSessionBindingEvent;
    12.  
    13. @WebListener()
    14. public class ApplicationListener implements ServletContextListener,
    15.         HttpSessionListener, HttpSessionAttributeListener {
    16.     TypeService tsService=new TypeService();
    17.     // Public constructor is required by servlet spec
    18.     public ApplicationListener() {
    19.     }
    20.  
    21.     // -------------------------------------------------------
    22.     // ServletContextListener implementation
    23.     // -------------------------------------------------------
    24.     public void contextInitialized(ServletContextEvent sce) {
    25.       /* This method is called when the servlet context is
    26.          initialized(when the Web application is deployed). 
    27.          You can initialize servlet context related data here.
    28.       */
    29.         sce.getServletContext().setAttribute("typeList",tsService.GetAllType());
    30.     }
    31.  
    32.     public void contextDestroyed(ServletContextEvent sce) {
    33.       /* This method is invoked when the Servlet Context 
    34.          (the Web application) is undeployed or 
    35.          Application Server shuts down.
    36.       */
    37.     }
    38.  
    39.     // -------------------------------------------------------
    40.     // HttpSessionListener implementation
    41.     // -------------------------------------------------------
    42.     public void sessionCreated(HttpSessionEvent se) {
    43.         /* Session is created. */
    44.     }
    45.  
    46.     public void sessionDestroyed(HttpSessionEvent se) {
    47.         /* Session is destroyed. */
    48.     }
    49.  
    50.     // -------------------------------------------------------
    51.     // HttpSessionAttributeListener implementation
    52.     // -------------------------------------------------------
    53.  
    54.     public void attributeAdded(HttpSessionBindingEvent sbe) {
    55.       /* This method is called when an attribute 
    56.          is added to a session.
    57.       */
    58.     }
    59.  
    60.     public void attributeRemoved(HttpSessionBindingEvent sbe) {
    61.       /* This method is called when an attribute
    62.          is removed from a session.
    63.       */
    64.     }
    65.  
    66.     public void attributeReplaced(HttpSessionBindingEvent sbe) {
    67.       /* This method is invoked when an attibute
    68.          is replaced in a session.
    69.       */
    70.     }
    71. }

    GoodsService

    1. package service;
    2.  
    3. import dao.GoodsDao;
    4. import model.Goods;
    5. import model.Page;
    6. import sun.nio.cs.ext.IBM037;
    7.  
    8. import javax.management.monitor.StringMonitorMBean;
    9. import java.sql.SQLException;
    10. import java.util.List;
    11. import java.util.Map;
    12.  
    13. public class GoodsService {
    14.     private GoodsDao gDao=new GoodsDao();
    15.     public List> getGoodsList(int recommendType) {
    16.         List> list=null;
    17.         try {
    18.             list=gDao.getGoodsList(recommendType);
    19.         } catch (SQLException e) {
    20.             e.printStackTrace();
    21.         }
    22.         return list;
    23.     }
    24.     public Map getScrollGood()
    25.     {
    26.         Map scroolGood=null;
    27.         try {
    28.             scroolGood=gDao.getScrollGood();
    29.         } catch (SQLException e) {
    30.             e.printStackTrace();
    31.         }
    32.         return scroolGood;
    33.     }
    34.     public List selectGoodsByTypeID(int typeID, int pageNumber, int pageSize)
    35.     {
    36.         List list=null;
    37.         try {
    38.             list=gDao.selectGoodsByTypeID(typeID,pageNumber,pageSize);
    39.         } catch (SQLException e) {
    40.             e.printStackTrace();
    41.         }
    42.         return list;
    43.     }
    44.     public Page selectPageByTypeID(int typeID,int pageNumber)
    45.     {
    46.         Page p=new Page();
    47.         p.setPageNumber(pageNumber);
    48.         int totalCount=0;
    49.         try {
    50.             totalCount=gDao.getCountOfGoodsByTypeID(typeID);
    51.         } catch (SQLException e) {
    52.             e.printStackTrace();
    53.         }
    54.         p.SetPageSizeAndTotalCount(8,totalCount);
    55.  
    56.         List list=null;
    57.         try {
    58.             list=gDao.selectGoodsByTypeID(typeID,pageNumber,8);
    59.         } catch (SQLException e) {
    60.             e.printStackTrace();
    61.         }
    62.  
    63.         p.setList(list);
    64.         return p;
    65.     }
    66.     public Page getGoodsRecommendPage(int type,int pageNumber) {
    67.         Page p = new Page();
    68.         p.setPageNumber(pageNumber);
    69.         int totalCount = 0;
    70.         try {
    71.             totalCount = gDao.getRecommendCountOfGoodsByTypeID(type);
    72.         } catch (SQLException e) {
    73.             // TODO Auto-generated catch block
    74.             e.printStackTrace();
    75.         }
    76.         p.SetPageSizeAndTotalCount(8, totalCount);
    77.         List list=null;
    78.         try {
    79.             list = gDao.selectGoodsbyRecommend(type, pageNumber, 8);
    80.             for(Goods g : (List)list) {
    81.                 g.setScroll(gDao.isScroll(g));
    82.                 g.setHot(gDao.isHot(g));
    83.                 g.setNew(gDao.isNew(g));
    84.             }
    85.         } catch (SQLException e) {
    86.             // TODO Auto-generated catch block
    87.             e.printStackTrace();
    88.         }
    89.         p.setList(list);
    90.         return p;
    91.     }
    92.     public Goods getGoodsById(int id) {
    93.         Goods g=null;
    94.         try {
    95.             g = gDao.getGoodsById(id);
    96.         } catch (SQLException e) {
    97.             // TODO Auto-generated catch block
    98.             e.printStackTrace();
    99.         }
    100.         return g;
    101.     }
    102.     public Page getSearchGoodsPage(String keyword, int pageNumber) {
    103.         Page p = new Page();
    104.         p.setPageNumber(pageNumber);
    105.         int totalCount = 0;
    106.         try {
    107. //			totalCount = gDao.getGoodsCount(typeId);
    108.             totalCount = gDao.getSearchCount(keyword);
    109.         } catch (SQLException e) {
    110.             // TODO Auto-generated catch block
    111.             e.printStackTrace();
    112.         }
    113.         p.SetPageSizeAndTotalCount(8, totalCount);
    114.         List list=null;
    115.         try {
    116. //			list = gDao.selectGoods(keyword, pageNo, 8);
    117.             list = gDao.selectSearchGoods(keyword,pageNumber,8);
    118.         } catch (SQLException e) {
    119.             // TODO Auto-generated catch block
    120.             e.printStackTrace();
    121.         }
    122.         p.setList(list);
    123.         return p;
    124.     }
    125.     public void addRecommend(int id,int type) {
    126.         try {
    127.             gDao.addRecommend(id, type);
    128.         } catch (SQLException e) {
    129.             // TODO Auto-generated catch block
    130.             e.printStackTrace();
    131.         }
    132.     }
    133.     public void removeRecommend(int id,int type) {
    134.         try {
    135.             gDao.removeRecommend(id, type);
    136.         } catch (SQLException e) {
    137.             // TODO Auto-generated catch block
    138.             e.printStackTrace();
    139.         }
    140.     }
    141.     public void insert(Goods goods) {
    142.         try {
    143.             gDao.insert(goods);
    144.         } catch (SQLException e) {
    145.             // TODO Auto-generated catch block
    146.             e.printStackTrace();
    147.         }
    148.     }
    149.     public void update(Goods goods) {
    150.         try {
    151.             gDao.update(goods);
    152.         } catch (SQLException e) {
    153.             // TODO Auto-generated catch block
    154.             e.printStackTrace();
    155.         }
    156.     }
    157.     public void delete(int id) {
    158.         try {
    159.             gDao.delete(id);
    160.         } catch (SQLException e) {
    161.             // TODO Auto-generated catch block
    162.             e.printStackTrace();
    163.         }
    164.     }
    165. }

    OrderService

    1. package service;
    2.  
    3. import dao.*;
    4. import model.*;
    5. import utils.*;
    6.  
    7. import java.sql.*;
    8. import java.util.List;
    9.  
    10. public class OrderService {
    11.     private OrderDao oDao = new OrderDao();
    12.     public void addOrder(Order order) {
    13.         Connection con = null;
    14.         try {
    15.             con = DBUtil.getConnection();
    16.             con.setAutoCommit(false);
    17.  
    18.             oDao.insertOrder(con, order);
    19.             int id = oDao.getLastInsertId(con);
    20.             order.setId(id);
    21.             for(OrderItem item : order.getItemMap().values()) {
    22.                 oDao.insertOrderItem(con, item);
    23.             }
    24.  
    25.             con.commit();
    26.         } catch (SQLException e) {
    27.             // TODO Auto-generated catch block
    28.             e.printStackTrace();
    29.             if(con!=null)
    30.                 try {
    31.                     con.rollback();
    32.                 } catch (SQLException e1) {
    33.                     // TODO Auto-generated catch block
    34.                     e1.printStackTrace();
    35.                 }
    36.         }
    37.     }
    38.     public List selectAll(int userid){
    39.         List list=null;
    40.         try {
    41.             list = oDao.selectAll(userid);
    42.             for(Order o :list) {
    43.                 List l = oDao.selectAllItem(o.getId());
    44.                 o.setItemList(l);
    45.             }
    46.         } catch (SQLException e) {
    47.             // TODO Auto-generated catch block
    48.             e.printStackTrace();
    49.         }
    50.         return list;
    51.     }
    52.     public Page getOrderPage(int status,int pageNumber) {
    53.         Page p = new Page();
    54.         p.setPageNumber(pageNumber);
    55.         int pageSize = 10;
    56.         int totalCount = 0;
    57.         try {
    58.             totalCount = oDao.getOrderCount(status);
    59.         } catch (SQLException e) {
    60.             // TODO Auto-generated catch block
    61.             e.printStackTrace();
    62.         }
    63.         p.SetPageSizeAndTotalCount(pageSize, totalCount);
    64.         List list=null;
    65.         try {
    66.             list = oDao.selectOrderList(status, pageNumber, pageSize);
    67.             for(Order o :(List)list) {
    68.                 List l = oDao.selectAllItem(o.getId());
    69.                 o.setItemList(l);
    70.             }
    71.         } catch (SQLException e) {
    72.             // TODO Auto-generated catch block
    73.             e.printStackTrace();
    74.         }
    75.         p.setList(list);
    76.         return p;
    77.     }
    78.     public void updateStatus(int id,int status) {
    79.         try {
    80.             oDao.updateStatus(id, status);
    81.         } catch (SQLException e) {
    82.             // TODO Auto-generated catch block
    83.             e.printStackTrace();
    84.         }
    85.     }
    86.     public void delete(int id) {
    87.         Connection con = null;
    88.         try {
    89.             con = DBUtil.getDataSource().getConnection();
    90.             con.setAutoCommit(false);
    91.  
    92.             oDao.deleteOrderItem(con, id);
    93.             oDao.deleteOrder(con, id);
    94.             con.commit();
    95.         } catch (SQLException e) {
    96.             // TODO Auto-generated catch block
    97.             e.printStackTrace();
    98.             if(con!=null)
    99.                 try {
    100.                     con.rollback();
    101.                 } catch (SQLException e1) {
    102.                     // TODO Auto-generated catch block
    103.                     e1.printStackTrace();
    104.                 }
    105.         }
    106.  
    107.  
    108.     }
    109. }

    TypeService

    1. package service;
    2.  
    3. import dao.TypeDao;
    4. import model.Type;
    5.  
    6. import java.sql.SQLException;
    7. import java.util.List;
    8.  
    9. public class TypeService {
    10.     TypeDao tDao=new TypeDao();
    11.     public List GetAllType()
    12.     {
    13.         List list=null;
    14.         try {
    15.             list=tDao.GetAllType();
    16.         } catch (SQLException e) {
    17.             e.printStackTrace();
    18.         }
    19.         return list;
    20.     }
    21.     public Type selectTypeNameByID(int typeid)
    22.     {
    23.         Type type=null;
    24.         try {
    25.             type=tDao.selectTypeNameByID(typeid);
    26.         } catch (SQLException e) {
    27.             e.printStackTrace();
    28.         }
    29.         return type;
    30.     }
    31.     public Type select(int id) {
    32.         Type t=null;
    33.         try {
    34.             t = tDao.select(id);
    35.         } catch (SQLException e) {
    36.             // TODO Auto-generated catch block
    37.             e.printStackTrace();
    38.         }
    39.         return t;
    40.     }
    41.     public void insert(Type t) {
    42.         try {
    43.             tDao.insert(t);
    44.         } catch (SQLException e) {
    45.             // TODO Auto-generated catch block
    46.             e.printStackTrace();
    47.         }
    48.     }
    49.     public void update(Type t) {
    50.         try {
    51.             tDao.update(t);
    52.         } catch (SQLException e) {
    53.             // TODO Auto-generated catch block
    54.             e.printStackTrace();
    55.         }
    56.     }
    57.     public boolean delete(int id) {
    58.         try {
    59.             tDao.delete(id);
    60.             return true;
    61.         } catch (SQLException e) {
    62.             // TODO Auto-generated catch block
    63.             e.printStackTrace();
    64.             return false;
    65.         }
    66.     }
    67. }

    UserService

    1. package service;
    2.  
    3. import dao.UserDao;
    4. import model.Page;
    5. import model.User;
    6.  
    7. import java.sql.SQLException;
    8. import java.util.List;
    9.  
    10. public class UserService {
    11.     private UserDao uDao = new UserDao();
    12.     public boolean register(User user) {
    13.         try {
    14.             if(uDao.isUsernameExist(user.getUsername())) {
    15.                 return false;
    16.             }
    17.             if(uDao.isEmailExist(user.getEmail())) {
    18.                 return false;
    19.             }
    20.             uDao.addUser(user);
    21.             return true;
    22.         } catch (SQLException e) {
    23.             // TODO Auto-generated catch block
    24.             e.printStackTrace();
    25.         }
    26.         return false;
    27.     }
    28.  
    29.     public User login(String ue,String password) {
    30.         User user=null;
    31.         try {
    32.             user = uDao.selectByUsernamePassword(ue, password);
    33.         } catch (SQLException e) {
    34.             // TODO Auto-generated catch block
    35.             e.printStackTrace();
    36.         }
    37.         if(user!=null) {
    38.             return user;
    39.         }
    40.         try {
    41.             user=uDao.selectByEmailPassword(ue, password);
    42.         } catch (SQLException e) {
    43.             // TODO Auto-generated catch block
    44.             e.printStackTrace();
    45.         }
    46.         if(user!=null) {
    47.             return user;
    48.         }
    49.         return null;
    50.     }
    51.     public User selectById(int id) {
    52.         User u=null;
    53.         try {
    54.             u = uDao.selectById(id);
    55.         } catch (SQLException e) {
    56.             // TODO Auto-generated catch block
    57.             e.printStackTrace();
    58.         }
    59.         return u;
    60.     }
    61.     public void updateUserAddress(User user) {
    62.         try {
    63.             uDao.updateUserAddress(user);
    64.         } catch (SQLException e) {
    65.             // TODO Auto-generated catch block
    66.             e.printStackTrace();
    67.         }
    68.     }
    69.     public void updatePwd(User user) {
    70.         try {
    71.             uDao.updatePwd(user);
    72.         } catch (SQLException e) {
    73.             // TODO Auto-generated catch block
    74.             e.printStackTrace();
    75.         }
    76.     }
    77.  
    78.     public Page getUserPage(int pageNumber) {
    79.         Page p = new Page();
    80.         p.setPageNumber(pageNumber);
    81.         int pageSize = 7;
    82.         int totalCount = 0;
    83.         try {
    84.             totalCount = uDao.selectUserCount();
    85.         } catch (SQLException e) {
    86.             // TODO Auto-generated catch block
    87.             e.printStackTrace();
    88.         }
    89.         p.SetPageSizeAndTotalCount(pageSize, totalCount);
    90.         List list=null;
    91.         try {
    92.             list = uDao.selectUserList( pageNumber, pageSize);
    93.         } catch (SQLException e) {
    94.             // TODO Auto-generated catch block
    95.             e.printStackTrace();
    96.         }
    97.         p.setList(list);
    98.         return p;
    99.     }
    100.     public boolean delete(int id ) {
    101.         try {
    102.             uDao.delete(id);
    103.             return true;
    104.         } catch (SQLException e) {
    105.             // TODO Auto-generated catch block
    106.             e.printStackTrace();
    107.             return false;
    108.         }
    109.     }
    110. }

    如果也想学习本系统，下面领取。关注并回复：070jsp

     

  • 相关阅读:
    【机器学习6】概率图模型
    vue2_路由01_路由的基本使用
    Linux常见面试题
    Oauth2.0的内容
    Modbus协议
    内中断（一）
    MySQL索引
    lua-arm平台交叉编译
    分布式事务-常见解决方案
    【算法leetcode】2325. 解密消息（rust和go重拳出击）
  • 原文地址：https://blog.csdn.net/m0_74967853/article/details/128031749