public String toWhereString(DataSource dataSource, WhereVO wherevo) throws Exception { StringBuffer where = new StringBuffer(""); if (first.getDataSource() != null) { where.append( first.getName() + "." + ((FieldDefVO) first.getFieldList().get(0)).getToFieldName()); } else { where.append(first.getName()); } where.append(" " + operate + " "); // System.out.println(where.toString()); if (second.getDataSource() != null) { where.append( second.getName() + "." + ((FieldDefVO) second.getFieldList().get(0)).getToFieldName()); } else { if (first.getFieldList() != null) { if (second.getName().indexOf("$F") >= 0) { where.append(second.getName()); } else { where.append(" ? "); } } else { if (second.getName().indexOf("$F") >= 0) { where.append(second.getName()); } else { where.append(new ResolveXmlService().changeType(first.getDataType(), second.getName())); } if (second.getType().equals("PARAM")) {} } } // System.out.println(where.toString()); return where.toString(); }
public String toSecondString(DataSource dataSource) throws Exception { StringBuffer where = new StringBuffer(""); String name = null; if (second.getDataSource() != null) { where.append( second.getName() + "." + ((FieldDefVO) second.getFieldList().get(0)).getToFieldName()); } else { if (first.getFieldList() != null) { name = second.getName(); if (second.getName().indexOf("$F") >= 0) { where.append(name); } else { if (second.getType().equals("VALUE")) { name = name.replaceAll("\'", "\'\'"); where.append( new ResolveXmlService() .changeValueType( ((FieldDefVO) first.getFieldList().get(0)).getToFieldType(), name)); } else { where.append( new ResolveXmlService() .changeOtherType( ((FieldDefVO) first.getFieldList().get(0)).getToFieldType(), name)); } } } else { String secondName = second.getName(); if (second.getName().indexOf("$F") >= 0) { where.append(secondName); } else { if (second.getType().equals("VALUE")) { secondName = name.replaceAll("\'", "\'\'"); where.append(new ResolveXmlService().changeValueType(first.getDataType(), secondName)); } else if (second.getType().equals("PARAM")) { where.append("?"); } else { where.append(new ResolveXmlService().changeOtherType(first.getDataType(), secondName)); } } } } return where.toString(); }
public String toWhereString(DataSource dataSource) throws Exception { StringBuffer where = new StringBuffer(""); if (first.getDataSource() != null) { where.append( first.getName() + "." + ((FieldDefVO) first.getFieldList().get(0)).getToFieldName()); } else { where.append(first.getName()); } where.append(" " + operate + " "); // System.out.println(where.toString()); if (second.getDataSource() != null) { where.append( second.getName() + "." + ((FieldDefVO) second.getFieldList().get(0)).getToFieldName()); } else { if (first.getFieldList() != null) { if (second.getName().indexOf("$P") >= 0) { // where.append(second.getName()); where.append(" ? "); } else { if ("LIKE".equals(operate)) { String temp = new ResolveXmlService() .changeType( ((FieldDefVO) first.getFieldList().get(0)).getToFieldType(), second.getName()); temp = temp.substring(1, temp.length() - 1); temp = "'%" + temp + "%'"; where.append(temp); } else { where.append( new ResolveXmlService() .changeType( ((FieldDefVO) first.getFieldList().get(0)).getToFieldType(), second.getName())); } } } else { if (second.getName().indexOf("$P") >= 0) { // where.append(second.getName()); where.append(" ? "); } else { where.append(new ResolveXmlService().changeType(first.getDataType(), second.getName())); } } } // System.out.println(where.toString()); return where.toString(); }
public String toWhereStoreString(DataSource dataSource) throws Exception { StringBuffer where = new StringBuffer(""); if (first.getDataSource() != null) { where.append( first.getName() + "." + ((FieldDefVO) first.getFieldList().get(0)).getToFieldName()); } else { // String firstName = new // Formula().formulaParsre(dataSource.getType() + "#"+ // dataSource.getDataType(), 0,first.getName()); // firstName = new FormulaParser().deleteFirstDot(firstName); // where.append(firstName); } where.append(" " + operate + " "); if (second.getDataSource() != null) { where.append( second.getName() + "." + ((FieldDefVO) second.getFieldList().get(0)).getToFieldName()); } else { if (first.getFieldList() != null) { // String name = new // Formula().formulaParsre(dataSource.getType() + "#"+ // dataSource.getDataType(), 0,second.getName()); // name = new FormulaParser().deleteFirstDot(name); where.append( new ResolveXmlService() .changeType( ((FieldDefVO) first.getFieldList().get(0)).getToFieldType(), second.getName())); } else { // String secondName = new // Formula().formulaParsre(dataSource.getType() + "#" + // dataSource.getDataType(), 0,second.getName()); // secondName = new FormulaParser().deleteFirstDot(secondName); where.append(new ResolveXmlService().changeType(first.getDataType(), second.getName())); } } return where.toString(); }