org.frameworkset.persitent.util.SQLUtil Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of bboss-persistent Show documentation
Show all versions of bboss-persistent Show documentation
bboss is a j2ee framework include aop/ioc,mvc,persistent,taglib,rpc,event ,bean-xml serializable and so on.http://www.bbossgroups.com
The newest version!
/*
* Copyright 2008 biaoping.yin
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package org.frameworkset.persitent.util;
import bboss.org.apache.velocity.VelocityContext;
import com.frameworkset.common.poolman.management.PoolManConfiguration;
import com.frameworkset.common.poolman.sql.PoolManResultSetMetaData;
import com.frameworkset.common.poolman.util.JDBCPool;
import com.frameworkset.common.poolman.util.SQLManager;
import com.frameworkset.util.DaemonThread;
import com.frameworkset.util.ResourceInitial;
import com.frameworkset.util.VariableHandler.SQLStruction;
import com.frameworkset.velocity.BBossVelocityUtil;
import org.frameworkset.spi.BaseApplicationContext;
import org.frameworkset.spi.assemble.Pro;
import org.frameworkset.util.shutdown.ShutdownUtil;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import java.io.StringWriter;
import java.net.URL;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.*;
/**
*
* Title: SQLUtil.java
*
*
* Description:
*
*
* bboss workgroup
*
*
* Copyright (c) 2007
*
*
* @Date 2010-7-12 下午07:38:55
* @author biaoping.yin
* @version 1.0
*/
public class SQLUtil {
protected BaseApplicationContext sqlcontext;
private static Logger log = LoggerFactory.getLogger(SQLUtil.class);
protected static Map sqlutils = new HashMap();
protected SQLBaseCache cache;
protected static long refresh_interval = 5000;
public static final int defaultResultMetaCacheSize = 6000;
public static final int defaultGloableResultMetaCacheSize = 10000;
public static final int defaultMaxGloableTemplateCacheSize = 10000;
public static final int defaultPerKeySqlStructionCacheSize = 5000;
public static final boolean defaultAlwaysCache = false;
public static final int defaultGlobalKeySqlStructionCacheSize = 10000;
protected String defaultDBName = null;
protected Map sqls;
protected Map sqlrefs;
protected boolean hasrefs;
protected boolean alwaysCache = defaultAlwaysCache;
protected String sqlFile;
protected int resultMetaCacheSize;
protected int perKeySqlStructionCacheSize;
public static class SQLRef
{
public SQLRef(String sqlname, String sqlfile, String name) {
super();
this.sqlname = sqlname;
this.sqlfile = sqlfile;
this.name = name;
}
private SQLUtil sqlutil;
private String sqlname;
private String sqlfile;
private String name;
public String getSqlname() {
return sqlname;
}
public String getSqlfile() {
return sqlfile;
}
public String getName() {
return name;
}
public SQLInfo getSQLInfo(String dbname)
{
if(sqlutil == null)
{
init();
}
return this.sqlutil.getSQLInfo(dbname, sqlname);
}
private synchronized void init()
{
if(sqlutil == null)
{
this.sqlutil = SQLUtil.getInstance(sqlfile);
}
}
public String getSQL(String dbname) {
if(sqlutil == null)
{
init();
}
return this.sqlutil.getSQL(dbname, sqlname);
}
public String getSQL() {
if(sqlutil == null)
{
init();
}
return this.sqlutil.getSQL(null, sqlname);
}
public String getSQL(String dbname, Map variablevalues) {
if(sqlutil == null)
{
init();
}
return this.sqlutil.getSQL(dbname, sqlname, variablevalues);
}
}
public Map getSQLRefers()
{
return this.sqlrefs;
}
/**
* 默认的sql结构缓存器
*/
private static GloableSQLUtil globalSQLUtil = null;
// /**
// * sql语句velocity模板索引表，以sql语句的名称为索引
// * 当sql文件重新加载时，这些模板也会被重置
// */
// private Map sqlVelocityTemplates;
//
private static DaemonThread damon = null;
/**
*
*/
private void trimValues()
{
if(sqlcontext == null)
return;
// sqls = null;
// sqlrefs = null;
Map sqls = new HashMap();
Map sqlrefs = new HashMap ();
Set keys = this.sqlcontext.getPropertyKeys();
boolean hasrefs = false;
if(keys != null && keys.size() > 0)
{
Iterator keys_it = keys.iterator();
while(keys_it.hasNext())
{
String key = keys_it.next();
Pro pro = this.sqlcontext.getProBean(key);
String sqlfile = (String)pro.getExtendAttribute("sqlfile");
if(sqlfile == null)
{
Object o = pro.getObject();
if(o instanceof String)
{
String value = (String)o;
if(value != null)
{
boolean cacheSql = pro.getBooleanExtendAttribute("cacheSql",true);//标识sql语句是否为velocity模板
boolean istpl = pro.getBooleanExtendAttribute("istpl",true);//标识sql语句是否为velocity模板
boolean multiparser = pro.getBooleanExtendAttribute("multiparser",istpl);//如果sql语句为velocity模板，则在批处理时是否需要每条记录都需要分析sql语句
SQLTemplate sqltpl = null;
value = value.trim();
SQLInfo sqlinfo = new SQLInfo(key, value, istpl,multiparser,cacheSql);
sqlinfo.setSqlutil(this);
if(istpl)
{
sqltpl = new SQLTemplate(sqlinfo);
sqlinfo.setSqltpl(sqltpl);
BBossVelocityUtil.initDBTemplate(sqltpl);
sqltpl.process();
}
sqls.put(key, sqlinfo);
}
}
}
else
{
String sqlname = (String)pro.getExtendAttribute("sqlname");
if(sqlname == null)
{
if(log.isWarnEnabled()) {
log.warn(new StringBuilder().append(sqlcontext.getConfigfile() ).append( "中name=" )
.append( key ).append( "的sql被配置为对" )
.append( sqlfile ).append( "中的sql引用，但是没有通过sqlname设置要引用的sql语句!").toString());
}
}
else
{
sqlrefs.put(key, new SQLRef(sqlname,sqlfile,key));
hasrefs = true;
}
}
}
}
int resultMetaCacheSize = sqlcontext.getIntProperty("resultMetaCacheSize",SQLUtil.defaultResultMetaCacheSize);
int perKeySqlStructionCacheSize = sqlcontext.getIntProperty("perKeySqlStructionCacheSize",SQLUtil.defaultPerKeySqlStructionCacheSize);
this.sqlrefs = sqlrefs;
this.sqls = sqls;
alwaysCache = sqlcontext.getBooleanProperty("alwaysCache",SQLUtil.defaultAlwaysCache);
if(alwaysCache) {
cache = new SQLCache(sqlFile, resultMetaCacheSize, perKeySqlStructionCacheSize);
}
else{
cache = new SQLMissingCache(sqlFile, resultMetaCacheSize, perKeySqlStructionCacheSize);
}
this.hasrefs = hasrefs;
}
public boolean hasrefs()
{
return this.hasrefs;
}
protected void _destroy()
{
if(sqls != null)
{
this.sqls.clear();
sqls = null;
}
if(sqlrefs != null)
{
this.sqlrefs.clear();
sqlrefs = null;
}
if(cache != null)
this.cache.clear();
if(sqlcontext != null)
sqlcontext.destroy(true);
defaultDBName = null;
}
void reinit()
{
if(sqlcontext != null) {
String file = sqlcontext.getConfigfile();
sqlcontext.removeCacheContext();
SQLSOAFileApplicationContext _sqlcontext = new SQLSOAFileApplicationContext(PoolManConfiguration.getSqlMappingDir(),file);
if(_sqlcontext.getParserError() == null) {
// if (sqls != null) {
// this.sqls.clear();
// sqls = null;
// }
// if (sqlrefs != null) {
// this.sqlrefs.clear();
// sqlrefs = null;
// }
// if (this.cache != null)
// this.cache.clear();
sqlcontext.destroy(false);
sqlcontext = _sqlcontext;
defaultDBName = sqlcontext.getProperty("default.dbname");
trimValues();
}
else{
sqlcontext.restoreCacheContext();
}
}
/**
if(sqlcontext != null) {
String file = sqlcontext.getConfigfile();
sqlcontext.destroy(true);
sqlcontext = new SQLSOAFileApplicationContext(file);
defaultDBName = sqlcontext.getProperty("default.dbname");
trimValues();
}
*/
}
public SQLStruction getSQLStruction(SQLInfo sqlinfo,String newsql)
{
return this.cache.getSQLStruction(sqlinfo,newsql);
}
public SQLStruction getTotalsizeSQLStruction(SQLInfo totalsizesqlinfo,String totalsizesql)
{
return this.cache.getTotalsizeSQLStruction(totalsizesqlinfo,totalsizesql);
}
static class ResourceSQLRefresh implements ResourceInitial
{
private SQLUtil sqlutil ;
public ResourceSQLRefresh(SQLUtil sqlutil)
{
this.sqlutil = sqlutil;
}
public void reinit() {
sqlutil.reinit();
}
}
public static void stopmonitor()
{
try {
if(SQLUtil.damon != null)
{
SQLUtil.damon.stopped();
damon = null;
}
} catch (Throwable e) {
// // TODO Auto-generated catch block
// e.printStackTrace();
}
}
public String getSQLFile()
{
return this.sqlcontext.getConfigfile();
}
static
{
ShutdownUtil.addShutdownHook(new Runnable(){
public void run() {
SQLUtil.stopmonitor();
destory();
if(globalSQLUtil != null) {
globalSQLUtil._destroy();
globalSQLUtil = null;
}
}});
}
private static Object lock = new Object();
private static void checkSQLUtil(URL sqlfileURL,String sqlfile, SQLUtil sqlutil){
refresh_interval = PoolManConfiguration.getRefresh_interval();
if(refresh_interval > 0)
{
if(damon == null)
{
synchronized(lock)
{
if(damon == null)
{
damon = new DaemonThread(refresh_interval,"SQL files Refresh Worker");
damon.start();
}
}
}
damon.addFile(sqlfileURL,sqlfile, new ResourceSQLRefresh(sqlutil));
}
}
private SQLUtil(String sqlfile) {
this.sqlFile = sqlfile;
sqlcontext = new SQLSOAFileApplicationContext(PoolManConfiguration.getSqlMappingDir(),sqlfile);
// int resultMetaCacheSize = sqlcontext.getIntProperty("resultMetaCacheSize",SQLUtil.defaultResultMetaCacheSize);
// int perKeySqlStructionCacheSize = sqlcontext.getIntProperty("perKeySqlStructionCacheSize",SQLUtil.defaultPerKeySqlStructionCacheSize);
// alwaysCache = sqlcontext.getBooleanProperty("alwaysCache",SQLUtil.defaultAlwaysCache);
// if(alwaysCache) {
// cache = new SQLCache(sqlfile, resultMetaCacheSize, perKeySqlStructionCacheSize);
// }
// else{
// cache = new SQLMissingCache(sqlfile, resultMetaCacheSize, perKeySqlStructionCacheSize);
// }
this.trimValues();
defaultDBName = sqlcontext.getProperty("default.dbname");
// refresh_interval = ApplicationContext.getApplicationContext().getLongProperty("sqlfile.refresh_interval", -1);
if(sqlcontext.getConfigFileURL() != null)
checkSQLUtil(sqlcontext.getConfigFileURL(),sqlfile,this);
else{
}
// if(refresh_interval > 0)
// {
// damon = new DaemonThread(sqlfile,refresh_interval,new ResourceSQLRefresh(this));
// damon.start();
// }
}
public SQLUtil(int resultMetaCacheSize,int perKeySqlStructionCacheSize,boolean alwaysCache) {
this.alwaysCache = alwaysCache;
this.resultMetaCacheSize = resultMetaCacheSize;
this.perKeySqlStructionCacheSize = perKeySqlStructionCacheSize;
if(alwaysCache) {
cache = new SQLCache(null, resultMetaCacheSize, perKeySqlStructionCacheSize);
}
else{
cache = new SQLMissingCache(null, resultMetaCacheSize, perKeySqlStructionCacheSize);
}
}
public static SQLUtil getInstance(String sqlfile){
if(sqlfile == null){
throw new SQLConfigException("SQL config file is null.");
}
SQLUtil sqlUtil = sqlutils.get(sqlfile);
if(sqlUtil != null)
return sqlUtil;
synchronized(sqlutils)
{
sqlUtil = sqlutils.get(sqlfile);
if(sqlUtil != null)
return sqlUtil;
sqlUtil = new SQLUtil(sqlfile);
sqlutils.put(sqlfile, sqlUtil);
}
return sqlUtil;
}
static void destory()
{
if(sqlutils != null)
{
Iterator> it = sqlutils.entrySet().iterator();
while(it.hasNext())
{
Map.Entry entry = it.next();
entry.getValue()._destroy();
}
sqlutils.clear();
sqlutils = null;
}
}
private SQLInfo getReferSQLInfo(String dbname, String sqlname)
{
SQLRef ref = this.sqlrefs.get(sqlname);
if(ref != null)
return ref.getSQLInfo(dbname);
else
return null;
}
public SQLInfo getSQLInfo(String dbname, String sqlname) {
SQLInfo sql = null;
if(this.hasrefs)
{
sql = this.getReferSQLInfo(dbname, sqlname);
if(sql != null)
return sql;
}
String dbtype = SQLManager.getInstance().getDBAdapter(dbname)
.getDBTYPE();
if(dbtype != null)
// sql = sqlcontext.getProperty(sqlname + "-" + dbtype.toLowerCase());
sql = sqls.get(sqlname + "-" + dbtype.toLowerCase());
if (sql == null) {
// sql = sqlcontext.getProperty(sqlname);
sql = sqls.get(sqlname);
}
if (sql == null) {
// sql = sqlcontext.getProperty(sqlname + "-default");
sql = sqls.get(sqlname + "-default");
}
return sql;
}
public String getPlainSQL(String dbname, String sqlname)
{
SQLInfo sql = null;
if(this.hasrefs)
{
sql = this.getReferSQLInfo(dbname, sqlname);
if(sql != null)
return sql.getSql();
}
String dbtype = SQLManager.getInstance().getDBAdapter(dbname)
.getDBTYPE();
if(dbtype != null)
// sql = sqlcontext.getProperty(sqlname + "-" + dbtype.toLowerCase());
sql = sqls.get(sqlname + "-" + dbtype.toLowerCase());
if (sql == null) {
// sql = sqlcontext.getProperty(sqlname);
sql = sqls.get(sqlname);
}
if (sql == null) {
// sql = sqlcontext.getProperty(sqlname + "-default");
sql = sqls.get(sqlname + "-default");
}
if(sql != null)
return sql.getSql();
else
return null;
}
private String getReferSQL(String dbname, String sqlname)
{
SQLRef ref = this.sqlrefs.get(sqlname);
if(ref != null)
return ref.getSQL(dbname);
else
return null;
}
public String getSQL(String dbname, String sqlname) {
if(this.hasrefs)
{
String sql = this.getReferSQL(dbname, sqlname);
if(sql != null)
return sql;
}
String dbtype = SQLManager.getInstance().getDBAdapter(dbname)
.getDBTYPE();
SQLInfo sql = null;
if(dbtype != null)
// sql = sqlcontext.getProperty(sqlname + "-" + dbtype.toLowerCase());
sql = sqls.get(sqlname + "-" + dbtype.toLowerCase());
if (sql == null) {
// sql = sqlcontext.getProperty(sqlname);
sql = sqls.get(sqlname);
}
if (sql == null) {
// sql = sqlcontext.getProperty(sqlname + "-default");
sql = sqls.get(sqlname + "-default");
}
return sql != null?sql.getSql():null;
}
private String getReferSQL(String dbname, String sqlname,Map variablevalues)
{
SQLRef ref = this.sqlrefs.get(sqlname);
if(ref != null)
return ref.getSQL(dbname,variablevalues);
else
return null;
}
public String getSQL(String dbname, String sqlname,Map variablevalues) {
if(this.hasrefs)
{
String sql = this.getReferSQL(dbname, sqlname,variablevalues);
if(sql != null)
return sql;
}
String dbtype = SQLManager.getInstance().getDBAdapter(dbname)
.getDBTYPE();
String newsql = null;
SQLInfo sql = null;
if(dbtype != null)
// sql = sqlcontext.getProperty(sqlname + "-" + dbtype.toLowerCase());
sql = sqls.get(sqlname + "-" + dbtype.toLowerCase());
if (sql == null) {
// sql = sqlcontext.getProperty(sqlname);
sql = sqls.get(sqlname);
}
if (sql == null) {
// sql = sqlcontext.getProperty(sqlname + "-default");
sql = sqls.get(sqlname + "-default");
}
if(sql != null )
{
newsql = _getSQL(sql,variablevalues);
}
return newsql;
}
public static String _getSQL(SQLInfo sqlinfo,Map variablevalues)
{
String sql = null;
VelocityContext vcontext = null;
if(sqlinfo.istpl())
{
sqlinfo.getSqltpl().process();//识别sql语句是不是真正的velocity sql模板
if(sqlinfo.istpl())
{
vcontext = BBossVelocityUtil.buildVelocityContext(variablevalues);//一个context是否可以被同时用于多次运算呢？
StringWriter sw = new StringWriter();
sqlinfo.getSqltpl().merge(vcontext,sw);
sql = sw.toString();
}
else
{
sql = sqlinfo.getSql();
}
}
else
{
sql = sqlinfo.getSql();
}
return sql;
}
/**
* mark 1
* @param name
* @param sql
* @param variablevalues
* @return
*/
public String evaluateSQL(String name,String sql,Map variablevalues) {
if(sql != null && variablevalues != null && variablevalues.size() > 0)
{
sql = BBossVelocityUtil.evaluate(variablevalues, sqlcontext.getConfigfile()+"|"+name, sql);
}
return sql;
}
public String getSQL(String sqlname,Map variablevalues) {
return getSQL(null, sqlname,variablevalues) ;
}
public String getDBName(String sqlname) {
Pro pro = sqlcontext.getProBean(sqlname);
if (pro == null) {
return defaultDBName;
}
return pro.getStringExtendAttribute("dbname");
}
public String[] getPropertyKeys()
{
Set keys = this.sqlcontext.getPropertyKeys();
if(keys == null )
return new String[]{};
String[] rets = new String[keys.size()];
Iterator its = keys.iterator();
int i = 0;
while(its.hasNext())
{
rets[i] = its.next();
i ++;
}
return rets;
}
public SQLInfo getSQLInfo(String sqlname) {
return getSQLInfo(null, sqlname);
}
public String getSQL(String sqlname) {
return getSQL(null, sqlname);
}
public Map getMapSQLs(String sqlname) {
return getMapSQLs(getDBName(sqlname), sqlname);
}
public Map getMapSQLs(String dbname, String sqlname) {
Map sqls = sqlcontext.getMapProperty(sqlname);
if (sqls == null) {
String dbtype = SQLManager.getInstance().getDBAdapter(dbname)
.getDBTYPE();
sqls = sqlcontext.getMapProperty(sqlname + "-"
+ dbtype.toLowerCase());
}
if (sqls == null) {
sqls = sqlcontext.getMapProperty(sqlname + "-default");
}
return sqls;
}
/**
*
* @param dbname
* @param sqlkey
* @param rsmetadata
* @return
* @throws SQLException
*/
public PoolManResultSetMetaData getPoolManResultSetMetaData(JDBCPool db, String dbname, String sqlkey, ResultSetMetaData rsmetadata) throws SQLException
{
return this.cache.getPoolManResultSetMetaData(true,db,dbname, sqlkey, rsmetadata);
}
public List getListSQLs(String sqlname) {
return getListSQLs(getDBName(sqlname), sqlname);
}
public List getListSQLs(String dbname, String sqlname) {
List sqls = sqlcontext.getListProperty(sqlname);
if (sqls == null) {
String dbtype = SQLManager.getInstance().getDBAdapter(dbname)
.getDBTYPE();
sqls = sqlcontext.getListProperty(sqlname + "-"
+ dbtype.toLowerCase());
}
if (sqls == null) {
sqls = sqlcontext.getListProperty(sqlname + "-default");
}
return sqls;
}
public Set getSetSQLs(String sqlname) {
return getSetSQLs(getDBName(sqlname), sqlname);
}
public Set getSetSQLs(String dbname, String sqlname) {
Set sqls = sqlcontext.getSetProperty(sqlname);
if (sqls == null) {
String dbtype = SQLManager.getInstance().getDBAdapter(dbname)
.getDBTYPE();
sqls = sqlcontext.getSetProperty(sqlname + "-"
+ dbtype.toLowerCase());
}
if (sqls == null) {
sqls = sqlcontext.getSetProperty(sqlname + "-default");
}
return sqls;
}
/**
* @return the sqlcontext
*/
public BaseApplicationContext getSqlcontext() {
return sqlcontext;
}
/**
* @return the refresh_interval
*/
public long getRefresh_interval() {
return refresh_interval;
}
public static List getSQLFiles()
{
Iterator it = sqlutils.keySet().iterator();
List files = new ArrayList();
while(it.hasNext())
files.add(it.next());
return files;
}
public static GloableSQLUtil getGlobalSQLUtil() {
if(globalSQLUtil != null)
return globalSQLUtil;
synchronized (GloableSQLUtil.class){
if(globalSQLUtil != null)
return globalSQLUtil;
globalSQLUtil = new GloableSQLUtil(SQLUtil.defaultGloableResultMetaCacheSize,
SQLUtil.defaultMaxGloableTemplateCacheSize,
SQLUtil.defaultGlobalKeySqlStructionCacheSize,
SQLUtil.defaultAlwaysCache);
}
return globalSQLUtil;
}
public boolean fromConfig() {
return this.sqlcontext != null;
}
}
© 2015 - 2024 Weber Informatics LLC | Privacy Policy