Package org.fto.jthink.jdbc

Examples of org.fto.jthink.jdbc.SQLExecutor.execute()


      SQL sql = sqlBuilder.constructSQLForInsert("Messages", messagesHM);
      if(logger.isDebugEnabled()){
        logger.debug("通过SQLBuilder构建的SQL: " + sql.getSQLString()+"     "+messagesHM);
      }
      /* 执行SQ语句 */
      sqlExecutor.execute(sql);
     
      /* 提交事务 */
      transaction.commit();
    }catch(Exception e){
      /* 回退事务 */
 
View Full Code Here


      SQL sql = sqlBuilder.constructSQLForUpdate("Messages", messagesHM, condi);
      if(logger.isDebugEnabled()){
        logger.debug("通过SQLBuilder构建的SQL: " + sql.getSQLString()+"     "+messagesHM);
      }
      /* 执行SQ语句 */
      Object rs = sqlExecutor.execute(sql);
     
      System.out.println("update rows="+rs);
     
      /* 提交事务 */
      transaction.commit();
View Full Code Here

      SQL sql = sqlBuilder.constructSQLForDelete("Messages", condi);
      if(logger.isDebugEnabled()){
        logger.debug("通过SQLBuilder构建的SQL: " + sql.getSQLString()+"     ");
      }
      /* 执行SQ语句 */
      Object rs = sqlExecutor.execute(sql);
     
      System.out.println("delete rows="+rs);
     
      /* 提交事务 */
      transaction.commit();
View Full Code Here

    SQLBuilder sqlBuilder = transaction.getSQLBuilderFactory("SampleDataSource").create("");
    try{
      /* 开始事务 */
      transaction.begin();
      /* 直接执行SQL查询语句 */
      return (List)sqlExecutor.execute(sqlBuilder.constructSQLForCount("messages", "*", "MsgCount", null));
     
    }finally{
      /* 关闭事务 */
      transaction.close();
    }
View Full Code Here

      SQL sql = sqlBuilder.constructSQLForSelect("Messages",false,new Column[]{new Column("SUBJECT"),new Column("SENDER")},condition,null,null,3,2);
      //SQL sql = sqlBuilder.constructSQLForSelect("Messages",true,null,condition,null,null);
     
      logger.debug("通过SQLBuilder构建的SQL: " + sql.getSQLString());
     
      return (List)sqlExecutor.execute(sql);
     
    }finally{
      /* 关闭事务 */
      transaction.close();
    }
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.