ÓÃMysqlÉú³ÉµÄÊý¾Ý¿âÖУ¬ÔÚ°²×°Ä¿Â¼ÏµÄDataÎļþ¼ÐÏÂÖ»ÓÐÒ»¸ö.optÎļþ»¹ÓÐÒ»¸ö.frmÎļþ£¬ÕâÁ½¸ö¾ÍÊÇÊý¾Ý¿âÎļþô£¿
ÔÚMyeclipse¿ª·¢ÖУ¬ÎÒ¿´µ½ÓеÄʾÀýÔ´ÂëÖÐÓÐÒ»¸ö.sqlÎļþ£¬Õâ¸öÊÇÊý¾Ý¿âÎļþô£¿
Ïñsql serverÖÐÄܹ»ÓÐMDF¡¢LDFÎļþ£¬ÔÚMysqlÖжÔÓ¦µÄÊÇʲôÎļþÄØ£¿
ÁíÍ⣬ÓÃMyeclipse¿ª·¢JSP£¬Ó¦¸ÃÔõÑùÐ ......
aÒ³ÃæÊÇÊäÈëÒ³Ãæ£¬¼´£ºaÒ³ÃæÖÐÓкܶàÎı¾¿ò¡£
bÒ³ÃæÊDZ£´æÒ³Ã棬¼´°ÑaÒ³ÃæÎı¾¿òÖеÄÊý¾Ý±£´æµ½×ÊÁϱíÖС£
ÏÖÒªÇó£º
µ±ÔÚaÒ³ÃæÎı¾¿òÖÐÊäÈëÊý¾Ýµã»÷È·ÈϺ󣬣¨×ÊÁϱ£´æµ½±íÖУ©
Ìø×ªµ½bÒ³Ãæ£¬È»ºó·µ»ØaÒ³ÃæÊäÈëÊý¾Ý£¬ÒòµÚ¶þ´ÎÊäÈëµÄÊý¾Ý£¬
ÓÐЩÎı¾¿òÖеÄÊý¾ÝºÍµÚÒ»´ÎÊäÈëµÄÏàͬ£¬ÏÖÒªÇ󼸸öÎı¾¿òÖеÄ
×ÊÁÏÏÔʾÉÏ´ÎÊ ......
jspÒ³ÃæÖУ¬Í¨¹ýµã»÷°´Å¥buttonµ÷ÓÃÒÔÏÂÄÚÈÝ
String procedure="{call p_hqdata}";
CallableStatement cstmt = conn.prepareCall(procedure);
cstmt.executeUpdate();
ÈçºÎ°ÑÕâЩ´úÂë¼ÓÈëµ½jsÖУ¡£¡
jsÖв»ÄܼÓÈë·þÎñÆ÷¶Ë´úÂ룬ҪִÐзþÎñÆ÷¶Ë´úÂ룬µÃÌá½»µ½Ò»Áí¸öÒ³Ãæ£¬Ò»°ãÓÃxmphttpÐÎʽ£¬Ò²¾ÍÊÇÏÖÔÚ³£Ë ......
jspÊý¾Ý¿â²éѯ£¬
Êý¾Ý¿âÀïÃæÓиö×Ö¶Îtime£¬Îı¾ÀàÐÍ£¬
±ÈÈç12-1Ô -10 10.51.09.687000 ÉÏÎç
±ÈÈç1-11Ô -10 10.51.09.687000 ÉÏÎç
¼Ç¼µÄÊÇ´¦Àíʱ¼ä£¬
1ÔÂ12ÈÕÉÏÎç10µã¶à
11ÔÂ1ÈÕÉÏÎç10µã¶à
ÎÒÏë²éѯָ¶¨Ô·ÝmonthµÄËùÓмǼ£¬ÏÂÃæµÄsqlÓ¦¸ÃÔõôд£¿£¿
String sql = "select * from ......
µÇÈëJSPÒ³Ãæ£¬×ÜÊÇÌáʾ´íÎóÈçÏ£¡
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
decription The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jaspe ......
ÎҼǵÃÒÔǰÓбðÈ˸øÎÒ×öµÄÍøÕ¾£¬Ò»¸öѹËõ°ü£¬½âѹºóÀïÃæÈ«ÊÇÎļþ¶øÒÑ£¬Ìí¼ÓºÃiis¾Í¿ÉÒÔ·¢²¼·ÃÎÊÁË¡£ÄǸöÊÇaspµÄ
×î½ü¸ÕÑ§ÍøÕ¾ÖÆ×÷£¬Ñ§µÄÊÇjsp£¬¶¼ÊÇÓÃMyEclipse¿ª·¢µÄ£¬ÐèÒªtomcatÆô¶¯ÔËÐУ¬ÇëÎÊÕâÖÖÍøÕ¾ÈçºÎ·¢²¼ÄØ£¿·þÎñÆ÷±ØÐëÒªÓÐMyEclipseºÍtomcat²ÅÄÜÔËÐÐÂ𣿾ÍÊÇ˵ÎÒÔõô°Ñ¸ø±ðÈË×öµÄÍøÕ¾¸ø±ðÈË£¿²»¿ÉÄܿͻ§¶¼ÓÐMyE ......