Package cn.org.rapid_framework.jdbc.sqlgenerator.metadata

Examples of cn.org.rapid_framework.jdbc.sqlgenerator.metadata.Column

51
52
53
54
55
56
57
58
59
60
61
62
63
    StringBuilder sb = new StringBuilder("INSERT INTO ").append(getTableName()).append(" (");
   
    List<String> insertColumns = new ArrayList(getColumns().size());
    List<String> insertPlaceholderColumns = new ArrayList(getColumns().size());
    for(int i = 0; i < getColumns().size(); i++) {
      Column c = getColumns().get(i);
      if(c.isInsertable()) {
        insertColumns.add(c.getSqlName());
        insertPlaceholderColumns.add(getColumnPlaceholder(c));
      }
    }
   
    sb.append(StringUtils.join(insertColumns.iterator(), ","));
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
106
   
    sb.append(StringUtils.join(getUpdateColumns().iterator(), ","));
    sb.append(" WHERE ");

    for(int i = 0; i < getPrimaryKeyColumns().size(); i++) {
      Column c = getPrimaryKeyColumns().get(i);
      sb.append(c.getSqlName()+" = "+getColumnPlaceholder(c));
      if(i < getPrimaryKeyColumns().size() - 1)
        sb.append(" AND ");
    }
    return sb.toString();
  }
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
118
  private List getUpdateColumns() {
    List<Column> columns = getColumns();
    List updateColumns = new ArrayList(columns.size());
    for(int i = 0; i < columns.size(); i++) {
      Column c = columns.get(i);
      if(c.isUpdatable() && !c.isPrimaryKey()) {
        updateColumns.add(c.getSqlName() + " = "+getColumnPlaceholder(c));
      }
    }
    return updateColumns;
  }
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
133
    sb.append(" WHERE ");

    List<Column> primaryKeyColumns = getPrimaryKeyColumns();
    for(int i = 0; i < primaryKeyColumns.size(); i++) {
      Column c = primaryKeyColumns.get(i);
      sb.append(c.getSqlName()+" = "+getColumnPlaceholder(c));
      if(i < primaryKeyColumns.size() - 1)
        sb.append(" AND ");
    }
    return sb.toString();
  }
View Full Code Here
146
147
148
149
150
151
152
153
154
155
156
157
  public String getSelectByMultiPkSql() {
    StringBuilder sb = new StringBuilder("SELECT "+getColumnsSql()+" FROM " + getTableName()+" WHERE ");
    List<Column> primaryKeyColumns = getPrimaryKeyColumns();
    for(int i = 0; i < primaryKeyColumns.size(); i++) {
      Column c = primaryKeyColumns.get(i);
      sb.append(c.getSqlName()+" = "+getColumnPlaceholder(c));
      if(i < primaryKeyColumns.size() - 1)
        sb.append(" AND ");
    }
    return sb.toString();
  }
View Full Code Here
171
172
173
174
175
176
177
178
179
180
181
182
  public String getColumnsSql(String columnPrefix) {
    String realPrefix = StringUtils.isEmpty(columnPrefix) ? "" : columnPrefix+".";
    StringBuilder sb = new StringBuilder();
    for(int i = 0; i < getColumns().size(); i++) {
      Column c = getColumns().get(i);
      sb.append(realPrefix+c.getSqlName()+" " + c.getPropertyName());
      if(i < getColumns().size() - 1)
        sb.append(",");
    }
    return sb.toString();
  }
View Full Code Here
184
185
186
187
188
189
190
191
  protected String getColumnPlaceholder(Column c) {
    return ":"+c.getPropertyName();
  }

  protected String getSinglePrimaryKeyWhere() {
    Column c = getPrimaryKeyColumns().get(0);
    return c.getSqlName()+" = ?";
  }
View Full Code Here
TOP

Related Classes of cn.org.rapid_framework.jdbc.sqlgenerator.metadata.Column

  • cn.org.rapid_framework.jdbc.sqlgenerator.SpringNamedSqlGenerator
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.