FilesExpand file tree

 master

/

ListToSql.java

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

109 lines (98 loc) · 3.01 KB

 master

/

ListToSql.java

Copy path

Top

File metadata and controls

• Code
• Blame

109 lines (98 loc) · 3.01 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

package com.utils.database;

import com.sun.xml.internal.ws.util.StringUtils;

import lombok.extern.slf4j.Slf4j;

import org.apache.commons.collections.CollectionUtils;

import java.io.File;

import java.io.IOException;

import java.lang.reflect.Method;

import java.nio.charset.Charset;

import java.nio.file.Files;

import java.nio.file.Path;

import java.nio.file.Paths;

import java.util.ArrayList;

import java.util.List;

import java.util.regex.Matcher;

import java.util.regex.Pattern;

/**

* <p>

* 生成sql脚本

* </p>

*

* @author wangliang

* @since 2017/9/5

*/

@Slf4j

public class ListToSql {

/**

* 生成sql脚本文件

*

* @param list 数据源

* @param template sql语句模版

* @param sqlFile 要输出的sql脚本文件路径

* @return

*/

public static boolean generateSqlScripFile(List list, String template, String sqlFile) {

boolean result = false;

try {

//生成sql脚本

List<String> sqlList = generateSqlStatement(list, template);

//创建sql脚本文件

File file = createFile(sqlFile);

Path filePath = Paths.get(file.getPath());

//写入数据到文件中

Files.write(filePath, sqlList, Charset.forName("UTF-8"));

} catch (Exception e) {

log.error("生成sql脚本异常", e);

}

return result;

}

/**

* 生成insert sql语句

*

* @param list 数据源

* @param template sql语句模版

* @return

*/

public static List<String> generateSqlStatement(List list, String template) throws Exception {

// 获取sql中的所有字段点位符

Matcher matcher = Pattern.compile("(:\\w*)").matcher(template);

List<String> fields = new ArrayList();

while (matcher.find()) {

fields.add(matcher.group().replace(":", ""));

}

List<String> sqlList = new ArrayList<>();

if (CollectionUtils.isNotEmpty(list)) {

for (Object o : list) {

Class clazz = o.getClass();

// 组装sql语句

String sql = new String(template);

for (String field : fields) {

String getterMethodName = "get" + StringUtils.capitalize(field);

Method method = clazz.getMethod(getterMethodName);

sql = sql.replace(":" + field, String.valueOf(method.invoke(o)));

}

log.info(sql);

sqlList.add(sql);

}

}

return sqlList;

}

/**

* 创建文件

*

* @param pathName 文件路径

*/

public static File createFile(String pathName) {

File file = null;

try {

file = new File(pathName);

//if file does not exists, then create it

// if (!file.exists()) {

file.createNewFile();

// }

} catch (IOException e) {

log.error("文件创建失败", e);

}

return file;

}

}