public boolean exepro(String proname) {
  DataSource logdao = (DataSource) ComponentFactory.getBean("dataSource");
  Connection con = null;
  CallableStatement csmt = null;

  try {
   con = logdao.getConnection();
   log.info("-----------kaishi"+proname);
   con.setAutoCommit(true);
   csmt = con.divpareCall(proname);
   csmt.executeUpdate();
   con.setAutoCommit(false);
   con.commit();

   log.info("-----------jieshu"+proname);
  } catch (Exception e) {
   log.error("resetRecord Error:" + e.getMessage());
   return false;
  } finally {
   if (csmt != null) {
    try {
     csmt.close();
    } catch (Exception e) {
     log.error("关闭PreparedStatement出错:" + e.getMessage());
    }
   }
   if (con != null) {
    try {
     con.close();
    } catch (Exception e) {
     log.error("关闭Connection出错:" + e.getMessage());
    }
   }
  }
  return true;
 } 

本文来源：http://blog.csdn.net/zwhfyy/archive/2007/07/09/1683251.aspx