java generator生成器_【Java】 rapid-generator 代码生成器

1 <?xml version="1.0" encoding="UTF-8"?>

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17 id,18 name,19 password,20 nickname,21 status,22 create_time,23 update_time24

25

26

27

28

29 SELECT LAST_INSERT_ID()30

31 INSERT INTO god_user (32 name,33 password,34 nickname,35 status,36 create_time,37 update_time38 ) VALUES (39 #{name,jdbcType=VARCHAR},40 #{password,jdbcType=VARCHAR},41 #{nickname,jdbcType=VARCHAR},42 #{status,jdbcType=INTEGER},43 #{createTime,jdbcType=TIMESTAMP},44 #{updateTime,jdbcType=TIMESTAMP}45 )46

47

48

49

50 SELECT LAST_INSERT_ID()51

52 INSERT INTO god_user53

54

55 name,56

57

58 password,59

60

61 nickname,62

63

64 status,65

66

67 create_time,68

69

70 update_time,71

72

73

74

75 #{name,jdbcType=VARCHAR},76

77

78 #{password,jdbcType=VARCHAR},79

80

81 #{nickname,jdbcType=VARCHAR},82

83

84 #{status,jdbcType=INTEGER},85

86

87 #{createTime,jdbcType=TIMESTAMP},88

89

90 #{updateTime,jdbcType=TIMESTAMP},91

92

93

94

95

96 UPDATE god_user SET97 name = #{name,jdbcType=VARCHAR},98 password = #{password,jdbcType=VARCHAR},99 nickname = #{nickname,jdbcType=VARCHAR},100 status = #{status,jdbcType=INTEGER},101 create_time = #{createTime,jdbcType=TIMESTAMP},102 update_time = #{updateTime,jdbcType=TIMESTAMP}103 WHERE104 id = #{id,jdbcType=INTEGER}105

106

107

108 UPDATE god_user SET109

110 name = #{name,jdbcType=VARCHAR},111

112

113 password = #{password,jdbcType=VARCHAR},114

115

116 nickname = #{nickname,jdbcType=VARCHAR},117

118

119 status = #{status,jdbcType=INTEGER},120

121

122 create_time = #{createTime,jdbcType=TIMESTAMP},123

124

125 update_time = #{updateTime,jdbcType=TIMESTAMP}126

127 WHERE128 id = #{id,jdbcType=INTEGER}129

130

131

132 DELETE FROM god_user WHERE133 id = #{id,jdbcType=INTEGER}134

135

136

137 SELECT

138 FROM god_user139 WHERE140 id = #{id,jdbcType=INTEGER}141

142

143

144

145

146

147

148

149

150

151 and ${criterion.condition}152

153

154 and ${criterion.condition} #{criterion.value}155

156

157 and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}158

159

160 and ${criterion.condition}161 #{listItem}

162

163

164

165

166

167

168

169

170

171

172

173

174 separator="or">

175

176

177

178

179

180 and ${criterion.condition}181

182

183 and ${criterion.condition} #{criterion.value}184

185

186 and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}187

188

189 and ${criterion.condition}190 #{listItem}

191

192

193

194

195

196

197

198

199

200

201 UPDATE god_user SET202 id = #{id,jdbcType=INTEGER},203 name = #{name,jdbcType=VARCHAR},204 password = #{password,jdbcType=VARCHAR},205 nickname = #{nickname,jdbcType=VARCHAR},206 status = #{status,jdbcType=INTEGER},207 create_time = #{createTime,jdbcType=TIMESTAMP},208 update_time = #{updateTime,jdbcType=TIMESTAMP}209

210

211

212

213

214

215 UPDATE god_user SET216

217 id = #{id,jdbcType=INTEGER},218

219

220 name = #{name,jdbcType=VARCHAR},221

222

223 password = #{password,jdbcType=VARCHAR},224

225

226 nickname = #{nickname,jdbcType=VARCHAR},227

228

229 status = #{status,jdbcType=INTEGER},230

231

232 create_time = #{createTime,jdbcType=TIMESTAMP},233

234

235 update_time = #{updateTime,jdbcType=TIMESTAMP}236

237

238

239

240

241

242

243 delete from god_user244

245

246

247

248

249

250 select count(*) from god_user251

252

253

254

255

256

257 select258

259 distinct260

261

262 from god_user263

264

265

266

267 order by #{orderByClause}268

269

270

271