• Java项目：基于jsp+servlet在线药店管理系统(含PPT)

    作者主页：夜未央5788

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

    文末获取源码

    项目介绍

    基于jsp+servlet在线药店管理系统。

    该项目是一个后管系统，只有一个管理员角色，功能比较简单，适合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.是否Maven项目: 否；查看源码目录中是否包含pom.xml；若包含，则为maven项目，否则为非maven项目 

    6.数据库：MySql 5.7版本；

    技术栈

    1. 后端：servlet

    2. 前端：JSP+bootstrap+jQuery

    使用说明

    1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
    2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;
    若为maven项目，导入成功后请执行maven clean;maven install命令，配置tomcat，然后运行；
    3. 将项目中c3p0.properties配置文件中的数据库配置改为自己的配置
    4. 运行项目，输入http://localhost:8080/shop 登录

    5. 账户admin  密码123456

    运行截图

     

     

     

     

     

     

     

    相关代码 

    AdminDao

    1. package dao;
    2.  
    3. import java.io.IOException;
    4. import java.sql.Date;
    5. import java.sql.SQLException;
    6. import java.util.List;
    7.  
    8.  
    9. import org.apache.commons.dbutils.QueryRunner;
    10. import org.apache.commons.dbutils.handlers.BeanHandler;
    11. import org.apache.commons.dbutils.handlers.BeanListHandler;
    12. import org.apache.commons.dbutils.handlers.ScalarHandler;
    13.  
    14. import com.mchange.v2.c3p0.ComboPooledDataSource;
    15.  
    16. import entity.Admin;
    17. import util.PageTools;
    18.  
    19. public class AdminDao {
    20. 	private QueryRunner qr=new QueryRunner(new ComboPooledDataSource());
    21. 	
    22. 	//添加一个管理员
    23. 	public boolean insertAdmin(Admin admin){
    24. 		String sql="insert into admin values(?,?,?,?,?)";
    25. 		try {
    26. 			int z=qr.update(sql,admin.getAid(),admin.getAname(),admin.getApassword(),admin.getAphone(),admin.getAaddress());
    27. 		    if(z>0) {
    28. 		    	return true;
    29. 		    }
    30. 		} catch (SQLException e) {
    31. 			// TODO Auto-generated catch block
    32. 			e.printStackTrace();
    33. 		}
    34. 		return false;
    35. 	}
    36. 	
    37. 	  public Admin  checkLogin(String aname,String apassword)
    38. 	    {
    39. 	    	String sql="select * from admin where aname=? and apassword=?";
    40. 	    	try {
    41. 	    		
    42. 				return qr.query(sql, new BeanHandler(Admin.class),aname,apassword);
    43. 			} catch (SQLException e) {
    44. 				// TODO Auto-generated catch block
    45. 				e.printStackTrace();
    46. 			}
    47. 	    	return null;
    48. 	    }
    49. 	  
    50. 	  
    51. 	  
    52. 	//删除一个管理员
    53. 	public boolean deleteAdminByAid(int aid){
    54. 		String sql="delete from admin where aid=?";
    55. 		try {
    56. 			int z=qr.update(sql,aid);
    57. 		    if(z>0) {
    58. 		    	return true;
    59. 		    }
    60. 		} catch (SQLException e) {
    61. 			// TODO Auto-generated catch block
    62. 			e.printStackTrace();
    63. 		}
    64. 		return false;
    65. 	}
    66. 	//查询所有管理员
    67. 	public List selectAdmin(){
    68. 		String sql="select * from admin";
    69. 		try {
    70. 			return qr.query(sql, new BeanListHandler(Admin.class));
    71. 		} catch (SQLException e) {
    72. 			// TODO Auto-generated catch block
    73. 			e.printStackTrace();
    74. 		}
    75. 		return null;
    76. 	}
    77. 	//按ID查询管理员
    78. 	public Admin selectAdminByAid(int aid) {
    79. 		   String sql="select * from admin where aid=?";
    80. 		  try {
    81. 			return qr.query(sql, new BeanHandler(Admin.class),aid);
    82. 		} catch (SQLException e) {
    83. 			// TODO Auto-generated catch block
    84. 			e.printStackTrace();
    85. 		}
    86. 		  return null;
    87. 	   }
    88. 	//按页码查询管理员
    89. 	public List selectAdminByPage(PageTools pt){
    90. 		   String sql="select * from admin limit ?,?";
    91. 		   try {
    92. 			return qr.query(sql, new BeanListHandler(Admin.class),pt.getStart_index(),pt.getPage_size());
    93. 		} catch (SQLException e) {
    94. 			// TODO Auto-generated catch block
    95. 			e.printStackTrace();
    96. 		}
    97. 		   return null;
    98. 	   }
    99. 	//修改一个管理员
    100. 	public boolean updateAdmin(Admin admin){
    101. 		   String sql="update admin set aname=?,apassword=?,aphone=?,aaddress=?  where aid=?";
    102. 		   try {
    103. 			int z=qr.update(sql,admin.getAname(),admin.getApassword(),admin.getAphone(),admin.getAaddress(),admin.getAid());
    104. 			if(z>0)
    105. 				return true;
    106. 		} catch (SQLException e) {
    107. 			// TODO Auto-generated catch block
    108. 			e.printStackTrace();
    109. 		}
    110. 		   return false;
    111. 	   }
    112. 	//统计管理员的个数
    113. 	public   int counts(){
    114. 		   String sql="select count(*) from admin";
    115. 		   try {
    116. 			Long l=(Long)qr.query(sql, new ScalarHandler());//反射
    117. 			return l.intValue();//java基础
    118. 		} catch (SQLException e) {
    119. 			// TODO Auto-generated catch block
    120. 			e.printStackTrace();
    121. 		}
    122. 		   return 0;
    123. 		   
    124. 	   }
    125. 	
    126. 	
    127. 	public static void main(String[] args) {
    128.  
    129. 		Admin z = new AdminDao().checkLogin("cc1", "1234");
    130. 		System.out.println(z);
    131. 		
    132. 	}
    133.  
    134. }

    CustomerDao

    1. package dao;
    2.  
    3. import java.sql.SQLException;
    4. import java.util.List;
    5.  
    6. import org.apache.commons.dbutils.QueryRunner;
    7. import org.apache.commons.dbutils.handlers.BeanHandler;
    8. import org.apache.commons.dbutils.handlers.BeanListHandler;
    9. import org.apache.commons.dbutils.handlers.ScalarHandler;
    10.  
    11. import com.mchange.v2.c3p0.ComboPooledDataSource;
    12.  
    13. import entity.Admin;
    14. import entity.Customer;
    15. import util.PageTools;
    16.  
    17. public class CustomerDao {
    18. 	private QueryRunner qr=new QueryRunner(new ComboPooledDataSource());
    19. 	//添加一个顾客
    20. 	public boolean insertCustomer(Customer customer){
    21. 		String sql="insert into customer values(?,?,?,?,?,?,?)";
    22. 		try {
    23. 			int z=qr.update(sql,customer.getCid(),customer.getCname(),customer.getCsex(),customer.getCage(),customer.getCphone(),customer.getCemail(),customer.getCaddress());
    24. 		    if(z>0) {
    25. 		    	return true;
    26. 		    }
    27. 		} catch (SQLException e) {
    28. 			// TODO Auto-generated catch block
    29. 			e.printStackTrace();
    30. 		}
    31. 		return false;
    32. 	}
    33. 	//删除一个顾客
    34. 	public boolean deleteCustomerByCid(int cid){
    35. 		String sql="delete from customer where cid=?";
    36. 		try {
    37. 			int z=qr.update(sql,cid);
    38. 		    if(z>0) {
    39. 		    	return true;
    40. 		    }
    41. 		} catch (SQLException e) {
    42. 			// TODO Auto-generated catch block
    43. 			e.printStackTrace();
    44. 		}
    45. 		return false;
    46. 	}
    47. 	//查询所有管理员
    48. 	public List selectCustomer(){
    49. 		String sql="select * from customer";
    50. 		try {
    51. 			return qr.query(sql, new BeanListHandler(Customer.class));
    52. 		} catch (SQLException e) {
    53. 			// TODO Auto-generated catch block
    54. 			e.printStackTrace();
    55. 		}
    56. 		return null;
    57. 	}
    58. 	//按ID查询顾客
    59. 	public Customer selectCustomerByCid(int cid) {
    60. 		   String sql="select * from customer where cid=?";
    61. 		  try {
    62. 			return qr.query(sql, new BeanHandler(Customer.class),cid);
    63. 		} catch (SQLException e) {
    64. 			// TODO Auto-generated catch block
    65. 			e.printStackTrace();
    66. 		}
    67. 		  return null;
    68. 	   }
    69. 	//按页码查询顾客
    70. 	public List selectCustomerByPage(PageTools pt){
    71. 		   String sql="select * from customer limit ?,?";
    72. 		   try {
    73. 			return qr.query(sql, new BeanListHandler(Customer.class),pt.getStart_index(),pt.getPage_size());
    74. 		} catch (SQLException e) {
    75. 			// TODO Auto-generated catch block
    76. 			e.printStackTrace();
    77. 		}
    78. 		   return null;
    79. 	   }
    80. 	//修改一个顾客
    81. 	public boolean updateCustomer(Customer customer){
    82. 		   String sql="update customer set cname=?,csex=?,cage=?,cphone=?,cemail=?,caddress=?  where cid=?";
    83. 		   try {
    84. 			int z=qr.update(sql,customer.getCname(),customer.getCsex(),customer.getCage(),customer.getCphone(),customer.getCemail(),customer.getCaddress(),customer.getCid());
    85. 			if(z>0)
    86. 				return true;
    87. 		} catch (SQLException e) {
    88. 			// TODO Auto-generated catch block
    89. 			e.printStackTrace();
    90. 		}
    91. 		   return false;
    92. 	   }
    93. 	//统计顾客的个数
    94. 	public   int counts(){
    95. 		   String sql="select count(*) from customer";
    96. 		   try {
    97. 			Long l=(Long)qr.query(sql, new ScalarHandler());//反射
    98. 			return l.intValue();//java基础
    99. 		} catch (SQLException e) {
    100. 			// TODO Auto-generated catch block
    101. 			e.printStackTrace();
    102. 		}
    103. 		   return 0;
    104. 		   
    105. 	   }
    106.  
    107. }

    DrugDao

    1. package dao;
    2.  
    3. import java.sql.SQLException;
    4. import java.util.List;
    5.  
    6. import org.apache.commons.dbutils.QueryRunner;
    7. import org.apache.commons.dbutils.handlers.BeanHandler;
    8. import org.apache.commons.dbutils.handlers.BeanListHandler;
    9. import org.apache.commons.dbutils.handlers.ScalarHandler;
    10.  
    11. import com.mchange.v2.c3p0.ComboPooledDataSource;
    12.  
    13. import entity.Drug;
    14. import util.PageTools;
    15.  
    16. public class DrugDao {
    17.     private QueryRunner qr=new QueryRunner(new ComboPooledDataSource());
    18. 	
    19. 	//添加药品
    20. 	public boolean insertDrug(Drug drug){
    21. 		String sql="insert into drug values(?,?,?,?,?,?,?,?,?)";
    22. 		try {
    23. 			int z=qr.update(sql,drug.getDid(),drug.getDname(),drug.getDclass(),drug.getDprice(),drug.getProdate(),drug.getExdate(),drug.getRequantity(),drug.getSname(),drug.getFunction());
    24. 		    if(z>0) {
    25. 		    	return true;
    26. 		    }
    27. 		} catch (SQLException e) {
    28. 			// TODO Auto-generated catch block
    29. 			e.printStackTrace();
    30. 		}
    31. 		return false;
    32. 	}
    33. 	//删除一个管理员
    34. 	public boolean deleteDrugByDid(String did){
    35. 		String sql="delete from drug where did=?";
    36. 		try {
    37. 			int z=qr.update(sql,did);
    38. 		    if(z>0) {
    39. 		    	return true;
    40. 		    }
    41. 		} catch (SQLException e) {
    42. 			// TODO Auto-generated catch block
    43. 			e.printStackTrace();
    44. 		}
    45. 		return false;
    46. 	}
    47. 	//查询所有管理员
    48. 	public List selectDrug(){
    49. 		String sql="select * from drug";
    50. 		try {
    51. 			return qr.query(sql, new BeanListHandler(Drug.class));
    52. 		} catch (SQLException e) {
    53. 			// TODO Auto-generated catch block
    54. 			e.printStackTrace();
    55. 		}
    56. 		return null;
    57. 	}
    58. 	//按ID查询管理员
    59. 	public Drug selectDrugByDid(String did) {
    60. 		   String sql="select * from drug where did=?";
    61. 		  try {
    62. 			return qr.query(sql, new BeanHandler(Drug.class),did);
    63. 		} catch (SQLException e) {
    64. 			// TODO Auto-generated catch block
    65. 			e.printStackTrace();
    66. 		}
    67. 		  return null;
    68. 	   }
    69. 	//按页码查询管理员
    70. 	public List selectDrugByPage(PageTools pt){
    71. 		   String sql="select * from drug limit ?,?";
    72. 		   try {
    73. 			return qr.query(sql, new BeanListHandler(Drug.class),pt.getStart_index(),pt.getPage_size());
    74. 		} catch (SQLException e) {
    75. 			// TODO Auto-generated catch block
    76. 			e.printStackTrace();
    77. 		}
    78. 		   return null;
    79. 	   }
    80. 	//修改一个管理员
    81. 	public boolean updateDrug(Drug drug){
    82. 		   String sql="update drug set dname=?,dclass=?,dprice=?,prodate=?,exdate=?,requantity=?,sname=?,function=?  where did=?";
    83. 		   try {
    84. 			int z=qr.update(sql,drug.getDname(),drug.getDclass(),drug.getDprice(),drug.getProdate(),drug.getExdate(),drug.getRequantity(),drug.getSname(),drug.getFunction(),drug.getDid());
    85. 			if(z>0)
    86. 				return true;
    87. 		} catch (SQLException e) {
    88. 			// TODO Auto-generated catch block
    89. 			e.printStackTrace();
    90. 		}
    91. 		   return false;
    92. 	   }
    93. 	//统计管理员的个数
    94. 	public   int counts(){
    95. 		   String sql="select count(*) from drug";
    96. 		   try {
    97. 			Long l=(Long)qr.query(sql, new ScalarHandler());//反射
    98. 			return l.intValue();//java基础
    99. 		} catch (SQLException e) {
    100. 			// TODO Auto-generated catch block
    101. 			e.printStackTrace();
    102. 		}
    103. 		   return 0;
    104. 		   
    105. 	   }
    106.  
    107. }

    OrderDao

    1. package dao;
    2.  
    3. import java.sql.SQLException;
    4. import java.util.List;
    5.  
    6. import org.apache.commons.dbutils.QueryRunner;
    7. import org.apache.commons.dbutils.handlers.BeanHandler;
    8. import org.apache.commons.dbutils.handlers.BeanListHandler;
    9. import org.apache.commons.dbutils.handlers.ScalarHandler;
    10.  
    11. import com.mchange.v2.c3p0.ComboPooledDataSource;
    12.  
    13. import entity.Order;
    14. import util.PageTools;
    15.  
    16. public class OrderDao {
    17. 	private QueryRunner qr=new QueryRunner(new ComboPooledDataSource());
    18.  
    19. 	//添加订单
    20. 	public boolean insertOrder(Order order){
    21. 		String sql="insert into ordered(did,oquantity,oprice,cid,odate) values(?,?,?,?,?)";
    22. 		try {
    23. 			int z=qr.update(sql,order.getDid(),order.getOquantity(),order.getOprice(),order.getCid(),order.getOdate());
    24. 			if(z>0) {
    25. 				return true;
    26. 			}
    27. 		} catch (SQLException e) {
    28. 			// TODO Auto-generated catch block
    29. 			e.printStackTrace();
    30. 		}
    31. 		return false;
    32. 	}
    33. 	//删除一个订单
    34. 	public boolean deleteOrderByOid(int oid){
    35. 		String sql="delete from ordered where oid=?";
    36. 		try {
    37. 			int z=qr.update(sql,oid);
    38. 			if(z>0) {
    39. 				return true;
    40. 			}
    41. 		} catch (SQLException e) {
    42. 			// TODO Auto-generated catch block
    43. 			e.printStackTrace();
    44. 		}
    45. 		return false;
    46. 	}
    47. 	//查询所有订单
    48. 	public List selectOrder(){
    49. 		String sql="select * from ordered";
    50. 		try {
    51. 			return qr.query(sql, new BeanListHandler(Order.class));
    52. 		} catch (SQLException e) {
    53. 			// TODO Auto-generated catch block
    54. 			e.printStackTrace();
    55. 		}
    56. 		return null;
    57. 	}
    58. 	//按ID查询订单
    59. 	public Order selectOrderByOid(int oid) {
    60. 		String sql="select * from ordered where oid=?";
    61. 		try {
    62. 			return qr.query(sql, new BeanHandler(Order.class),oid);
    63. 		} catch (SQLException e) {
    64. 			// TODO Auto-generated catch block
    65. 			e.printStackTrace();
    66. 		}
    67. 		return null;
    68. 	}
    69.  
    70. 	//按页码查询订单
    71. 	public List selectOrderByPage(PageTools pt){
    72. 		String sql="select * from ordered limit ?,?";
    73. 		try {
    74. 			return qr.query(sql, new BeanListHandler(Order.class),pt.getStart_index(),pt.getPage_size());
    75. 		} catch (SQLException e) {
    76. 			// TODO Auto-generated catch block
    77. 			e.printStackTrace();
    78. 		}
    79. 		return null;
    80. 	}
    81.  
    82. 	//修改一个订单
    83. 	public boolean updateOrder(Order order){
    84. 		String sql="update ordered set did=?,oquantity=?,oprice=?,cid=?,odate=? where oid=?";
    85. 		try {
    86. 			int z=qr.update(sql,order.getDid(),order.getOquantity(),order.getOprice(),order.getCid(),order.getOdate(),order.getOid());
    87. 			if(z>0)
    88. 				return true;
    89. 		} catch (SQLException e) {
    90. 			// TODO Auto-generated catch block
    91. 			e.printStackTrace();
    92. 		}
    93. 		return false;
    94. 	}
    95.  
    96. 	//统计订单的个数
    97. 	public   int counts(){
    98. 		String sql="select count(*) from ordered";
    99. 		try {
    100. 			Long l=(Long)qr.query(sql, new ScalarHandler());//反射
    101. 			return l.intValue();//java基础
    102. 		} catch (SQLException e) {
    103. 			// TODO Auto-generated catch block
    104. 			e.printStackTrace();
    105. 		}
    106. 		return 0;
    107. 	}
    108. }

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

  • 相关阅读:
    蜂蜜配送销售商城小程序的作用是什么
    原码、反码、补码相关知识
    思科路由器配置
    Qt 信号与槽
    MySQL学习笔记18
    期货客户开户手续费（期货开户最低手续费）
    NSAT-8000电源自动测试系统，测试速度快测量准确
    缓存与数据一致性问题
    SpringBoot SpringBoot 开发实用篇 5 整合第三方技术 5.3 手机验证码案例 - 生成验证码
    YOLO目标检测——口罩规范佩戴数据集+已标注xml和txt格式标签下载分享
  • 原文地址：https://blog.csdn.net/hanyunlong1989/article/details/127096550