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

SpringÅäC3P0Á¬½Ó³Ø(ÒÔMySQLÊý¾Ý¿âÅäÖÃΪÀý)

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xmlns:jee="http://www.springframework.org/schema/jee"
        xsi:schemaLocation="http://www.springframework.org/schema/beans [url]http://www.springframework.org/schema/beans/spring-beans-2.0.xsdhttp://www.springframework.org/schema/jee[/url] http://www.springframework.org/schema/jee/spring-jee-2.0.xsd">
        <bean id="dataSource"
                class="com.mchange.v2.c3p0.ComboPooledDataSource"
                destroy-method="close">
                <property name="driverclass">
                        <value>com.mysql.jdbc.Driver</value>
                </property>
                <property name="jdbcUrl">
                        <value>
                                jdbc:mysql://localhost:3306/DBName?useUnicode=true&characterEncoding=GBK
                        </value>
                </property>
                   <!--MySQLÊý¾Ý¿âµÄÓû§Ãû -->
                <property name="user">
                        <value>root</value>
        &nbs


Ïà¹ØÎĵµ£º

Mysql֪ʶµã×ܽ᣺Flush privileges

mysql> flush privileges;ʲôÒâ˼£¿­
mysql> update mysql.user set password=PASSWORD('ÐÂÃÜÂë') where User='root';­
mysql> flush privileges;­
mysql> quit­
´ð:­
mysql ÐÂÉèÖÃÓû§»ò¸ü¸ÄÃÜÂëºóÐèÓÃflush privilegesË¢ÐÂMySQLµÄϵͳȨÏÞÏà¹Ø±í£¬·ñÔò»á³öÏ־ܾø·ÃÎÊ£¬»¹ÓÐÒ»ÖÖ·½· ......

MySQL showµÄÓ÷¨

a. show tables»òshow tables from database_name; // ÏÔʾµ±Ç°Êý¾Ý¿âÖÐËùÓбíµÄÃû³Æ
   b. show databases; // ÏÔʾmysqlÖÐËùÓÐÊý¾Ý¿âµÄÃû³Æ
   c. show columns from table_name from database_name; »òshow columns from database_name.table_name;   // ÏÔʾ±íÖÐÁÐÃû³Æ
   ......

¹ØÓÚCµÄ±ä³¤²ÎÊý

ijЩÇé¿öÏÂÏ£Íûº¯ÊýµÄ²ÎÊý¸öÊý¿ÉÒÔ¸ù¾ÝÐèҪȷ¶¨¡£µäÐ͵ÄÀý×ÓÓдó¼ÒÊìϤµÄº¯Êýprintf()¡¢scanf()ºÍϵͳµ÷ÓÃexecl()µÈ¡£ÄÇôËüÃÇÊÇÔõÑùʵÏÖµÄÄØ£¿C±àÒëÆ÷ͨ³£ÌṩÁËһϵÁд¦ÀíÕâÖÖÇé¿öµÄºê£¬ÒÔÆÁ±Î²»Í¬µÄÓ²¼þƽ̨Ôì³ÉµÄ²îÒ죬Ôö¼Ó³ÌÐòµÄ¿ÉÒÆÖ²ÐÔ¡£ÕâЩºê°üÀ¨va_start¡¢ va_argºÍva_endµÈ¡£
²ÉÓÃANSI±ê×¼ÐÎʽʱ£¬²ÎÊý¸öÊý¿É± ......

cÎļþ²Ù×÷£¬¼æÈݶà×Ö½ÚºÍunicode

ÔÚ<TCHAR.h>Í·ÎļþÀÓÐÕâôһ×é²Ù×÷ÎļþµÄºê
       #define _tfdopen    _wfdopen
      
#define _tfsopen    _wfsopen
      
#define _tfopen     _wfope ......

Linux°²×°Mysql+Apach+PHP+phpMyAdmin


Linux°²×°Mysql+Apach+PHP+phpMyAdmin
 
 
 ¡¡¡¡ÎÒµÄϵͳÊÇredhat as5 ½¨Òé´ó¼ÒÍêÈ«°²×°£¬ÒÔÃⰲװʱȱÉÙÏà¹ØµÄ±àÒëÆ÷µÈµÈ¡£
Ò»¡¢°²×°mysql£¨mysql-5.0.21.tar.gz£©  
# tar zxf mysql-5.0.21.tar.gz
# cd mysql-5.0.21
#./configure --prefix=/usr/local/mysql --sysconfdir=/etc --lo ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ