Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $
You can buy this project and download/modify it how often you want.
com.pugwoo.dbhelper.sql.SQLUtils Maven / Gradle / Ivy
package com.pugwoo.dbhelper.sql;
import java.lang.reflect.Field;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import com.pugwoo.dbhelper.annotation.Column;
import com.pugwoo.dbhelper.annotation.JoinLeftTable;
import com.pugwoo.dbhelper.annotation.JoinRightTable;
import com.pugwoo.dbhelper.annotation.JoinTable;
import com.pugwoo.dbhelper.annotation.Table;
import com.pugwoo.dbhelper.enums.JoinTypeEnum;
import com.pugwoo.dbhelper.exception.BadSQLSyntaxException;
import com.pugwoo.dbhelper.exception.InvalidParameterException;
import com.pugwoo.dbhelper.exception.NoKeyColumnAnnotationException;
import com.pugwoo.dbhelper.exception.NullKeyValueException;
import com.pugwoo.dbhelper.exception.OnConditionIsNeedException;
import com.pugwoo.dbhelper.utils.DOInfoReader;
import net.sf.jsqlparser.JSQLParserException;
import net.sf.jsqlparser.expression.Expression;
import net.sf.jsqlparser.parser.CCJSqlParserUtil;
import net.sf.jsqlparser.statement.Statement;
import net.sf.jsqlparser.statement.select.PlainSelect;
import net.sf.jsqlparser.statement.select.Select;
/**
* SQL解析工具类
*
* @author pugwoo
* 2017年3月16日 23:02:47
*/
public class SQLUtils {
private static final Logger LOGGER = LoggerFactory.getLogger(SQLUtils.class);
/**
* select 字段 from t_table, 不包含where子句及以后的语句
* @param clazz
* @param withSQL_CALC_FOUND_ROWS 查询是否带上SQL_CALC_FOUND_ROWS，当配合select FOUND_ROWS();时需要为true
* @return
*/
public static String getSelectSQL(Class clazz, boolean withSQL_CALC_FOUND_ROWS) {
StringBuilder sql = new StringBuilder();
sql.append("SELECT ");
if(withSQL_CALC_FOUND_ROWS) {
sql.append("SQL_CALC_FOUND_ROWS ");
}
// 处理join方式clazz
JoinTable joinTable = DOInfoReader.getJoinTable(clazz);
if(joinTable != null) {
Field leftTableField = DOInfoReader.getJoinLeftTable(clazz);
Field rightTableField = DOInfoReader.getJoinRightTable(clazz);
JoinLeftTable joinLeftTable = leftTableField.getAnnotation(JoinLeftTable.class);
JoinRightTable joinRightTable = rightTableField.getAnnotation(JoinRightTable.class);
Table table1 = DOInfoReader.getTable(leftTableField.getType());
List fields1 = DOInfoReader.getColumnsForSelect(leftTableField.getType());
Table table2 = DOInfoReader.getTable(rightTableField.getType());
List fields2 = DOInfoReader.getColumnsForSelect(rightTableField.getType());
sql.append(join(fields1, ",", joinLeftTable.alias() + "."));
sql.append(",");
sql.append(join(fields2, ",", joinRightTable.alias() + "."));
sql.append(" FROM ").append(getTableName(table1))
.append(" ").append(joinLeftTable.alias()).append(" ");
sql.append(joinTable.joinType().getCode()).append(" ");
sql.append(getTableName(table2)).append(" ").append(joinRightTable.alias());
if(joinTable.on() == null || joinTable.on().trim().isEmpty()) {
throw new OnConditionIsNeedException("join table VO:" + clazz.getName());
}
sql.append(" on ").append(joinTable.on().trim());
} else {
Table table = DOInfoReader.getTable(clazz);
List fields = DOInfoReader.getColumnsForSelect(clazz);
sql.append(join(fields, ","));
sql.append(" FROM ").append(getTableName(table)).append(" ").append(table.alias());
}
return sql.toString();
}
/**
* select count(*) from t_table, 不包含where子句及以后的语句
* @param clazz
* @return
*/
public static String getSelectCountSQL(Class clazz) {
StringBuilder sql = new StringBuilder();
sql.append("SELECT count(*)");
// 处理join方式clazz
JoinTable joinTable = DOInfoReader.getJoinTable(clazz);
if(joinTable != null) {
Field leftTableField = DOInfoReader.getJoinLeftTable(clazz);
Field rightTableField = DOInfoReader.getJoinRightTable(clazz);
JoinLeftTable joinLeftTable = leftTableField.getAnnotation(JoinLeftTable.class);
JoinRightTable joinRightTable = rightTableField.getAnnotation(JoinRightTable.class);
Table table1 = DOInfoReader.getTable(leftTableField.getType());
Table table2 = DOInfoReader.getTable(rightTableField.getType());
sql.append(" FROM ").append(getTableName(table1))
.append(" ").append(joinLeftTable.alias()).append(" ");
sql.append(joinTable.joinType().getCode()).append(" ");
sql.append(getTableName(table2)).append(" ").append(joinRightTable.alias());
if(joinTable.on() == null || joinTable.on().trim().isEmpty()) {
throw new OnConditionIsNeedException("join table VO:" + clazz.getName());
}
sql.append(" on ").append(joinTable.on().trim());
} else {
Table table = DOInfoReader.getTable(clazz);
sql.append(" FROM ").append(getTableName(table));
}
return sql.toString();
}
/**
* 获得主键where子句，包含where关键字。会自动处理软删除条件
*
* @param t
* @param keyValues 返回传入sql的参数，如果提供list则写入
* @return 返回值前面会带空格，以确保安全。
* @throws NoKeyColumnAnnotationException
* @throws NullKeyValueException
*/
public static String getKeysWhereSQL(T t, List keyValues)
throws NoKeyColumnAnnotationException, NullKeyValueException {
List keyFields = DOInfoReader.getKeyColumns(t.getClass());
List _keyValues = new ArrayList();
String where = joinWhereAndGetValue(keyFields, "AND", _keyValues, t);
// 检查主键不允许为null
for(Object value : keyValues) {
if(value == null) {
throw new NullKeyValueException();
}
}
if(keyValues != null) {
keyValues.addAll(_keyValues);
}
return autoSetSoftDeleted("WHERE " + where, t.getClass());
}
/**
* 获得主键where子句，包含where关键字。会自动处理软删除条件
*
* @param clazz
* @throws NoKeyColumnAnnotationException
*/
public static String getKeysWhereSQL(Class clazz)
throws NoKeyColumnAnnotationException {
List keyFields = DOInfoReader.getKeyColumns(clazz);
String where = joinWhere(keyFields, "AND");
return autoSetSoftDeleted("WHERE " + where, clazz);
}
/**
* 获得主键in(?)的where子句，包含where关键字。会自动处理软删除条件
* @param clazz
* @return
*/
public static String getKeyInWhereSQL(Class clazz) {
Field keyField = DOInfoReader.getOneKeyColumn(clazz);
return autoSetSoftDeleted("WHERE " +
getColumnName(keyField.getAnnotation(Column.class)) + " in (?)", clazz);
}
/**
* 生成insert语句，将值放到values中。
* @param t
* @param values 必须
* @param isWithNullValue 标记是否将null字段放到insert语句中
* @return
*/
public static String getInsertSQL(T t, List values, boolean isWithNullValue) {
List list = new ArrayList();
list.add(t);
return _getInsertSQL(list, values, isWithNullValue);
}
/**
* 生成insert语句，将值放到values中。
* @param tList 要插入的元素值
* @param values 必须
* @return
*/
public static String getInsertSQLWithNull(List tList, List values) {
return _getInsertSQL(tList, values, true);
}
private static String _getInsertSQL(List tList, List values,
boolean isWithNullValue) {
StringBuilder sql = new StringBuilder("INSERT INTO ");
if(tList.size() > 1) {
isWithNullValue = true; // 对于多个值的，只能含null值一起插入
}
Table table = DOInfoReader.getTable(tList.get(0).getClass());
List fields = DOInfoReader.getColumns(tList.get(0).getClass());
sql.append(getTableName(table)).append(" (");
List _values = new ArrayList(); // 之所以增加一个临时变量，是避免values初始不是空的易错情况
String fieldSql = joinAndGetValue(fields, ",", _values, tList.get(0), isWithNullValue);
sql.append(fieldSql);
sql.append(") VALUES ");
String dotSql = "(" + join("?", _values.size(), ",") + ")";
sql.append(dotSql);
values.addAll(_values);
for(int i = 1; i < tList.size(); i++) {
joinAndGetValue(fields, ",", values, tList.get(i), isWithNullValue);
sql.append(",").append(dotSql);
}
return sql.toString();
}
/**
* 生成insert into (...) select ?,?,? from where not exists (select 1 from where)语句
* @param t
* @param values
* @param whereSql
* @return
*/
public static String getInsertWhereNotExistSQL(T t, List values,
boolean isWithNullValue, String whereSql) {
StringBuilder sql = new StringBuilder("INSERT INTO ");
Table table = DOInfoReader.getTable(t.getClass());
List fields = DOInfoReader.getColumns(t.getClass());
sql.append(getTableName(table)).append(" (");
sql.append(joinAndGetValue(fields, ",", values, t, isWithNullValue));
sql.append(") select ");
sql.append(join("?", values.size(), ","));
sql.append(" from dual where not exists (select 1 from ");
if(!whereSql.trim().toUpperCase().startsWith("WHERE ")) {
whereSql = "where " + whereSql;
}
whereSql = autoSetSoftDeleted(whereSql, t.getClass());
sql.append(getTableName(table)).append(" ").append(whereSql).append(" limit 1)");
return sql.toString();
}
/**
* 生成update语句
* @param t
* @param values
* @param withNull
* @param postSql
* @return 返回值为null表示不需要更新操作，这个是这个方法特别之处
*/
public static String getUpdateSQL(T t, List values,
boolean withNull, String postSql) {
StringBuilder sql = new StringBuilder();
sql.append("UPDATE ");
Table table = DOInfoReader.getTable(t.getClass());
List keyFields = DOInfoReader.getKeyColumns(t.getClass());
List notKeyFields = DOInfoReader.getNotKeyColumns(t.getClass());
sql.append(getTableName(table)).append(" SET ");
List setValues = new ArrayList();
String setSql = joinSetAndGetValue(notKeyFields, setValues, t, withNull);
if(setValues.isEmpty()) {
return null; // all field is empty, not need to update
}
sql.append(setSql);
values.addAll(setValues);
List whereValues = new ArrayList();
String where = "WHERE " + joinWhereAndGetValue(keyFields, "AND", whereValues, t);
// 检查key值是否有null的，不允许有null
for(Object v : whereValues) {
if(v == null) {
throw new NullKeyValueException();
}
}
values.addAll(whereValues);
// 带上postSql
if(postSql != null) {
postSql = postSql.trim();
if(!postSql.isEmpty()) {
if(postSql.startsWith("where")) {
postSql = " AND " + postSql.substring(5);
}
where = where + postSql;
}
}
sql.append(autoSetSoftDeleted(where, t.getClass()));
return sql.toString();
}
/**
* 获得批量更新sql
* @param clazz
* @param setSql
* @param whereSql
* @return
*/
public static String getUpdateAllSQL(Class clazz, String setSql, String whereSql) {
StringBuilder sql = new StringBuilder();
sql.append("UPDATE ");
Table table = DOInfoReader.getTable(clazz);
List fields = DOInfoReader.getColumns(clazz);
sql.append(getTableName(table)).append(" ");
if(setSql.trim().toLowerCase().startsWith("set ")) {
sql.append(setSql);
} else {
sql.append("SET ").append(setSql);
}
// 加上更新时间
for(Field field : fields) {
Column column = field.getAnnotation(Column.class);
if(column.setTimeWhenUpdate() && Date.class.isAssignableFrom(field.getType())) {
sql.append(",").append(getColumnName(column))
.append("=").append(getDateString(new Date()));
}
}
sql.append(autoSetSoftDeleted(whereSql, clazz));
return sql.toString();
}
/**
* 获得自定义更新的sql
* @param t
* @param values
* @param setSql
* @return
*/
public static String getCustomUpdateSQL(T t, List values, String setSql) {
StringBuilder sql = new StringBuilder();
sql.append("UPDATE ");
Table table = DOInfoReader.getTable(t.getClass());
List fields = DOInfoReader.getColumns(t.getClass());
List keyFields = DOInfoReader.getKeyColumns(t.getClass());
sql.append(getTableName(table)).append(" ");
if(setSql.trim().toLowerCase().startsWith("set ")) {
sql.append(setSql);
} else {
sql.append("SET ").append(setSql);
}
// 加上更新时间
for(Field field : fields) {
Column column = field.getAnnotation(Column.class);
if(column.setTimeWhenUpdate() && Date.class.isAssignableFrom(field.getType())) {
sql.append(",").append(getColumnName(column))
.append("=").append(getDateString(new Date()));
}
}
List whereValues = new ArrayList();
String where = "WHERE " + joinWhereAndGetValue(keyFields, "AND", whereValues, t);
for(Object value : whereValues) {
if(value == null) {
throw new NullKeyValueException();
}
}
values.addAll(whereValues);
sql.append(autoSetSoftDeleted(where, t.getClass()));
return sql.toString();
}
/**
* 获得软删除SQL
* @param t
* @param values
* @return
*/
public static String getSoftDeleteSQL(T t, Column softDeleteColumn, List values) {
String setSql = getColumnName(softDeleteColumn) + "="
+ softDeleteColumn.softDelete()[1];
return getCustomUpdateSQL(t, values, setSql);
}
/**
* 获得自定义删除SQL
* @param clazz
* @param postSql
* @return
*/
public static String getCustomDeleteSQL(Class clazz, String postSql) {
StringBuilder sql = new StringBuilder();
Table table = DOInfoReader.getTable(clazz);
sql.append("DELETE FROM ");
sql.append(getTableName(table));
sql.append(autoSetSoftDeleted(postSql, clazz));
return sql.toString();
}
public static String getCustomSoftDeleteSQL(Class clazz, String postSql) {
Table table = DOInfoReader.getTable(clazz);
List fields = DOInfoReader.getColumns(clazz);
Field softDelete = DOInfoReader.getSoftDeleteColumn(clazz);
Column softDeleteColumn = softDelete.getAnnotation(Column.class);
StringBuilder sql = new StringBuilder();
sql.append("UPDATE ").append(getTableName(table));
sql.append(" SET ").append(getColumnName(softDeleteColumn));
sql.append("=").append(softDeleteColumn.softDelete()[1]);
// 特殊处理@Column setTimeWhenUpdate时间
for(Field field : fields) {
Column column = field.getAnnotation(Column.class);
if(column.setTimeWhenUpdate() && Date.class.isAssignableFrom(field.getType())) {
sql.append(",").append(getColumnName(column)).append("='");
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
sql.append(df.format(new Date())).append("'");
}
}
sql.append(autoSetSoftDeleted(postSql, clazz));
return sql.toString();
}
/**
* 获得硬删除SQL
* @param t
* @param values
* @return
*/
public static String getDeleteSQL(T t, List values) {
Table table = DOInfoReader.getTable(t.getClass());
List keyFields = DOInfoReader.getKeyColumns(t.getClass());
StringBuilder sql = new StringBuilder();
sql.append("DELETE FROM ");
sql.append(getTableName(table));
List _values = new ArrayList();
String where = "WHERE " + joinWhereAndGetValue(keyFields, "AND", _values, t);
for(Object value : _values) { // 检查key的值是不是null
if(value == null) {
throw new NullKeyValueException();
}
}
values.addAll(_values);
sql.append(autoSetSoftDeleted(where, t.getClass()));
return sql.toString();
}
/**
* 往where sql里面插入AND关系的表达式。
*
* 例如：whereSql为 where a!=3 or a!=2 limit 1
* condExpress为 deleted=0
* 那么返回：where deleted=0 and (a!=3 or a!=2) limit 1
*
* @param whereSql 从where起的sql子句，如果有where必须带上where关键字。
* @param condExpression 例如a=? 不带where或and关键字。
* @return 注意返回字符串前面没有空格
* @throws JSQLParserException
*/
public static String insertWhereAndExpression(String whereSql, String condExpression)
throws JSQLParserException {
if(condExpression == null || condExpression.trim().isEmpty()) {
return whereSql == null ? "" : whereSql;
}
if(whereSql == null || whereSql.trim().isEmpty()) {
return "WHERE " + condExpression;
}
whereSql = whereSql.trim();
if(!whereSql.toUpperCase().startsWith("WHERE ")) {
return "WHERE " + condExpression + " " + whereSql;
}
String selectSql = "select * from dual "; // 辅助where sql解析用
Statement statement = CCJSqlParserUtil.parse(selectSql + whereSql);
Select selectStatement = (Select) statement;
PlainSelect plainSelect = (PlainSelect)selectStatement.getSelectBody();
Expression ce = CCJSqlParserUtil.parseCondExpression(condExpression);
Expression oldWhere = plainSelect.getWhere();
Expression newWhere = new FixedAndExpression(ce, oldWhere);
plainSelect.setWhere(newWhere);
return plainSelect.toString().substring(selectSql.length());
}
/**
* 自动为【最后】where sql字句加上软删除查询字段
* @param whereSql 如果有where条件的，【必须】带上where关键字；如果是group by或空的字符串或null都可以
* @param clazz 要操作的DO类
* @return 无论如何前面会加空格，更安全
*/
public static String autoSetSoftDeleted(String whereSql, Class clazz) {
if(whereSql == null) {
whereSql = "";
}
String deletedExpression = "";
// 处理join方式clazz
JoinTable joinTable = DOInfoReader.getJoinTable(clazz);
if(joinTable != null) {
Field leftTableField = DOInfoReader.getJoinLeftTable(clazz);
Field rightTableField = DOInfoReader.getJoinRightTable(clazz);
JoinLeftTable joinLeftTable = leftTableField.getAnnotation(JoinLeftTable.class);
JoinRightTable joinRightTable = rightTableField.getAnnotation(JoinRightTable.class);
Field softDeleteT1 = DOInfoReader.getSoftDeleteColumn(leftTableField.getType());
Field softDeleteT2 = DOInfoReader.getSoftDeleteColumn(rightTableField.getType());
if(softDeleteT1 == null && softDeleteT2 == null) {
return " " + whereSql; // 不处理
}
StringBuilder deletedExpressionSb = new StringBuilder();
if(softDeleteT1 != null) {
Column softDeleteColumn = softDeleteT1.getAnnotation(Column.class);
String columnName = getColumnName(softDeleteColumn);
if(joinTable.joinType() == JoinTypeEnum.RIGHT_JOIN) {
deletedExpressionSb.append("(").append(joinLeftTable.alias()).append(".").append(
columnName + "=" + softDeleteColumn.softDelete()[0])
.append(" or ").append(joinLeftTable.alias()).append(".")
.append(columnName).append(" is null)");
} else {
deletedExpressionSb.append(joinLeftTable.alias()).append(".").append(
columnName + "=" + softDeleteColumn.softDelete()[0]);
}
}
if(softDeleteT2 != null) {
if(softDeleteT1 != null) {
deletedExpressionSb.append(" AND ");
}
Column softDeleteColumn = softDeleteT2.getAnnotation(Column.class);
String columnName = getColumnName(softDeleteColumn);
if(joinTable.joinType() == JoinTypeEnum.LEFT_JOIN) {
deletedExpressionSb.append("(").append(joinRightTable.alias()).append(".").append(
columnName + "=" + softDeleteColumn.softDelete()[0])
.append(" or ").append(joinRightTable.alias()).append(".")
.append(columnName).append(" is null)");
} else {
deletedExpressionSb.append(joinRightTable.alias()).append(".").append(
columnName + "=" + softDeleteColumn.softDelete()[0]);
}
}
deletedExpression = deletedExpressionSb.toString();
} else {
Field softDelete = DOInfoReader.getSoftDeleteColumn(clazz);
if(softDelete == null) {
return " " + whereSql; // 不处理
}
Column softDeleteColumn = softDelete.getAnnotation(Column.class);
deletedExpression = getColumnName(softDeleteColumn) + "="
+ softDeleteColumn.softDelete()[0];
}
try {
return " " + SQLUtils.insertWhereAndExpression(whereSql, deletedExpression);
} catch (JSQLParserException e) {
LOGGER.error("Bad sql syntax,whereSql:{},deletedExpression:{}",
whereSql, deletedExpression, e);
throw new BadSQLSyntaxException();
}
}
/**
* 拼凑limit字句。前面有空格。
* @param offset 可以为null
* @param limit 不能为null
* @return
*/
public static String genLimitSQL(Integer offset, Integer limit) {
StringBuilder sb = new StringBuilder();
if (limit != null) {
sb.append(" limit ");
if(offset != null) {
sb.append(offset).append(",");
}
sb.append(limit);
}
return sb.toString();
}
/**
* 拼凑select的field的语句
* @param fields
* @param sep
* @return
*/
private static String join(List fields, String sep) {
return join(fields, sep, null);
}
/**
* 拼凑select的field的语句
* @param fields
* @param sep
* @param fieldPrefix
* @return
*/
private static String join(List fields, String sep, String fieldPrefix) {
return joinAndGetValueForSelect(fields, sep, fieldPrefix);
}
/**
* 拼凑where子句，并把需要的参数写入到values中。返回sql【不】包含where关键字
*
* @param fields
* @param logicOperate 操作符，例如AND
* @param values
* @param obj
* @return
*/
private static String joinWhereAndGetValue(List fields,
String logicOperate, List values, Object obj) {
StringBuilder sb = new StringBuilder();
int fieldSize = fields.size();
for(int i = 0; i < fieldSize; i++) {
Column column = fields.get(i).getAnnotation(Column.class);
sb.append(getColumnName(column)).append("=?");
if(i < fieldSize - 1) {
sb.append(" ").append(logicOperate).append(" ");
}
values.add(DOInfoReader.getValue(fields.get(i), obj));
}
return sb.toString();
}
/**
* 拼凑where子句。返回sql【不】包含where关键字
* @param fields
* @param logicOperate 操作符，例如AND
* @return
*/
private static String joinWhere(List fields, String logicOperate) {
StringBuilder sb = new StringBuilder();
int fieldSize = fields.size();
for(int i = 0; i < fieldSize; i++) {
Column column = fields.get(i).getAnnotation(Column.class);
sb.append(getColumnName(column)).append("=?");
if(i < fieldSize - 1) {
sb.append(" ").append(logicOperate).append(" ");
}
}
return sb.toString();
}
/**
* 拼凑字段逗号,分隔子句（用于insert），并把参数obj的值放到values中
* @param fields
* @param sep
* @param values
* @param obj
* @param isWithNullValue 是否把null值放到values中
* @return
*/
private static String joinAndGetValue(List fields, String sep,
List values, Object obj, boolean isWithNullValue) {
return joinAndGetValueForInsert(fields, sep, null, values, obj, isWithNullValue);
}
/**
* 拼凑字段逗号,分隔子句（用于select）。会处理computed的@Column字段
* @param fields
* @param sep
* @param fieldPrefix
* @return
*/
private static String joinAndGetValueForSelect(List fields, String sep, String fieldPrefix) {
fieldPrefix = fieldPrefix == null ? "" : fieldPrefix.trim();
StringBuilder sb = new StringBuilder();
for(Field field : fields) {
Column column = field.getAnnotation(Column.class);
String computed = column.computed().trim();
if(!computed.isEmpty()) {
sb.append("(").append(computed).append(") AS ");
} else {
sb.append(fieldPrefix); // 计算列不支持默认前缀，当join时，请自行区分计算字段的命名
}
sb.append(getColumnName(column)).append(sep);
}
int len = sb.length();
return len == 0 ? "" : sb.toString().substring(0, len - 1);
}
/**
* 拼凑字段逗号,分隔子句（用于insert），并把参数obj的值放到values中。会排除掉computed的@Column字段
*
* @param fields
* @param sep
* @param fieldPrefix
* @param values 不应该为null
* @param obj 不应该为null
* @param isWithNullValue 是否把null值放到values中
* @return
*/
private static String joinAndGetValueForInsert(List fields, String sep, String fieldPrefix,
List values, Object obj, boolean isWithNullValue) {
if(values == null || obj == null) {
throw new InvalidParameterException("joinAndGetValueForInsert require values and obj");
}
fieldPrefix = fieldPrefix == null ? "" : fieldPrefix.trim();
StringBuilder sb = new StringBuilder();
for(Field field : fields) {
Column column = field.getAnnotation(Column.class);
if(!(column.computed().trim().isEmpty())) {
continue; // insert不加入computed字段
}
Object value = DOInfoReader.getValue(field, obj);
if(isWithNullValue) {
values.add(value);
} else {
if(value == null) {
continue; // 不加入该column
} else {
values.add(value);
}
}
sb.append(fieldPrefix).append(getColumnName(column)).append(sep);
}
int len = sb.length();
return len == 0 ? "" : sb.toString().substring(0, len - 1);
}
/**
* 例如：str=?,times=3,sep=, 返回 ?,?,?
*/
private static String join(String str, int times, String sep) {
StringBuilder sb = new StringBuilder();
for(int i = 0; i < times; i++) {
sb.append(str);
if(i < times - 1) {
sb.append(sep);
}
}
return sb.toString();
}
/**
* 拼凑set子句
* @param fields
* @param values
* @param obj
* @param withNull 当为true时，如果field的值为null，也加入
* @return
*/
private static String joinSetAndGetValue(List fields,
List values, Object obj, boolean withNull) {
StringBuilder sb = new StringBuilder();
int fieldSize = fields.size();
for(int i = 0; i < fieldSize; i++) {
Column column = fields.get(i).getAnnotation(Column.class);
Object value = DOInfoReader.getValue(fields.get(i), obj);
if(withNull || value != null) {
sb.append(getColumnName(column)).append("=?,");
values.add(value);
}
}
return sb.length() == 0 ? "" : sb.substring(0, sb.length() - 1);
}
private static String getTableName(Table table) {
return "`" + table.value() + "`";
}
private static String getColumnName(Column column) {
return "`" + column.value() + "`";
}
/**
* 输出类似：'2017-05-25 11:22:33'
* @param date
* @return
*/
private static String getDateString(Date date) {
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
return "'" + df.format(date) + "'";
}
}
