/** * Gets the parameter clause. * * @param introspectedColumn * the introspected column * @return the parameter clause */ public static String getParameterClause( IntrospectedColumn introspectedColumn) { return getParameterClause(introspectedColumn, null); }
public static String getParameterClause( IntrospectedColumn introspectedColumn) { return getParameterClause(introspectedColumn, null); }
public static String getParameterClause(IntrospectedColumn introspectedColumn) { return getParameterClause(introspectedColumn, null); }
public static String getParameterClause( IntrospectedColumn introspectedColumn) { return getParameterClause(introspectedColumn, null); }
protected void checkAndReplaceInput(List<IntrospectedColumn> columns, TextElement te) { String sql = te.getContent(); for(IntrospectedColumn column : columns){ if(column.getFullyQualifiedJavaType().getShortName().equals("Geometry")){ String paramStr = MyBatis3FormattingUtilities.getParameterClause(column); sql = StringUtils.replace(sql, paramStr, "ST_GeomFromText(" + paramStr + ","+srid+")"); //replace no prefix geo relate column paramStr = MyBatis3FormattingUtilities.getParameterClause(column, "record."); sql = StringUtils.replace(sql, paramStr, "ST_GeomFromText(" + paramStr + ","+srid+")"); //replace mbg generate prefix geo relate column paramStr = MyBatis3FormattingUtilities.getParameterClause(column, "item."); sql = StringUtils.replace(sql, paramStr, "ST_GeomFromText(" + paramStr + ","+srid+")"); //replace mbg batch plugin generate prefix geo relate column // System.out.println(); // System.out.println(sql); } } try { FieldUtils.writeDeclaredField(te, "content", sql, true); } catch (IllegalAccessException e) { e.printStackTrace(); } }
protected void generateParameterForSet(String fieldPrefix, boolean ifNullCheck, List<IntrospectedColumn> columns, XmlElement dynamicElement) { XmlElement trimElement = new XmlElement("trim"); trimElement.addAttribute(new Attribute("suffixOverrides", ",")); StringBuilder sb = new StringBuilder(); for (IntrospectedColumn introspectedColumn : columns) { sb.setLength(0); sb.append(MyBatis3FormattingUtilities.getAliasedEscapedColumnName(introspectedColumn)); sb.append(" = "); sb.append(MyBatis3FormattingUtilities.getParameterClause(introspectedColumn, fieldPrefix)); sb.append(','); doIfNullCheck(fieldPrefix, ifNullCheck, trimElement, sb, introspectedColumn); } dynamicElement.addElement(trimElement); }
protected void generateWhereConditions(String fieldPrefix, String columnPrefix, boolean ifNullCheck, List<IntrospectedColumn> columns, XmlElement parent) { XmlElement trimElement = new XmlElement("trim"); trimElement.addAttribute(new Attribute("suffixOverrides", ",")); StringBuilder sb = new StringBuilder(); for (IntrospectedColumn introspectedColumn : columns) { sb.setLength(0); sb.append((columnPrefix == null ? "" : columnPrefix) + MyBatis3FormattingUtilities.getAliasedEscapedColumnName(introspectedColumn)); sb.append(" = "); sb.append(MyBatis3FormattingUtilities.getParameterClause(introspectedColumn, fieldPrefix)); sb.append(","); doIfNullCheck(fieldPrefix, ifNullCheck, trimElement, sb, introspectedColumn); } XmlElement where = new XmlElement("where"); where.addElement(trimElement); parent.addElement(where); }
getEscapedColumnName(introspectedColumn))); sb.append(" = "); //$NON-NLS-1$ sb.append(getParameterClause(introspectedColumn)); sb.append('\"'); if (iter.hasNext()) {
getEscapedColumnName(introspectedColumn))); sb.append(" = "); //$NON-NLS-1$ sb.append(getParameterClause(introspectedColumn)); sb.append('\"'); if (iter.hasNext()) {
sb.append(getParameterClause(introspectedColumn)); sb.append('\"'); if (iter.hasNext()) {
getEscapedColumnName(introspectedColumn))); sb.append(" = "); //$NON-NLS-1$ sb.append(getParameterClause(introspectedColumn)); sb.append('\"'); if (iter.hasNext()) {
protected void generateParametersSeparateByComma(String fieldPrefix, boolean ifNullCheck, boolean withParenthesis, List<IntrospectedColumn> columns, XmlElement parent) { XmlElement trimElement = new XmlElement("trim"); trimElement.addAttribute(new Attribute("suffixOverrides", ",")); if (withParenthesis) { trimElement.addAttribute(new Attribute("prefix", "(")); trimElement.addAttribute(new Attribute("suffix", ")")); } StringBuilder sb = new StringBuilder(); for (IntrospectedColumn introspectedColumn : columns) { sb.setLength(0); sb.append(MyBatis3FormattingUtilities.getParameterClause(introspectedColumn, fieldPrefix)); sb.append(","); doIfNullCheck(fieldPrefix, ifNullCheck, trimElement, sb, introspectedColumn); } parent.addElement(trimElement); }
sb.append(MyBatis3FormattingUtilities.getParameterClause(introspectedColumn, "record.")); //$NON-NLS-1$
sb.append(MyBatis3FormattingUtilities.getParameterClause(introspectedColumn, "record.")); //$NON-NLS-1$
.getAliasedEscapedColumnName(introspectedColumn)); sb.append(" = "); //$NON-NLS-1$ sb.append(MyBatis3FormattingUtilities.getParameterClause( introspectedColumn, "record.")); //$NON-NLS-1$
sb.append(MyBatis3FormattingUtilities.getAliasedEscapedColumnName(introspectedColumn)); sb.append(" = "); sb.append(MyBatis3FormattingUtilities.getParameterClause(introspectedColumn, PROPERTY_PREFIX));
sb.append(MyBatis3FormattingUtilities.getAliasedEscapedColumnName(introspectedColumn)); sb.append(" = "); //$NON-NLS-1$ sb.append(MyBatis3FormattingUtilities.getParameterClause(introspectedColumn, "record.")); //$NON-NLS-1$ sb.append(',');
.getAliasedEscapedColumnName(introspectedColumn)); sb.append(" = "); //$NON-NLS-1$ sb.append(MyBatis3FormattingUtilities.getParameterClause( introspectedColumn, "record.")); //$NON-NLS-1$ sb.append(',');
.getAliasedEscapedColumnName(introspectedColumn)); sb.append(" = "); //$NON-NLS-1$ sb.append(MyBatis3FormattingUtilities.getParameterClause( introspectedColumn, "record.")); //$NON-NLS-1$ sb.append(',');
sb.append(getParameterClause(introspectedColumn)); sb.insert(2, "record."); //$NON-NLS-1$