|

java 学习英语

throw new IllegalStateException("Could not load 'ContextLoader.properties': " + ex.getMessage());

long elapsedTime = System.currentTimeMillis() - startTime;
                logger.info("Root WebApplicationContext: initialization completed in " + elapsedTime + " ms");

固定链接 | 评论: 0 | 引用: 0 | 查看次数: 36

mysql 存储过程

/* 2013-06-20 创建附件表存储过程  */
/* begin of added by zhugexh for prc_create_table_attachment 2013-07-11 */
DELIMITER $$
Drop PROCEDURE IF EXISTS `prc_create_table_attachment`$$
Create PROCEDURE `prc_create_table_attachment`(mdate varchar(6))
BEGIN
    declare attachment_table_name varchar(32);
    declare attachment_index_name varchar(64);
    declare db_name varchar(32);
    SET @db_name = DATABASE();
    SET @attachment_table_name = concat('base_attachment_info_', mdate);
    SET @tableSql = concat("create table if not exists ",@attachment_table_name,
                           " (`attach_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '附件编号:非空,主键',
                              `object_type` int(11) NOT NULL COMMENT '对象类型:非空,联合索引1,1-签约用户申请',
                              `object_id` bigint(20) NOT NULL COMMENT '对象编号:非空,联合索引1',
                              `file_name` varchar(128) NOT NULL COMMENT '文件名:非空',

固定链接 | 评论: 0 | 引用: 0 | 查看次数: 41

mysql 事件

/* begin of added by zhugexh for event_create_table_attachment 2013-07-11 */
DELIMITER $$
SET GLOBAL event_scheduler = ON$$
Drop EVENT IF EXISTS `event_create_table_attachment`$$
Create    EVENT `event_create_table_attachment`
ON SCHEDULE    
   EVERY 1 YEAR
   STARTS '2013-12-25 03:52:59'
ON COMPLETION PRESERVE ENABLE

DO
  BEGIN
    call prc_create_table_nextyear_attachment();
  END$$
DELIMITER ;
/* end of added by zhugexh for event_create_table_attachment 2013-07-11 */

固定链接 | 评论: 0 | 引用: 0 | 查看次数: 48