mysqlÁ¬½Ótomcat - Java / Web ¿ª·¢
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = "">
<Resource name = "jdbc/pos" auth = "Container" type = "javax.sql.DataSource" maxActive = "100" maxIdle ="30" maxWait = "10000"
username = "root" password = "rarzyz" driverClassName = "org.gjt.mm.mysql.Driver" url = "jdbc:mysql:// localhost/test"/>
</Context>
Ò²°Ñ½Ì³Ì¹âÅÌÉϵÄweb.xmlºÍappcontext.xml¶¼¸´ÖÆÈ¥ÁË¡£µ«ÊÇ»¹ÊÇÔÚ°´Ìá½»µÇ½µÄÓû§ÃûºÍÃÜÂëÒ³Ãæºó£¬ÏÔʾhttp status 500 The server encountered an internal error () that prevented it from fulfilling this request.
org.hibernate.exception.GenericJDBCException: Cannot open connection
Õâ¸ö²»ÄÜ´ò¿ªÁ¬½ÓÌáʾ£¬ÊDz»ÊÇÌáʾÎҵijö´íÁ˰¡¡£ÎÒ¿´¹ýtomcatºÍmysql·þÎñÎÒ¶¼¿ªÁË¡£ÓôÃÆ°¡¡£Çý¶¯ÎÒÒ²¿¼µ½libÀïÃæÁË¡£ÊµÔÚ²»ÖªµÀ´íÎóÔÚÄÄÀïÁË
Ã²ËÆÕâÁ½¸ö¶¼ÓÐÎÊÌ⣺
driverClassName = "org.gjt.mm.mysql.Driver" url = "jdbc:mysql:// localhost/test"/>
Çý¶¯Ãû²»¶Ô£¬urlÉÙÁ˶˿ں𣡣¡£
public static String driver="com.mysql.jdbc.Driver"
public static String url="jdbc:mysql://localhost/mydata?user=Óû§Ãû&password=ÃÜÂë"
¿ÉÒÔ²»Òª¶Ë¿ÚºÅ
Ïà¹ØÎÊ´ð£º
ÎÊÌâÃèÊö£ºÐ´ÈÕÖ¾¹¦ÄÜ£¬Ð´ºÃµÄдÈÕÖ¾·þÎñ£¬ÆäËûÓû§Í¨¹ýhttpµ÷Ó÷þÎñ£¬´«Èë²ÎÊý£¬È»ºó¼Ç¼ÈÕÖ¾£¬
ÎҵķþÎñ¸ÃÔõôд£¬ ±ðÈËÔõôͨ¹ýhttpµ÷ÓÃÎҵķþÎñ£¬ÎÒÓÃwebserviceдºÃÁËÒ»¸ö£¬¿ÉÊDz¢·¢ÓÐÉÏÏߣ¬Ïë¸ÄÓ ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
¹¤×÷ÐèÒª Çó´ó¼Ò°ïæд¸ö³ÌÐò
ÎÒÊÇѧC++µÄ ²»¶®JAVA
±àдһ¸öJavaÓ¦ÓóÌÐò£¬¶ÔÓÚ¸ø¶¨µÄÒ»¸ö×Ö·û´®µÄ¼¯ºÏ£¬¸ñʽÈ磺
{aaa bbb ccc}£¬ {bbb ddd}£¬{eee fff}£¬{ggg}£¬{ddd hhh}
ÒªÇ󽫯äÖн»¼¯²»Îª¿ÕµÄ ......
<html><head><title>[@title]</title>
<meta http-equiv=Content-Type content="text/html; charset=gb2312">
<script language='javascript'>
function diyCheck ......