Repository navigation
Expand file tree
/
Copy pathSQLGener.java
More file actions
154 lines (140 loc) · 3.56 KB
/
Copy pathSQLGener.java
File metadata and controls
154 lines (140 loc) · 3.56 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
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
package org.ithang.tools;
import java.lang.reflect.Field;
import java.util.Map;
import org.ithang.tools.lang.StrUtils;
@Deprecated
public class SQLGener {
/**
* 根据实体类生成Insert SQL
* @param bean
* @return
*/
public static String insert(Object bean){
StringBuilder sber=new StringBuilder();
String[] fieldNames=ModelTools.getFieldNames(bean.getClass());
sber.append("insert into ").append(ModelTools.getTableName(bean.getClass()));
sber.append("(").append(StrUtils.trimSuffix(StrUtils.pkg(fieldNames, "", ","),",")).append(")");
sber.append(" values (");
int i=0;
for(String fieldName:fieldNames){
sber.append(ModelTools.getFieldValue(bean, fieldName));
if(i<fieldNames.length-1){
sber.append(",");
}
i++;
}
sber.append(")");
return sber.toString();
}
/**
* 根据类信息与key-value对生成Insert SQL
* @param cls
* @param values
* @return
*/
public static String insertSQL(Class<?> cls,Map<String,Object> values){
StringBuilder sber=new StringBuilder();
String[] fieldNames=ModelTools.getFieldNames(cls);
String[] columnNames=ModelTools.getColumnNames(cls);
sber.append("insert into ").append(ModelTools.getTableName(cls));
sber.append("(").append(StrUtils.trimSuffix(StrUtils.pkg(columnNames, "", ","),",")).append(")");
sber.append(" values (");
int i=0;
for(String fieldName:fieldNames){
Field field=ModelTools.getField(cls, fieldName);
if(field.getType()==String.class){
sber.append("'").append(values.get(fieldName)).append("'");
}else{
sber.append(values.get(fieldName));
}
if(i<fieldNames.length-1){
sber.append(",");
}
i++;
}
sber.append(")");
return sber.toString();
}
/**
* 根据类信息与相关值(有顺序性)生成Insert SQL
* @param cls
* @param values
* @return
*/
public static String insertSQL(Class<?> cls,Object...values){
StringBuilder sber=new StringBuilder();
String[] fieldNames=ModelTools.getFieldNames(cls);
String[] columnNames=ModelTools.getColumnNames(cls);
sber.append("insert into ").append(ModelTools.getTableName(cls));
sber.append("(").append(StrUtils.trimSuffix(StrUtils.pkg(columnNames, "", ","),",")).append(")");
sber.append(" values (");
if(null!=values&&values.length>0){
int i=0;
for(Object value:values){
if(value.getClass()==String.class){
sber.append("'").append(value).append("'");
}else{
sber.append(value);
}
if(i<fieldNames.length-1){
sber.append(",");
}
i++;
}
}else{
int len=fieldNames.length;
for(int i=0;i<len;i++){
if(i<fieldNames.length-1){
sber.append("?,");
}else{
sber.append("?");
}
}
}
sber.append(")");
return sber.toString();
}
/**
* 根据实体类实例生成Update SQL
* @param bean
* @return
*/
public static String updateSQL(Object bean){
return null;
}
/**
* 根据类信息及key-value对生成Update SQL
* @param cls
* @param values
* @return
*/
public static String updateSQL(Class<?> cls,Map<String,Object> values){
return null;
}
/**
* 根据类信息及主键ID值生成Delete SQL
* @param cls
* @param id 主键值
* @return
*/
public static String deleteSQL(Class<?> cls,Object... id){
return null;
}
/**
* 根据类信息生成全量Select SQL
* @param cls
* @return
*/
public static String selectSQL(Class<?> cls){
return null;
}
/**
* 根据条件生成条件Select SQL
* @param cls
* @param values
* @return
*/
public static String selectSQL(Class<?> cls,Map<String,Object> values){
return null;
}
}