public static SQLParams convertMaptoSqlParams(Map<String,Object> bean,SQLInfo sql) throws SetSQLParamException { if(bean == null || bean.size() == 0) { // return null; SQLParams temp = new SQLParams(); temp.setFrommap(true); temp.setOldsql(sql); return temp; } // if(bean.size() == 0) // return null; SQLParams temp = new SQLParams(); temp.setFrommap(true); temp.setOldsql(sql); Iterator<Map.Entry<String,Object>> its = bean.entrySet().iterator(); while(its.hasNext()) { Map.Entry<String,Object> entrie = its.next(); temp.addSQLParam(entrie.getKey(), entrie.getValue(), SQLParams.OBJECT); } return temp; } public static SQLParams convertBeanToSqlParams(Object bean,SQLInfo sql,String dbname,int action,Connection con) throws SQLException
public void addSQLParamWithDateFormateMeta(String name, Object value, String type,DateFormateMeta dataformat,String charset) throws SetSQLParamException { addSQLParamWithDateFormateMeta(name, value, -100,type,dataformat,charset) ; } /**
/** * 创建预编译更新语句 * * @param sql * @throws SQLException */ public void preparedSelect(SQLParams params_,String sql) throws SQLException { params_.buildParams(sql,prepareDBName); preparedSelect(params_.getRealParams(),params_.getNewsql()); }
public void buildParams(SQLInfo sql,SQLInfo totalsizesql,String dbname) throws SetSQLParamException { if(realParams != null) return; // if(sqlparams == null || this.sqlparams.size() <=0) // { // this.newsql = new NewSQLInfo(sql.getSql()); // this.newsql .setNewtotalsizesql(totalsizesql.getSql()); // this.newsql.setOldsql(sql); // this.newsql.setOldtotalsizesql(totalsizesql); // return; // } // if(realParams == null) { if(this.pretoken.equals("#\\[") && this.endtoken.equals("\\]")) buildParamsByVariableParser(sql,totalsizesql,dbname,(NewSQLInfo)null); else buildParamsByRegex( sql,totalsizesql,dbname); } }
SQLParams params = new SQLParams(); params.addSQLParam("roleid", roleid, SQLParams.STRING); params.addSQLParam("userids", ids, SQLParams.OBJECT); this.executor.deleteBean("deleteUsersOfRole", params);
SQLParams temp = new SQLParams(); temp.setFrommap(true); temp.setOldsql(sql); return temp; if(temp.getOldsql() == null) temp.setOldsql(sql); SQLParams temp = convertMaptoSqlParams((Map )bean,sql); return temp; SQLParams temp = new SQLParams(); temp.setFrommap(true); temp.setOldsql(sql); temp.setPagineOrderby(pagineOrderby); return temp; if(temp.getOldsql() == null) temp.setOldsql(sql); temp.setPagineOrderby(pagineOrderby ); return temp; SQLParams temp = convertMaptoSqlParams((Map )condition,sql); temp.setPagineOrderby(pagineOrderby ); return temp;
/** * 添加sql参数,由DefaultDataInfoImpl进行处理 * @param name * @param value * @param type * @throws SetSQLParamException */ public void addSQLParam(String name, Object value, String type) throws SetSQLParamException { addSQLParam( name, value, -100, type, (String)null,(String)null); }
private void init() { if(sqlparams == null) { sqlparams = new SQLParams(); } } /**
sqlParams.buildParams( this.prepareDBName); newsql = sqlParams.getNewsql(); i ++; sqlParams.buildParamsNewSQLInfo( this.prepareDBName,newsql); sqlParams.buildParams( this.prepareDBName); this.Params = sqlParams.getRealParams(); this.Params.prepareSqlifo = sqlParams.getNewsql(); batchparams.add(this.Params);
public static List<SQLParams> convertBeansToSqlParams(List beans,SQLInfo sql,String dbname,int action ,Connection con) throws SQLException { if(beans == null) return null; List<SQLParams> batchparams = new ArrayList<SQLParams>(beans.size()); for(Object bean:beans) { SQLParams params = convertBeanToSqlParams(bean,sql,dbname,action,con); batchparams.add(params); } return batchparams; } public static List<SQLParams> convertBeansToSqlParams(List beans,SQLInfo sql,String dbname,int action
vcontext = buildVelocityContext();//一个context是否可以被同时用于多次运算呢? vcontext = buildVelocityContext(); BBossStringWriter sw = new BBossStringWriter(); totalsizesqlinfo.getSqltpl().merge(vcontext,sw); + var.getVariableName() + "\r\n" + this.toString()); Param newparam = temp.clone(var); vcontext = buildVelocityContext(); log.debug("SQL INFO:" + this.toString() );
public void buildParams(String dbname) throws SetSQLParamException { buildParams(this.oldsql, dbname); } public void buildParamsNewSQLInfo(String dbname,NewSQLInfo newsql) throws SetSQLParamException
if(sqlinfo.istpl()) vcontext = buildVelocityContext(); BBossStringWriter sw = new BBossStringWriter(); sqlinfo.getSqltpl().merge(vcontext, sw); vcontext = buildVelocityContext(); BBossStringWriter sw = new BBossStringWriter(); totalsizesqlinfo.getSqltpl().merge(vcontext, sw);
SQLParams params = new SQLParams(); final SimpleDateFormat dateformat = DataFormatUtil.getSimpleDateFormat(request,"yyyy-MM-dd"); if (null != srcName && !"".equals(srcName)) params.addSQLParam("srcName", "%" + srcName +"%", SQLParams.STRING); params.addSQLParam("provider", "%" + provider +"%", SQLParams.STRING); params.addSQLParam("fromDate", dateformat.parse(fromDate), SQLParams.DATE); params.addSQLParam("toDate", dateformat.parse(toDate), SQLParams.DATE);
/** * 添加sql参数,由DefaultDataInfoImpl进行处理 * @param name * @param value * @param type * @throws SetSQLParamException */ public static void addSQLParam(SQLParams sqlparams,String name, Object value, String type,String dataformat) throws SetSQLParamException { // init(); sqlparams.addSQLParam( name, value, type, dataformat); }
private SQLParams buildParams() { // TODO Auto-generated method stub return new SQLParams(); }
public static List<SQLParams> convertBeansToSqlParams(List beans,SQLInfo sql,String dbname,int action ,Connection con,int start,int end,int step) throws SQLException { if(beans == null) return null; List<SQLParams> batchparams = new ArrayList<SQLParams>(step); for(int i = start; i < end; i++) { Object bean = beans.get(i); SQLParams params = convertBeanToSqlParams(bean,sql,dbname,action,con); batchparams.add(params); } return batchparams; } // public static SQLParams convertMaptoSqlParams(Map<String,Object> bean,String sql) throws SetSQLParamException
public void buildParams(SQLInfo sql,String dbname,NewSQLInfo firstnewsql) throws SetSQLParamException { if(realParams != null) return; // if(sqlparams == null || this.sqlparams.size() <=0) // { // if(firstnewsql != null) // { // this.newsql = firstnewsql; // return; // } // else // { // this.newsql = new NewSQLInfo(sql.getSql()); // newsql.setOldsql(sql); // return; // } // } if(realParams == null) { if(this.pretoken.equals("#\\[") && this.endtoken.equals("\\]")) buildParamsByVariableParser(sql,null,dbname, firstnewsql); else buildParamsByRegex( sql,null,dbname); } }
public void buildParams(SQLInfo sql,String dbname) throws SetSQLParamException { buildParams( sql,dbname,(NewSQLInfo)null); } public void buildParams(SQLInfo sql,String dbname,NewSQLInfo firstnewsql) throws SetSQLParamException
SQLParams params = new SQLParams(); params.addSQLParam("operName", operName, SQLParams.STRING); params.addSQLParam("resId", resId, SQLParams.STRING); params.addSQLParam("restypeId", restypeId, SQLParams.STRING); list = SQLExecutor.queryListBeanByRowHandler(new RowHandler<Role>(){