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=ÃÜÂë"
¿ÉÒÔ²»Òª¶Ë¿ÚºÅ
Ïà¹ØÎÊ´ð£º
<%@page language="java" contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="wang.connectDB"/>
< ......
ÎÒÏëÓÃJavaдһ¸ö³ÌÐò£¬¾ÍÊÇÎÒÏëÔÚÔËÐдúÂëºó£¬ÔÚÖ¸¶¨µÄʱ¼ä´ò¿ªÄ³³ÌÐò£¬ÀýÈçÎÒÔËÐдúÂëºó£¬½²ÔÚ12£º00´ò¿ª"D:\Program Files\Tencent\QQ2009\Bin\QQ.exe"Õâ¸ö³ÌÐò£¬Çó¸ßÈËÖ¸µã¡£»¹ÓпÉÄܵϰÔÚÖ¸¶¨µÄʱ¼ä ......
Ïë換個µØ·½¹¤×÷£¬²»ÊÇ´ó連¾ÍÐУ¬
java對ÈÕÍâ°ü4Äê經驗£¬ÈÕ語3級£¬±¾¿Æ
ÓÐÄÄλ´ó´ó給ÍÆÒ»個Ŷ
ÉϺ£±±¾©ºÜ¶àµÄ£¬È¥´³Ò»Ï°É
¶ÔÈյϹÐÐ.
ÄãÔõô² ......
ÎÊÌâÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öÎļþnagiv.jsp ÁíÒ»¸öÎļþfailure.jsp°üº¬Ëû£¬Í¬Ê±nagivÎļþÖÐÓÐÒ»¸ö¿ÉÒÔÌø×ªµ½yy.jspµÄcommandButton£¬µ«ÊÇÎÒ½«failureÖеã»÷nagivÖеÄÄĸöcommandButton£¬Ò²Ãæ²»»áÌø×ª ......
ÎÒ¶¨ÒåÁËÒ»¸öJRadioButtonNanµÄµ¥Ñ¡°´Å¥£¬Èç¹ûÔÚÎÒÑ¡ÔñÁËÕâ¸ö°´Å¥ºóÏëµã»÷ÖØÖÃÈÃÕâ¸ö°´Å¥´¦ÓÚδѡÔñµÄ״̬¸ÃÔõô×öÄØ£¿Çë¸ßÊÖÖ¸½Ì
jRadioButton.setSelected(false);
²»ÖªµÀÄãÊÇʲôÒâ˼
Õâ¸öÊDz»Ñ¡Ôñ״̬ÁË
Î ......