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

apache tomcat mysql ¸ºÔØÆ½ºâºÍ¼¯Èº¼¼Êõ

¹«Ë¾¿ª·¢ÁËÒ»¸öÍøÕ¾£¬¹À¼Æ×î¸ßÔÚÏßÈËÊýÊÇ3 Íò£¬²¢·¢ÈËÊý×î¶à100 ÈË¡£¿ª·¢µÄÍøÕ¾ÊÇ·ñÄÜ·ñ³ÐÊÜÕâ¸öѹÁ¦£¬ÈçºÎÈ·±£ÍøÕ¾µÄ¸ººÉûÓÐÎÊÌ⣬¾­¹ýÑо¿¾ö¶¨ÈçÏ£º
£¨1 £©²ÉÓøºÔØÆ½ºâºÍ¼¯Èº¼¼Êõ£¬³õ²½»ú¹¹²ÉÓÃApache Tomcat µÄ»úȺ¼¼Êõ¡£
£¨2 £©²ÉÓÃѹÁ¦²âÊÔ¹¤¾ß£¬²âÊÔѹÁ¦¡£¹¤¾ßÊÇLoadrunner.
Ó²¼þ»·¾³´î½¨£º
ΪÁËÄܹ»½øÐÐѹÁ¦²âÊÔ£¬ÐèÒª´î½¨Ò»¸ö»·¾³¡£¸Õ¿ªÊ¼Ê±£¬²âÊÔÔÚ¹«Ë¾¾ÖÓòÍøÄÚ½øÐУ¬µ«ºÜ¿ì·¢ÏÖÁËÒ»¸öÎÊÌ⣬¼´Ò»¸ö½Å±¾µÄѹÁ¦²âÊÔ½á¹ûÿ´Î¶¼²»Ò»Ñù£¬²¢ÇÒ²î±ðºÜ´ó¡£Ô­À´ÊÇÊܹ«Ë¾ÍøÂçµÄÓ°Ï죬ÓÚÊǾö¶¨´î½¨Ò»¸öÍêÈ«¸ôÀëµÄ¾ÖÓòÍø²âÊÔ¡£´î½¨ºóµÄ¾ÖÓòÍøÅäÖÃÈçÏ£º
£¨1£© ÍøÂçËÙ¶È£º100M
£¨2£© Èý̨
·þÎñÆ÷
£º
¸ºÔØ
·þÎñÆ÷
£º²Ù×÷ϵͳwindows2003£¬
Tomcat·þÎñÆ÷£º²Ù×÷ϵͳwindows2000 Professional
Êý¾Ý¿â·þÎñÆ÷£º²Ù×÷ϵͳwindows2000 Professional
Èý̨»úÆ÷µÄcpu 2.4 G, ÄÚ´æ 1G¡£
Èí¼þ»·¾³´î½¨£º
Èí¼þµÄ°æ±¾ÈçÏ£º
Apache °æ±¾£º2.054£¬
Tomcat5.0.30,
mysql £º4.1.14.
JDK1.5
ѹÁ¦²âÊÔ¹¤¾ß£ºLoadrunner7.8¡£
¸ºÔØÆ½ºâ·½°¸ÈçÏ£º
һ̨»úÆ÷£¨²Ù×÷ϵͳ2003£©°²×°apache£¬×÷Ϊ¸ºÔØ·þÎñÆ÷£¬²¢°²×°tomcat×÷Ϊһ¸öworker£»Ò»¸öµ¥¶À°²×°tomcat£¬×÷ΪµÚ¶þ¸öworker£»Ê£ÏµÄһ̨µ¥¶À×÷ΪÊý¾Ý¿â·þÎñÆ÷¡£
ApacheºÍtomcatµÄ¸ºÔØÆ½ºâ²ÉÓÃJK1.2.14£¨Ã»ÓвÉÓÃ2.0£¬Ö÷ÒªÊÇ2.0²»ÔÙά»¤ÁË£©¡£
¼¯Èº·½°¸£º
²ÉÓÃTomcat±¾ÉíµÄ¼¯Èº·½°¸¡£ÔÚserver.xmlÅäÖá£
ѹÁ¦²âÊÔÎÊÌ⣺
ѹÁ¦²âÊԺ󣬷¢ÏÖÁËһЩÎÊÌ⣬ÏÖÒ»Ò»ÁгöÀ´£º
£¨1£© ²ÉÓÃTocmat¼¯Èººó£¬ËٶȱäµÃºÜÂý¡£ÒòΪ¼¯Èººó£¬Òª½øÐÐsession¸´ÖÆ£¬µ¼ÖÂËٶȽÏÂý¡£TomcatdµÄ¸´ÖÆ£¬Ä¿Ç°²»Ö§³Öapplication¸´ÖÆ¡£¸´ÖƵÄ×÷Óã¬Ö÷ÒªÓÃÀ´ÈÝ´íµÄ£¬¼´Ò»Ì¨»úÆ÷ÓйÊÕϺó£¬apache¿ÉÒÔ°ÑÇëÇó×Ô¶¯×ª·¢µ½ÁíÍâÒ»¸ö»úÆ÷¡£ÔÚÈÝ´íºÍËٶȵĿ¼ÂÇÉÏ£¬ÎÒÃÇ×îÖÕÑ¡ÔñËÙ¶È£¬È¥µôÁËTomcat¼¯Èº¡£
£¨2£© ²Ù×÷ϵͳ×î´ó²¢·¢Óû§µÄÏÞÖÆ£º
ΪÁ˲ÉÓÃÍøÕ¾µÄѹÁ¦£¬ÎÒÃÇ¿ªÊ¼µÄʱºò£¬½ö²âÊÔTomcatµÄ×î´ó¸ºÔØÊý¡£Tomcat·þÎñÆ÷°²×°µÄ²Ù×÷ϵͳÊÇwindows2000 Professional¡£µ±ÎÒÃÇÓÃѹÁ¦²âÊÔ¹¤¾ß£¬²¢·¢²âÊÔʱ£¬·¢ÏÖÖ»Òª³¬¹ý15¸ö²¢·¢Óû§£¬»á¾­³£³öÏÖÎÞ·¨Á¬½Ó·þÎñÆ÷µÄÇé¿ö¡£¾­¹ýÑо¿£¬·¢ÏÖÊDzÙ×÷ϵͳµÄÎÊÌ⣺windows2000 Professional Ö§³ÖµÄ²¢·¢·ÃÎÊÓû§ÓÐÏÞ£¬Ä¬ÈϵĺÃÏñÊÇ15¸ö¡£ÓÚÊÇÎÒÃǰѲÙ×÷ϵͳȫ²¿²ÉÓÃwindows2003 server°æ±¾¡£
£¨3£© Êý¾Ý¿âÁ¬½Ó³ØµÄÎÊÌ⣺
²âÊÔÊý¾Ý¿âÁ¬½ÓÐÔÄÜʱ£¬·¢ÏÖÊý¾Ý¿âÁ¬½ÓËٶȺÜÂý¡£Ã¿Ôö¼ÓһЩÓû§£¬Á¬½ÓÐÔÄܾͲîÁ˺ܶ


Ïà¹ØÎĵµ£º

JAVAµ÷ÓÃMYSQL´æ´¢¹ý³Ì

JAVAµ÷ÓÃMYSQL´æ´¢¹ý³Ì
¹¤³ÌÊÓͼ£º
´úÂëÇåµ¥£º
myconn.java
package org.apache.sh_mysql.test;
import java.sql.*;
public class MyConn {

private static final String DRIVER = "com.mysql.jdbc.Driver";
private static final String URL = "jdbc:mysql://localhost/test?useUnicode=true&characterEn ......

MySQL×Ö·û´®º¯ÊýµÄÓ¦ÓÃÓë×¢ÒâÊÂÏî

MySQL×Ö·û´®º¯ÊýµÄÓ¦ÓÃÓë×¢ÒâÊÂÏî
 
ÒÔϵÄÎÄÕÂÖ÷ÒªÏò´ó¼ÒÃèÊöµÄÊÇMySQL×Ö·û´®º¯ÊýµÄʵ¼ÊÓ¦ÓÃÓëÆäʵ¼Ê²Ù×÷´úÂëµÄÃèÊö£¬Í¬Ê±±¾ÎÄ»¹¶ÔÆäÔÚʵ¼ÊÓ¦ÓÃÖУ¬Ò»Ð©ÖµµÃÎÒÃÇ´ó¼Ò×¢ÒâµÄÏà¹ØÊÂÏîµÄÃèÊö£¬ÒÔϾÍÊÇÎÄÕµÄÖ÷ÒªÄÚÈÝÃèÊö£¬ÍûÄã»áÓÐËùÊÕ»ñ¡£
 
CHARSET(str)  ·µ»Ø×Ö´®×Ö·û¼¯
 
CONCAT (string2 [,& ......

OracleµÄNVL()º¯ÊýºÍMySQLÖеÄIfNull()º¯Êý

MS SQL ÖеÄIsNull()º¯Êý£º
IsNull ( check_expression , replacement_expression )
check_expression: ¿ÉÒÔÊÇÈκÎÀàÐÍ,½«Òª¼ì²éµÄ±í´ïʽ  ²»Îª¿Õ£¬·µ»ØËü
replacement_expression: ÀàÐͱØÐëºÍcheck_expressionÏàͬ£¬check_expressionΪnull£¬·µ»ØËü
Õâ¸öº¯ÊýµÄ×÷ÓþÍÊÇ£ºÅжÏcheck_expressionÊÇ·ñΪ¿Õ£¬Îª¿Õ¾Í·µ» ......

MySQL Master Slave Replication

MySQL±¾ÉíûÓÐÌṩreplication failoverµÄ½â¾ö·½°¸(¼ûHow can I use replication to provide redundancy or high availability?)
ÈçºÎʹReplication·½°¸¾ßÓÐHA£¿
´ð°¸ÊÇMMM(MySQL Master-Master Replication Manager)
MMM¶ÔMySQL Master-Slave Replication¾ø¶ÔÊÇÒ»¸öºÜÓÐÒæµÄ²¹³ä!
ÒýÑÔ
Master-SlaveµÄÊý¾Ý¿â»ú¹¹ ......

½â¾öÖÐÎÄ´æÈëMySql³öÏÖÂÒÂëÎÊÌâ

½â¾ö°ì·¨£ºÔÚÁ¬½Ó×Ö·û´®ÖÐ˵Ã÷Á¬½Ó×Ö·ûµÄÊôÐÔ£¬È磺
    <add name="server_mysql" connectionString="server=127.0.0.1;user id=root; password=123; database=baiduemail; pooling=false;charset=gbk"/>
»òÕßÊÇ;charset=gb2312
ÁíÍâ×¢Ò⣺ÔÚ´´½¨mysqlÊý¾Ý¿âµÄ±íµÄʱºòÑ¡Ôñ±àÂ뼯gbk ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ