目录
实现效果
源代码
数据库文件
结语
实现效果
源代码
login.jsp
登录界面
用户名或密码错误,请重新登录");}rs.close();pstmt.close();} catch (Exception e) {e.printStackTrace();} finally {if (conn != null) {try {conn.close();} catch (SQLException e) {e.printStackTrace();}}}%>
index.jsp
购物商城 购物商城
欢迎:
- 商品管理
- 用户管理
- 购物车
- 登出
商品编号 商品名称 商品价格 操作 <%// 连接数据库String url = "jdbc:mysql://localhost:3306/shop?useSSL=false&serverTimezone=UTC";String user = "root";String password = "123456";Connection conn = null;try {Class.forName("com.mysql.cj.jdbc.Driver");conn = DriverManager.getConnection(url, user, password);Statement stmt = conn.createStatement();ResultSet rs = stmt.executeQuery("SELECT * FROM product");while (rs.next()) {out.println("" + rs.getInt("id") + " " + rs.getString("name") + " "+ rs.getDouble("price") + " "+"" + "添加到购物车 "+"" + "修改 " + "删除" + " ");}rs.close();stmt.close();} catch (Exception e) {e.printStackTrace();} finally {if (conn != null) {try {conn.close();} catch (SQLException e) {e.printStackTrace();}}}%>
function del(id) {var flag = confirm("确认删除?");if (flag) {window.location.href = "delpro.jsp?id=" + id;}}
userinfo.jsp
购物商城 购物商城
欢迎:
- 商品管理
- 用户管理
- 购物车
- 登出
用户编号 用户名称 password 操作 <%// 连接数据库String url = "jdbc:mysql://localhost:3306/shop?useSSL=false&serverTimezone=UTC";String user = "root";String password = "123456";Connection conn = null;try {Class.forName("com.mysql.cj.jdbc.Driver");conn = DriverManager.getConnection(url, user, password);Statement stmt = conn.createStatement();ResultSet rs = stmt.executeQuery("SELECT * FROM user");while (rs.next()) {out.println("" + rs.getInt("id") + " " + rs.getString("username") + " "+ rs.getString("password") + " " + "不可删除" + " ");}rs.close();stmt.close();} catch (Exception e) {e.printStackTrace();} finally {if (conn != null) {try {conn.close();} catch (SQLException e) {e.printStackTrace();}}}%>
addcart.jsp
购物车列表 购物车列表
欢迎:
- 商品管理
- 用户管理
- 购物车
- 登出
购物人编号 购物人 商品编号 商品名称 商品价格 <%// 连接数据库String url = "jdbc:mysql://localhost:3306/shop?useSSL=false&serverTimezone=UTC";String user = "root";String password = "123456";Connection conn = null;try {Class.forName("com.mysql.cj.jdbc.Driver");conn = DriverManager.getConnection(url, user, password);Statement stmt = conn.createStatement();ResultSet rs = stmt.executeQuery("SELECT * FROM cart");while (rs.next()) {out.println("" + rs.getInt("id") + " " + rs.getString("username") + " "+rs.getInt("productid")+" "+ rs.getString("name") + " " + rs.getDouble("price") + " ");}rs.close();stmt.close();} catch (Exception e) {e.printStackTrace();} finally {if (conn != null) {try {conn.close();} catch (SQLException e) {e.printStackTrace();}}}%>
function del(id) {var flag = confirm("确认删除?");if (flag) {window.location.href = "delcart.jsp?id=" + id;}}
addcartdo.jsp
购物车列表 购物车列表
欢迎:
返回购物车
modpro.jsp
Insert use here 商品编号为
<form action="modprodo.jsp?id="method="post"> <input type="text"class="form-control" name="name"placeholder="请输入名称" value=""> <input type="text"class="form-control" name="price"placeholder="请输入价格" value="">
modprodo.jsp
delpro.jsp
Delete Pro Delete Pro
id= 的商品已经被删除!
返回主页面No user has been deleted.
数据库文件
shop.sql
/* Navicat Premium Data Transfer Source Server : tuomasi Source Server Type: MySQL Source Server Version : 80023 Source Host : localhost:3306 Source Schema : shop Target Server Type: MySQL Target Server Version : 80023 File Encoding : 65001 Date: 10/04/2023 22:13:56*/SET NAMES utf8mb4;SET FOREIGN_KEY_CHECKS = 0;-- ------------------------------ Table structure for cart-- ----------------------------DROP TABLE IF EXISTS `cart`;CREATE TABLE `cart`(`id` int(0) NOT NULL,`username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`productid` int(0) NOT NULL,`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`price` double NOT NULL) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ------------------------------ Table structure for product-- ----------------------------DROP TABLE IF EXISTS `product`;CREATE TABLE `product`(`id` int(0) NOT NULL AUTO_INCREMENT,`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`price` decimal(8, 2) NOT NULL,`stock` int(0) NOT NULL,`description` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ------------------------------ Records of product-- ----------------------------INSERT INTO `product` VALUES (1, 'iPhone 12 Pro', 9999.00, 100, 'A14 Bionic chip, 5G, Ceramic Shield, Pro camera system, LiDAR scanner');INSERT INTO `product` VALUES (2, 'MacBook Pro', 14999.00, 50, 'Apple M1 chip, 8-core CPU, 8-core GPU, 16GB unified memory, 512GB SSD storage');INSERT INTO `product` VALUES (3, 'iPad Pro', 7999.00, 80, 'M1 chip, 12.9-inch Liquid Retina XDR display, 5G, Thunderbolt, Apple Pencil (2nd generation)');INSERT INTO `product` VALUES (4, 'Apple Watch 6', 3999.00, 120, 'Blood Oxygen app, ECG app, Always-On Retina display, GPS, LTE, 50m water resistance');INSERT INTO `product` VALUES (5, 'AirPods Pro', 1999.00, 200, 'Active Noise Cancellation, Transparency mode, Adaptive EQ, sweat and water resistant');INSERT INTO `product` VALUES (6, 'iMac', 11999.00, 30, 'Apple M1 chip, 24-inch 4.5K Retina display, 8-core GPU, 8GB unified memory, 256GB SSD storage');INSERT INTO `product` VALUES (7, 'HomePod mini', 749.00, 150, 'Siri voice control, Apple Music, Intercom, HomeKit smart home accessories');INSERT INTO `product` VALUES (8, 'Apple TV 4K', 1699.00, 90, 'A12 Bionic chip, 4K High Frame Rate HDR, Dolby Vision, Siri Remote, Apple Arcade');INSERT INTO `product` VALUES (9, 'Magic Mouse 2', 549.00, 300, 'Multi-Touch surface, Wireless, Rechargeable, Bluetooth, Lightning to USB Cable');INSERT INTO `product` VALUES (10, 'AirTag', 229.00, 500, 'Precision Finding, Find My app, Privacy and security, Replaceable battery');INSERT INTO `product` VALUES (11, 'AirPods Max', 4799.00, 80, 'High-Fidelity Audio, Adaptive EQ, Active Noise Cancellation, Transparency mode');INSERT INTO `product` VALUES (12, 'MacBook Air', 9499.00, 70, 'Apple M1 chip, 8-core CPU, 7-core GPU, 8GB unified memory, 256GB SSD storage');INSERT INTO `product` VALUES (13, 'iPad Air', 5999.00, 100, 'A14 Bionic chip, 10.9-inch Liquid Retina display, Touch ID, Apple Pencil (2nd generation)');INSERT INTO `product` VALUES (14, 'Apple Watch SE', 2599.00, 150, 'Retina display, GPS, LTE, fall detection, heart rate monitoring, sleep tracking');INSERT INTO `product` VALUES (15, 'iMac Pro', 41999.00, 10, '27-inch Retina 5K display, 10-core Xeon W processor, 32GB memory, 1TB SSD storage, Radeon Pro Vega 56');INSERT INTO `product` VALUES (16, 'Magic Keyboard', 899.00, 250, 'Full-size keyboard, Numeric keypad, Bluetooth, Rechargeable, Lightning to USB Cable');INSERT INTO `product` VALUES (17, 'Mac Pro', 63999.00, 5, '3.5GHz 8-core Intel Xeon W processor, 32GB memory, Radeon Pro 580X, 256GB SSD storage');INSERT INTO `product` VALUES (18, 'HomePod', 1299.00, 100, 'High-fidelity audio, Siri voice control, Apple Music, Intercom, HomeKit smart home accessories');INSERT INTO `product` VALUES (19, 'Apple TV HD', 699.00, 120, 'A8 chip, 1080p HD, Dolby Digital Plus 7.1 surround sound, Siri Remote, Apple Arcade');INSERT INTO `product` VALUES (20, 'iPad mini', 3599.00, 80, 'A12 Bionic chip, 7.9-inch Retina display, Touch ID, Apple Pencil (1st generation) support');-- ------------------------------ Table structure for user-- ----------------------------DROP TABLE IF EXISTS `user`;CREATE TABLE `user`(`id` int(0) NOT NULL AUTO_INCREMENT,`username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ------------------------------ Records of user-- ----------------------------INSERT INTO `user` VALUES (1, 'Alice', '123456', 'alice@example.com');INSERT INTO `user` VALUES (2, 'Bob', 'abcdef', 'bob@example.com');INSERT INTO `user` VALUES (3, 'Charlie', 'qwerty', 'charlie@example.com');INSERT INTO `user` VALUES (4, 'David', '123abc', 'david@example.com');INSERT INTO `user` VALUES (5, 'Eve', 'password', 'eve@example.com');INSERT INTO `user` VALUES (6, 'Frank', 'hello123', 'frank@example.com');INSERT INTO `user` VALUES (7, 'Grace', 'abc123xyz', 'grace@example.com');INSERT INTO `user` VALUES (8, 'Henry', 'p@ssw0rd', 'henry@example.com');INSERT INTO `user` VALUES (9, 'Irene', 'qwerty123', 'irene@example.com');INSERT INTO `user` VALUES (10, 'Jack', 'password123', 'jack@example.com');SET FOREIGN_KEY_CHECKS = 1;
结语
再者,记得把jdbc驱动包加到lib目录下,启动tomcat,购物商城小项目就算完成了