public void executeSelectWithRowhandler(String dbname, String sql,long offset,int pagesize, Connection con,NullRowHandler rowhandler) throws SQLException { StatementInfo stmtInfo = new StatementInfo(dbname, new NewSQLInfo(sql), false, offset, pagesize, true, con,oraclerownum); this.innerExecutePagineJDBC(stmtInfo, null, rowhandler, ResultMap.type_null); }
public String executeSelectForXML(String dbname,String sql,long offset,int pagesize,boolean robotquery , Connection con,RowHandler rowhandler) throws SQLException { StatementInfo stmtInfo = new StatementInfo(dbname, new NewSQLInfo(sql), // Connection con, false, offset, pagesize, robotquery, con,oraclerownum); ResultMap resultMap = innerExecutePagineJDBC(stmtInfo, XMLMark.class, rowhandler, ResultMap.type_xml); return (String)resultMap.getCommonresult(); }
public List executeSelectForList(String dbname, String sql, long offset, int pagesize, boolean robotquery,Connection con,Class objectType,RowHandler rowhandler) throws SQLException { StatementInfo stmtInfo = new StatementInfo(dbname, new NewSQLInfo(sql), // Connection con, false, offset, pagesize, robotquery, con,oraclerownum); ResultMap resultMap = this.innerExecutePagineJDBC(stmtInfo, objectType, rowhandler, ResultMap.type_list); return (List)resultMap.getCommonresult(); } public List executeSelectForList(String dbname, String sql, long offset, int pagesize,Connection con,Class objectType,RowHandler rowhandler) throws SQLException
public Object[] executeSelectForObjectArray(String dbname,String sql,long offset,int pagesize,Class objectType,Connection con,RowHandler rowhandler) throws SQLException { StatementInfo stmtInfo = new StatementInfo(dbname, new NewSQLInfo(sql), // Connection con, false, offset, pagesize, isRobotQuery(dbname), con,oraclerownum); ResultMap resultMap = innerExecutePagineJDBC(stmtInfo, objectType, rowhandler, ResultMap.type_objectarray); return (Object[])resultMap.getCommonresult(); }
public void executeSelectWithRowhandler(String dbname, String sql, Connection con,NullRowHandler rowhandler) throws SQLException { StatementInfo stmtInfo = null; try { stmtInfo = new StatementInfo(dbname, new NewSQLInfo(sql), false,con,false); ResultMap resultMap = innerExecuteJDBC(stmtInfo, null,rowhandler,ResultMap.type_null); // return (List)resultMap.getCommonresult(); } finally { if(stmtInfo != null) { stmtInfo.dofinally(); stmtInfo = null; } } }
public List executeSelectForOracleList(String dbname, String sql, long offset, int pagesize, String oraclerownum,Connection con,Class objectType,RowHandler rowhandler) throws SQLException { StatementInfo stmtInfo = new StatementInfo(dbname, new NewSQLInfo(sql), // Connection con, false, offset, pagesize, isRobotQuery(dbname), con,oraclerownum); ResultMap resultMap = this.innerExecutePagineJDBC(stmtInfo, objectType, rowhandler, ResultMap.type_list); return (List)resultMap.getCommonresult(); }
public List executeSelectForList(String dbname, String sql, Connection con,Class objectType,RowHandler rowhandler) throws SQLException { StatementInfo stmtInfo = null; try { stmtInfo = new StatementInfo(dbname, new NewSQLInfo(sql), false,con,false); ResultMap resultMap = innerExecuteJDBC(stmtInfo, objectType,rowhandler,ResultMap.type_list); return (List)resultMap.getCommonresult(); } finally { if(stmtInfo != null) { stmtInfo.dofinally(); stmtInfo = null; } } }
try stmtInfo = new StatementInfo(this.prepareDBName, Params.prepareSqlifo, false,
/*************************************************************************** * for xml ***************************************************************************/ public String executeSelectForXML(String dbname, String sql, Connection con,RowHandler rowhandler) throws SQLException { StatementInfo stmtInfo = null; try{ stmtInfo = new StatementInfo(dbname, new NewSQLInfo(sql), false,con,false); ResultMap resultMap = innerExecuteJDBC(stmtInfo, XMLMark.class,rowhandler,ResultMap.type_xml); return (String)resultMap.getCommonresult(); } finally { if(stmtInfo != null) { stmtInfo.dofinally(); stmtInfo = null; } } }
try { stmtInfo = new StatementInfo(dbname, new NewSQLInfo(sql),
stmtInfo = new StatementInfo(dbname, null, false,
stmtInfo = new StatementInfo(this.prepareDBName, null, false,
dbname_ = SQLManager.getInstance().getDefaultDBName(); try { stmtInfo = new StatementInfo(dbname_, null, false,
public Object[] executeSelectForObjectArray(String dbname,String sql, Class objectType,Connection con, RowHandler rowhandler) throws SQLException { StatementInfo stmtInfo = null; try{ stmtInfo = new StatementInfo(dbname, new NewSQLInfo(sql), false,con,false); ResultMap resultMap = innerExecuteJDBC(stmtInfo, objectType,rowhandler,ResultMap.type_objectarray); return (Object[])resultMap.getCommonresult(); } finally { if(stmtInfo != null) { stmtInfo.dofinally(); stmtInfo = null; } } }
public Object executeSelectForObject(String dbname, String sql, Connection con,Class objectType, RowHandler rowhandler) throws SQLException { StatementInfo stmtInfo = null; try { stmtInfo = new StatementInfo(dbname, new NewSQLInfo(sql), false,con,false); ResultMap resultMap = innerExecuteJDBC(stmtInfo, objectType,rowhandler,ResultMap.type_objcet); return (Object)resultMap.getCommonresult(); } finally { if(stmtInfo != null) { stmtInfo.dofinally(); stmtInfo = null; } } }
try stmtInfo = new StatementInfo(dbname, new NewSQLInfo(sql),
stmtInfo = new StatementInfo(dbname_, new NewSQLInfo(sql_), goNative_,
try stmtInfo = new StatementInfo(dbname_,new NewSQLInfo( sql_), goNative_,con_,!this.isAutoCommit()); ResultMap resultMap = innerExecuteJDBC(stmtInfo, null,null,ResultMap.type_maparray);
if(pool == null) throw new NestedSQLException(new StringBuilder().append("执行sql[").append(this.Params.prepareSqlifo != null?this.Params.prepareSqlifo.getNewsql():"").append("]失败:数据源[").append(prepareDBName).append("]不存在,请检查数据源是否正确启动.").toString()); stmtInfo = new StatementInfo(this.prepareDBName, this.Params.prepareSqlifo,