tomcat6+mysqlÁ¬½Ó³Ø
ÍøÉϵ½´¦ÕÒ
ÎÄÕ¶¼ÊÇÄã³ÎÒ ÎÒ³Äã¡£¡£¡£
·³ËÀÁË¡£
ÊÔÁ˼¸¸ö¶¼ÓÐÎÊÌâ¡£
ÄÄλÈÊÐÖÖ¸µ¼ÏÂСµÜ¡£¡£¶àлÁË¡£
Java code:
1.ÐèÒªµÄÎļþ:mysql-5.0.27-win32.zip(°²×°Îļþ),mysql-connector-java-5.0.4-bin.jar(Á¬½ÓÇý¶¯³ÌÐò),apache-tomcat-6.0.10.exe(°²×°Îļþ)
2.ÅäÖÃtomcatϵÄconfϵÄcontext.xmlÎļþ,ÔÚ<context></context>Ö®¼äÌí¼ÓÁ¬½Ó³ØÈçÏÂ:
1.<Resource name="jdbc/mysql"
2. auth="Container"
3.
4. type="javax.sql.DataSource"
5. driverClassName="com.mysql.jdbc.Driver"
6. url="jdbc:mysql://localhost/test"
7. username="root"
8. password="root"
9. maxActive="100"
10. maxIdle="30"
11. maxWait="10000" />
ÉÏÃæµÄ²ÎÊý²»ÓÃÎÒ˵Á˰É,ÕâЩ¶¼ÖªµÀÊÇʲôÒâ˼°É.
3.ÅäÖÃÄãµÄÓ¦ÓÃϵÄweb.xmlÖеÄ<web-app></web-app>Ö®¼ä¼ÓÈë:
xml ´úÂë
1.<resource-ref>
2. <description>DB Connection</description>
3. <res-ref-name>jdbc/mysqlx</res-ref-name>
4. <res-type>javax.sql.DataSource</res-type>
5. <res-auth>Container</res-auth>
6. </resource-ref>
4.´ó¹¦¸æ³É,²»ÓÃÔÚÔÀ´µÄserver.xmlÀïÃæÅäÖÃÁË,ÏÂÃæ¾Í¿ÉÒÔ±àд²âÊÔ³ÌÐòÁË,Õâ¸öÍøÉϾͺܶàÁË,Ö÷ÒªµÄ¾
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
ÓÐÒ»¸öjsÎļþ£¬ÊÇʵÏÖÎÄ×Ö¹ö¶¯µÄ£¬ÆäÖеıäÁ¿ÐèÒªµ½mysqlÊý¾Ý¿âÖжÁÈ¡£¬ÄÇôÔõÑùʵÏÖÊý¾Ý¿âÁ¬½Ó¶ø¶ÁÈ¡Êý¾Ý£¿
ÎÒÊDzËÄñ£¬×îºÃÓÐÍêÕûµÄ´úÂëºÍ½âÊÍ£¬Ð»Ð»¸÷λ´óϺ°¡°¡°¡°¡°¡°¡£¡£¡£¡
http://blog.csdn.net/jemlee2002 ......
±íÁÐ×Ö¶ÎÔÚÎÞÖµµÄÇé¿öÏÂ
ĬÈÏֵΪnullºÃ,»¹Êǿհ×ÖµºÃÄØ?
1)¶ÔÊý¾Ý²åÈë/²éѯ/µÄÓ°ÏìÈçºÎ?
2)¶Ô¸ÃÁнøÐÐË÷Òý,»áÓв»Í¬µÄЧÓÃô?
´ó¼ÒÒ»°ã¶Ô±êÌâ×ֶεÄλÊýÉèΪ¶àÉÙ?256
ÕýÎÄ×ֶεÄ?text?
¼¸Ç§ÍòÌõµÄÊý¾Ý´æ´¢,Òª ......