org.pentaho.di.core.database.Database.execStatements()方法的使用及代码示例

x33g5p2x  于2022-01-18 转载在 其他  
字(3.3k)|赞(0)|评价(0)|浏览(166)

本文整理了Java中org.pentaho.di.core.database.Database.execStatements()方法的一些代码示例,展示了Database.execStatements()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Database.execStatements()方法的具体详情如下:
包路径:org.pentaho.di.core.database.Database
类名称:Database
方法名:execStatements

Database.execStatements介绍

[英]Execute a series of SQL statements, separated by ;

We are already connected...

Multiple statements have to be split into parts We use the ";" to separate statements...

We keep the results in Result object from Jobs
[中]执行一系列SQL语句,以分隔;
我们已经联系上了。。。
必须将多个语句拆分为多个部分,我们使用“;”要分离语句。。。
我们将结果保存在作业的结果对象中

代码示例

代码示例来源:origin: pentaho/pentaho-kettle

  1. /**
  2. * Execute a series of SQL statements, separated by ;
  3. * <p/>
  4. * We are already connected...
  5. * <p/>
  6. * Multiple statements have to be split into parts We use the ";" to separate statements...
  7. * <p/>
  8. * We keep the results in Result object from Jobs
  9. *
  10. * @param script The SQL script to be execute
  11. * @return A result with counts of the number or records updates, inserted, deleted or read.
  12. * @throws KettleDatabaseException In case an error occurs
  13. */
  14. public Result execStatements( String script ) throws KettleDatabaseException {
  15. return execStatements( script, null, null );
  16. }

代码示例来源:origin: pentaho/pentaho-kettle

  1. data.result = data.db.execStatement( sql );
  2. } else {
  3. data.result = data.db.execStatements( sql );

代码示例来源:origin: pentaho/pentaho-kettle

  1. /**
  2. * Lock a tables in the database for write operations
  3. *
  4. * @param tableNames The tables to lock. These need to be the appropriately quoted fully qualified (schema+table)
  5. * names.
  6. * @throws KettleDatabaseException
  7. */
  8. public void lockTables( String[] tableNames ) throws KettleDatabaseException {
  9. if ( Utils.isEmpty( tableNames ) ) {
  10. return;
  11. }
  12. // Get the SQL to lock the (quoted) tables
  13. //
  14. String sql = databaseMeta.getSQLLockTables( tableNames );
  15. if ( sql != null ) {
  16. execStatements( sql );
  17. }
  18. }

代码示例来源:origin: pentaho/pentaho-kettle

  1. return execStatement( sql );
  2. } else {
  3. return execStatements( sql );

代码示例来源:origin: pentaho/pentaho-kettle

  1. db.connect();
  2. try {
  3. db.execStatements( stat.getSQL() );
  4. } catch ( KettleDatabaseException dbe ) {
  5. errors++;

代码示例来源:origin: pentaho/pentaho-kettle

  1. db.execStatement( theSQL );
  2. } else {
  3. db.execStatements( theSQL );

代码示例来源:origin: pentaho/pentaho-kettle

  1. execStatements( sql );
  2. if ( log.isDetailed() ) {
  3. log.logDetailed( "Executed connect time SQL statements:" + Const.CR + sql );

代码示例来源:origin: pentaho/pentaho-kettle

  1. data.result = data.db.execStatement( sql, data.paramsMeta, paramsData );
  2. } else {
  3. data.result = data.db.execStatements( sql, data.paramsMeta, paramsData );

代码示例来源:origin: pentaho/pentaho-kettle

  1. database.execStatements( sql );
  2. if ( log.isDetailed() ) {
  3. log.logDetailed( "Created/altered table " + schemaTable );
  4. database.execStatements( sql );
  5. if ( log.isDetailed() ) {
  6. log.logDetailed( "Created/altered table " + schemaTable );
  7. database.execStatements( sql );
  8. if ( log.isDetailed() ) {
  9. log.logDetailed( "Created/altered table " + schemaTable );
  10. database.execStatements( sql );
  11. if ( log.isDetailed() ) {
  12. log.logDetailed( "Created or altered table " + schemaTable );
  13. database.execStatements( sql );
  14. if ( log.isDetailed() ) {
  15. log.logDetailed( "Created or altered table " + schemaTable );
  16. database.execStatements( sql );
  17. if ( log.isDetailed() ) {
  18. log.logDetailed( "Created or altered table " + schemaTable );
  19. database.execStatements( sql );
  20. if ( log.isDetailed() ) {
  21. log.logDetailed( "Created or altered table " + schemaTable );
  22. database.execStatements( sql );

代码示例来源:origin: pentaho/pentaho-kettle

  1. data.result = data.db.execStatement( data.sql );
  2. } else {
  3. data.result = data.db.execStatements( data.sql );

相关文章