forked from maxliaops/Java_Web_Examples
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathCarAction.java
More file actions
115 lines (99 loc) · 3.18 KB
/
CarAction.java
File metadata and controls
115 lines (99 loc) · 3.18 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
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
package com.webtier;
import java.util.List;
import com.dao.CarDao;
import com.form.CarForm;
import com.tools.MyPagination;
public class CarAction extends CarForm {
private static CarDao carDao = null;
public CarAction() {
carDao = new CarDao();
}
public String queryCarList() {
List list = carDao.queryCarList(null);
request.setAttribute("list", list);
return SUCCESS;
}
public void validateInsertCar() {
if (null == username || username.equals("")) {
this.addFieldError("username", "请您输入姓名");
}
if (null == user_number || user_number.equals("")) {
this.addFieldError("user_number", "请您输入身份证号");
}
if (null == car_number || car_number.equals("")) {
this.addFieldError("car_number", "请您输入车牌号");
}
if (null == tel || tel.equals("")) {
this.addFieldError("tel", "请您输入电话");
}
if (null == address || address.equals("")) {
this.addFieldError("address", "请您输入地址");
}
if (null == car_road || car_road.equals("")) {
this.addFieldError("car_road", "请您输入运输路线");
}
if (null == car_content || car_content.equals("")) {
this.addFieldError("car_content", "请您输入车辆描述");
}
}
public String deleteCar() {
String sql = "delete from tb_car where id='" + id + "'";
carDao.operationCar(sql);
return "operationSuccess";
}
public String insertCar() {
String sql = "insert into tb_car (username,user_number,car_number,tel,address,car_road,car_content) value('"
+ username
+ "','"
+ user_number
+ "','"
+ car_number
+ "','"
+ tel
+ "','"
+ address
+ "','"
+ car_road
+ "','"
+ car_content + "')";
carDao.operationCar(sql);
return "operationSuccess";
}
public String queryCarForm() {
CarForm carForm = carDao.queryCarForm(id.toString());
request.setAttribute("carForm", carForm);
return SUCCESS;
}
public void validateUpdateCar() {
if (null == username || username.equals("")) {
this.addFieldError("username", "请您输入姓名");
}
if (null == user_number || user_number.equals("")) {
this.addFieldError("user_number", "请您输入身份证号");
}
if (null == car_number || car_number.equals("")) {
this.addFieldError("car_number", "请您输入车牌号");
}
if (null == tel || tel.equals("")) {
this.addFieldError("tel", "请您输入电话");
}
if (null == address || address.equals("")) {
this.addFieldError("address", "请您输入地址");
}
if (null == car_road || car_road.equals("")) {
this.addFieldError("car_road", "请您输入运输路线");
}
if (null == car_content || car_content.equals("")) {
this.addFieldError("car_content", "请您输入车辆描述");
}
}
public String updateCar() {
String sql = "update tb_car set username='" + username
+ "',user_number='" + user_number + "',car_number='"
+ car_number + "',tel='" + tel + "',address='" + address
+ "',car_road='" + car_road + "',car_content='" + car_content
+ "' where id='" + id + "'";
carDao.operationCar(sql);
return "operationSuccess";
}
}