Examples of SqlCol


Examples of com.exedosoft.plat.gene.jquery.SqlCol

      log.info("正在处理业务对象:" + table);
      log.info("正在产生业务属性添加语句。。。。。");
      int i = 1;
      for (Iterator itCol = this.getCols(table).iterator(); itCol
          .hasNext();) {
        SqlCol sqlCol = (SqlCol) itCol.next();
        if (!isModify(sqlCol.getName(), boUid)) { // ///没有被修改过的字段才可以被覆盖
          StringBuffer buffer = new StringBuffer();
          buffer
              .append(
                  "insert into DO_BO_Property(objuid,boUid,col_name,prop_name,l10n,dbType,isNull,isModify,order_num,dbSize,readonly) values(")
              .append("'").append(
                  UUIDHex.getInstance().generate()).append(
                  "',") // //viewUID
              .append("'").append(boUid).append("',") // /colname
              .append("'").append(sqlCol.getName()).append("',") // /colname
              .append("'").append(sqlCol.getName()).append("',") // /propname
              .append("'").append(sqlCol.getName()).append("',") // /l10n
              .append(sqlCol.getDataType()).append(","); // /datatype

          if (sqlCol.isAllowedNull()) {
            buffer.append("'1'");
          } else {
            buffer.append("'0'");
          } // /////////////////////////////isNull
          buffer.append(",").append("'0'"); // ///isModify,指修改状态,现在是未修改,是由系统生成的
          buffer.append(",").append(i * 5); // ///order numbber
          buffer.append(",").append(sqlCol.getSize()); // ///readonly
          buffer.append(",").append("'0'"); // ///readonly
          buffer.append(")");
          log.info(buffer);
          stmt.addBatch(buffer.toString());
        }
View Full Code Here

Examples of com.exedosoft.plat.gene.jquery.SqlCol

        schema = dds.getUserName().trim().toUpperCase();
      }
      ResultSet rs = meta.getColumns(null, schema, aTable, null);

      while (rs.next()) {
        SqlCol qc = new SqlCol();
        qc.setName(rs.getString("COLUMN_NAME").toLowerCase());
        qc.setDataType(rs.getInt("DATA_TYPE"));
        qc.setScale(rs.getInt("DECIMAL_DIGITS"));
        qc.setNullable(rs.getString("IS_NULLABLE"));
        qc.setSize(rs.getInt("COLUMN_SIZE"));
        cc.add(qc);
      }
    } catch (SQLException ex) {
      ex.printStackTrace();
    } finally {
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.