ÈçºÎͨ¹ýPHP½«excelµÄÊý¾Ýµ¼ÈëMySQLÖÐ
ÈçºÎͨ¹ýPHP½«excelµÄÊý¾Ýµ¼ÈëMySQLÖÐ
ÔÚ¿ª·¢PHP³ÌÐòʱ£¬ºÜ¶àʱºòÎÒÃÇ»áÓн«Êý¾ÝÅúÁ¿µ¼ÈëÊý¾Ý¿âµÄÐèÇó£¬ÈçѧÉúÐÅÏ¢ÅúÁ¿Ìí¼Óµ½Êý¾Ý¿âÖУ¬¶øÊÂÏÈÓÃexcel±àÅźã¬¶ÔexcelʵÐвÙ×÷£¬±ãÊÇÎÒÃDZȽϳ£ÓõÄÑ¡Ôñ·½Ê½¡£
ÔÚ¶ÔexcelµÄ²Ù×÷ÖУ¬phpExcelReade±ãÊǺܶàÈ˵Ĺ²Í¬Ñ¡Ôñ¡£ÔÚ¾ßÌåʵÏÖÖУ¬ÎÒÃÇ¿ÉÒÔÒÔÎļþÉÏ´«·½Ê½½«excelÎļþÉÏ´«µ½·þÎñÆ÷ÖеÄij¸öλÖã¬Í¨¹ýÒÔϲÙ×÷½«excelÖеÄÊý¾Ýµ¼Èëµ½Êý¾Ý¿âºó£¬ÔÚ½«ÉÏ´«µÄÎļþɾ³ý¼´¿É¡£
´úÂëÈçÏ£º
$dir=dirname(__FILE__); //»ñÈ¡µ±Ç°½Å±¾µÄ¾ø¶Ô·¾¶
$dir=str_replace("\\","/",$dir)."/";
$filename='uploadFile.xls'; //¿ÉÒÔ¶¨ÒåÒ»¸öÉÏ´«ºóµÄÎļþÃû³Æ
$result=move_uploaded_file($_FILES['upload']['tmp_name'],$dir.$filename);//¼ÙÈçÉÏ´«µ½µ±Ç°Ä¿Â¼ÏÂ
if($result) //Èç¹ûÉÏ´«Îļþ³É¹¦£¬¾ÍÖ´Ðе¼Èëexcel²Ù×÷
{
require_once 'phpExcelReader/Excel/reader.php';
$data = new Spreadsheet_Excel_Reader();
$data->setOutputEncoding('utf-8');//ÉèÖÃÔÚÒ³ÃæÖÐÊä³öµÄ±àÂ뷽ʽ,¶ø²»ÊÇutf8
//¸Ã·½·¨»á×Ô¶¯ÅжÏÉÏ´«µÄÎļþ¸ñʽ£¬²»·ûºÏÒªÇó»áÏÔʾ´íÎóÌáʾÐÅÏ¢(´íÎóÌáʾÐÅÏ¢Ôڸ÷½·¨ÄÚ²¿)¡£
$data->read("$filename"); //¶ÁÈ¡ÉÏ´«µ½µ±Ç°Ä¿Â¼ÏÂÃû½Ð$filenameµÄÎļþ
error_reporting(E_ALL ^ E_NOTICE);
//Èç¹ûexcel±í´ø±êÌ⣬Ôò´Ó$i=2¿ªÊ¼£¬È¥µôexcel±íÖеıêÌⲿ·Ö(Òª½«$i<=¸ÄΪ$i<·ñÔò»á²åÈëÒ»Ìõ¶àÓàµÄ¿ÕÊý¾Ý)
for ($i = 2; $i < $data->sheets[0]['numRows']; $i++)
{
$sql = "INSERT INTO user (stuid,class,name,sex,classNum,tel,addr,remark)
Ïà¹ØÎĵµ£º
ÏÖÔÚÔÚWEB Ó¦ÓÃÖÐʹÓ÷ÖÒ³¼¼ÊõÔ½À´Ô½ÆÕ±éÁË£¬ÆäÖÐÀûÓÃÊý¾Ý¿â²éѯ·ÖÒ³ÊÇÒ»ÖÖЧÂʱȽϸߵķ½·¨£¬
ÏÂÃæÁгöÁËOracle, DB2 ¼° MySQL ·ÖÒ³²éѯд·¨¡£
Ò»£ºOracle
select * from (select rownum,name from table where rownum <=endIndex )
where rownum > startIndex
¶þ£ºDB2
DB2·ÖÒ³²éѯ
SELECT * ......
¡¡¡¡ÓÃC++²Ù×÷MySQLÊý¾Ý¿âÀࣺ
¡¡¡¡×¢ÊÍ£ºÕ⼸¸öÀà¶Ô´¦Àí²»ÊǺܴóÊý¾ÝÁ¿µÄ²Ù×÷ÊǺÜÀíÏëµÄ£¬ µ«²»ÊÊÒËÌØ´óÐ͵ÄÊý¾ÝµÄ²éѯ£¬ÒòΪԴÂëÖн«²éѯµ½µÄÊý¾ÝÖ±½Ó·ÅÈëÁËÄÚ´æ¡£
¡¡¡¡/*
¡¡¡¡* project:
¡¡¡¡* ͨÓÃÄ£¿é ( Óà c++ ´¦Àí mysql Êý¾Ý¿âÀ࣬ÏñADO )
¡¡¡¡*
¡¡¡¡* description:
¡¡¡¡*
¡¡¡¡* ͨ¹ýDataBase,Reco ......
1.CMDÃüÁîÐÐÏÂÇл»µ½ mysql°²×°Ä¿Â¼ÏµÄbinĿ¼
ÀýÈç:cd D:\program\study\mysql\bin>
2. D:\program\study\mysql\bin> mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > sqlÎļþ´æ·Å·¾¶ºÍÃû³Æ
D:\program\study\mysql\bin>mysqldump -u root -p oa > D:\oa.sql
3.ÊäÈëÃÜÂë
4.ÉÔ΢µÈ´ýƬ¿Ì(Êý¾Ý¿â½Ï´óµÈ´ýʱ¼ä¿ÉÄ ......
LOCK TABLES/UNLOCK TABLES ¾ä·¨
LOCK TABLES tbl_name [AS alias] {READ [LOCAL] | [LOW_PRIORITY] WRITE}
[, tbl_name [AS alias] {READ [LOCAL] | [LOW_PRIORITY] WRITE} ...]
...
UNLOCK TABLES
LOCK TABLES Ϊµ±Ç°Ïß³ÌËø¶¨±í¡£UNLOCK TABLES Êͷŵ±Ç°Ïß³ÌÓµÓеÄËùÓÐËø¶¨¡£µ±Ï̷߳¢³öÁíÒ»¸ö LOCK TABLES£¬»òµ±Óë·þ ......