Package org.fto.jthink.lang

Examples of org.fto.jthink.lang.ObjectBuffered

65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
    }
    if(rowLen<0){
      throw new JThinkRuntimeException("rowLen不能小于0!");
    }

    ObjectBuffered values = null;   

    StringBuffered sqlStr = new StringBuffered(16)
      .append("SELECT ");

    /* 生成DISTINCT串 */
    if (distinct) {
      sqlStr.append(" DISTINCT ");
    }
   
    /* 生成TOP串 */
    if (rowLen != -1) {
      sqlStr.append(" TOP ").append((startIndex + rowLen)).append(" ");
    }
   
    /* 生成返回列的串 */
    if (columns != null && columns.length != 0) {
      SQL columnSQL = constructSelectedColumn(columns);
      sqlStr.append(columnSQL.getSQLStatement());
      values = columnSQL.getValueBuffered();
    }else{
      sqlStr.append("*");
    }

    /* 生成FROM子串, 如果tableName为空,将不构建FROM子句 */
    if (tableName != null && tableName.length() != 0) {
      sqlStr.append(" FROM ").append(tableName);
    }
   
    /* 生成查询条件串 */
    if (condition != null && condition.size() != 0) {
      sqlStr.append(" WHERE ").append(condition.getConditionStatement());
      if(values==null){
        values = condition.getValueBuffered();
      }else{
        values.append(condition.getValueBuffered());
      }
    }
   
    /* 生成GROUP BY串 */
    if (groupby != null && groupby.length() != 0) {
View Full Code Here
141
142
143
144
145
146
147
148
149
150
151
   * @return 描述此列的SQL语句
   *
   */
  public SQL getColumn(){
    StringBuffered column=null;
    ObjectBuffered values=null;
    if(columnValue instanceof java.lang.String){
      if(columnName==columnValue){
        return new SQL(SQL.UNDEFINED, columnName, null);
      }else{
        column = new StringBuffered(4).append("(").append(columnValue).append(") AS ").append(columnName);
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
          "The value of an columns cannot be empty.");
    }
    int size = columns.size();
    StringBuffered names = new StringBuffered(size*2);
    StringBuffered valueStatement = new StringBuffered(size);
    ObjectBuffered values  = new ObjectBuffered(size);
    Iterator columnsIT = columns.entrySet().iterator();
   
    for(int i=0;i<size;i++){
    //while(columnsIT.hasNext()){
      Map.Entry column = (Map.Entry)columnsIT.next();
      Object value = column.getValue();
      if(value!=null){
        if(values.size()==0){
          names.append(column.getKey());
          valueStatement.append("?");
        }else{
          names.append(",").append(column.getKey());
          valueStatement.append(",?");
        }
        values.append(value);
      };     
    }
    StringBuffered sql = new StringBuffered(5+names.size()+valueStatement.size())
      .append("INSERT INTO ")
      .append(tableName)
View Full Code Here
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
      throw new IllegalArgumentException(
          "The value of an columns cannot be empty.");
    }
    int columnsCapacity = columns.size();

    ObjectBuffered values  = new ObjectBuffered(columnsCapacity+1);
    StringBuffered sql = new StringBuffered(columnsCapacity+columnsCapacity+columnsCapacity+4)
    .append("UPDATE ")
    .append(tableName)
    .append(" SET ");

    /* 处理被更新的字段 */
    Iterator columnsIT = columns.entrySet().iterator();
    //while(columnsIT.hasNext()){
    for(int i=0;i<columnsCapacity;i++){
      Map.Entry column = (Map.Entry)columnsIT.next();
      Object value = column.getValue();
      int valuesSize = values.size();
      if(value==null){
        sql.append(valuesSize>0?",":"").append(column.getKey()).append("=NULL");
      }else{
        sql.append(valuesSize>0?",":"").append(column.getKey()).append("=?");
        values.append(value);
      }
    }
    /* 处理条件 */
    if(condition!=null && condition.size()!=0){
      sql.append(" WHERE ").append(condition.getConditionStatement());
      values.append(condition.getValueBuffered());
    }
    return new SQL(SQL.UPDATE, sql, values);
  } 
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
//      conditionStatementSize = conditionStatement.size();
//    }
   
    StringBuffered sqlStr = new StringBuffered(17)
      .append("SELECT ");
    ObjectBuffered values = null;//new ObjectBuffered();
   
    /* 生成DISTINCT串 */
    if (distinct) {
      sqlStr.append(" DISTINCT ");
    }
   
    /* 生成返回列的串 */
    if (columns != null && columns.length != 0) {
      SQL columnSQL = constructSelectedColumn(columns);
      sqlStr.append(columnSQL.getSQLStatement());
      values = columnSQL.getValueBuffered();
    }else{
      sqlStr.append("*");
    }

    /* 生成FROM子串, 如果tableName为空,将不构建FROM子句 */
    if (tableName != null && tableName.length() != 0) {
      sqlStr.append(" FROM ").append(tableName);
    }
   
    /* 生成查询条件串 */
    if (condition != null && condition.size() != 0) {
      sqlStr.append(" WHERE ").append(condition.getConditionStatement());
      if(values==null){
        values = condition.getValueBuffered();
      }else{
        values.append(condition.getValueBuffered());
      }
    }
   
    /* 生成GROUP BY串 */
    if (groupby != null && groupby.length() != 0) {
View Full Code Here
690
691
692
693
694
695
696
697
698
699
700
701
702
703
      case SQL.SELECT_SP:
        startIndex = sql.getRowStartIndex();
        length = sql.getRowLength();
        if(startIndex>=0 && length>=0){
          //List values = Arrays.asList(sql.getValues());
          ObjectBuffered values = sql.getValueBuffered();
          values.append(new Integer(startIndex));
          values.append(new Integer(length));
          return executeStoredProcedure(sql.getSQLString(), values.toArray(), doClazz);
        }else{
          return executeStoredProcedure(sql.getSQLString(), sql.getValues(), doClazz);
        }
      case SQL.UNDEFINED_SP:
        return executeStoredProcedure(sql.getSQLString(), sql.getValues(), doClazz);
View Full Code Here
210
211
212
213
214
215
216
217
218
219
220
          "The name of an table cannot be null.");
    }
    StringBuffered sqlstr = new StringBuffered(4)
      .append("DELETE FROM ")
      .append(tableName);
    ObjectBuffered values = null;
    if (condition != null && condition.size()>0) {
      sqlstr.append(" WHERE ").append(condition.getConditionStatement());
      values = condition.getValueBuffered();
    }
    return new SQL(SQL.UPDATE, sqlstr, values);
View Full Code Here
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
          "The name of an table cannot be null.");
    }
   
    StringBuffered sqlStr = new StringBuffered(11)
    .append("SELECT ");
    ObjectBuffered values = null;

    /* 生成DISTINCT串 */
    if (distinct) {
      sqlStr.append(" DISTINCT ");
    }
    /* 生成返回列的串 */
    if (columns != null && columns.length != 0) {
      SQL columnSQL = constructSelectedColumn(columns);
      sqlStr.append(columnSQL.getSQLStatement());
      values = columnSQL.getValueBuffered();
    }else{
      sqlStr.append("*");
    }
   
    /* 生成FROM子串, 如果tableName为空,将不构建FROM子句 */
    if (tableName != null && tableName.length() != 0) {
      sqlStr.append(" FROM ").append(tableName);
    }
   
    /* 生成查询条件串 */
    if (condition != null && condition.size() != 0) {
      sqlStr.append(" WHERE ")
            .append(condition.getConditionStatement());
      if(values==null){
        values = condition.getValueBuffered();
      }else{
        values.append(condition.getValueBuffered());
      }
    }
    /* 生成GROUP BY串 */
    if (groupby != null && groupby.length() != 0) {
      sqlStr.append(" GROUP BY ").append(groupby);
View Full Code Here
376
377
378
379
380
381
382
383
384
385
386
      String tableName, String fieldName, String attrName,Condition condition) {
    fieldName = fieldName==null?"*":fieldName;

    StringBuffered sqlstr = new StringBuffered(8)
      .append("SELECT COUNT(").append(fieldName).append(") AS ").append(attrName).append(" FROM ").append(tableName);
    ObjectBuffered values = null;
    if (condition != null && condition.size() != 0) {
      sqlstr.append(" WHERE ").append(condition.getConditionStatement());
      values = condition.getValueBuffered();
    }
    return new SQL(SQL.SELECT, sqlstr, values);
View Full Code Here
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
   * @return  描述列的SQL子语句
   */
  protected SQL constructSelectedColumn(Column[] columns){
    int len = columns.length;
    StringBuffered columnsStr = new StringBuffered(len);
    ObjectBuffered valuesLT = new ObjectBuffered(len+1);
    for(int i=0;i<len;i++){
      Column column = columns[i];
      columnsStr.append(i==0?"":",");
      if(column.isSimpleColumn()){
        columnsStr.append(column.getColumnName());
      }else{
        SQL columnSQL = column.getColumn();
        if(columnSQL.isStringBufferedType()){
          columnsStr.append(columnSQL.getSQLStatement());
        }else{
          columnsStr.append(columnSQL.getSQLString());
        }
       
        ObjectBuffered values = columnSQL.getValueBuffered();
        if(values!=null){
          valuesLT.append(values);
        }
      }
    }
View Full Code Here
TOP

Related Classes of org.fto.jthink.lang.ObjectBuffered

  • org.fto.jthink.jdbc.Column
  • org.fto.jthink.jdbc.Condition
  • org.fto.jthink.jdbc.hsql.HsqlSQLBuilder
  • org.fto.jthink.jdbc.mssql.MssqlSQLBuilder
  • org.fto.jthink.jdbc.mysql.MysqlSQLBuilder
  • org.fto.jthink.jdbc.SQL
  • org.fto.jthink.jdbc.SQLBuilder
  • org.fto.jthink.jdbc.SQLExecutor
    • 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.