JSP购物小项目

• 项目运行截图
  • 登录

• 登录成功
  

• 选择种类
  

• 勾选商品
  

• 结算清单
  

#创建一个新的数据库



use student;

#----------------------------------------------

#创建用户表格

create table user(

	uname varchar(20),

	upassword varchar(20)

)character set utf8;

#设置主键约束

alter table user add primary key(uname);

#添加数据

insert into user values('zhangsan','333');

insert into user values('lisi','444');

#-----------------------------------------------

#创建种类表格

create table kind(

	kid int(4),

	kname varchar(20)

)character set utf8;

#设置主键约束

alter table kind add primary key(kid);

#添加数据

insert into kind values(1,'食品');

insert into kind values(2,'书籍');

insert into kind values(3,'服饰');

#------------------------------------------------

#创建商品表格

create table commodity(

	cid int(6),

	cname varchar(20),

	cprice float(10,2),

	kid int(4)

)character set utf8;

#添加主键约束

alter table commodity add primary key(cid);

#添加外键约束

alter table commodity add constraint fk_commodity_kind 

foreign key (kid) references kind(kid);

#添加商品数据

insert into commodity values(1,'费列罗巧克力',10,1);

insert into commodity values(2,'安慕希酸奶',8,1);

insert into commodity values(3,'百草味草莓干',20,1);

insert into commodity values(4,'Head First Java',78,2);

insert into commodity values(5,'Java核心技术',87,2);

insert into commodity values(6,'算法导论',96,2);

insert into commodity values(7,'程序员格子衫',200,3);

insert into commodity values(8,'程序员双肩包',150,3);

insert into commodity values(9,'程序员假发',300,3);

package controller;

import domain.Commodity;

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 java.io.IOException;
import java.util.ArrayList;

public class CalculatePriceController extends HttpServlet {
   

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
   
        //获取购物车对象
        HttpSession session = request.getSession();
        ArrayList<Commodity> shoppingCar = (ArrayList<Commodity>)session.getAttribute("shoppingCar");
        //计算价格
        float sumPrice = 0;
        for(Commodity commodity:shoppingCar){
   
            sumPrice += commodity.getCprice();
        }
        //将计算好的价钱存起来
        request.setAttribute("sumPrice",sumPrice);
        //转发做最后列表展示
        request.getRequestDispatcher("showEndList.jsp").forward(request,response);
    }
}

package controller;

import service.UserService;
import util.MySpring;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;

public class LoginController extends HttpServlet {
   

    private UserService service = MySpring.getBean("service.UserService");

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
   
        //1.处理字符集
        request.setCharacterEncoding("UTF-8");
        //2.接受请求发送过来的参数
        String uname = request.getParameter("uname");
        String upassword = request.getParameter("upassword");
        //3.调用业务层的方法执行操作
        String result = service.login(uname,upassword);
        //4.根据结果转发
        if(result.equals("登录成功")){
   
            //转发welcome
            request.getRequestDispatcher("welcome.jsp").forward(request,response);
        }else{
   
            request.setAttribute("result",result);
            request.getRequestDispatcher("index.jsp").forward(request,response);
        }
    }
}

package controller;

import domain.Commodity;
import service.CommodityService;
import util.MySpring;

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 java.io.IOException;
import java.util.ArrayList;

public class SaveCommodityController extends HttpServlet {
   

    private CommodityService service = MySpring.getBean("service.CommodityService");

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
   
        //1.处理一下字符集
        request.setCharacterEncoding("UTF-8");
        //2.获取请求提交发送过来的信息
        //传递过来的flag 继续购物、结算清单
        String flag = request.getParameter("flag");
        //所有勾选商品的对应cid编号
        String[] cids = request.getParameterValues("cid");
        //3.去session范围内找寻购物车对象
        HttpSession session = request.get