lrenwang博客

//iostream 库的基础是两种命名为 istream 和 ostream 的类型，分别表示输入流和输出流。流是指要从某种 IO 设备上读入或写出的字符序列
#include <iostream>
//主函数必有
int main()
{
  // cin输入
  // cout输出
  // endl 是一个特殊值，称为操纵符，将它写入输出流时，具有输出换行的效果，并刷新与设备相关联的缓冲区。通过刷新缓冲区，用户可立即看到写入到流中的输出。
  std::cout << "Enter two numbers:" << std::endl;
  int v1, v2;
  std::cin >> v1 >> v2;
  std::cout << "The sum of " << v1 << " and " << v2
      << " is " << v1 + v2 << std::endl;

  //如果不写这个,窗口直接关闭
  std::cin >> v1 >> v2;
  return 0;
}

<?php
/**
* demo
*/

$doc = array (
   array ("哈哈", "测试哦", "12313123"),
   array ("Marlene", "Lucy", "Lina"),
   array ("哈哈", "测试哦", "12313123"),
   array ("Marlene", "Lucy", "Lina"),
);

$m = excel::get_xml('测试下载',$doc);

/**
* excel下载
*
*/
class excel
{

  /**
     * Header of excel document (prepended to the rows)
     *
     * Copied from the excel xml-specs.
     *
     * @access private
     * @var string
     */
  static private $header = "<?xml version=\"1.0\" encoding=\"UTF-8\"?\>
<Workbook xmlns=\"urn:schemas-microsoft-com:office:spreadsheet\"
xmlns:x=\"urn:schemas-microsoft-com:office:excel\"
xmlns:ss=\"urn:schemas-microsoft-com:office:spreadsheet\"
xmlns:html=\"http://www.w3.org/TR/REC-html40\">";

  /**
     * Footer of excel document (appended to the rows)
     *
     * Copied from the excel xml-specs.
     *
     * @access private
     * @var string
     */
  static private $footer = "</Workbook>";

  /**
     * Document lines (rows in an array)
     *
     * @access private
     * @var array
     */
  static private $lines = array ();

  /**
     * Worksheet title
     *
     * Contains the title of a single worksheet
     *
     * @access private
     * @var string
     */
  static private $worksheet_title = "Table1";

  /**
     * Add a single row to the $document string
     *
     * @access private
     * @param array 1-dimensional array
     * @todo Row-creation should be done by $this->addArray
     */
  static private function addRow ($array)
  {

    $cells = "";
    foreach ($array as $k => $v):

    $cells .= "<Cell><Data ss:Type=\"String\">" . $v. "</Data></Cell>\n";

    endforeach;

    self::$lines[] = "<Row>\n" . $cells . "</Row>\n";

  }

  /**
     * Add an array to the document
     *
     * This should be the only method needed to generate an excel
     * document.
     *
     * @access public
     * @param array 2-dimensional array
     * @todo Can be transfered to __construct() later on
     */
  static function addArray ($array)
  {

    // run through the array and add them into rows
    foreach ($array as $k => $v):
    self::addRow ($v);
    endforeach;

  }

  /**
     * Set the worksheet title
     *
     * Checks the string for not allowed characters (:\/?*),
     * cuts it to maximum 31 characters and set the title. Damn
     * why are not-allowed chars nowhere to be found? Windows
     * help's no help...
     *
     * @access public
     * @param string $title Designed title
     */
  static function setWorksheetTitle ($title)
  {

    // strip out special chars first
    $title = preg_replace ("/[\\\|:|\/|\?|\*|\[|\]]/", "", $title);

    // now cut it to the allowed length
    $title = substr ($title, 0, 31);

    // set title
    self::$worksheet_title = $title;

  }

  /**
     * Generate the excel file
     *
     * Finally generates the excel file and uses the header() function
     * to deliver it to the browser.
     *
     * @access public
     * @param string $filename Name of excel file to generate (...xls)
     */
  static function generateXML ($filename)
  {

    // deliver header (as recommended in php manual)
    header("Content-Type: application/vnd.ms-excel; charset=UTF-8");
    header("Content-Disposition: inline; filename=\"" . $filename . ".xls\"");

    // print out document to the browser
    // need to use stripslashes for the damn ">"
    echo stripslashes ( self::$header);
    echo "\n<Worksheet ss:Name=\"" . self::$worksheet_title . "\">\n<Table>\n";
    echo "<Column ss:Index=\"1\" ss:AutoFitWidth=\"0\" ss:Width=\"110\"/>\n";
    echo implode ("\n", self::$lines);
    echo "</Table>\n</Worksheet>\n";
    echo self::$footer;

  }

  static function get_xml($name,$array)
  {
    self::addArray ( $array );
    self::generateXML ($name);
  }
}

?>

#!/bin/sh
/usr/local/webserver/mysql/bin/mysqldump -uroot -p123456 test>  /data/bak/sql/test_$(date -d "day" +"%Y%m%d").sql

00 17 * * * /bat/sqlbak