相关推荐recommended
- mysql 存储过程
- 配置SSL证书后，Nginx的HTTPS 不能正常
- 【Spring Boot学习】今天是我的生日,舍友催我去吃饭,我还是坚
- 基于flask的web应用开发——访问漂亮的html页面以及页面跳转
- Windows搭建Typecho个人博客并发布公网访问【内网穿透】
- Mysql时间戳（随笔）
- 解决Tomcat异常:java.lang.IllegalStateEx
- springboot、java实现调用企业微信接口向指定用户发送消息
- 【SpringMVC】Jrebel 插件实现热部署与文件上传
- Mybatis-plus解析sql发生异常：net.sf.jsqlpa
- SpringBoot调用第三方WebService接口的两种实现方式
- SSM框架详细讲解
- JavaWeb核心、综合案例(详细！Web开发流程)
- Tomcat安装测试、Eclipse配置Tomcat步骤
- 【MySQL】表的基本查询
- 手把手教小白如何在Window系统下搭建Nginx服务器环境并部署前端
- MySQL—SQL优化：插入数据（insert、大批量插入）、主键优化
- python教程lxml详解
- Rust 一门赋予每个人构建可靠且高效软件能力的语言
- springboot 对接 minio 分布式文件系统
- Nginx超时配置
- BaseMapper接口的使用
- 总结Nginx的安装、配置与设置开机自启
- IDEA（2022.2）搭建Servlet基本框架详细步骤
- 基于JAVA的学生信息管理系统
- 记录Bug：idea连接数据库报错DBMS: MySQL (no ve
- SpringCloud Gateway网关多路由配置访问404解决方案
- Java完整版(JavaSe语法，数据结构，Mysql，网络，Java
- MySQL之索引(入门级讲解）
- Stable Diffusion WebUI linux部署问题
JavaWeb在线商城系统(java+jsp+servlet+MySQL+jdbc+css+js+jQuery)
作者：mmseoamin日期：2023-12-19
JavaWeb在线商城系统
- JavaWeb在线商城开发知识总结(java+jsp+servlet+MySQL+jdbc+css+js+jQuery)
- 获取项目数据和数据库：
- 期末实训项目-JavaWeb在线商城系统
- 项目代码及数据库下载链接
- 数据库设计
- 前端界面设计
- 商城首页
- 登录注册页面
- 购物车页面
- 编写代码实现功能
- 连接数据库实现登录注册功能
- 购物车连接数据库，将商品加入购物车后，能够查看商品详细信息
- 通过点击首页的商品图片，查看商品的详细信息
- 资源包
JavaWeb在线商城开发知识总结(java+jsp+servlet+MySQL+jdbc+css+js+jQuery)
这个基于JavaWeb的在线商城项目是我们专业这学期期末实训的项目
项目视频演示
期末实训项目-JavaWeb在线商城系统(java+jsp+servlet+MySQL+jdbc+css+js+jQuery)
获取项目数据和数据库：
期末实训项目-JavaWeb在线商城系统
项目代码及数据库下载链接
gitee链接：
https://gitee.com/yuhaowen/ShoppingMall.git
GitHub：
https://github.com/yuhaowen0917/JavaWeb-ShoppingMall.git
项目资源和数据库
https://download.csdn.net/download/yuyunbai0917/85839278
项目结构图
数据库设计
前端界面设计
商城首页
https://blog.csdn.net/yuyunbai0917/article/details/商城首页.html
实训在线商城 
手机
电脑
家用电器
- 手机
- 电脑
- 家居
- 服饰
返回顶部登录注册页面
登录注册页面.html
在线商城注册页面 已有帐号？
请使用您的帐号进行登录
没有帐号？
立即注册加入我们，和我们一起开始旅程吧
购物车页面
car.html
商城购物车界面 全选已选择数量: 0 件总价是：￥ 00.00car.js
能够实现购物车中对商品的复选框全选、计算商品的数量小计，以及购物车中商品总价
$(function(){ // $(".c-sum_num").click(function(){ // console.info($(this).text()); // }) totl(); goodsnum(); // 全选 $(".all").click(function() { let all = $(this).prop("checked") $(".each").each(function() { $(this).prop("checked", all); }) }) // 减少商品数量 $(".reduce").click(function(){ var num = $(this).siblings(".text_num").val(); if(num>0){ num--; $(this).siblings(".text_num").val(num); } var price=$(this).parents().siblings(".c-price").children(".c-price_num").text(); var sum_num = $(this).parents().siblings(".c-sum").children(".c-sum_num"); var sum = parseFloat(price*num); // console.log(sum); $(sum_num).text(sum); totl(); goodsnum(); }); // 增加商品数量 $(".add").click(function(){ var num = $(this).siblings(".text_num").val(); num++; $(this).siblings(".text_num").val(num); var price=$(this).parents().siblings(".c-price").children(".c-price_num").text(); var sum_num = $(this).parents().siblings(".c-sum").children(".c-sum_num"); var sum = parseFloat(price*num); // console.log(sum); $(sum_num).text(sum); totl(); goodsnum(); }); // 删除商品 $(".remove").click(function(){ $(this).parents(".carts-goods").remove(); totl(); goodsnum(); }); // 总价 function totl(){ let sumprice = 0; $.each($(".c-sum_num"),function() { sumprice+=parseFloat($(this).text()); $(".show-money span").text(sumprice); }); } // 统计商品数量 function goodsnum(){ let goods_num=0; $.each($(".text_num"),function() { goods_num+=parseInt($(this).val()); $(".goods_num span").text(goods_num); }); } });编写代码实现功能
连接数据库实现登录注册功能
user.java
package User; public class user { private int user_id; private String username; private String password; public int getId() { return user_id; } public void setId(int id) { this.user_id = user_id; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } @Override public String toString() { return "User [user_id=" + user_id + ", username=" + username + ", password=" + password + "]"; } public user(int id, String username, String password, String address) { super(); this.user_id = user_id; this.username = username; } public user() { super(); } }RegisterController.java
package controller; import shop_servlet.Register; 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 java.io.IOException; //import service.UserService2; @WebServlet("/register.do") public class RegisterController extends HttpServlet{ private static final long serialVersionUID = 7804524886360637172L; public RegisterController() { super(); } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { try { request.setCharacterEncoding("UTF-8"); response.setCharacterEncoding("UTF-8"); String username = request.getParameter("username"); String user_id = request.getParameter("user_id"); String password = request.getParameter("password"); String email = request.getParameter("email"); String birth = request.getParameter("birth"); String phone = request.getParameter("phone"); String address = request.getParameter("address"); Register userService = new Register(); if(userService.register(username, user_id, password, email, birth, phone, address) > 0) { response.getWriter().print("register success!"); }else { response.getWriter().print("register false!"); } } catch (Exception e) { e.printStackTrace(); } } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); } }LoginController.java
package controller; import java.io.IOException; 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 shop_servlet.Register; @WebServlet("/login.do") public class LoginController extends HttpServlet{ private static final long serialVersionUID = 7242872008838278971L; public LoginController() { super(); } @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { try { String user_id = request.getParameter("user_id"); String password = request.getParameter("password"); Register userService = new Register(); if(userService.login(user_id,password)) { request.getSession().setAttribute("user_id", user_id); response.sendRedirect("first.jsp"); }else { response.getWriter().print("register false!"); } }catch(Exception e) { e.printStackTrace(); } } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); } }购物车连接数据库，将商品加入购物车后，能够查看商品详细信息
Car.java
package beans; public class Car { private String goods_id; private String goods_name; private String unitprice; private String quantity; private String userid; private String pic; public String getGoods_id() { return goods_id; } public void setGoods_id(String goods_id) { this.goods_id = goods_id; } public String getGoods_name() { return goods_name; } public void setGoods_name(String goods_name) { this.goods_name = goods_name; } public String getUnitprice() { return unitprice; } public void setUnitprice(String unitprice) { this.unitprice = unitprice; } public String getQuantity() { return quantity; } public void setQuantity(String quantity) { this.quantity = quantity; } public String getUserid() { return userid; } public void setUserid(String userid) { this.userid = userid; } public String getPic() { return pic; } public void setPic(String pic) { this.pic = pic; } }AddCarController.java
package controller; import beans.Car; import beans.Good; import utils.JDBCUtils; 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.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List; //import service.UserService2; @WebServlet("/addcar.do") public class AddCarController extends HttpServlet{ private static final long serialVersionUID = 7804524886360637172L; public AddCarController() { super(); } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { try { request.setCharacterEncoding("UTF-8"); response.setCharacterEncoding("UTF-8"); HttpSession session= request.getSession(); String id = request.getParameter("id"); Object user_id= session.getAttribute("user_id"); //1查询 //查询商品 String sql="SELECT * FROM goods WHERE goods_id=?"; Connection connection= JDBCUtils.getConnection(); PreparedStatement stmt = connection.prepareStatement(sql); stmt.setString(1, id); ResultSet rs = stmt.executeQuery(); Good good=new Good(); while (rs.next()) { good.setGoods_id(rs.getString("goods_id")); good.setGoods_name(rs.getString("goods_name")); good.setUnitprice(rs.getString("unitprice")); good.setDetails(rs.getString("details")); good.setPic(rs.getString("photo")); } //2添加到数据库 String sqladd="INSERT INTO car (goods_id, goods_name,unitprice,quantity,userid,pic) VALUES (?,?,?,?,?,?)"; stmt = connection.prepareStatement(sqladd); stmt.setString(1, good.getGoods_id()); stmt.setString(2,good.getGoods_name()); stmt.setString(3,good.getUnitprice()); stmt.setString(4,"1"); stmt.setString(5,user_id.toString()); stmt.setString(6, good.getPic()); int res=stmt.executeUpdate();//执行sql语句 if (res>0){ System.out.println("插入成功"); } //3返回购物车 String carsql="select * from car where userid=?"; stmt = connection.prepareStatement(carsql); stmt.setString(1, user_id.toString()); //查询商品 rs = stmt.executeQuery(); Car car=null; ListcarList=new ArrayList<>(); while (rs.next()) { car=new Car(); car.setGoods_id(rs.getString("goods_id")); car.setGoods_name(rs.getString("goods_name")); car.setUnitprice(rs.getString("unitprice")); car.setQuantity(rs.getString("quantity")); car.setPic(rs.getString("pic")); carList.add(car); } connection.close(); request.getSession().setAttribute("carList", carList); response.sendRedirect("car.jsp"); } catch (Exception e) { e.printStackTrace(); } } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); } } 通过点击首页的商品图片，查看商品的详细信息
Goods.java
package beans; public class Good { private String goods_id; private String goods_name; private String unitprice; private String details; private String pic; public String getPic() { return pic; } public void setPic(String pic) { this.pic = pic; } public String getGoods_id() { return goods_id; } public void setGoods_id(String goods_id) { this.goods_id = goods_id; } public String getGoods_name() { return goods_name; } public void setGoods_name(String goods_name) { this.goods_name = goods_name; } public String getUnitprice() { return unitprice; } public void setUnitprice(String unitprice) { this.unitprice = unitprice; } public String getDetails() { return details; } public void setDetails(String details) { this.details = details; } @Override public String toString() { return "User [goods_id=" + goods_id + ", goods_name=" + goods_name + ", unitprice=" + unitprice + ", details=" + details + "]"; } public Good(String goods_id, String goods_name, String unitprice, String details) { super(); this.goods_id = goods_id; this.goods_name = goods_name; this.unitprice = unitprice; this.details = details; } public Good() { super(); } }DetailController.java
package controller; import beans.Good; import utils.JDBCUtils; 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 java.io.IOException; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; //import service.UserService2; @WebServlet("/detail.do") public class DetailController extends HttpServlet{ private static final long serialVersionUID = 7804524886360637172L; public DetailController() { super(); } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { try { String id = request.getParameter("id"); request.setCharacterEncoding("UTF-8"); response.setCharacterEncoding("UTF-8"); //查询商品 String sql="SELECT * FROM goods WHERE goods_id=?"; Connection connection= JDBCUtils.getConnection(); PreparedStatement stmt = connection.prepareStatement(sql); stmt.setString(1, id); ResultSet rs = stmt.executeQuery(); Good good=new Good(); while (rs.next()) { good.setGoods_id(rs.getString("goods_id")); good.setGoods_name(rs.getString("goods_name")); good.setUnitprice(rs.getString("unitprice")); good.setDetails(rs.getString("details")); good.setPic(rs.getString("photo")); } connection.close(); request.getSession().setAttribute("good", good); response.sendRedirect("phone.jsp"); } catch (Exception e) { e.printStackTrace(); } } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); } }资源包
内容太多，文章里面只能够简单的描述一下，我正在整理文件，后面会将项目的所有文件打包上传到Gitee上面，供大家下载下来学习使用
这个项目我做得并不是很完美，各位可以发挥自己的才能去完善它
码字不易，还请点赞支持一下，谢谢
购物车
- 关注我们
- 扫描二维码
- 获取更多信息
- 精彩一手掌握
Copyright © 2014-2019 seo,上海网站优化_网络制作_网站seo排名_网站建设推广_上海网络公司 版权所有
沪ICP备19022315号
沪ICP备19022315号 
