firstservlet.java

管理药品的进出销量以及对销售状况的统计 Java+SQL医药进销存管理系统,可实现简单的操作

package org.xsp.web.servlet;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import org.xsp.vo.DbserviserInfo;
import org.xsp.vo.impl.DbserviseInfoImpl;
import org.xsp.model.UserBean;
import org.xsp.vo.DbserviserPage;
import org.xsp.vo.impl.DbserviserPageImpl;

public class FirstServlet extends HttpServlet {
    private static final String CONTENT_TYPE = "text/html; charset=GBK";
    private DbserviserInfo ds = new DbserviseInfoImpl();
     private DbserviserPage Db = new DbserviserPageImpl();
    UserBean ub = new UserBean();
    //Initialize global variables
    public void init() throws ServletException {
    }

    //Process the HTTP Get request
    public void doGet(HttpServletRequest request, HttpServletResponse response) throws
            ServletException, IOException {
        String method = request.getParameter("method");
        if (method != null) {
            if (method.equalsIgnoreCase("Query")) {
                Query(request, response);
            } else if (method.equalsIgnoreCase("Insert")) {
                Insert(request, response);
            }else if(method.equalsIgnoreCase("insertMedicinal")){
                insertMedicinal(request,response);
            }else if(method.equalsIgnoreCase("insertBuyInfo")){
                insertBuyInfo(request,response);
            }else if(method.equals("QueryMed")){
                QueryMed(request,response);
            }
        }

    }

    public void Query(HttpServletRequest request, HttpServletResponse response) throws
            ServletException, IOException {
        String userName = request.getParameter("txtUserName");
        String userPwd = request.getParameter("txtUserPwd");
         int num = Db.getMedicinalCount();
        ub = ds.query(userName, userPwd);
        if (ub != null) {
            HttpSession session = request.getSession(true);
            session.setAttribute("NAME", userName);
            session.setAttribute("POWER", ub.getPower());
            request.setAttribute("num",num+"");
            request.setAttribute("DELU", "登陆成功！！！！");
            request.getRequestDispatcher("power.jsp").forward(request, response);
        } else {
            request.setAttribute("DELU", "用户名密码有错！！！！");
            request.getRequestDispatcher("DeLu.jsp").forward(request, response);
        }
    }

    public void Insert(HttpServletRequest request, HttpServletResponse response) throws
            ServletException, IOException {
        String userName = request.getParameter("txtUserName");
        String userPwd = request.getParameter("txtUserPwd");
        String userPwds = request.getParameter("txtUserPwd1");
        if (userName.equals("")) {
            request.setAttribute("AAA", "用户名不能为空！！");
            request.getRequestDispatcher("insert.jsp").forward(request,
                    response);
            return;
        } else if (userPwd.equals("")) {
            request.setAttribute("AAA", "密码不能为空！！");
            request.getRequestDispatcher("insert.jsp").forward(request,
                    response);
            return;
        } else if (!userPwd.equals(userPwds)) {
            request.setAttribute("AAA", "两次密码必须相同！！");
            request.getRequestDispatcher("insert.jsp").forward(request,
                    response);
            return;
        } else if (ds.insert(userName, userPwd) > 0) {
            request.setAttribute("INSERT", "注册会员成功！！！！");
            request.getRequestDispatcher("insert.jsp").forward(request,
                    response);
        } else {
            request.setAttribute("INSERT", "注册会员失败！！！！");
            request.getRequestDispatcher("insert.jsp").forward(request,
                    response);
        }

    }

    public void insertMedicinal(HttpServletRequest request,
                                HttpServletResponse response) throws
            ServletException, IOException {
        String medicinalName = request.getParameter("txtMedicinalName");
        String medicinalaccount = request.getParameter("txtMedicinalaccount");
        String medicinalNum = request.getParameter("txtMedicinalNum");
        if (medicinalName.equals("")) {
            request.setAttribute("AAA", "药品名不能为空！！");
            request.getRequestDispatcher("insertNewMedicinal.jsp").forward(request,
                    response);
            return;
        } else if (medicinalaccount.equals("")) {
            request.setAttribute("AAA", "药品功能不能为空！！");
            request.getRequestDispatcher("insertNewMedicinal.jsp").forward(request,
                    response);
            return;
        } else if (medicinalNum.equals("")) {
            request.setAttribute("AAA", "药品数量不能为空！！");
            request.getRequestDispatcher("insertNewMedicinal.jsp").forward(request,
                    response);
            return;
        } else if (ds.insertMedicinal(medicinalName,medicinalaccount,medicinalNum) > 0) {
            request.setAttribute("INSERTMEDICINAL", "新药添加成功！！！！");
            request.getRequestDispatcher("insertNewMedicinal.jsp").forward(request,
                    response);
        } else {
            request.setAttribute("INSERTMEDICINAL", "新药添加失败！！！！");
            request.getRequestDispatcher("insertNewMedicinal.jsp").forward(request,
                    response);
        }

    }

    public void insertBuyInfo(HttpServletRequest request,
                              HttpServletResponse response) throws
            ServletException, IOException {
        String userName = request.getParameter("txtUserName");
        String medicinalName = request.getParameter("txtMedicinalName");
        String medicinalNum = request.getParameter("txtMedicinalNum");
        if (userName.equals("")) {
           request.setAttribute("AAA", "用户名不能为空！！");
           request.getRequestDispatcher("BuyMedicinal.jsp").forward(request, response);
           return;
       } else if (medicinalName.equals("")) {
           request.setAttribute("AAA", "药品不能为空！！");
           request.getRequestDispatcher("BuyMedicinal.jsp").forward(request, response);
           return;
       } else if (medicinalNum.equals("")) {
           request.setAttribute("AAA", "药品数量不能为空！！");
           request.getRequestDispatcher("BuyMedicinal.jsp").forward(request, response);
           return;
       }else if(ds.insertBuyInfo(userName,medicinalName,medicinalNum)>0){
           request.setAttribute("INSERTBUYINFO","购买成功,已添加到购物车！！！！");
           request.getRequestDispatcher("BuyMedicinal.jsp").forward(request,response);
       }else{
           request.setAttribute("INSERTBUYINFO","购买失败！！！！");
           request.getRequestDispatcher("BuyMedicinal.jsp").forward(request,response);
       }

    }
    public void QueryMed(HttpServletRequest request, HttpServletResponse response) throws
           ServletException, IOException {
       List list = ds.cha();
       if(list!=null){
           request.setAttribute("QUERY",list);
           request.getRequestDispatcher("BuyMedicinal.jsp").forward(request,response);
       }else{
           System.out.println("AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA");
       }
   }


    //Process the HTTP Post request
    public void doPost(HttpServletRequest request, HttpServletResponse response) throws
            ServletException, IOException {
        doGet(request, response);
    }

    //Clean up resources
    public void destroy() {
    }
}