先将前端时间开发的药物销售管理系统贡献出来,仅供参考
基于javaEE的一个数据管理系统,数据库使用Microsoft sqlserver2008,界面使用了bootstrap框架
实现了数据库的用户名登录以及赋予不同权限;和网页端的不同用户登录
针对不同的用户身份设定了不同的数据访问权限。
发送源码和数据库希望对你有帮助
本系统是idea开发的
<%@ page import="beans.Staff" %>
<%@ page import="utils.createStaffId" %>
<%--
Created by IntelliJ IDEA.
User: beauw
Date: 2018/1/6
Time: 12:44
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" %>
<html>
<p class="navbar-text">当前登录用户</p>
<p class="navbar-text">
<%
Staff staff = (Staff) session.getAttribute("staff");
out.println(staff.getName());
%>
</p>
<p class="navbar-text navbar-right"></p>
<a href="managermaster?id=11" type="button" class="btn btn-default navbar-btn navbar-right">退出</a> </div>
</div>
<!-- 左侧导航 -->
<div class="navbox">
<ul class="nav">
<li><a href="managermaster?id=1">管理主页</a></li>
<li><a href="managermaster?id=2">员工管理</a></li>
<li><a href="managermaster?id=3">查看库存</a></li>
<li><a href="managermaster?id=4">查看进货</a></li>
<li><a href="managermaster?id=5">查看售货</a></li>
<li><a href="managermaster?id=6">查看退厂</a></li>
<li><a href="managermaster?id=7">查看客户</a></li>
<li><a href="managermaster?id=8">查看厂商</a></li>
</ul>
</div>
<div class="mainArea">
<div class="showArea">
<div class="container">
<form action="adduser" class="col-md-6 col-md-offset-3" method="post">
<fieldset class="mycontainer">
<legend></legend>
<div class="panel panel-default">
<div class="panel-heading">
<p class="loginTitle">添加用户</p>
</div>
<div class="panel-body">
<div class="form-group">
<div class="input-group">
<span class="input-group-addon">
用户ID</span>
<input type="text" name="userid" class="form-control" value=<%= createStaffId.getStaffId()%> id="userId">
<input type="text" name="userid1" class="form-control" value=<%= createStaffId.getStaffId()%> id="userId1" disabled>
</div>
</div>
<div class="form-group">
<div class="input-group">
<span class="input-group-addon">
姓名
</span>
<input type="text" name="username" class="form-control" placeholder="请输入用户名" id="userName" required>
</div>
</div>
<div class="form-group">
<div class="input-group">
<span class="input-group-addon">
密码
</span>
<input type="text" name="userpwd" class="form-control" placeholder="请输入密码" id="userPwd" required>
</div>
</div>
<div class="form-group">
<div class="input-group">
<span class="input-group-addon">
电话
</span>
<input type="text" name="userphone" class="form-control" placeholder="请输入用户电话" id="userPhone" required>
</div>
</div>
<div class="form-group">
<select class="form-control" name="myformcontrol" id="myformcontrol">
<option selected>管理员</option>
<option>药品整理员</option>
<option>售货员</option>
<option>进货员</option>
<option>退货员</option>
</select>
</div>
<%--记得将来将领导ID改成选择框,选择领导名称--%>
<div class="form-group">
<div class="input-group">
<span class="input-group-addon">
领导ID
</span>
<input type="text" name="userLeaderId" class="form-control" placeholder="请输入领导ID" id="userLeaderId" required>
</div>
</div>
<div class="form-group">
<input type="submit" name="login" class="btn btn-primary col-xs-2" id="userLogin" value="确定">
<input type="reset" name="cancel" class="btn btn-warning col-xs-2 col-xs-push-8" id="userCancel" value="取消">
</div>
</div>
</div>
</fieldset>
</form>
</div>
</div>
</div>
<script src="bootstrap/js/jquery.min.js" charset="utf-8"></script>
<script src="bootstrap/js/bootstrap.min.js" charset="utf-8"></script>
</body>
</html>
import beans.Staff;
import utils.StaffOper;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
@WebServlet(name = "LoginServlet")
public class LoginServlet extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
String sid = request.getParameter("userid");
String spwd = request.getParameter("userpwd");
String pos = request.getParameter("userpos");
// System.out.println(pos);
Staff staff = new Staff();
staff.setID(sid);
staff.setPsd(spwd);
staff.setPosition(pos);
HttpSession session = request.getSession();
Staff staffPos = StaffOper.check(staff); //根据返回值进行跳转
if (staffPos != null){
session.setAttribute("sid",sid);
session.setAttribute("staff",staffPos);
String position = staffPos.getPosition();
switch (position) {
case "管理员":{
RequestDispatcher rd = request.getRequestDispatcher("master.jsp"); //转到管理页面
rd.forward(request,response); //转发请求
break;
}
case "药品整理员": {
RequestDispatcher rd = request.getRequestDispatcher("trim.jsp"); //转到整理员页面
rd.forward(request,response); //转发请求
break;
}
case "售货员":{
RequestDispatcher rd = request.getRequestDispatcher("salesman.jsp"); //转到售货员页面
rd.forward(request,response); //转发请求
break;
}
case "进货员":{
RequestDispatcher rd = request.getRequestDispatcher("buyer.jsp"); //转到进货员页面
rd.forward(request,response); //转发请求
break;
}
case "退货员":{
RequestDispatcher rd = request.getRequestDispatcher("refund.jsp"); //转到退厂员页面
rd.forward(request,response); //转发请求
break;
}
default:{
// response.sendRedirect("index.jsp");
session.setAttribute("lose",sid);
RequestDispatcher rd = request.getRequestDispatcher("index.jsp"); //转到退厂员页面
rd.forward(request,response);
break;
}
}
} else {
// response.sendRedirect("index.jsp");
session.setAttribute("lose",sid);
RequestDispatcher rd = request.getRequestDispatcher("index.jsp"); //转到退厂员页面
rd.forward(request,response);
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
}
package servlet;
import beans.*;
import utils.*;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
@WebServlet(name = "ManagerMasterServlet")
public class ManagerMasterServlet extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
HttpSession session=request.getSession();
int id=Integer.parseInt(request.getParameter("id"));
switch (id){
case 1:{
request.getRequestDispatcher("master.jsp").forward(request,response);
break;
}
case 2:{
List<Staff> list = new StaffProcess().getStaffInfo();
session.setAttribute("stafflist",list);
request.getRequestDispatcher("manageUser.jsp").forward(request,response);
break;
}
case 3:{
List<Stock> list = new StockProcess().getStockInfo();
session.setAttribute("stocklist",list);
request.getRequestDispatcher("showStock.jsp").forward(request,response);
break;
}
case 4:{
List<BuyBill> list = new BaleOrderProcess().getBaleInfo();
session.setAttribute("balelist",list);
request.getRequestDispatcher("showBaleOrder.jsp").forward(request,response);
break;
}
case 5:{
List<SaleBill> list = new SaleOrderProcess().getSaleInfo();
session.setAttribute("salelist",list);
request.getRequestDispatcher("showSaleOrder.jsp").forward(request,response);
break;
}
case 6:{
session.removeAttribute("returnlist");
List<ReturnGoods> list = CancelProcess.getReturnInfo();
session.setAttribute("returnlist",list);
request.getRequestDispatcher("showCancel.jsp").forward(request,response);
break;
}
case 7:{
List<Customer> list = new CustomProcess().getCustomInfo();
session.setAttribute("customlist",list);
request.getRequestDispatcher("showCustom.jsp").forward(request,response);
break;
}
case 8:{
List<Producer> list = new FirmProcess().getFirmInfo();
session.setAttribute("firmlist",list);
request.getRequestDispatcher("showFirm.jsp").forward(request,response);
break;
}
case 9:{
// request.getRequestDispatcher("checkExpire.jsp").forward(request,response);
request.getRequestDispatcher("index.jsp").forward(request,response);
break;
}
case 10:{
request.getRequestDispatcher("addUser.jsp").forward(request,response);
break;
}
case 11:{
request.getSession().invalidate();
response.sendRedirect("index.jsp");
}
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request,response);
}
}
来源:https://www.icode9.com/content-1-460851.html
联系客服