mysql Ôõô±£´æÂ·¾¶
mysql Ôõô±£´æÂ·¾¶ £¿ÀýÈçÏë±£´æC:\Dreamweaver 8\Help µ«ÊDZ£´æÈëÊý¾Ý¿âºó\»á²»¼ûÁË£¬ÇëÎÊÔõô½â¾öÕâ¸öÎÊÌ⣡~~~лл
·¾¶¾¡Á¿²»ÓÃÖÐÎÄÐÅÏ¢
лл~~ûÓÐÖÐÎÄÐÅÏ¢°¡£¬C:\Dreamweaver 8\Help£¬µ«ÊDZ£´æºó\»á²»¼ûÁË
C:\Dreamweaver 8\Help
-->
C:\\Dreamweaver 8\\Help
лл..Òѽâ¾öÁË,C:\\Dreamweaver 8\\Help ÕâÑù±£´æ¾Í»á±ä³ÉC:\Dreamweaver 8\Help
Ïà¹ØÎÊ´ð£º
jspÌá½»Ò³±àÂëÊÇUTF-8£¬MYSQL¿âÒ²ÊÇUTF-8,ΪʲôÌá½»ÁËÖÐÎÄ×Ö·ûÔÚÊý¾Ý¿âÀï±ä³ÉÂÒÂëÁËÄØ£¿
ÕâÖÖÎÊÌâÔõô½â¾ö£¿Ð»Ð»
ÁíÍ⣬JSPµ¯³ö¶Ô»°¿ò£¨±ÈÈ絯³ö¡°XXXÉóºËͨ¹ý¡±ÏÂÃæ¸úÈ·¶¨°´Å¥£©ºÍ·µ»ØÉÏÒ»Ò³ÒÔ¼°×ªµ ......
Java code:
public static void load(String filename) {
try {
@SuppressWarnings("unused")
Process process = Runtime.getRuntime().exec(
......
Õâ¸öÎÊÌâÀ§ÈÅÎҺþÃÁË£¬ÎÒÒ²²»ÖªµÀÔõôÎÊ£¬Ö»ÄÜ´óÖÂ˵һÏ£º
ÎÒÓÃMySQL´´½¨ÁËÒ»¸öÊý¾Ý¿â bookinfo±í£¬ÒªÓÃJavaµ÷ÓÃÕâÕÅ±í£¬µ«Êǵ÷Óò»³öÀ´£¬ÒªÊ²Ã´¾ä×Ó²ÅÄܵ÷ÓÃMySQL´´½¨µÄÊý¾Ý¿âÄØ¡£
Java code:
String url = ......
select time from table
time
2009-09-12 12
2009-09-12 13
2009-09-12 14
2009-09-12 15
Ôõô½« ²éѯµÄÊý¾Ý±äΪ
time
2009-09-12 12ʱ
2009-09-12 13ʱ
2009-09-12 14ʱ
......
ÎÒÔÚ°²×°ÂÛ̳µÄʱºò£¬Ð½¨ÁËÒ»¸öMYSQLÓû§£¬È¨ÏÞÊÇALL£¨grant all ¡¡£©£¬ÏÖÔÚÂÛ̳°²×°ºÃÁË£¬ÎÒÏëÈÃÕâ¸öÓû§Ö»ÄܲÙ×÷ÌØ¶¨Êý¾Ý¿â£¨·ÃÎʺÍÐ޸쬰üÀ¨´´½¨É¾³ý±í£¬×îºÃ²»ÄÜɾ³ýÊý¾Ý¿â£¬µ«×ö²»µ½¾ÍËãÁË£©£¬ÀýÈçtestÊý¾Ý ......