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 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 void preparedDelete(SQLParams params,String dbName, String sql) throws SQLException { if(params != null) { params.buildParams(sql, dbName); preparedDelete(params.getRealParams(),dbName, params.getNewsql()); } else { preparedDelete((Params)null,dbName, new NewSQLInfo(sql)); } }
public void updateByKeysWithDBName(String dbname,String sqlname, String... fields) throws SQLException { SQLInfo sql = getSqlInfo(dbname,sqlname); SQLInfoExecutor.updateByKeysWithDBName(dbname,sql, fields); // executeBatch(dbname, sql,PreparedDBUtil.DELETE, fields); }
public void deleteByShortKeys(String sqlname, short... fields) throws SQLException { SQLInfo sql = getSqlInfo(null,sqlname); SQLInfoExecutor.deleteByShortKeys(sql, fields); // executeBatch(null, sql,PreparedDBUtil.DELETE, fields); } public void deleteByShortKeysWithDBName(String dbname,String sqlname, short... fields) throws SQLException {
public void deleteByShortKeysWithDBName(String dbname,String sqlname, short... fields) throws SQLException { SQLInfo sql = getSqlInfo(dbname,sqlname); SQLInfoExecutor.deleteByShortKeysWithDBName(dbname,sql, fields); // executeBatch(dbname, sql,PreparedDBUtil.DELETE, fields); } public void updateByShortKeys(String sqlname, short... fields) throws SQLException {
public Object insertWithDBName(String dbname, String sqlname, Object... fields) throws SQLException { SQLInfo sql = getSqlInfo(dbname,sqlname); return SQLInfoExecutor.insertWithDBName(dbname,sql, fields); // return execute(dbname, sql,PreparedDBUtil.INSERT, fields); }
public void updateBean(String dbname, String sqlname, Object bean) throws SQLException { if(bean == null ) return ; // List datas = new ArrayList(); // datas.add(bean); // updateBeans( dbname, sql, datas); SQLInfo sql = getSqlInfo(dbname,sqlname); SQLInfoExecutor.updateBean(dbname,sql, bean); }
public ListInfo queryListInfoWithDBName2ndTotalsizeByRowHandler(RowHandler rowhandler,Class<?> beanType,String dbname, String sqlname, long offset,int pagesize,long totalsize,Object... fields) throws SQLException { SQLInfo sql = getSqlInfo(dbname, sqlname); return SQLInfoExecutor.queryListInfoWithDBName2ndTotalsizeByRowHandler(rowhandler,beanType,dbname, sql, offset,pagesize,totalsize,fields); } public ListInfo queryListInfoWithDBName2ndTotalsizesqlByRowHandler(RowHandler rowhandler,Class<?> beanType,String dbname, String sqlname, long offset,int pagesize,String totalsizesqlname,Object... fields) throws SQLException
public ListInfo queryListInfoWithDBName2ndTotalsizesqlByRowHandler(RowHandler rowhandler,Class<?> beanType,String dbname, String sqlname, long offset,int pagesize,String totalsizesqlname,Object... fields) throws SQLException { SQLInfo sql = getSqlInfo(dbname, sqlname); SQLInfo totalsizesql = this.getSqlInfo(dbname, totalsizesqlname); return SQLInfoExecutor.queryListInfoWithDBName2ndTotalsizesqlByRowHandler(rowhandler,beanType,dbname, sql, offset,pagesize,totalsizesql,fields); } /**
public <T> T queryObjectWithDBNameByRowHandler(RowHandler rowhandler,Class<T> beanType,String dbname, String sqlname, Object... fields) throws SQLException { SQLInfo sql = getSqlInfo(dbname, sqlname); return SQLInfoExecutor.queryObjectWithDBNameByRowHandler( rowhandler, beanType, dbname, sql, fields); }
public ListInfo queryListInfoWithDBName2ndTotalsizeByNullRowHandler(NullRowHandler rowhandler,String dbname, String sqlname, long offset,int pagesize,long totalsize,Object... fields) throws SQLException { SQLInfo sql = getSqlInfo(dbname, sqlname); return SQLInfoExecutor.queryListInfoWithDBName2ndTotalsizeByNullRowHandler( rowhandler,dbname, sql, offset,pagesize,totalsize,fields); } public ListInfo queryListInfoWithDBName2ndTotalsizesqlByNullRowHandler(NullRowHandler rowhandler,String dbname, String sqlname, long offset,int pagesize,String totalsizesqlname,Object... fields) throws SQLException
public ListInfo queryListInfoWithDBName2ndTotalsizesqlByNullRowHandler(NullRowHandler rowhandler,String dbname, String sqlname, long offset,int pagesize,String totalsizesqlname,Object... fields) throws SQLException { SQLInfo sql = getSqlInfo(dbname, sqlname); SQLInfo totalsizesql = this.getSqlInfo(dbname, totalsizesqlname); return SQLInfoExecutor.queryListInfoWithDBName2ndTotalsizesqlByNullRowHandler( rowhandler,dbname, sql, offset,pagesize,totalsizesql,fields); } /**
public <T> T queryTFieldBeanWithDBName(String dbname, Class<T> type,String sqlname, Object bean) throws SQLException { SQLInfo sql = getSqlInfo(dbname, sqlname); return SQLInfoExecutor.queryTFieldBeanWithDBName( dbname, type, sql, bean); }
public <T> T queryObjectBeanWithDBName(Class<T> beanType,String dbname, String sqlname, Object bean) throws SQLException { SQLInfo sql = getSqlInfo(dbname, sqlname); return SQLInfoExecutor.queryObjectBeanWithDBName( beanType,dbname, sql, bean); }
public ListInfo moreListInfoBeanByRowHandler(RowHandler rowhandler,Class<?> beanType, String sqlname, long offset,int pagesize,Object bean) throws SQLException { SQLInfo sql = getSqlInfo(null, sqlname); return SQLInfoExecutor.moreListInfoBeanWithDBNameByRowHandler( rowhandler,beanType,(String)null, sql, offset,pagesize,bean); }
/** * * @param sql */ public void prepareCallable(String sql) { this.Params = this.buildCallableParams(CALL_PROCEDURE); Params.prepareSqlifo = new NewSQLInfo(sql); }
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 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