All Downloads are FREE. Search and download functionalities are using the official Maven repository.
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.
pers.clare.hisql.util.SQLStoreUtil Maven / Gradle / Ivy
package pers.clare.hisql.util;
import pers.clare.hisql.exception.HiSqlException;
import pers.clare.hisql.naming.NamingStrategy;
import pers.clare.hisql.query.SQLQueryBuilder;
import pers.clare.hisql.store.FieldColumn;
import pers.clare.hisql.store.SQLCrudStore;
import pers.clare.hisql.store.SQLData;
import javax.persistence.Column;
import java.lang.reflect.Field;
import java.util.ArrayList;
import java.util.List;
public class SQLStoreUtil {
public static SQLData toInsertSQLData(SQLCrudStore sqlStore, Object entity) throws IllegalAccessException {
FieldColumn[] fieldColumns = sqlStore.getFieldColumns();
StringBuilder columnSql = new StringBuilder("insert into " + sqlStore.getTableName() + "(");
StringBuilder valueSql = new StringBuilder("values(");
List values = new ArrayList<>();
Object value;
for (FieldColumn fieldColumn : fieldColumns) {
if (fieldColumn == null || !fieldColumn.isInsertable()) continue;
value = fieldColumn.getField().get(entity);
if (value == null) {
if (fieldColumn.isAuto()) continue;
if (fieldColumn.isNotNullable()) continue;
}
columnSql.append(fieldColumn.getColumnName())
.append(',');
valueSql.append('?')
.append(',');
values.add(value);
}
valueSql.deleteCharAt(valueSql.length() - 1).append(')');
columnSql.deleteCharAt(columnSql.length() - 1)
.append(')')
.append(valueSql);
return new SQLData(columnSql.toString(), values.toArray());
}
public static SQLData toUpdateSQLData(SQLCrudStore sqlStore, Object entity) throws IllegalAccessException {
FieldColumn[] fieldColumns = sqlStore.getFieldColumns();
StringBuilder valueSql = new StringBuilder("update " + sqlStore.getTableName() + " set ");
StringBuilder whereSql = new StringBuilder(" where ");
List setValues = new ArrayList<>();
List whereValues = new ArrayList<>();
for (FieldColumn fieldColumn : fieldColumns) {
if (fieldColumn == null) continue;
Object value = fieldColumn.getField().get(entity);
if (fieldColumn.isId()) {
whereSql.append(fieldColumn.getColumnName())
.append('=')
.append('?');
whereValues.add(value);
whereSql.append(" and ");
} else {
if (!fieldColumn.isUpdatable()) continue;
if (value == null && fieldColumn.isNotNullable()) continue;
valueSql.append(fieldColumn.getColumnName())
.append('=')
.append('?')
.append(',');
setValues.add(value);
}
}
whereSql.delete(whereSql.length() - 5, whereSql.length() - 1);
valueSql.deleteCharAt(valueSql.length() - 1)
.append(whereSql);
Object[] values = new Object[setValues.size() + whereValues.size()];
int i = 0;
for (Object value : setValues) {
values[i++] = value;
}
for (Object value : whereValues) {
values[i++] = value;
}
return new SQLData(valueSql.toString(), values);
}
public static SQLQueryBuilder buildCountById(FieldColumn[] fieldColumns, String tableName) {
StringBuilder sql = new StringBuilder("select count(*) from ")
.append(tableName)
.append(" where ");
String and = " and ";
for (FieldColumn fieldColumn : fieldColumns) {
if (fieldColumn == null) continue;
if (fieldColumn.isId()) {
sql.append(fieldColumn.getColumnName())
.append('=')
.append(':')
.append(fieldColumn.getField().getName())
.append(and);
}
}
sql.delete(sql.length() - and.length(), sql.length() - 1);
return SQLQueryBuilder.create(sql.toString());
}
public static String buildSelect(FieldColumn[] fieldColumns, String tableName) {
StringBuilder sql = new StringBuilder("select ");
if (fieldColumns != null && fieldColumns.length > 0) {
for (FieldColumn column : fieldColumns) {
sql.append(column.getColumnName()).append(',');
}
sql.delete(sql.length() - 1, sql.length());
}
sql.append(" from ").append(tableName);
return sql.toString();
}
public static SQLQueryBuilder getSelectById(FieldColumn[] fieldColumns, String tableName) {
StringBuilder sql = new StringBuilder("select ");
StringBuilder columnSql = new StringBuilder();
StringBuilder whereSql = new StringBuilder(" where ");
String and = " and ";
for (FieldColumn fieldColumn : fieldColumns) {
if (fieldColumn == null) continue;
columnSql.append(fieldColumn.getColumnName()).append(',');
if (fieldColumn.isId()) {
whereSql.append(fieldColumn.getColumnName())
.append('=')
.append(':')
.append(fieldColumn.getField().getName())
.append(and);
}
}
columnSql.delete(columnSql.length() - 1, columnSql.length());
whereSql.delete(whereSql.length() - and.length(), whereSql.length());
sql.append(columnSql).append(" from ").append(tableName).append(whereSql);
return SQLQueryBuilder.create(sql.toString());
}
public static SQLQueryBuilder buildDeleteById(FieldColumn[] fieldColumns, String tableName) {
StringBuilder sql = new StringBuilder("delete from ")
.append(tableName)
.append(" where ");
String and = " and ";
for (FieldColumn fieldColumn : fieldColumns) {
if (fieldColumn == null) continue;
if (fieldColumn.isId()) {
sql.append(fieldColumn.getColumnName())
.append('=')
.append(':')
.append(fieldColumn.getField().getName())
.append(and);
}
}
sql.delete(sql.length() - and.length(), sql.length() - 1);
return SQLQueryBuilder.create(sql.toString());
}
public static String buildInsertSQL(SQLCrudStore store, T entity) {
try {
FieldColumn[] fieldColumns = store.getFieldColumns();
String tableName = store.getTableName();
StringBuilder sql = new StringBuilder();
sql.append("insert into ").append(tableName).append("(");
StringBuilder valueSql = new StringBuilder("values(");
for (FieldColumn fieldColumn : fieldColumns) {
if (fieldColumn == null || !fieldColumn.isInsertable()) continue;
Object value = fieldColumn.getField().get(entity);
if (value == null && (fieldColumn.isAuto() || fieldColumn.isNotNullable())) continue;
sql.append(fieldColumn.getColumnName()).append(',');
SQLQueryUtil.appendValue(valueSql, value);
valueSql.append(',');
}
valueSql.deleteCharAt(valueSql.length() - 1).append(')');
sql.deleteCharAt(sql.length() - 1).append(')');
return sql.append(valueSql).toString();
} catch (Exception e) {
throw new HiSqlException(e);
}
}
public static String buildUpdateSQL(SQLCrudStore store, T entity) {
try {
FieldColumn[] fieldColumns = store.getFieldColumns();
String tableName = store.getTableName();
StringBuilder sql = new StringBuilder();
sql.append("update ").append(tableName).append(" set ");
StringBuilder whereSql = new StringBuilder(" where ");
String and = " and ";
for (FieldColumn fieldColumn : fieldColumns) {
if (fieldColumn == null) continue;
if (fieldColumn.isId()) {
Object value = fieldColumn.getField().get(entity);
whereSql.append(fieldColumn.getColumnName())
.append('=');
SQLQueryUtil.appendValue(whereSql, value);
whereSql.append(and);
} else {
if (!fieldColumn.isUpdatable()) continue;
Object value = fieldColumn.getField().get(entity);
if (value == null && fieldColumn.isNotNullable()) continue;
sql.append(fieldColumn.getColumnName())
.append('=');
SQLQueryUtil.appendValue(sql, value);
sql.append(',');
}
}
whereSql.delete(whereSql.length() - and.length(), whereSql.length());
sql.deleteCharAt(sql.length() - 1);
return sql.append(whereSql).toString();
} catch (Exception e) {
throw new HiSqlException(e);
}
}
public static String getColumnName(NamingStrategy namingStrategy, Field field, Column column) {
return column == null || column.name().length() == 0 ? namingStrategy.turnCamelCase(field.getName()) : column.name();
}
}
