/** * 创建预编译更新语句 * * @param sql * @throws SQLException */ public void preparedSelect(String sql) throws SQLException { preparedSelect((Params)null,new NewSQLInfo(sql)); }
/** * 创建特定数据库的预编译更新语句 * * @param params * @param sql * @throws SQLException */ public void preparedUpdate(Params params, String sql) throws SQLException { preparedUpdate(params, this.prepareDBName,new NewSQLInfo(sql)); }
public void prepareCallable(String preparedDBName,String sql) { this.prepareDBName = preparedDBName; this.Params = this.buildCallableParams(CALL_PROCEDURE); Params.prepareSqlifo = new NewSQLInfo(sql); }
/** * 创建特定数据库预编译删除语句 * * @param dbName * @param sql * @throws SQLException */ public void preparedDelete(String dbName, SQLInfo sql) throws SQLException { preparedDelete((Params)null,dbName, new NewSQLInfo(sql)); } /**
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); }
/** * * @param sql */ public void prepareCallable(String sql) { this.Params = this.buildCallableParams(CALL_PROCEDURE); Params.prepareSqlifo = new NewSQLInfo(sql); }
private void prepareCallable(String preparedDBName,String sql,int calltype) throws SQLException { if(calltype != CALL_FUNCTION && calltype != CALL_PROCEDURE) throw new SQLException("CALL_TYPE error: Must be CALL_FUNCTION or CALL_PROCEDURE."); this.prepareDBName = preparedDBName; this.Params = this.buildCallableParams(calltype); Params.prepareSqlifo = new NewSQLInfo(sql); } public void executeCallable() throws java.sql.SQLException
/** * * @param sql * @throws SQLException */ private void prepareCallable(String sql,int calltype) throws SQLException { if(calltype != CALL_FUNCTION && calltype != CALL_PROCEDURE) throw new SQLException("CALL_TYPE error: Must be CALL_FUNCTION or CALL_PROCEDURE."); this.Params = this.buildCallableParams(calltype); Params.prepareSqlifo = new NewSQLInfo(sql); }
/** * 创建缺省数据库预编译删除语句 * * @param sql * @throws SQLException */ public void preparedDelete(Params params,String sql) throws SQLException { preparedDelete(params,this.prepareDBName, new NewSQLInfo(sql)); }
/** * 创建特定数据库预编译删除语句 * * @param dbName * @param sql * @throws SQLException */ public void preparedDelete(String dbName, String sql) throws SQLException { preparedDelete((Params)null,dbName, new NewSQLInfo(sql)); }
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(); }
/** * 创建特定数据库的预编译更新语句 * * @param dbName * @param sql * @throws SQLException */ public void preparedUpdate(String dbName, String sql) throws SQLException { Params = this.buildParams(); Params.action = UPDATE; preparedSql(Params,dbName, new NewSQLInfo(sql)); }
/** * 创建预编译更新语句 * * @param sql * @throws SQLException */ public void preparedUpdate(String sql) throws SQLException { Params = this.buildParams(); Params.action = UPDATE; preparedSql(Params,prepareDBName, new NewSQLInfo(sql)); }
/** * 创建预编译更新语句 * * @param sql * @throws SQLException */ public void preparedSelect(String prepareDBName, String sql) throws SQLException { Params = this.buildParams(); preparedSelect(Params ,prepareDBName, new NewSQLInfo(sql)); }
/** * 创建预编译查询语句 * * @param sql * @throws SQLException */ public void preparedSelect(String prepareDBName, String sql, long offset, int pagesize, String oraclerownum) throws SQLException { Params = this.buildParams(); preparedSelect(Params ,prepareDBName, new NewSQLInfo(sql), offset, pagesize, oraclerownum,-1L); }
/** * 创建预编译更新语句 * * @param sql * @throws SQLException */ public void preparedSelect(String prepareDBName, SQLInfo sql) throws SQLException { Params = this.buildParams(); preparedSelect(Params ,prepareDBName, new NewSQLInfo(sql)); }
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)); } }