2023年8月3日发(作者：)
使⽤SqlBuilder⽣成SQL语句在MyBatis的映射配置⽂件中写sql语句有时候很⽅便，但是对于有⼤量字段的表结构却不太简单，幸好MyBatis提供的有SqlBuilder⼯具类，可以⽣成相应的SQL语句，如下例程：[java]
01.
02.
03.
04.
05.
06.
07.
08.
09.
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.
package ;
import lder;
public class MyBatisUtils extends SqlBuilder {
public String selectUserSql() {
BEGIN();
SELECT("*");
FROM("UserDto");
return SQL();
}
public String deleteUserSql() {
BEGIN();
DELETE_FROM("UserDto");
WHERE("username = #{username}");
return SQL();
}
public String insertUserSql() {
BEGIN();
INSERT_INTO("UserDto");
VALUES("username", "#{username}");
VALUES("password", "#{password}");
VALUES("address", "#{address}");
VALUES("age", "#{age}");
VALUES("sex", "#{sex}");
return SQL();
}
public String updateUserSql() {
BEGIN();
UPDATE("UserDto");
SET("password = #{password}");
WHERE("username = #{username}");
return SQL();
}
public static void main(String[] args) {
MyBatisUtils myBatisUtils = new MyBatisUtils();
n("查询 = " + UserSql());
n("删除 = " + UserSql());
n("插⼊ = " + UserSql());
n("更新 = " + UserSql());
}
}
2023年8月3日发(作者：)
使⽤SqlBuilder⽣成SQL语句在MyBatis的映射配置⽂件中写sql语句有时候很⽅便，但是对于有⼤量字段的表结构却不太简单，幸好MyBatis提供的有SqlBuilder⼯具类，可以⽣成相应的SQL语句，如下例程：[java]
01.
02.
03.
04.
05.
06.
07.
08.
09.
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.
package ;
import lder;
public class MyBatisUtils extends SqlBuilder {
public String selectUserSql() {
BEGIN();
SELECT("*");
FROM("UserDto");
return SQL();
}
public String deleteUserSql() {
BEGIN();
DELETE_FROM("UserDto");
WHERE("username = #{username}");
return SQL();
}
public String insertUserSql() {
BEGIN();
INSERT_INTO("UserDto");
VALUES("username", "#{username}");
VALUES("password", "#{password}");
VALUES("address", "#{address}");
VALUES("age", "#{age}");
VALUES("sex", "#{sex}");
return SQL();
}
public String updateUserSql() {
BEGIN();
UPDATE("UserDto");
SET("password = #{password}");
WHERE("username = #{username}");
return SQL();
}
public static void main(String[] args) {
MyBatisUtils myBatisUtils = new MyBatisUtils();
n("查询 = " + UserSql());
n("删除 = " + UserSql());
n("插⼊ = " + UserSql());
n("更新 = " + UserSql());
}
}
发布评论