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=ÃÜÂë"
¿ÉÒÔ²»Òª¶Ë¿ÚºÅ
Ïà¹ØÎÊ´ð£º
µ±ÖªµÀÒ»¸öÈÕÆÚ£¬ÈçºÎ°ÑÕâ¸öÈÕÆÚËùÔÚÑ®µÄǰºóÁ½¸öÈÕÆÚÈ¡³ö
±ÈÈçÊäÈë20090905£¬¾ÍÊäÈë20090901 20090910
Êä³ö20090901 20090910
È¡µÃÌìÊýºó×÷Ò»ÏÂÅжÏÔÙ°ÑÕâ¸ö·½·¨ÓÃÏÂvoid set(int field, int value)
......
ÎÒÏÖÔÚÓÃstruts2¿ò¼Ü,ÐèҪʹÓÃajaxʵÏÖ¾Ö²¿Ë¢Ð£¬µ«ÊÇ´ÓÈÝÆ÷Àï·µ»ØµÄÖµ²»ÖªµÀÔõô´Óstruts.xmlÅäÖÃÎļþÀïÓ³Éäµ½jspÒ³ÃæÀÒÔǰservletÀïдout.orint("xxxxx")¾Í¿ÉÒԵõ½~£¬µ«ÊÇÏÖÔÚÓÃstruts¾Í²»ÖªµÀÔõôР......
Ò»¸öJSPÒ³Ãæ½ÓÊÕÆäËûÒ³ÃæÌá½»¹ýÀ´µÄFORM±íµ¥£¬µ«ÊÇÒªÇóÖ»½ÓÊÕµ±Ç°Õ¾µã¼°Æä×ÓÕ¾µãÌá½»¹ýÀ´µÄFORM±íµ¥£¬ÆäËûÕ¾µãÌá½»¹ýÀ´µÄ±íµ¥²»½ÓÊÕ£¬Õâ¸öÔõôÉèÖã¿
ÓùýÂËÆ÷
filter
½«µ±Ç°Õ¾µã¼°Æä×ÓÕ¾µã·ÅÒ»¸öĿ¼
È» ......
<html><head><title>[@title]</title>
<meta http-equiv=Content-Type content="text/html; charset=gb2312">
<script language='javascript'>
function diyCheck ......
ÄÄλÀÏ´óÓбȽϺõķÖÒ³¿Ø¼þ»òÕß´úÂë!
ÒªÇó ¿ÉÒÔÏÔʾ×ÜÒ³Êý.»ù±¾µÄÉÏÏ·ҳ.
Êý¾Ý¿âΪOracle
±íÊý¾ÝÁ¿ÓÐ300Íò×óÓÒ ËùÒÔÏÖÔÚÎҵķÖҳЧÂÊÌ«ÂýÁË.
Ï£ÍûÀÏ´óÃÇÄÜÌṩ¸ü¿ ......