使用mybatis自动创建dao、mapping(2)

46. #{sffx,jdbcType=VARCHAR}) 47.

48. 49. insert into user

50. 51. 52. id, 53.

54. 55. username, 56.

57. 58. password, 59.

60. 61. email, 62.

63. 64. name, 65.

66. 67. sex, 68.

69. 70. birthday, 71.

72. 73. address, 74.

75. 76. tel, 77.

78. 79. qq, 80.

81. 82. image, 83.

84. 85. sfjh, 86.

87. 88. sfzx, 89.

90. 91. sfhf, 92.

93. 94. sfpl, 95.

96. 97. sffx, 98. 99.

100. 101. 102. #{id,jdbcType=VARCHAR}, 103.

104. 105. #{username,jdbcType=VARCHAR}, 106.

107. 108. #{password,jdbcType=VARCHAR}, 109.

110. 111. #{email,jdbcType=VARCHAR}, 112.

113. 114. #{name,jdbcType=VARCHAR}, 115.

116. 117. #{sex,jdbcType=VARCHAR}, 118.

119. 120. #{birthday,jdbcType=VARCHAR}, 121.

122. 123. #{address,jdbcType=VARCHAR}, 124.

125. 126. #{tel,jdbcType=VARCHAR}, 127.

128. 129. #{qq,jdbcType=VARCHAR}, 130.

131. 132. #{image,jdbcType=VARCHAR}, 133.

134. 135. #{sfjh,jdbcType=VARCHAR}, 136.

137. 138. #{sfzx,jdbcType=VARCHAR}, 139.

140. 141. #{sfhf,jdbcType=VARCHAR}, 142.

143. 144. #{sfpl,jdbcType=VARCHAR}, 145.

146. 147. #{sffx,jdbcType=VARCHAR}, 148. 149. 150.

151.

o\ >

152. update user 153.

154.

155. username = #{username,jdbcType=VARCHAR}, 156.

157.

158. password = #{password,jdbcType=VARCHAR}, 159.

160.

161. email = #{email,jdbcType=VARCHAR}, 162.

163.

164. name = #{name,jdbcType=VARCHAR}, 165.

166.

167. sex = #{sex,jdbcType=VARCHAR}, 168.

169.

170. birthday = #{birthday,jdbcType=VARCHAR}, 171.

172.

173. address = #{address,jdbcType=VARCHAR}, 174.

175.

176. tel = #{tel,jdbcType=VARCHAR},

177.

178. 179. qq = #{qq,jdbcType=VARCHAR}, 180.

181.

182. image = #{image,jdbcType=VARCHAR}, 183.

184.

185. sfjh = #{sfjh,jdbcType=VARCHAR}, 186.

187.

188. sfzx = #{sfzx,jdbcType=VARCHAR}, 189.

190.

191. sfhf = #{sfhf,jdbcType=VARCHAR}, 192.

193.

194. sfpl = #{sfpl,jdbcType=VARCHAR}, 195.

196.

197. sffx = #{sffx,jdbcType=VARCHAR}, 198. 199.

200. where id = #{id,jdbcType=VARCHAR} 201.

202. 203. update user

204. set username = #{username,jdbcType=VARCHAR}, 205. password = #{password,jdbcType=VARCHAR}, 206. email = #{email,jdbcType=VARCHAR}, 207. name = #{name,jdbcType=VARCHAR}, 208. sex = #{sex,jdbcType=VARCHAR},

209. birthday = #{birthday,jdbcType=VARCHAR}, 210. address = #{address,jdbcType=VARCHAR}, 211. tel = #{tel,jdbcType=VARCHAR}, 212. qq = #{qq,jdbcType=VARCHAR}, 213. image = #{image,jdbcType=VARCHAR}, 214. sfjh = #{sfjh,jdbcType=VARCHAR}, 215. sfzx = #{sfzx,jdbcType=VARCHAR}, 216. sfhf = #{sfhf,jdbcType=VARCHAR}, 217. sfpl = #{sfpl,jdbcType=VARCHAR}, 218. sffx = #{sffx,jdbcType=VARCHAR} 219. where id = #{id,jdbcType=VARCHAR} 220.

221.