<%--*该文件用于调用数据库存储过程*new2013-10-29*authoryangwentao*--%><%@pagecontentType="text/html;charset=GBK"%><%@pagelanguage="java"import="java.util.*"pageEncoding="GBK"%><%@pageimport="com.sinosoft.sysframework.reference.DBManager"%><%@pageimport="com.sinosoft.utility.SysConfig"%><%@pageimport="java.sql.Connection"%><%@pageimport="java.sql.CallableStatement"%><%@pageimport="java.text.SimpleDateFormat"%><%@pageimport="java.text.DateFormat"%><%@pageimport="java.util.Calendar"%><%@pageimport="java.util.Date"%><%@pageimport="com.sinosoft.sysframeworkmon.datatype.DateTime"%><%@pageimport="com.sinosoft.sysframework.reference.AppConfig"%><%Calendarc=Calendar.getInstance();c.set(Calendar.DATE,1);java.sql.DatereinsFirstDay=newjava.sql.Date((c.getTime()).getTime());c.add(Calendar.MONTH,1);c.set(Calendar.DAY_OF_MONTH,0);java.sql.DatereinsLastDay=newjava.sql.Date((c.getTime()).getTime());Stringcontent=reinsFirstDay.toString().substring(0,4)+"年"+reinsFirstDay.toString().substring(5,7)+"月";Stringmsg="message";DBManagerdbManager=newDBManager();try{dbManager.open(SysConfig.getProperty("DDCCDATASOURCE"));dbManager.beginTransaction();Connectionconnection=dbManager.getConnection();CallableStatementcallableStatement=connection.prepareCall("{callprc_prpdriskcodebak}");//调用自动分入清单存储过程callableStatement.execute();content+="数据同步成功";dbManagermitTransaction();}catch(Exceptione){dbManager.rollbackTransaction();content+="数据同步异常";msg="error";e.printStackTrace();}finally{dbManager.close();}%>.gif'><%=content%>