|  |  | 
 |  |  |             // 删除半年以上的历史档 | 
 |  |  |             jdbcTemplate.update("delete from asr_stk_hplc where dateadd(day,180,appe_time) <= getdate();"); | 
 |  |  |             jdbcTemplate.update("delete from asr_wrk_detl_log where dateadd(day,1080,appe_time) <= getdate();"); | 
 |  |  |             jdbcTemplate.update("delete from asr_wrk_mast_log where dateadd(day,360,appe_time) <= getdate();"); | 
 |  |  |             jdbcTemplate.update("delete from asr_wrk_mast_log where dateadd(day,1080,appe_time) <= getdate();"); | 
 |  |  |             jdbcTemplate.update("delete from cust_wait_pakin_log where dateadd(day,1080,appe_time) <= getdate();"); | 
 |  |  |  | 
 |  |  |         } catch (Exception e) { |