栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

jsp传智书城前台代码完善(图书查找+我的账户+用户退出)

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

jsp传智书城前台代码完善(图书查找+我的账户+用户退出)

文章目录
  • 一、图书查找
    • 1.案例演示
    • 2.实现步骤
      • 2.1 menu_search.jsp
      • 2.1 selectBooksServlet
  • 二、用户退出
    • 1.案例演示
    • 2.实现步骤
      • 2.1 head.jsp
      • 2.2 UsersServlet
  • 三、我的账户
    • 1.案例演示
    • 2.实现步骤
      • 2.1 myAccount.jsp
      • 2.2 modifyuserinfo.jsp
      • 2.2 UsersServlet
      • 2.2 UsersDao
  • 四、我的账户中订单查询
    • 1.案例演示
    • 2.实现步骤
        • 订单查看
      • 2.1 orderlist.jsp
      • 2.1 UsersServlet
      • 2.1 OrderDao
        • 订单支付
      • 2.2 pay.jsp
      • 2.2 UsersServlet
      • 2.2 OrderDao
        • 订单删除
      • 2.3 UsersServlet
      • 2.3 OrderDao


一、图书查找 1.案例演示

搜索框输入java,点击搜索到购物车页面
menu_search.jsp

info.jsp

2.实现步骤 2.1 menu_search.jsp
Search
2.1 selectBooksServlet
@WebServlet(name = "selectBooksServlet", value = "/selectBooksServlet")
public class selectBooksServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request,response);
    }
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");
        response.setCharacterEncoding("UTF-8");
        response.setContentType("text/html;charset=utf-8");
        //由书名查找书
            String name=request.getParameter("bookname");
            BooksDao bd=new BooksDao();
            Books b=new Books();
            b.setName(name);
            Books books=bd.select(b);
            System.out.println("books"+books);
            request.getSession().setAttribute("p",books);
            request.getRequestDispatcher("/client/info.jsp").forward(request,response);
    }
}
二、用户退出 1.案例演示

点击用户退出,返回到主页面
head.jsp

login.jsp

2.实现步骤 2.1 head.jsp
| 用户退出



欢迎您: ${user.username} <%
2.2 UsersServlet

新版可以用value当做路径,旧版需要配置xml,这里UserServlet用映射路径client/logins

@WebServlet(name = "UsersServlet2", value = {"/UserServlet"})
public class UsersServlet extends HttpServlet {

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request, response);
    }

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //前台所有servlet
        request.setCharacterEncoding("UTF-8");
        response.setCharacterEncoding("UTF-8");
        response.setContentType("text/html;charset=utf-8");
        String act = request.getParameter("act");
        //用户退出
        if("exit".equals(act)){
            request.getSession().invalidate();
            response.sendRedirect(request.getContextPath()+"/client/login.jsp");
        }
    }
}

    
        UsersServlet2
        bookshop.servlet.UsersServlet
    

    
        UsersServlet2
        /client/logins
    
三、我的账户 1.案例演示

myAccount.jsp

modifyuserinfo.jsp

orderlist.jsp

2.实现步骤 2.1 myAccount.jsp
我的帐户

jsp传智书城前台代码完善(图书查找+我的账户+用户退出)
     用户信息修改

jsp传智书城前台代码完善(图书查找+我的账户+用户退出)
     订单查询

jsp传智书城前台代码完善(图书查找+我的账户+用户退出)
     用户退出
2.2 modifyuserinfo.jsp
//自己创建form表单,进行提交处理
会员邮箱: ${user.email }  
会员名: ${user.username }  
修改密码: 密码设置至少6位,请区分大小写
重复密码:  
性别:    user.gender=='男'?'checked':'' }/> 男         user.gender=='女'?'checked':'' }/> 女
联系方式:
     
<%--

--%> <%-- --%> <%--
jsp传智书城前台代码完善(图书查找+我的账户+用户退出)
--%> <%-- --%> <%--

--%> //创建自己的提交图片

 

2.2 UsersServlet
        //用户信息修改
        if("update".equals(act)){
            String id= request.getParameter("id");
            int bid=Integer.parseInt(id);
            System.out.println(bid);
            UsersDao ud=new UsersDao();
            //实例化Users
            Users u=new Users();
            //设置修改的数值
            u.setId(bid);
            u.setPassword(request.getParameter("password"));
            u.setGender(request.getParameter("gender"));
            u.setTelephone(request.getParameter("telephone"));
            if(ud.updateuser(u)){
                response.getWriter().println("update success");
            }else {
                response.getWriter().println("update error");
            }
        }
         //订单查询(由user_id找到订单)
        if("showorder".equals(act)){
             OrderDao od=new OrderDao();
             Order o=new Order();
             Users user= (Users) request.getSession().getAttribute("user");
             o.setUser(user);
             List order=new ArrayList();
             order=od.selectid(o);
             request.getSession().setAttribute("orders",order);
             request.getRequestDispatcher("/client/orderlist.jsp").forward(request,response);
        }
        
2.2 UsersDao
    //用户内容修改
    public boolean updateuser(Users users){
        Connection con = null;
        PreparedStatement pst = null;
        ResultSet rs = null;
        try {
            con = user.utils.JDBCutils.getConnection();
            String sql="update users set password=?,gender=?,telephone=? where id=?";
            pst=con.prepareStatement(sql);
            pst.setString(1,users.getPassword());
            pst.setString(2,users.getGender());
            pst.setString(3, users.getTelephone());
            pst.setInt(4,users.getId());
            int i=pst.executeUpdate();
            if(i==1){
                return true;
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            user.utils.JDBCutils.close(con, pst, rs);
        }
        return false;
    }
    //由user_id找到订单
    public List selectid(Order order){
        List list=new ArrayList();
        Connection con = null;
        PreparedStatement pst = null;
        ResultSet rs = null;
        try {
            con = JDBCutils.getConnection();
            String sql="select *from orders,users where orders.user_id=users.id and user_id=?";
            pst=con.prepareStatement(sql);
            pst.setInt(1,order.getUser().getId());
            rs=pst.executeQuery();
            while (rs.next()){
                Order orders=new Order();
                Users users=new Users();
                orders.setId(rs.getInt("id"));
                orders.setReceiverName(rs.getString("receiverName"));
                orders.setReceiverAddress(rs.getString("receiverAddress"));
                orders.setReceiverPhone(rs.getString("receiverPhone"));
                orders.setMoney(rs.getInt("money"));
                orders.setPaystate(rs.getInt("paystate"));
                orders.setOrdertime(rs.getString("ordertime"));
                users.setUsername(rs.getString("username"));
                orders.setUser(users);
                list.add(orders);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return list;
    }
四、我的账户中订单查询 1.案例演示

orderlist.jsp

点击查看到结算页面
orderInfo.jsp

跳转到支付页面
pay.jsp

点击支付回来发现已经支付

点击删除删除该订单发现已经删除

2.实现步骤 订单查看 2.1 orderlist.jsp

	查看  
	
		刪除
	 
	
		刪除
	

2.1 UsersServlet

查看

        //查看单个订单
        if("shower".equals(act)){
            //订单编号order id
            String id=request.getParameter("id");
            int sid= Integer.parseInt(id);
            //orders,users 查询
            Order o=new Order();
            OrderDao od=new OrderDao();
            List order=new ArrayList();
            order=od.show(sid);

            //books,orderItems 查询
            List orderitems=new ArrayList();
            orderitems=od.show2(sid);
            request.getSession().setAttribute("orderItems",orderitems);;
            request.getSession().setAttribute("order",order);
            request.getRequestDispatcher("/client/orderInfo.jsp").forward(request,response);
        }
2.1 OrderDao
    public List show(int id){
        List list=new ArrayList();
        Connection con = null;
        PreparedStatement pst = null;
        ResultSet rs = null;
        Users users=new Users();
        try {
            con = JDBCutils.getConnection();
            String sql="select orders.id,receiverName,receiverAddress,receiverPhone,money,paystate,ordertime,username from orders,users where orders.user_id=users.id and orders.id=?";
            pst=con.prepareStatement(sql);
            pst.setInt(1,id);
            rs=pst.executeQuery();
            if(rs.next()){
                Order orders=new Order();
                orders.setId(rs.getInt("id"));
                orders.setReceiverName(rs.getString("receiverName"));
                orders.setReceiverAddress(rs.getString("receiverAddress"));
                orders.setReceiverPhone(rs.getString("receiverPhone"));
                orders.setMoney(rs.getInt("money"));
                orders.setPaystate(rs.getInt("paystate"));
                orders.setOrdertime(rs.getString("ordertime"));
                users.setUsername(rs.getString("username"));
                orders.setUser(users);
                list.add(orders);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return list;
    }
    //查询订单内容view.jsp中的buyname和books
    public List show2(int id){
        List list=new ArrayList();
        List list2=new ArrayList();
        Connection con = null;
        PreparedStatement pst = null;
        ResultSet rs = null;
        Users users=new Users();
        try {
            con = JDBCutils.getConnection();
            String sql="select * from books,orderItems where books.id=orderItems.book_id and order_id=?";
            pst=con.prepareStatement(sql);
            pst.setInt(1,id);
            rs=pst.executeQuery();
            if(rs.next()){
                Books p=new Books();
                OrderItem oi=new OrderItem();
                oi.setBuynum(rs.getInt("buynum"));
                p.setId(rs.getInt("book_id"));
                p.setName(rs.getString("name"));
                p.setPrice(rs.getDouble("price"));
                p.setCatagory(rs.getString("catagory"));
                p.setDescription(rs.getString("description"));
                p.setImgurl(rs.getString("imgurl"));
                oi.setP(p);
                list.add(oi);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return list;
    }
订单支付 2.2 pay.jsp

2.2 UsersServlet
        //支付订单
        if("pay".equals(act)){
            //订单编号order id
            String id=request.getParameter("id");
            int sid= Integer.parseInt(id);
            OrderDao od=new OrderDao();
            if(od.pay(sid)){
                response.getWriter().println("pay success");
            }else {
                response.getWriter().println("pay error");
            }
        }
2.2 OrderDao
    //由订单编号修改支付状态
    public boolean pay(int id){
        Connection con = null;
        PreparedStatement pst = null;
        ResultSet rs = null;
        try {
            con = JDBCutils.getConnection();
            String sql="update orders set paystate=1 where id=?";
            pst=con.prepareStatement(sql);
            pst.setInt(1,id);
            System.out.println(pst);
            int i=pst.executeUpdate();
            if(i==1){
                return true;
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JDBCutils.close(con, pst, rs);
        }
        return false;
    }
订单删除 2.3 UsersServlet

删除

        //删除我的订单
        if("delete".equals(act)){
            String id=request.getParameter("id");
            int sid= Integer.parseInt(id);
            OrderDao od=new OrderDao();
            if(od.delete2(sid)){
                if(od.delete(sid)){
                    response.getWriter().println("delete success");
                }else {
                    response.getWriter().println("delete error");
                }
            }else {
                response.getWriter().println("delete error");
            }
        }
2.3 OrderDao
    //删除我的订单orderItems
    public boolean delete2(int id){
        Connection con = null;
        PreparedStatement pst = null;
        ResultSet rs = null;
        try {
            con = JDBCutils.getConnection();
            String sql="delete from orderItems where order_id=?";
            pst=con.prepareStatement(sql);
            pst.setInt(1,id);
            System.out.println(pst);
            int i=pst.executeUpdate();
            if(i==1){
                return true;
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JDBCutils.close(con, pst, rs);
        }
        return false;
    }
    //删除我的订单orders
    public boolean delete(int id){
        Connection con = null;
        PreparedStatement pst = null;
        ResultSet rs = null;
        try {
            con = JDBCutils.getConnection();
            String sql="delete from orders where id=?";
            pst=con.prepareStatement(sql);
            pst.setInt(1,id);
            System.out.println(pst);
            int i=pst.executeUpdate();
            if(i==1){
                return true;
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JDBCutils.close(con, pst, rs);
        }
        return false;
    }
转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/972261.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号