语源科技BlogJava-cbtprohttp://www.blogjava.net/cbtpro/zh-cnMon, 13 Apr 2026 08:54:17 GMTMon, 13 Apr 2026 08:54:17 GMT60trigger http://www.blogjava.net/cbtpro/archive/2011/09/07/358198.html陈碧滔陈碧滔Wed, 07 Sep 2011 08:45:00 GMThttp://www.blogjava.net/cbtpro/archive/2011/09/07/358198.htmlhttp://www.blogjava.net/cbtpro/comments/358198.htmlhttp://www.blogjava.net/cbtpro/archive/2011/09/07/358198.html#Feedback0http://www.blogjava.net/cbtpro/comments/commentRss/358198.htmlhttp://www.blogjava.net/cbtpro/services/trackbacks/358198.htmlcreate or replace trigger pm4h_hw_db.t_get_sys_bhstore
  after insert on pm4h_ad.sys_bhstore
declare
  pragma autonomous_transaction;
  tablename varchar2(64);
  cursor cr is
    select bhtable from pm4h_ad.sys_bhstore where bhmodelid = 'TODBH';
begin
  open cr;
  fetch cr
    into tablename;
  while cr%found loop
    if fun_is_exists_table(tablename) = 0 then
      pm4h_hw_db.create_bh_table(tablename);
    end if;
    fetch cr
      into tablename;
  end loop;
  close cr;
end pm4h_hw_db.t_get_sys_bhstore;

陈碧滔 2011-09-07 16:45 发表评论
]]>不使用spring读取ApplicationContet.xml文件中数据库配置http://www.blogjava.net/cbtpro/archive/2011/09/06/358145.html陈碧滔陈碧滔Tue, 06 Sep 2011 14:00:00 GMThttp://www.blogjava.net/cbtpro/archive/2011/09/06/358145.htmlhttp://www.blogjava.net/cbtpro/comments/358145.htmlhttp://www.blogjava.net/cbtpro/archive/2011/09/06/358145.html#Feedback0http://www.blogjava.net/cbtpro/comments/commentRss/358145.htmlhttp://www.blogjava.net/cbtpro/services/trackbacks/358145.html实现方法如下
配置一个struts监听器，
实现ServletContextListener接口
public class HuaweiDBListener implements ServletContextListener {

}
实现接口中方法
public void contextInitialized(ServletContextEvent context) {
    String serverPath = context.getServletContext().getRealPath("/"); 
    ApplicationContext appC= new FileSystemXmlApplicationContext(serverPath + "WEB-INF\\spring\\applicationContext.xml"); 
    ComboPooledDataSource c = (ComboPooledDataSource) appC.getBean("dataSource"); 
    System.out.println("DriverClass=="+ c.getDriverClass());
}


使用ComboPooledDataSource对象直接从ApplicationContet.xml中得到数据源配置。



陈碧滔 2011-09-06 22:00 发表评论
]]>开始写bolghttp://www.blogjava.net/cbtpro/archive/2011/09/06/358144.html陈碧滔陈碧滔Tue, 06 Sep 2011 13:53:00 GMThttp://www.blogjava.net/cbtpro/archive/2011/09/06/358144.htmlhttp://www.blogjava.net/cbtpro/comments/358144.htmlhttp://www.blogjava.net/cbtpro/archive/2011/09/06/358144.html#Feedback0http://www.blogjava.net/cbtpro/comments/commentRss/358144.htmlhttp://www.blogjava.net/cbtpro/services/trackbacks/358144.html

陈碧滔 2011-09-06 21:53 发表评论
]]>