Examples of Sql

Examples of org.fto.jthink.jdbc.SQL

77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
          //System.out.println("time:"+(NumberHelper.formatNumber(usetime, NumberHelper.NUMBER_I_6_0)));
      }
      System.out.println("constructSQLForInsert测试 次数："+count+", 总用时："+NumberHelper.formatNumber(totalUseTime, NumberHelper.NUMBER_I_6_0)+", 平均用时（毫秒）:"+NumberHelper.formatNumber((totalUseTime/count), NumberHelper.NUMBER_I_6_0));
    }

    SQL sqlStatement = sqlBuilder.constructSQLForInsert("departments", columns);
    System.out.println(sqlStatement.getSQLString());
    if(!"INSERT INTO departments (F1,DeptName,DeptId,F3,F2) VALUES (?,?,?,?,?) ".equals(sqlStatement.getSQLString())){
      super.fail();
    }
    printObjects(sqlStatement.getValues());
   
    DataObject data = new DefaultDataObject();
    data.setTableName("departments");
    data.set("DeptId", "1");
    sqlStatement = sqlBuilder.constructSQLForInsert(data);
    System.out.println(sqlStatement.getSQLString());
    printObjects(sqlStatement.getValues());
   
    //List a;
    //a.addAll(c)
  }
View Full Code Here

Examples of org.g4studio.core.orm.xibatis.sqlmap.engine.mapping.sql.Sql

57
58
59
60
61
62
63
64
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
    statementScope.getSession().setCommitRequired(true);

    try {
      parameterObject = validateParameter(parameterObject);

      Sql sql = getSql();

      errorContext.setMoreInfo("Check the parameter map.");
      ParameterMap parameterMap = sql.getParameterMap(statementScope, parameterObject);

      errorContext.setMoreInfo("Check the result map.");
      ResultMap resultMap = sql.getResultMap(statementScope, parameterObject);

      statementScope.setResultMap(resultMap);
      statementScope.setParameterMap(parameterMap);

      int rows = 0;

      errorContext.setMoreInfo("Check the parameter map.");
      Object[] parameters = parameterMap.getParameterObjectValues(statementScope, parameterObject);

      errorContext.setMoreInfo("Check the SQL statement.");
      String sqlString = sql.getSql(statementScope, parameterObject);

      errorContext.setActivity("executing mapped statement");
      errorContext.setMoreInfo("Check the statement or the result map.");
      rows = sqlExecuteUpdate(statementScope, trans.getConnection(), sqlString, parameters);

      errorContext.setMoreInfo("Check the output parameters.");
      if (parameterObject != null) {
        postProcessParameterObject(statementScope, parameterObject, parameters);
      }

      errorContext.reset();
      sql.cleanup(statementScope);
      notifyListeners();
      return rows;
    } catch (SQLException e) {
      errorContext.setCause(e);
      throw new NestedSQLException(errorContext.toString(), e.getSQLState(), e.getErrorCode(), e);
View Full Code Here

Examples of org.jeecgframework.minidao.annotation.Sql

434
435
436
437
438
439
440
441
442
443
444
445
446
447
     
    }
   
    //[2].获取方法的SQL标签
    if(method.isAnnotationPresent(Sql.class)){
      Sql sql = method.getAnnotation(Sql.class);
      //如果用户采用自定义标签SQL，则SQL文件无效
      if(StringUtils.isNotEmpty(sql.value())){
        templateSql = sql.value();
      }
            logger.debug("@Sql------------------------------------------"+sql.value()); 
    }
    return templateSql;
  }
View Full Code Here

Examples of org.nutz.dao.sql.Sql

36
37
38
39
40
41
42
43
  }

  @Test
  public void check_Create_SQL() {
    SqlManager sqls = createSqls();
    Sql sql = sqls.create(".abc.create");
    assertTrue(sql.toString().toUpperCase().startsWith("CREATE"));
  }
View Full Code Here

Examples of org.nutz.dao.sql.Sql

43
44
45
46
47
48
49
50
  }

  @Test
  public void check_Insert_SQL() {
    SqlManager sqls = createSqls();
    Sql sql = sqls.create(".abc.insert");
    assertTrue(sql.toString().toUpperCase().startsWith("INSERT"));
  }
View Full Code Here

Examples of org.nutz.dao.sql.Sql

50
51
52
53
54
55
56
57
  }

  @Test
  public void check_Update_SQL() {
    SqlManager sqls = createSqls();
    Sql sql = sqls.create(".abc.update");
    assertTrue(sql.toString().toUpperCase().startsWith("UPDATE"));
  }
View Full Code Here

Examples of org.nutz.dao.sql.Sql

57
58
59
60
61
62
63
64
  }

  @Test
  public void check_Fetch_SQL() {
    SqlManager sqls = createSqls();
    Sql sql = sqls.create("abc.fetch");
    assertTrue(sql.toString().toUpperCase().startsWith("SELECT"));
  }
View Full Code Here

Examples of railo.runtime.db.SQL

144
145
146
147
148
149
150
151
152
153
154
155
156
      comment.append( " (showing top " ).append( Caster.toString( top ) ).append( ")" );
    comment.append("\n");
    comment.append("Cached: ").append(query.isCached()?"Yes\n":"No\n");
    comment.append("Lazy: ").append(query instanceof SimpleQuery?"Yes\n":"No\n");
   
    SQL sql=query.getSql();
    if(sql!=null)
      comment.append("SQL: ").append("\n").append(StringUtil.suppressWhiteSpace(sql.toString().trim())).append("\n");
   
    //table.appendRow(1, new SimpleDumpData("Execution Time (ms)"), new SimpleDumpData(exeTime));
    //table.appendRow(1, new SimpleDumpData("recordcount"), new SimpleDumpData(getRecordcount()));
    //table.appendRow(1, new SimpleDumpData("cached"), new SimpleDumpData(isCached()?"Yes":"No"));
View Full Code Here

Examples of servers.Sql

49
50
51
52
53
54
55
56
   
  //  rect = fd.analyze(image);
   
  //  println(rect.length);
  //  println(rect.toString());
    sql = new Sql("./db/serBahia.sqlite");
   
  }
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.