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

项目结构图

数据库设计

前端界面设计

商城首页

商城首页.html

	
		
		
		
		
		
		
	
	
		

			

				

					,欢迎您
				
				

					
						购物车
					
				
				

					
登录
					
注册
				

			
		
		
		

			

				
				
			
		
		

			

				
				
				

					

						
					
					

						
					
					

						
					
					

						
					
					

						
					
				
			
			

				

					
手机
					

						

							

								
									

										
									
									
Xiaomi 12X
									
￥3199
								
							
							

								
									

										
									
									
Xiaomi 12 Pro
									
￥4699
								
							
							

								
									

										
									
									

                                        Xiaomi 11 青春活力版
                                    
									
￥1999
								
							
							

								
									

										
									
									

                                        Redmi Note 11 Pro系列
                                    
									
￥1799
								
							
							

								
									

										
									
									
Xiaomi 12X
									
￥3199
								
							
							

								
									

										
									
									
Xiaomi 12 Pro
									
￥4699
								
							
							

								
									

										
									
									

										Xiaomi 11 青春活力版
									
									
￥1999
								
							
							

								
									

										
									
									

										Redmi Note 11 Pro系列
									
									
￥1799
								
							
						
					
				
				

					
电脑
					

						

							

								
									

										
									
									
微星(MSI)PRO 电脑主板
									
￥3629
								
							
							

								
									

										
									
									
新品英特尔酷睿12代
									
￥1999
								
							
							

								
									

										
									
									

										笔记本电脑小新Air14 银
									
									
￥4399
								
							
							

								
									

										
									
									

										索尼（SONY）playstation5
									
									
￥5099
								
							
							

								
									

										
									
									
微星(MSI)PRO 电脑主板
									
￥3629
								
							
							

								
									

										
									
									
新品英特尔酷睿12代
									
￥1999
								
							
							

								
									

										
									
									

										笔记本电脑小新Air14 银
									
									
￥4399
								
							
							

								
									

										
									
									

										索尼（SONY）playstation5
									
									
￥5099
								
							
						
					
				
				

					
家用电器
					

						

							

								
									

										
									
									

										西门子（SIEMENS）蒸烤箱一体机嵌入式
									
									
￥7999
								
							
							

								
									

										
									
									
小米电视6 至尊版 65英寸
									
￥7999
								
							
							

								
									

										
									
									

										亿田（entive）D2ZK 集成灶蒸烤一体
									
									
￥13800
								
							
							

								
									

										
									
									

										卡萨帝（Casarte）635升四开门十字对开门冰箱
									
									
￥12499
								
							
							

								
									

										
									
									

										西门子（SIEMENS）蒸烤箱一体机嵌入式
									
									
￥7999
								
							
							

								
									

										
									
									
小米电视6 至尊版 65英寸
									
￥7999
								
							
							

								
									

										
									
									

										亿田（entive）D2ZK 集成灶蒸烤一体
									
									
￥13800
								
							
							

								
									

										
									
									

										卡萨帝（Casarte）635升四开门十字对开门冰箱
									
									
￥12499
								
							
						
					
				
				

					
服饰
					

						

							

								
									

										
									
									
梵希蔓垂感卡其色西装外套女
									
￥299
								
							
							

								
									

										
									
									
海青蓝时尚通勤小西服女
									
￥358
								
							
							

								
									

										
									
									

										森马卫衣男2021秋新款oversize创意图案
									
									
￥139
								
							
							

								
									

										
									
									

										Lilbetter情侣重磅卫衣男加绒
									
									
￥215
								
							
							

								
									

										
									
									
梵希蔓垂感卡其色西装外套女
									
￥299
								
							
							

								
									

										
									
									
海青蓝时尚通勤小西服女
									
￥358
								
							
							

								
									

										
									
									

										森马卫衣男2021秋新款oversize创意图案
									
									
￥139
								
							
							

								
									

										
									
									

										Lilbetter情侣重磅卫衣男加绒
									
									
￥215
								
							
						
					
				
			
		
		

			

				
手机
				
电脑
				
家居
				
服饰
				
返回顶部
			
		

		

			

				

					
购物指南
					

						
购物流程
						
会员介绍
						
生活旅行
						
常见问题
						
联系客服
					
				
				

					
支付方式
					

						
信用卡
						
货到付款
						
在线付款
						
分期付款
					
				
				

					
售后服务
					

						
售后政策
						
退款说明
						
返修/退换货
					
				
				

					
帮助中心
					

						
账户管理
						
自助服务
						
订单操作
						
服务网点
						
授权体验店/专区
					
				
				

					
关于我们
					

						
新浪微博
						
官方微信
						
联系我们
						
加入我们
						
公益基金会
					
				
			
		
	

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475

登录注册页面

登录注册页面.html

    
        
        
        
        
        
        
		

    
    
        

            

                商城首页
            
        
        

			
            

                

                    
注册
                    
					
                    
                    
					
					
					
					
                    注册
                
            
			
            

                

                    
登录
                    
                    
                    忘记密码？
                    登录
                
            
			
            

                

					
                    

                        
已有帐号？
                        
请使用您的帐号进行登录
                        登录
                    
					
                    

                        
没有帐号？
                        
立即注册加入我们，和我们一起开始旅程吧
                        注册
                    
                
            
        
    

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64

购物车页面

car.html

	
		
		
		
		
		
		
	
	
		

			

				商城首页
			
		
		

			

				

					

						
					
					全选
				
				
图片
				
商品名称
				
商品信息
				
单价
				
数量
				
小计
				
操作
			
			

				

					

						
					
				
				

					
				
				
Vue.js全家桶零基础入门到进阶项目实战
				
Vue.js全家桶零基础入门到进阶项目实战
				

					￥
					
99.20
				
				

					-
					
					+
				
				

					￥
					
99.20
				
				

					移除商品
				
			
			

				

					

						
					
				
				

					
				
				
CSS新世界
				
CSS新世界
				

					￥
					
108.80
				
				

					-
					
					+
				
				

					￥
					
108.80
				
				

					移除商品
				
			
			

				

					

						
					
				
				

					
				
				
CSS世界(异步图书出品)
				
CSS世界(异步图书出品)
				

					￥
					
57.80
				
				

					-
					
					+
				
				

					￥
					
57.80
				
				

					移除商品
				
			
		
		

			

				

					

						
						全选
					
					

						已选择数量:
						0
						件
					
				
				

					

						

							结算
						
						

							
总价是：
							

								￥
								00.00
							
						
					
				
			
		
	

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148

car.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);
		});
	}
	
});
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65

编写代码实现功能

连接数据库实现登录注册功能

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();
    }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

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);
    }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53

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);
    }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45

购物车连接数据库，将商品加入购物车后，能够查看商品详细信息

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;
    }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58

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;
            List carList=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);
    }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116

通过点击首页的商品图片，查看商品的详细信息

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();
    }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66

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);
    }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66

资源包

内容太多，文章里面只能够简单的描述一下，我正在整理文件，后面会将项目的所有文件打包上传到Gitee上面，供大家下载下来学习使用

这个项目我做得并不是很完美，各位可以发挥自己的才能去完善它

码字不易，还请点赞支持一下，谢谢