private String createOneInsertSql(Object[] oneResult, String tablename) {
StringBuffer buffer = new StringBuffer();
buffer.append(
Constants.ONESQL_PREFIX
+ INSERT_INTO
+ SPLIT
+ tablename
+ SPLIT
+ SPACE
+ VALUES
+ LEFTBRACE);
for (int j = 0; j < oneResult.length; j++) {
if (oneResult[j] != null) {
if (oneResult[j] instanceof Date) {
buffer.append(QUOTES + oneResult[j] + QUOTES);
} else if (oneResult[j] instanceof String) {
buffer.append(QUOTES + StrUtils.replaceKeyString((String) oneResult[j]) + QUOTES);
} else if (oneResult[j] instanceof Boolean) {
if ((Boolean) oneResult[j]) {
buffer.append(1);
} else {
buffer.append(0);
}
} else {
buffer.append(oneResult[j]);
}
} else {
buffer.append(oneResult[j]);
}
buffer.append(COMMA);
}
buffer = buffer.deleteCharAt(buffer.lastIndexOf(COMMA));
buffer.append(RIGHTBRACE + BRANCH + BR);
return buffer.toString();
}
@Transactional(readOnly = true)
public String createTableDataSQL(String tablename) {
StringBuffer buffer = new StringBuffer();
List<Object[]> results = dao.createTableData(tablename);
for (Object[] oneResult : results) {
buffer.append(Constants.ONESQL_PREFIX + INSERT_INTO + tablename + VALUES + LEFTBRACE);
for (int j = 0; j < oneResult.length; j++) {
if (oneResult[j] != null) {
if (oneResult[j] instanceof Date) {
buffer.append(QUOTES + oneResult[j] + QUOTES);
} else if (oneResult[j] instanceof String) {
buffer.append(QUOTES + StrUtils.replaceKeyString((String) oneResult[j]) + QUOTES);
} else if (oneResult[j] instanceof Boolean) {
if ((Boolean) oneResult[j]) {
buffer.append(1);
} else {
buffer.append(0);
}
} else {
buffer.append(oneResult[j]);
}
} else {
buffer.append(oneResult[j]);
}
buffer.append(COMMA);
}
buffer = buffer.deleteCharAt(buffer.lastIndexOf(COMMA));
buffer.append(RIGHTBRACE + BRANCH + BR);
}
return buffer.toString();
}