forked from maxliaops/Java_Web_Examples
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathGoodsAction.java
More file actions
81 lines (70 loc) · 2.42 KB
/
GoodsAction.java
File metadata and controls
81 lines (70 loc) · 2.42 KB
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
package com.webtier;
import java.util.List;
import com.dao.CarDao;
import com.dao.GoodsAndLogDao;
import com.form.GoodsForm;
import com.tools.MyPagination;
public class GoodsAction extends GoodsForm {
private static GoodsAndLogDao goodsAndLogDao = null;
private static CarDao carDao = null;
static {
goodsAndLogDao = new GoodsAndLogDao();
carDao=new CarDao();
}
public String queryGoodsId(){
GoodsForm goodsForm = goodsAndLogDao.queryGoodsForm(request.getParameter("goods_id"));
request.setAttribute("goodsForm", goodsForm);
return SUCCESS;
}
public String queryCar(){
List list = carDao.queryCarList(null);
request.setAttribute("list", list);
return SUCCESS;
}
public String insertGoods() {
String sql1 = "insert into tb_operationgoods (car_id,customer_id,goods_id,goods_name,goods_tel,goods_address,goods_sure) value ("
+ this.car_id
+ ","
+ this.customer_id
+ ",'"
+ this.goods_id
+ "','"
+ this.goods_name
+ "','"
+ this.goods_tel + "','" + this.goods_address + "',1)";
String startTime = request.getParameter("startTime");
String endTime = request.getParameter("endTime");
String describer = request.getParameter("describer");
String sql2 = "insert into tb_carlog (goods_id,car_id,startTime,endTime,describer) value ('"
+ goods_id
+ "','"
+ car_id
+ "','"
+ startTime
+ "','" + endTime + "','" + describer + "')";
this.goodsAndLogDao.operationGoodsAndLog(sql1);
this.goodsAndLogDao.operationGoodsAndLog(sql2);
request.setAttribute("goodsSuccess", "<br><br>您添加订货单成功");
return SUCCESS;
}
public String changeOperation(){
String goods_id=request.getParameter("goods_id");
String sql1="update tb_operationgoods set goods_sure=0 where goods_id='"+goods_id+"'";
String sql2="delete from tb_carlog where goods_id='"+goods_id+"'";
this.goodsAndLogDao.operationGoodsAndLog(sql1);
this.goodsAndLogDao.operationGoodsAndLog(sql2);
request.setAttribute("goods_id", goods_id);
return SUCCESS;
}
public String queryGoodsList(){
List list = goodsAndLogDao.queryGoodsList();
request.setAttribute("list", list);
return SUCCESS;
}
public String deleteGoods(){
String id=request.getParameter("id");
String sql="delete from tb_operationgoods where id='"+id+"'";
this.goodsAndLogDao.operationGoodsAndLog(sql);
return "deleteSuccess";
}
}