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

MySQL Master/SlaveÊý¾Ý¿â¶Áд²Ù×÷Àà

Êý¾Ý¿â²Ù×÷ÀࣺDBCommon.class.php
//---------------------------------------------------------------------
// MySQL Master/SlaveÊý¾Ý¿â¶Áд²Ù×÷Àà
//
// ¿ª·¢×÷Õß: heiyeluren
// °æ±¾ÀúÊ·:
// 2006-09-20 »ù±¾µ¥Êý¾Ý¿â²Ù×÷¹¦ÄÜ, 25 ¸ö½Ó¿Ú
// 2007-07-30 Ö§³Öµ¥Master/¶àSlaveÊý¾Ý¿â²Ù×÷£¬29¸ö½Ó¿Ú
// 2008-09-07 ÐÞÕýÁËÉÏÒ»°æ±¾µÄ²¿·ÖBug
// 2009-11-17 ÔÚMaster/SlaveÀàµÄ»ù´¡ÉÏÔö¼ÓÁËÇ¿»¯µ¥Ö÷»ú²Ù×÷£¬
// Ôö¼ÓÁ˲¿·Ö¼ò½à²Ù×÷½Ó¿ÚºÍµ÷ÊÔ½Ó¿Ú£¬ÓÅ»¯Á˲¿·Ö´úÂ룬
// ±¾°æ±¾¹²42¸ö½Ó¿Ú
// Ó¦ÓÃÏîÄ¿: Y!NCP, Y!SNS, TM MiniSite//
// ¹¦ÄÜÃèÊö£º×Ô¶¯Ö§³ÖMaster/Slave ¶Á/д ·ÖÀë²Ù×÷£¬Ö§³Ö¶àSlaveÖ÷»ú
//
//-----------------------------------------------------------------------



/**
* ³£Á¿¶¨Òå
*/
define("_DB_INSERT", 1);
define("_DB_UPDATE", 2);


/**
* DB Common class
*
* ÃèÊö£ºÄܹ»·Ö±ð´¦Àíһ̨Masterд²Ù×÷£¬¶ą̀Slave¶Á²Ù×÷
*/
class DBCommon
{
/**
* Êý¾Ý¿âÅäÖÃÐÅÏ¢
*/
var $wdbConf = array();
var $rdbConf = array();
/**
* MasterÊý¾Ý¿âÁ¬½Ó
*/
var $wdbConn = null;
/**
* SlaveÊý¾Ý¿âÁ¬½Ó
*/
var $rdbConn = array();
/**
* µ±Ç°²Ù×÷µÄÊý¾Ý¿âÁ´½Ó
*/
var $currConn = null;
/**
* ÊÇ·ñÖ»ÓÐһ̨MasterÊý¾Ý¿â·þÎñÆ÷
*/
var $singleHost = true;
/**
* Êý¾Ý¿â½á¹û
*/
var $dbResult;
/**
* Êý¾Ý¿â²éѯ½á¹û¼¯
*/
var $dbRecord;

/**
* SQLÓï¾ä
*/
var $dbSql;
/**
* Êý¾Ý¿â±àÂë
*/
var $dbCharset = "UTF8";
/**
* Êý¾Ý¿â°æ±¾
*/
var $dbVersion = "5.0";


/**
* ³õʼ»¯µÄʱºòÊÇ·ñÒªÁ¬½Óµ½Êý¾Ý¿â
*/
var $isInitConn = false;


Ïà¹ØÎĵµ£º

mysqlÎļþµ¼ÈëÂÒÂëÎÊÌâµÄ½â¾ö£º

mysqlÎļþµ¼ÈëÂÒÂëÎÊÌâµÄ½â¾ö£º
1 ÃüÁî²ì¿´×Ö·ûÉèÖá£
mysql> show   variables   like   "%char%";
2 ½«²»ÊÇutf-8µÄ¶¼¸Ä³Éutf8¡£Ö»ÓÐfilesystem²»±ä;
| Variable_name            | Value
   &nb ......

MyEclipse Á¬½ÓÔ¶³ÌµÄ MYSQL

mysql Êý¾Ý¿âĬÈϵÄÁ¬½ÓÖ»ÄÜÔÚ±¾»úÁ¬½Ó£¬Ô¶³ÌÁ¬½Ó±ØÐëÊÚȨ¡£
´úÂë: ȫѡ
¡¡GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%'IDENTIFIED
BY 'mypassword' WITH GRANT
OPTION;Èç¹ûÄãÏëÔÊÐíÓû§myuser´ÓipΪ192.168.1.6µÄÖ÷»úÁ¬½Óµ½mysql·þÎñÆ÷£¬²¢Ê¹ÓÃ
mypassword×÷ΪÃÜÂë
´úÂë:      GRANT ALL PR ......

mySqlÊý¾Ý¿âÁ¬½Ó

Class.forName("com.mySQL.jdbc.Driver");
   String strUrl="jdbc:mysql://localhost:3306/stu?useUnicode=true&characterEncoding=GB2312";
   String strUser="nuey";
   String strPassword="password";
   Connection conn=DriverManager.getCon ......

mysqlÖÐÎÄÅÅÐò¼°javaÖÐÎÄÅÅÐò


Ö®ËùÒÔдÕâÆª²©¿Í£¬ÊÇÒòΪǰ¼¸Ìì²ÅÅöµ½ÁËÕâôһ¸öÎÊÌ⣬ÒÔǰ»¹²»ÖªµÀmysqlÓÐÕâôһ¸öÎÊÌâ¡£
ÎÒÃǵÄϵͳʹÓÃÁËstruts+hibernate£¬Êý¾Ý¿âʹÓõÄÊÇmysql£¬×Ö·û¼¯Í³Ò»Îªutf-8¡£
±¾À´ÒѾ­Íê³ÉÁË£¬µ«ÊÇϵͳʹÓõÄʱºò£¬·¢ÏÖ²é³öÀ´µÄÈËÃûûÓÐ˳Ðò£¬±¾À´ÒÔΪºÜ¼òµ¥£¬ÔÚ²éѯµÄʱºò£¬Ö¸¶¨°´ÕÕnameÅÅÐò¾Í¿ÉÒÔÁË£¬Æñ֪ʵ¼ÊÒ»×ö²Å·¢Ï ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ