mysqlÁ¬½Ó³¬Ê±
¿ò¼ÜÓõÄÊÇssi
dataSourceÅäÖÃÎļþ
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName">
<value>com.mysql.jdbc.Driver </value>
</property>
<property name="url">
<value>jdbc:mysql://192.168.0.108:3306/restaurant
</value>
</property>
<property name="username">
<value>root </value>
</property>
<property name="password">
<value>root </value>
</property>
<!-- Á¬½Ó³ØÆô¶¯Ê±µÄ³õʼֵ -->
<property name="initialSize" value="10" />
<!-- Á¬½Ó³ØµÄ×î´óÖµ -->
<property name="maxActive" value="1000" />
<!-- ×î´ó¿ÕÏÐÖµ£¬µ±¾¹ýÒ»¸ö¸ß·åÆÚºó£¬Á¬½Ó³Ø¿ÉÒÔÂýÂý½«ÒѾÓò»µ½µÄÁ¬½Ó½øÐÐÊÍ·Å£¬Ò»Ö±´ïµ½maxIdelΪֹ -->
<property name="maxIdle" value="100" />
<!-- ×îС¿ÕÏÐÖµ£¬µ±¿ÕÏеÄÁ¬½ÓСÓÚ·§ÖµÊ±£¬Á¬½Ó³Ø»áÈ¥Ô¤ÉóһЩÁ¬½Ó£¬ÒÔÃâºé·åÀ´Ê±À´²»¼°È¥ÉêÇë -->
<property name="minIdle" value="105" />
</bean>
×òÌ컹ºÃµÄ½ñÌìÁ¬½Ó¾Í³¬Ê±ÁË
±¨´í
org.apache.commons.dbcp.SQLNestedExc
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡¡µ½µ×¸Ãզд°¡
Íò·Ö¸Ðл£¡
String SQL=&q ......
100215 9:55:47 [Warning] Aborted connection 247 to db: 'gases' user: 'root' host: 'localhost' (Got an error reading communication packets)
100215 9:55:47 [Warning] Aborted connection 257 to db: 'ga ......