本文整理汇总了Java中com.alibaba.druid.sql.SQLUtils.toSQLExpr方法的典型用法代码示例。如果您正苦于以下问题:Java SQLUtils.toSQLExpr方法的具体用法?Java SQLUtils.toSQLExpr怎么用?Java SQLUtils.toSQLExpr使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类com.alibaba.druid.sql.SQLUtils
的用法示例。
在下文中一共展示了SQLUtils.toSQLExpr方法的13个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: addTableMapping
import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
public void addTableMapping(String srcTable, String destTable) {
if (tableMapping == null) {
tableMapping = new HashMap<String, String>();
}
if (srcTable.indexOf('.') >= 0) {
SQLExpr expr = SQLUtils.toSQLExpr(srcTable, dbType);
if (expr instanceof SQLPropertyExpr) {
srcTable = ((SQLPropertyExpr) expr).simplify().toString();
}
} else {
srcTable = SQLUtils.normalize(srcTable);
}
tableMapping.put(srcTable, destTable);
}
示例2: selectWithAlias
import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
@Override
public SQLSelectBuilderImpl selectWithAlias(String column, String alias) {
SQLSelectQueryBlock queryBlock = getQueryBlock();
SQLExpr columnExpr = SQLUtils.toSQLExpr(column, dbType);
SQLSelectItem selectItem = new SQLSelectItem(columnExpr, alias);
queryBlock.addSelectItem(selectItem);
return this;
}
示例3: having
import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
@Override
public SQLSelectBuilderImpl having(String expr) {
SQLSelectQueryBlock queryBlock = getQueryBlock();
SQLSelectGroupByClause groupBy = queryBlock.getGroupBy();
if (groupBy == null) {
groupBy = createGroupBy();
queryBlock.setGroupBy(groupBy);
}
SQLExpr exprObj = SQLUtils.toSQLExpr(expr, dbType);
groupBy.setHaving(exprObj);
return this;
}
示例4: into
import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
@Override
public SQLSelectBuilderImpl into(String expr) {
SQLSelectQueryBlock queryBlock = getQueryBlock();
SQLExpr exprObj = SQLUtils.toSQLExpr(expr, dbType);
queryBlock.setInto(exprObj);
return this;
}
示例5: where
import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
@Override
public SQLSelectBuilderImpl where(String expr) {
SQLSelectQueryBlock queryBlock = getQueryBlock();
SQLExpr exprObj = SQLUtils.toSQLExpr(expr, dbType);
queryBlock.setWhere(exprObj);
return this;
}
示例6: whereOr
import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
@Override
public SQLSelectBuilderImpl whereOr(String expr) {
SQLSelectQueryBlock queryBlock = getQueryBlock();
SQLExpr exprObj = SQLUtils.toSQLExpr(expr, dbType);
SQLExpr newCondition = SQLUtils.buildCondition(SQLBinaryOperator.BooleanOr, exprObj, false,
queryBlock.getWhere());
queryBlock.setWhere(newCondition);
return this;
}
示例7: where
import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
@Override
public SQLUpdateBuilderImpl where(String expr) {
SQLUpdateStatement update = getSQLUpdateStatement();
SQLExpr exprObj = SQLUtils.toSQLExpr(expr, dbType);
update.setWhere(exprObj);
return this;
}
示例8: whereAnd
import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
@Override
public SQLUpdateBuilderImpl whereAnd(String expr) {
SQLUpdateStatement update = getSQLUpdateStatement();
SQLExpr exprObj = SQLUtils.toSQLExpr(expr, dbType);
SQLExpr newCondition = SQLUtils.buildCondition(SQLBinaryOperator.BooleanAnd, exprObj, false, update.getWhere());
update.setWhere(newCondition);
return this;
}
示例9: whereOr
import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
@Override
public SQLUpdateBuilderImpl whereOr(String expr) {
SQLUpdateStatement update = getSQLUpdateStatement();
SQLExpr exprObj = SQLUtils.toSQLExpr(expr, dbType);
SQLExpr newCondition = SQLUtils.buildCondition(SQLBinaryOperator.BooleanOr, exprObj, false, update.getWhere());
update.setWhere(newCondition);
return this;
}
示例10: setValue
import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
public SQLUpdateBuilderImpl setValue(String column, Object value) {
SQLUpdateStatement update = getSQLUpdateStatement();
SQLExpr columnExpr = SQLUtils.toSQLExpr(column, dbType);
SQLExpr valueExpr = toSQLExpr(value, dbType);
SQLUpdateSetItem item = new SQLUpdateSetItem();
item.setColumn(columnExpr);
item.setValue(valueExpr);
update.addItem(item);
return this;
}
示例11: where
import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
@Override
public SQLDeleteBuilder where(String expr) {
SQLDeleteStatement delete = getSQLDeleteStatement();
SQLExpr exprObj = SQLUtils.toSQLExpr(expr, dbType);
delete.setWhere(exprObj);
return this;
}
示例12: whereAnd
import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
@Override
public SQLDeleteBuilder whereAnd(String expr) {
SQLDeleteStatement delete = getSQLDeleteStatement();
SQLExpr exprObj = SQLUtils.toSQLExpr(expr, dbType);
SQLExpr newCondition = SQLUtils.buildCondition(SQLBinaryOperator.BooleanAnd, exprObj, false, delete.getWhere());
delete.setWhere(newCondition);
return this;
}
示例13: whereOr
import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
@Override
public SQLDeleteBuilder whereOr(String expr) {
SQLDeleteStatement delete = getSQLDeleteStatement();
SQLExpr exprObj = SQLUtils.toSQLExpr(expr, dbType);
SQLExpr newCondition = SQLUtils.buildCondition(SQLBinaryOperator.BooleanOr, exprObj, false, delete.getWhere());
delete.setWhere(newCondition);
return this;
}