Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ʹÓÃJavaʵÏÖ¶ÔMySqlÊý¾Ý¿âµÄµ¼ÈëÓëµ¼³ö

package com.project.ajaxs;
import java.io.BufferedReader;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.OutputStream;
import java.io.OutputStreamWriter;
import java.util.Calendar;
import java.util.Date;
public class BakMysql {
//mainµÄ·½·¨£¬Ö÷ÒªÊÇÎÒÓÃÓÚ²âÊԵģ¬ÊÇÏë×ÅÈ¡µÃCLASSµÄ·¾¶£¬È»ºó±¸·ÝµÄÎļþдÔÚ·þÎñÆ÷µÄÀà·¾¶ÏÂ
public static void main(String[] args) {
BakMysql bk = new BakMysql();
  
        bk.backup();
    // bk.load();
     }
   //backup·½·¨ÊDZ¸·ÝÊý¾Ý¿âµ½·þÎñÆ÷µØÖ·
     public void backup() {
     Calendar now = Calendar.getInstance();
     String name = now.getTime()+""+(now.getTime().getMonth()+1)+""+now.getTime().getDate();
     String filename = name.substring(24)+" "+name.substring(11,13)+""+name.substring(14,16)+""+name.substring(17,19);
         try {
         String filePath ="e:/project"+filename+".sql";
             Runtime rt = Runtime.getRuntime();
             // µ÷Óà mysql µÄ cmd:
             Process child = rt.exec("C:/Program Files/MySQL/MySQL Server 5.0/bin/mysqldump.exe -uroot -p8095longchun project");// ÉèÖõ¼³ö±àÂëΪutf8¡£ÕâÀï±ØÐëÊÇutf8
            //×¢ÒâÕâÒ»¾ä£¬ÊÇÖ¸ÔËÐÐmysqldumpÃüÁºóÃæ¸úµÄÊǵǼÃûºÍµÇ¼µÄÃÜÂ룬½ÓןóÃæµÄÊÇÖ¸±¸·ÝµÄÊý¾Ý¿âµÄÃû×Ö£¬µ½´Ë½áÊø£¬ÒÔ´ËÉú³ÉÒ»¸öÖ´ÐеĽø³Ì£¬È¡µÃ´Ë½ø³ÌµÄÊä³öÁ÷µ½ÎÒÃÇÒª±¸·ÝµÄÎļþ
             // °Ñ½ø³ÌÖ´ÐÐÖеĿØÖÆÌ¨Êä³öÐÅϢдÈë.sq


Ïà¹ØÎĵµ£º

linux·þÎñÆ÷°²×°£¨centos5.3 apache php mysql£©

 ×î½ü×°Á˼¸´Îlinux£¬Ñ§Á˺ܶ࣬°Ñ¹ý³ÌдÏÂÀ´ÁË£¬Ï£Íû¸ø¿´µÄÈ˰ïÖú£¬Ò²¶à¸øÐ©½¨Òé¡£
Ò»¡¢Ñ¡Ôñ×îС»¯°²×°£¨Ê²Ã´Ò²²»Ñ¡£¬µ«ÊÇ»¹ÊÇÑ¡ÁËvim£©
¶þ¡¢Ê¹ÓùâÅÌ×÷ΪԴ°²×°£¨ÏêÇé²Î¼û/etc/yum.repos.d/CentOS-Media.repo£©ËùÓÃÌ×¼þ£¨Ê¹ÓÃyumµÄÇ¿´ó¹¦ÄÜ£©
####²¢²»ÊǼòµ¥µÄÓÃyumÃüÁÐèÒªÔÚyumºóÃæ¼ÓһЩ¶«Î÷£¬/etc/yum.repo ......

php±à³Ì£¬Õë¶ÔMYSQLµÄ²Ù×÷Àà

<?php
/*
*PHP¹ÜÀíMYSQLµÄÊý¾Ý¿âÀà
ʹÓ÷½·¨£º$dbConn = new DbConn([$Êý¾Ý¿âÃû(¿ÉÑ¡)]);
ÔÊÐí·µ»ØµÄ·½·¨£º
Execute($sql) //Ö´ÐÐSQLÓï¾ä£¬Ã»Óзµ»ØÖµ;
getRs($sql) //·µ»Ø²éѯÓï¾äµÄ¼Ç¼£¬Ò»Ìõ;
getRsArray($sql) //·µ» ......

Linux+Apache+Mysql+PHPÓÅ»¯¼¼ÇÉ


LAMPÕâ¸ö´ÊµÄÓÉÀ´×îÔçʼÓڵ¹úÔÓÖ¾“c't Magazine”£¬Michael KunzeÔÚ1990Äê×îÏȰÑÕâЩÏîÄ¿×éºÏÔÚÒ»Æð´´ÔìÁËLAMPµÄËõд×Ö¡£ÕâЩ×é¼þËäÈ»²¢²»ÊÇ¿ª¿ªÊ¼¾ÍÉè¼ÆÎªÒ»ÆðʹÓõ쬵«ÊÇ£¬ÕâЩ¿ªÔ´Èí¼þ¶¼¿ÉÒԺܷ½±ãµÄËæÊ±»ñµÃ²¢Ãâ·Ñ»ñµÃ¡£Õâ¾Íµ¼ÖÂÁËÕâЩ×é¼þ¾­³£ÔÚÒ»ÆðʹÓá£ÔÚ¹ýÈ¥µÄ¼¸ÄêÀÕâЩ×é¼þµÄ¼æÈÝÐÔ²»¶ÏÍêÉÆ£¬Ô ......

Apache + PHP + MySql °²×°


ËùÐèÈí¼þ£¨×¢Òâ°æ±¾£¡£©£º
Apache2.2.3 
PHP5.1.5 
MySQL5.0.24
ÕâÈý¸öÈí¼þ¶¼ÊÇÃâ·ÑµÄ£¬¿É´Ó¹ÙÍøÉÏÏÂÔØ£¬Ä¿Ç°ÎÒËùÓеÄÈí¼þÃûΪ£º
apache_2.2.3-win32-x86-no_ssl.msi 
mysql-5.0.24-win32.zip 
php-5.1.5-Win32.zip
»ùÓÚwindows²Ù×÷ϵͳ£¬ÔÚWindows XPϰ²×°Ê¹Óãº
1¡¢°²×°¹ý³Ì£º  ......

java¶ÁÐ´ËøÊµÏÖ»úÖÆ

package thread.lock;
import java.util.ArrayList;
import java.util.List;
import java.util.concurrent.locks.Lock;
import java.util.concurrent.locks.ReentrantLock;
import java.util.concurrent.locks.ReentrantReadWriteLock;
/**
 * @file_name ReadAndWriteLockDemo.java
 * @description ¶ÁÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ