/** * 创建特定数据库的预编译插入语句 * * @param dbName * @param sql * @throws SQLException */ public void preparedInsert(SQLParams params,String dbName, SQLInfo sql) throws SQLException { params.buildParams(sql, dbName); preparedInsert(params.getRealParams(),dbName, params.getNewsql()); } /**
/** * 创建特定数据库的预编译插入语句 * * @param dbName * @param sql * @throws SQLException */ public void preparedInsert(SQLParams params,String dbName, SQLInfo sql) throws SQLException { params.buildParams(sql, dbName); preparedInsert(params.getRealParams(),dbName, params.getNewsql()); } /**
/** * 创建特定数据库的预编译插入语句 * * @param dbName * @param sql * @throws SQLException */ public void preparedInsert(SQLParams params,String dbName, String sql) throws SQLException { params.buildParams(sql, dbName); preparedInsert(params.getRealParams(),dbName, params.getNewsql()); }
/** * 创建预编译更新语句 * * @param sql * @throws SQLException */ public void preparedSelect(SQLParams params_,String sql) throws SQLException { params_.buildParams(sql,prepareDBName); preparedSelect(params_.getRealParams(),params_.getNewsql()); }
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)); } }
/** * 预编译分页查询方法,总记录数通过totalsizesql查询获取 * * @param sql * @throws SQLException */ public void preparedSelectWithTotalsizesql(SQLParams params,String prepareDBName, String sql, long offset, int pagesize,String totalsizesql) throws SQLException { if( params != null) { params.buildParams(sql,totalsizesql,prepareDBName); preparedSelectWithTotalsizesql(params.getRealParams(),prepareDBName, params.getNewsql(), offset, pagesize); } else preparedSelectWithTotalsizesql((Params)null,prepareDBName, new NewSQLInfo(sql,totalsizesql), offset, pagesize); }
/** * 预编译分页查询方法,总记录数通过totalsizesql查询获取 * * @param sql * @throws SQLException */ public void preparedSelectWithTotalsizesql(SQLParams params,String prepareDBName, SQLInfo sql, long offset, int pagesize,SQLInfo totalsizesql) throws SQLException { if( params != null) { params.buildParams(sql,totalsizesql,prepareDBName); preparedSelectWithTotalsizesql(params.getRealParams(),prepareDBName, params.getNewsql(), offset, pagesize); } else preparedSelectWithTotalsizesql((Params)null,prepareDBName, new NewSQLInfo(sql,totalsizesql), offset, pagesize); }
/** * 预编译分页查询方法 ,外部传入总记录数 * @mark * @param sql * @throws SQLException */ public void preparedSelect(SQLParams params,String prepareDBName, String sql, long offset, int pagesize,long totalsize) throws SQLException { if( params != null) { params.buildParams(sql,prepareDBName); preparedSelect(params.getRealParams(),prepareDBName, params.getNewsql(), offset, pagesize,totalsize); } else preparedSelect((Params)null,prepareDBName, new NewSQLInfo(sql), offset, pagesize,totalsize); }
/** * 预编译分页查询方法 ,外部传入总记录数 * @mark * @param sql * @throws SQLException */ public void preparedSelect(SQLParams params,String prepareDBName, SQLInfo sql, long offset, int pagesize,long totalsize) throws SQLException { if( params != null) { params.buildParams(sql,prepareDBName); preparedSelect(params.getRealParams(),prepareDBName, params.getNewsql(), offset, pagesize,totalsize); } else preparedSelect((Params)null,prepareDBName, new NewSQLInfo(sql), offset, pagesize,totalsize); } /**
/** * 预编译查询方法 * * @param sql * @throws SQLException */ public void preparedSelect(SQLParams params,String prepareDBName, String sql, long offset, int pagesize) throws SQLException { if( params != null) { params.buildParams(sql,prepareDBName); preparedSelect(params.getRealParams(),prepareDBName, params.getNewsql(), offset, pagesize,-1L); } else preparedSelect((Params)null,prepareDBName, new NewSQLInfo(sql), offset, pagesize,-1L); }
/** * 创建预编译更新语句 * * @param sql * @throws SQLException */ public void preparedSelect(SQLParams params,String prepareDBName, String sql) throws SQLException { if(params != null) { params.buildParams(sql,prepareDBName); preparedSelect(params.getRealParams(),prepareDBName, params.getNewsql()); } else { preparedSelect((Params)null,prepareDBName, new NewSQLInfo(sql)); } }
/** * 创建特定数据库预编译删除语句 * * @param dbName * @param sql * @throws SQLException */ public void preparedDelete(SQLParams params,String dbName, SQLInfo sql) throws SQLException { if(params != null) { params.buildParams(sql, dbName); preparedDelete(params.getRealParams(),dbName, params.getNewsql()); } else { preparedDelete((Params)null,dbName, new NewSQLInfo(sql)); } } /**
/** * 创建特定数据库的预编译更新语句 * * @param dbName * @param sql * @throws SQLException */ public void preparedUpdate(SQLParams params,String dbName, SQLInfo sql) throws SQLException { if(params != null) { params.buildParams(sql, dbName); preparedUpdate(params.getRealParams(),dbName, params.getNewsql()); } else { preparedUpdate((Params)null,dbName, new NewSQLInfo(sql)); } }
/** * 创建特定数据库预编译删除语句 * * @param dbName * @param sql * @throws SQLException */ public void preparedDelete(SQLParams params,String dbName, SQLInfo sql) throws SQLException { if(params != null) { params.buildParams(sql, dbName); preparedDelete(params.getRealParams(),dbName, params.getNewsql()); } else { preparedDelete((Params)null,dbName, new NewSQLInfo(sql)); } }
/** * 创建特定数据库的预编译更新语句 * * @param dbName * @param sql * @throws SQLException */ public void preparedUpdate(SQLParams params,String dbName, String sql) throws SQLException { if(params != null) { params.buildParams(sql, dbName); preparedUpdate(params.getRealParams(),dbName, params.getNewsql()); } else { preparedUpdate((Params)null,dbName, new NewSQLInfo(sql)); } } /**
/** * 创建预编译更新语句 * * @param sql * @throws SQLException */ public void preparedSelect(SQLParams params,String prepareDBName, SQLInfo sql) throws SQLException { if(params != null) { params.buildParams(sql,prepareDBName); preparedSelect(params.getRealParams(),prepareDBName, params.getNewsql()); } else { preparedSelect((Params)null,prepareDBName, new NewSQLInfo(sql)); } }
/** * 创建特定数据库的预编译更新语句 * * @param dbName * @param sql * @throws SQLException */ public void preparedUpdate(SQLParams params,String dbName, SQLInfo sql) throws SQLException { if(params != null) { params.buildParams(sql, dbName); preparedUpdate(params.getRealParams(),dbName, params.getNewsql()); } else { preparedUpdate((Params)null,dbName, new NewSQLInfo(sql)); } } /**
/** * 创建预编译查询语句 * * @param sql * @throws SQLException */ public void preparedSelectWithTotalsizesql(SQLParams params,String prepareDBName, String sql, long offset, int pagesize, String oraclerownum,String totalsizesql) throws SQLException { if(params != null) { params.buildParams(sql,totalsizesql,prepareDBName); preparedSelectWithTotalsizesql(params.getRealParams(),prepareDBName, params.getNewsql(), offset, pagesize, oraclerownum); } else { preparedSelectWithTotalsizesql((Params)null,prepareDBName, new NewSQLInfo(sql,totalsizesql), offset, pagesize, oraclerownum); } }
/** * 创建预编译查询语句 * @mark * @param sql * @throws SQLException */ public void preparedSelect(SQLParams params,String prepareDBName, String sql, long offset, int pagesize, String oraclerownum,long totalsize) throws SQLException { if(params != null) { params.buildParams(sql,prepareDBName); preparedSelect(params.getRealParams(),prepareDBName, params.getNewsql(), offset, pagesize, oraclerownum,totalsize); } else { preparedSelect((Params)null,prepareDBName, new NewSQLInfo(sql), offset, pagesize, oraclerownum,totalsize); } }
/** * 创建预编译查询语句 * * @param sql * @throws SQLException */ public void preparedSelect(SQLParams params,String prepareDBName, String sql, long offset, int pagesize, String oraclerownum) throws SQLException { if(params != null) { params.buildParams(sql,prepareDBName); preparedSelect(params.getRealParams(),prepareDBName, params.getNewsql(), offset, pagesize, oraclerownum,-1L); } else { preparedSelect((Params)null,prepareDBName, new NewSQLInfo(sql), offset, pagesize, oraclerownum,-1L); } }